Page 1 of 1
SQL Server ODBC will not install on 64bit machines
Posted: Fri Dec 03, 2010 7:39 am
by 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?
Re: SQL Server ODBC will not install on 64bit machines
Posted: Fri Dec 03, 2010 4:26 pm
by mills
How are you trying to install them?
Re: SQL Server ODBC will not install on 64bit machines
Posted: Mon Dec 06, 2010 8:35 am
by 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$~
Re: SQL Server ODBC will not install on 64bit machines
Posted: Mon Dec 06, 2010 6:50 pm
by 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
Re: SQL Server ODBC will not install on 64bit machines
Posted: Tue Dec 07, 2010 11:49 am
by 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.
Re: SQL Server ODBC will not install on 64bit machines
Posted: Tue Dec 07, 2010 1:09 pm
by 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.