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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft IIS Web Server

From novice to tech pro — start learning today.