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...

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...

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...

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

...

in my connection string i'm using sql authentification. but it doesn't work