Skygod
4th February 2004 16:25 UTC

How to register an SQL Server 2000 DSN?
Have found references to use BdeInst.dll for register an DSN from the installation prg, but no example for SQL Server 2000?

Anyone?

kichik
4th February 2004 17:29 UTC

These should help:

http://forums.winamp.com/showthread....&highlight=dsn
http://nsis.sourceforge.net/archive/...php?pageid=106
http://nsis.sourceforge.net/archive/...php?pageid=387
http://nsis.sourceforge.net/archive/...php?pageid=390

Skygod
5th February 2004 02:12 UTC

Thanks a lot, now it works! There was a typing error on the last link where it said:

WriteRegStr HKEY_LOCAL_MACHINE "Software\ODBC\ODBC.INI\DSNNAME" "Driver" "C:\\WINNT\\System32\\SQLSRV32.dll"
WriteRegStr HKEY_LOCAL_MACHINE "Software\ODBC\ODBC.INI\DSNNAME" "Server" "Server Name"
WriteRegStr HKEY_LOCAL_MACHINE "Software\ODBC\ODBC.INI\DSNNAME" "Database" "db on sql server"
WriteRegStr HKEY_LOCAL_MACHINE "Software\ODBC\ODBC.INI\DSNNAME" "LastUser" "sa"
WriteRegStr HKEY_LOCAL_MACHINE "Software\ODBC\ODB.INI\ODBC Data Sources" "DSNNAME" "SQL Server"

But it should be:

WriteRegStr HKEY_LOCAL_MACHINE "Software\ODBC\ODBC.INI\DSNNAME" "Driver" "C:\\WINNT\\System32\\SQLSRV32.dll"
WriteRegStr HKEY_LOCAL_MACHINE "Software\ODBC\ODBC.INI\DSNNAME" "Server" "Server Name"
WriteRegStr HKEY_LOCAL_MACHINE "Software\ODBC\ODBC.INI\DSNNAME" "Database" "db on sql server"
WriteRegStr HKEY_LOCAL_MACHINE "Software\ODBC\ODBC.INI\DSNNAME" "LastUser" "sa"
WriteRegStr HKEY_LOCAL_MACHINE "Software\ODBC\ODBC.INI\ODBC Data Sources" "DSNNAME" "SQL Server"

opher
5th February 2004 08:10 UTC

Could you point out the difference? Perhaps emphesize it with some color?
Thanks.

Skygod
5th February 2004 11:41 UTC

Last line it says:

ODB.ini instead of ODBC.ini