problem in connecting Databas trhough ODBC

[imrankhaldi]

i am facing problem in connecting databas through my VB application.
If I use application from the same comuputer where dabase resides then there is no problem. it connects and works. but when i run this application from different computer within a LAN, it do does not connect and raise error. I am trying to connect database through ODBC connection. I did try to establish ODBC from different computer but its unable to create and raise following error.

Connection Failed
SQL State '01000'
SQL Server error 53
[microsoft][ODBC SQL Server Driver][DBNETLIB]Connection Open connection Failed
SQL Stat '08001
SQL Error 17
[microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server Does not exist or access denied.

Awaiting for help.

[jggtz]

It would be helpful if you post the code where you are connecting to the database

[DataMiser]

Are you getting the error from your program or from the ODBC utility? Did you create a DSN via ODBC and test the connection?

Is the PC the database is on set up to allow outside connections?

[firoz.raj]

Why don't you use ado Control it is much better then old boredom way creating DSN Via ODBC ?

[imrankhaldi]

Are you getting the error from your program or from the ODBC utility? Did you create a DSN via ODBC and test the connection?

Is the PC the database is on set up to allow outside connections?

i am not getting error from the program, i am getting error in configuring ODBC on the computer of my colleage who will run the application from his computer.

However, on the computer where database resides, there is no problem in creating ODBC and running application on same computer using this ODBC.

[DataMiser]

Why don't you use ado Control it is much better then old boredom way creating DSN Via ODBC ?

ado Control has nothing to do with it and I would not suggest using it. Always use ADO Code but the issue here is not the method but the connection.

The problem here would seem to be the configuration of the database server itself.

This thread should be moved to the database area.

[firoz.raj]

ado Control has nothing to do with it and I would not suggest using it. Always use ADO Code but the issue here is not the method but the connection.

The problem here would seem to be the configuration of the database server itself.

This thread should be moved to the database area.

i mean ado code not ado control . as he understood ! .what i said .

[DataMiser]

i mean ado code not ado control . as he understood ! .what i said .

Why would you think that anyone understood that you meant ADO code when you said ADO Control? What was understodd is that this has nothing to do with the issue. If you can't connect to the DB via the ODBC manager then you are not going to get a connection from VB.

BTW you can use ADO code and still use an ODBC DSN connection.

[goma_23]

perhaps your firewall on the database server is not configured to accept incoming connections,

[imrankhaldi]

tanks for the help, my firewall was on.