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 ?
LVL 1
AleksAsked:
Who is Participating?
 
Dave BaldwinFixer of ProblemsCommented:
Here are two connection strings, one using a DSN-less connection and the second using a System DSN.  They both connect to the same database.
' DSN-less
connectstr = "Provider=SQLNCLI;Server=YOURSYS\SQLEXPRESS;Database=TestDB;Uid=yourid; Pwd=yourpwd;"
' using System DSN
connectstr = "DSN=SysSQL;Uid=yourid;Pwd=yourpwd;"

Open in new window

0
 
letmetryCommented:
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.
0
 
AleksAuthor Commented:
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.
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
letmetryCommented:
I'd try this
- search for odbcad32.exe (or odbc*.exe) on IIS server, you might have it in 2 locations. I think C:\Windows\System32\; C:\windows\syswow64\
- Open and close one after another. You might find them in one of them
- If not you can create a new connection

Most probably, the connections were defined in x64 and x32 or vice-verse. Hope this helps.
0
 
AleksAuthor Commented:
We tried that with no luck :(
0
 
Dave BaldwinFixer of ProblemsCommented:
I would look in the ASP files for a DSN-less connection.  That is one where the connection parameters are directly specified and a DSN in the ODBC manager is not required.  I use that method more often than I use a DSN.
0
 
AleksAuthor Commented:
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 ?
0
 
Dave BaldwinFixer of ProblemsCommented:
No, an ODBC DSN must be on the computer that is using it.  A DSN connection in ASP only gives the name of the DSN.  If it shows the driver and database in the connect statement then it is a DSN-less connection.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.