sql odbc DRIVER not available as a choice in DSN driver listing-XP PRO SP3



Hello,
I have recently installed an HP Proliant ML370 G2 system as a test
server, and also have installed SQL 2000 on that system. I installed
Great Plains 8.0 on that system, and have created the SQL ODBC system
dsn for that application. On the server, this program works fine.

On one of my test workstations (which is an older Gateway Laptop)
running XP PRO SP3, I installed the client portion of the Great Plains
application. When I attempt to set up an ODBC driver for the SQL
connection there is NO SQL selection available. I have installed the
client only portion of SQL 2000 on this computer, and have even gone
so far as to completely reinstall SP3. Still no SQL choice in the ODBC
setup.

I noticed that on this system, there appears to be NO WINDOWS\SYSTEM32
directory (at least it is not visible). There is however, a WINNT
\SYSTEM32 directory. The WINNT directory does include "sqlsrv32.dll".

AM I overlooking something in my ODBC configuration?

Thanks for your help.
Regards....Dave K
.



Relevant Pages

  • RE: Invalid cursor state when using PRINT in MSSQL
    ... Interesting article but I seriously doubt you are using the ODBC 2.0 MS SQL ... DBD::ODBC does call SQLError immediately after SQLExecute returns ... I was unable to reproduce this with the ODBC 3 MS SQL Server driver ...
    (perl.dbi.users)
  • Re: DTC Fehler
    ... Lege im SQL Server einen Linked Server für die AS/400 an. ... Einstellungen für den Providerstring - vergleiche auch Angaben zum ODBC ... Die Verbindung zur AS/400 wird über den IBM Client Access ...
    (microsoft.public.de.sqlserver)
  • Re: MS Access database to gradually become a server based database - which one ?
    ... Server 2008 Express Edition. ... SQL server is indeed a high performance system, and also a system that can ... Before Microsoft started "really" selling sql server, they rated JET could ... (this ONLY applies to odbc to sql server...you CAN and are FREE to do this ...
    (microsoft.public.access.gettingstarted)
  • ODBC-Verbindung zu {SQL Native Client}(schulelb002) fehlgeschlagen.
    ... Muss ich etwa einen ODBC Driver am Server oder am Client installieren? ... OleDb ist nicht etwa besser oder so... ... den kriegst Du indem Du {SQL Server} durch ersetzt. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: DTC Fehler
    ... Auf dem Windows Server ist SQL Server 2000 SP3a und ... wird der Barcode im SQL ... Server abgespeichert und der Trigger ausgelöst (After ... Access Express ODBC to a R510 or later OS/400 system. ...
    (microsoft.public.de.sqlserver)