ODBC Connection not showing on ODBC panel
I have a client who setup a connection years ago and now they are moving the sql database to a new server. They need to change the ODBC connection to point to the new server but when they open the ODBC panel no connections are displayed.
The connection MUST exist because the system is working right now, it should show on DSN Connections but its all blank. Is there a way to find the connection manually without using the ODBC panel and is there a reason why it would not show ?
The connection MUST exist because the system is working right now, it should show on DSN Connections but its all blank. Is there a way to find the connection manually without using the ODBC panel and is there a reason why it would not show ?
letmetry
Adding more details like Server OS version and IIS version will help answer the query. List the steps you've followed to open the panel will also help to nail it.
ASKER
Windows and IIS7
We simply open the ODBC connections panel and its empty. Also on 'start > ODBC' the connections come up but there is none listed.
The Sql database is on a different server but I assume the ODBC should be on the server with IIS that hosts the ASP pages correct? it will try and find the server to connect to where the database is.
We simply open the ODBC connections panel and its empty. Also on 'start > ODBC' the connections come up but there is none listed.
The Sql database is on a different server but I assume the ODBC should be on the server with IIS that hosts the ASP pages correct? it will try and find the server to connect to where the database is.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We tried that with no luck :(
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Checked this too .. its using DSN connection.
Is there a way to check for the connection without using the panel ? has to be somewhere in the server right ?
Could it be on the Database server instead of the IIS server ?
Is there a way to check for the connection without using the panel ? has to be somewhere in the server right ?
Could it be on the Database server instead of the IIS server ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.