SQL Server ODBC will not install on 64bit machines

[Roostar2004]

I am trying to install some ODBCs on a 64bit windows 7 and cannot get them to work. I am using a 64bit installer as well as the correct ODBCs but they never seem to get added. I was wondering if anybody else had this same issue or not?

[mills]

How are you trying to install them?

[Roostar2004]

Here is the code I am using below.

Code: Select all

~InstallAware Clipboard Data~
~Create ODBC DSN~
~{4BD693A8-E07C-4F6A-9F77-B32A5A6594FC}~
~MYDBWA~
~SQL Native Client~
~TRUE~
~Server=.\SQLSERVER$NEWLINE$Database=MYDB$NEWLINE$Trusted_Connection=Yes$NEWLINE$~
~Create ODBC DSN~
~{3340F4EA-7873-4C85-A70E-CD297BFFFE7A}~
~MYDBDB~
~SQL Native Client~
~TRUE~
~Server=.\SQLSERVER$NEWLINE$Database=MYDB$NEWLINE$~
~Install ODBC Driver~
~{F573957B-FE84-4767-ADB8-B4370E823306}~
~SQL Native Client~
~c:\Windows\SysWOW64\sqlncli.dll~
~c:\Windows\SysWOW64\sqlncli.dll~
~$WINSYSDIR$~
~~
~APILevel=2$NEWLINE$ConnectFunctions=YYY$NEWLINE$CPTimeout=60$NEWLINE$DriverODBCVer=09.00$NEWLINE$FileUsage=0$NEWLINE$SQLLevel=1$NEWLINE$~


[mills]

You code suggests you're trying to install the native client..

Are you trying to install native client or ODBC. If ODBC, shouldn't you be installing MDAC?

http://stackoverflow.com/questions/1645 ... dbc-driver
http://www.microsoft.com/downloads/en/d ... laylang=en

[Roostar2004]

We are installing ODBCs that use the native client. For the 32bit installer we have always included the driver for the native client as well as the ODBCs. Our install sets do not include the MDAC as it is not needed a a prereq to install the SQL Server 2005 Sp3 x64 version supplied by installaware. Also our 64bit install will only be used for Windows 7 machine and up.

[Roostar2004]

I removed the code to install the ODBC driver and it is still not working. Something that I noticed as I am running installaware 9 on a Windows 7 64bit it is not able to see the ODBCs that I have created on my system like it used to be able to. I am wondering if maybe installaware 9 is not able to access the ODBC correctly inorder to be able to create them in a 64bit environment.