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