Dave Than you again for your response. Exactly, we now test with the 3 forms to connect: 1. Standard Security 2. Trusted Connection 3. Connect via an IP address (referer : http://www.connectionstrings.com/) So, we have 3 more servers and try to connect to them, but only one server failed to connect. I think like you is a configuration (meaby SQL server) or software to install problem, but We don't know what it´s. We can follow like first step the MDAC gangeles
Serpiente
Posts
-
Error conexion with vbNet 2005 but not with others -
Error conexion with vbNet 2005 but not with othersDave thank you for your response, We work with VB6, VB.NET, VB.NET.2003 and the last VB.NET.2005 We try to walk with the technology. When work with VB6, VB.NET, VB.NET.2003 don't have problem, what I can say, we don't to change nothing because works fine. But, since install VB.NET.2005 and try to do an application don't can stablish a conexion to the server. So, we don't need to change the configuration but meaby vb.net.2005 requieres to change, and we don't have the config to change, I look on sql-server-tool and have de TCP/IP added (enabled), you refer to this? The NET Principal Server (have the DB) Have a Domain We attach to the domain I test on two ways from client to server and server to client to stablish conexion but don't stablish. Hope that you can help us gangeles
-
ConnectionString works for VB6/VBNET/VBNET2003 for SQL SERVER but not for VBNET2005 SQL SERVER only localHello, I have this sub: Sub ConDB() Dim oSqlCliCon As SqlConnection oSqlCliCon = New SqlConnection("Data Source=120.260.9.8;Integrated Security=SSPI;Initial Catalog=pubs") Try oSqlCliCon.Open() Catch ex As Exception msgbox(ex.Message) End Try oSqlCliCon.Close() End Sub The problem: The code works for VB6/VBNET/VBNET2003 for SQL SERVER for VBNET2005 works only local but for the SQL SERVER don't. The exception message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The exception message if modify the connectionstring: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Please help, thank you. gangeles
-
Error conexion with vbNet 2005 but not with othersHello, I have this sub: Sub ConDB() Dim oSqlCliCon As SqlConnection oSqlCliCon = New SqlConnection("Data Source=120.260.9.8;Integrated Security=SSPI;Initial Catalog=pubs") Try oSqlCliCon.Open() Catch ex As Exception msgbox(ex.Message) End Try oSqlCliCon.Close() End Sub The problem: The code works for VB6/VBNET/VBNET2003 for SQL SERVER for VBNET2005 works only local but for the SQL SERVER don't. The exception message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The exception message if modify the connectionstring: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Please help, thank you. gangeles
-
Build a treeview from database table vb.netHi!, I want to store and build a tree (using the control treeview of windows forms) from database table. Some people say to me that the table structure is like: Table Name : TUserStruct Table Fields of TUserStruct : iNodeParent, vcNodeText And the functions are recursive. Please some body do this?, is possible send the code... Thank you. gangeles
-
Move Image within PicBoxWell Folks, Finally I founded that I need. The ImagXpress Pegasus control 7.0 have all the things I need. http://pegasusimaging.com/imagxpress.htm This demo have an example: C:\Program Files\Pegasus Imaging\ImagXpress\V7.0\Samples\ActiveX-COM\VB6\ViewingTools CU and Thanx gangeles
-
Move Image within PicBoxHello, Well, I have a PictureBox and this control contained an image. For example the PictureBox has 200 x 300. Well the image size is 800 x 600. Is possible that move the image in the picturebox, for example the coord(0,0) of the picture box show the coord(100,100) of the image. I want to drag and drop and move the image on the picturebox, so the picturebox is like a window only I can see an area 200 x 300 of the image. Thank you, sorry meaby a I can't explained for my bad english. See you gangeles
-
How make my own class and imports thisHello world!, I want to make my classes, is possible that I can imported this classes?. I think that I can use: Imports MyClass Is possible, How can do that?... gangeles
-
Image ManipulationHello World.NET!, Sorry new project, new question. I need to show a group of images from a Directory, then the size of image is variable, is necesary capture some data so, if the picture is small no problem, but if the pic es big the user need to surf on the pic. I use a picturebox but the control don't have scroll bar. What kind of control I can use to move on the image, I thnik about if is posible with a click and drag move the image. And if is possible make a zoom much better. well c2. Thank You gangeles
-
Order data in table by headerThank you, I find an better example: http://www.kryogenix.org/code/browser/sorttable gangeles
-
Order data in table by headerHello World!, I want to order the data of each column in a table when clic on the header of the column. I try with: http://www.glendinning.org/webbuilder/sortTable/ but have problem with the data type int and string. gangeles
-
Column DataTypeHello World!, How can I get the datatype for each column on my table?. I try with: oDataReader.GetDataTypeName(i) But when the field on the record don't have a value, return dbnull, so I need to validate on my form the values enter for the user and need to know the datatype for each value (column). Well, happy lines! gangeles
-
Call application .exeHello, ¿Is possible to run a visual basic .NET aplication (app.exe) from ASP.NET?. We have a web application project and have a visual basic .NET then from ASP.NET we are trying to execute an exe file, but the message are "don't found the file or access denied". We try with: shell response.redirect process Javascript document.location And href=path We test with out example from the web site and run, but we need run from the web site. (sorry for my english) Thank you! gangeles
-
Infragistics.WebUI.UltraWebNavigatorHello Friends, I need your help. I want to use UltraWebNavigator of Infragistics but in the help I can't found examples. Please if you have some example, I will apreciated so much. Have I nice 2006. gangeles
-
(Work Flow, Procces or job component)Thank you for your reference, I try to Install Biz Talk but have troubles with configuration, meaby Biz talk is a solution, I read about biz tal can do that. If you use Biz talk, is possible that I give to the user an application where he can paint or model a procces?, I can read the work flow of this procces?. I'm waiting for your best commentes and one more again THANK YOU and have happy days. gangeles
-
(Work Flow, Procces or job component)Hello, We need a component for the users where they can to paint (or model) and work flow or procces or job. I'm try to FlowChart and GoDiagram. If you know for a best component, please tell to me. We need to add, read and modify properties for a symbols and read the flow from the beggining to the end. Than you (Happy Days) gangeles