nsODBC

Where do I get the nsODBC dll? The code is in the comment section of nsODBC, but doesn't include the dll and I can't get it to compile (prolly don't have the proper nmake.exe because it crashes and burns on the VS 2005 and VS 2003 nmake.exe's). Any help would be very much appreciated.

Thanks Much,
Eric

The download from this page contains nsODBC.dll. Which one doesn't?

That download wasn't there an hour ago. The only download for nsODBC was HERE

But Thanks!

It was in "ODBC Manager", but not in "nsODBC plug-in". After you've asked, I modified the plug-in page to include the download and redirected the first page to the plug-in page. But the first page showed up in the search, that's how I found it.

Gotcha. Hey, do you know what all the accepted parameters are. The doc pulls the old "..." on you. The example only shows:

nsODBC::AddSysDSN "Microsoft Access Driver (*.mdb)" "DSN=SERVER_${PRJ_NAME}_DB"
"DBQ=$INSTDIR\${PRJ_NAME}.mdb"

We're doing a SQL Server ODBC on a different server (not local) with a different user and password. The code doesn't seem to have much for comments about usage either.

Thanks,
Eric

Sorry, no idea. As far as I know, the parameters part is driver dependent. MSDN is probably the best source for this one.

Can anybody give me an example of a SQL Server nsODBC usage? Here's what I'm trying unsuccessfully:

;create DSN's
nsODBC::AddSysDSN "SQL Server" "Database=MyDB" "Description=MyDB" "Driver=C:\WINNT\System32\SQLSVR32.dll" "Server=SVRName" "LastUser=sa" "Trusted_Connection=Yes"

It seems to just skip by the command.

Thanks,
Eric

Shouldn't all of those be in one parameter?

That seems right, but it still didn't work (I'm basing this on no registry entries being created). Here's our entry now:

;create DSN's
nsODBC::AddSysDSN "SQL Server" " "DSN=MyDSN" "Driver=C:\WINNT\System32\SQLSVR32.dll Server=MyServer Database=MyDB LastUser=sa TrustedConnection=Yes Description=MyDB"

Seems like it expects them to be separate after all. It also expects to bump the end of the stack to find the last parameter. Try clearing the stack with Pop before calling the plug-in. If that works, the plug-in corrupts the stack and loads parameters it shouldn't.

For a list of attributes for the "SQL Server" driver....



EX:
nsODBC::AddSysDSN "SQL Server" "DSN=DSNName" "Server=ServerName" "Description=Duh" "Trusted_Connection=1"