MS SQL Server ODBC - location of ODBC drivers for SQL 2k5 x64 in Win Server 2003 x64 ST

Author

location of ODBC drivers for SQL 2k5 x64 in Win Server 2003 x64 ST

Olgun

2006-10-24, 6:40 pm

Hi,
I've got Win Server 2003 Standard 64bit edition trying to work with SQL 2005
standard 64bit edition however there is a problem.

I need to locate the ODBC driver in Win Ser.

I know where they are in the 32bit edition but not in the 64bit version.
can anyone help?
Thanks
Olgun.Ucurel@ccsmedia.com

Warren Brunk

2006-10-24, 6:40 pm

Is there a 64 bit ODBC Driver? I didnt think that there was. You might have
to compile your application in x86 or if you are using SSIS or DTS exec you
can use this post...
http://forums.microsoft.com/MSDN/Sh...603814&SiteID=1

Can you use the OLE DB Driver?

C:\WINDOWS\SysWOW64\
odbcad32.exe
uses...
odbc32.dll

and
C:\WINDOWS\System32\
odbcad32.exe
uses
odbc32.dll

I am sure others will have some thoughts as well.

--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/

"Olgun" <Olgun@discussions.microsoft.com> wrote in message
news:9BA59FAC-D013-4BF4-9700- A97D71D65545@microso
ft.com...
> Hi,
> I've got Win Server 2003 Standard 64bit edition trying to work with SQL
> 2005
> standard 64bit edition however there is a problem.
>
> I need to locate the ODBC driver in Win Ser.
>
> I know where they are in the 32bit edition but not in the 64bit version.
> can anyone help?
> Thanks
> Olgun.Ucurel@ccsmedia.com

lucm@iqato.com

2006-10-24, 6:40 pm

Olgun wrote:
> Hi,
> I've got Win Server 2003 Standard 64bit edition trying to work with SQL 2005
> standard 64bit edition however there is a problem.
>
> I need to locate the ODBC driver in Win Ser.
>
> I know where they are in the 32bit edition but not in the 64bit version.
> can anyone help?
> Thanks
> Olgun.Ucurel@ccsmedia.com

As far as I know the ODBC driver is not working on 64 bits Windows. You
could use OLEDB instead, which is working fine.

Regards,
lucm

Sponsored Links