SQL Server DSN not visible

[Jeff Mowatt]

Hello,

Can anyone help with this?

I'm creating a procedure to build a system DSN for SQL Server on 600
client by editing the odbc.ini file and the registry entries in
HKLM\SOFTWARE\ODBC under ODBC.INI and ODBC Data Sources.

The DSN works fine but it never shows in the list of system dsn's,
it's invisible so so something else must be missing. Any suggestions.

Secondly the lastuser key on this DSN doesn't appear to need a
password, does this mean SQL Server has it tucked away somewhere?

TIA

Jeff Mowatt

 

[Dave Patrick]

You'll need to get the subkey with the DSN names
HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

and also the subkey for each DSN
HKLM\SOFTWARE\ODBC\ODBC.INI\

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft MVP [Windows NT/2000 Operating Systems]