January 14, 2002 at 3:20 am
hi
i've created an aplication in vb/sql server2000. my server is in a domain and my client is in a workgroup. so when i install the aplication at the client the programm can' t run because he can' t connect to the DB.
i think the problem comes from the domain and the workgroup. is some one has an idea to help me????????????????
January 14, 2002 at 5:32 am
Try using a SQL login and password.
Andy
January 14, 2002 at 5:55 am
in my connection string i'm using sql authentification. but it doesn't work
January 14, 2002 at 7:41 am
Are you receiving a server not found/access is denied error? Can you connect to the server through another client application such as Access using ODBC? Can you create an ODBC connection successfully to the SQL Server?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
January 14, 2002 at 9:04 am
the message error i receive from the application is code: -2147467259, [dbnmpntw]
connectionOpen(createfile())
this deosn' t allow to have access to the DB.
i've tried to do an ODBC connection but it failed
January 14, 2002 at 9:07 am
Have you tried creating an ODBC connection to the IP address (selecting TCP/IP as the NetLib) as opposed to the server name?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
January 14, 2002 at 9:18 am
in my programm the connection string is calling the ip adress and not the name of the server.
Public Sub connection()
Set cn = New ADODB.connection
On Error GoTo errFind
With cn
.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID= " & login & "; Password= " & pwd & " ;Initial Catalog=DNTDB_TEST;Data Source=xxx.xxx.x.xxx"
.Open
End With
Exit Sub
January 14, 2002 at 9:18 am
in my programm the connection string is calling the ip adress and not the name of the server.
Public Sub connection()
Set cn = New ADODB.connection
On Error GoTo errFind
With cn
.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID= " & login & "; Password= " & pwd & " ;Initial Catalog=DNTDB_TEST;Data Source=xxx.xxx.x.xxx"
.Open
End With
Exit Sub
January 14, 2002 at 2:46 pm
OK, let's start from the ground up. I apologize if you've already tried this.
Can you ping the database server from the application client system?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
January 14, 2002 at 5:49 pm
January 15, 2002 at 1:23 am
ok gyus, i can ping the BD server from the client computer. about the port 1433, i don' t how can i ckeck if it's open or not?
thankxx 4 ur help
January 15, 2002 at 7:26 am
Login at the console to the SQL Server.
Go to a command prompt.
Execute the command: netstat -an
You may have to a | more if it scrolls off the screen (likely).
Can you login with the SQL Server user account you are trying to use at the console itself?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply