Finding ODBC Settings in files

[lsgko]

We've a got a database server that was running SQL 7 and the machine went do and now the operating system needs to be reinstalled. Where does SQL server keep information on ODBC settings? (I'm looking for settings that would be involved in the setup of ODBC for access by a custom program).

 

[nigelrivett]

Do a search in the registry for odbc

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[lsgko]

I made a typo in my first post. The machine has the database, has to have the operating system reinstalled. So the only files I have access to are files in the SQL7 directory. Is there a utility to look at the registry from another machine?

 

[nigelrivett]

regedt32 will allow you to look at a remote registry if you have permission

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.