SQL remote connection
I wrote this application in visual basic .net and installed it on a server with SQL 2000 installed. I can locally start the application and I have confirmed that I can communicate with SQL.
Our environment is a little different as the server that I have installed the application does not have access to IE. It is on a network, but on a restricted network behind a fire wall.
I used the Click once deploy and I have processed the installation on a client pc. The client installation worked fine. When the client starts the application, it comes back to tell me that it cannot establish a SQL connection. I have created an ODBC connection on the server and I have used SQL Query to prove that I am able to communicate with the database.
Any suggestions on how I can get this remote connection to work.