Re: perl DBI on windows 64

Sorry for the mess of replying but for some reason my email client won't include your text when it was added after my signature. There are 2 odbc administrators - one you get to in the normal way through control panel, administrative tools, data sources (the 64 bit one) and one you have to go to X:\windows\syswow64 and double click on odbcad32.exe. If you start both you should see you data source in one and not the other.

You will need to use the latter one.

Martin

Ramakrishna Raju wrote:

Martin,

My Perl on the 64-bit windows is 32 bit. The version string is:

D:\perl\testing>perl -v

This is perl, v5.8.8 built for MSWin32-x86-multi-thread
(with 33 registered patches, see perl -V for more detail)

It's a System DSN entry and references the SQL Server driver
called SQLSRV32.DLL . The name implies it's a 32bit driver. When I add
an ODBC entry the drivers tab in the wizard lists only 2 drivers: SQL
Native Client ( SQLNCLI.DLL ) and SQL Server (SQLSRV32.DLL )

And my SQL Server version string is:


Microsoft SQL Server 2005 - 9.00.3054.00 (X64)
Mar 23 2007 18:41:50
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790:
Service Pack 2)

And Windows is: Windows server 2003 Standard x64 edition, SP2 build
3790.

I searched the Windows folder for sqlsrv32.dll and I see 2
files.

============================================
C:\WINDOWS>dir sqlsrv*.DLL /s
Volume in drive C has no label.
Volume Serial Number is 4C12-6CB9

Directory of C:\WINDOWS\system32

02/18/2007 07:00 AM 671,744 sqlsrv32.dll
1 File(s) 671,744 bytes

Directory of C:\WINDOWS\SysWOW64

02/18/2007 07:00 AM 446,464 sqlsrv32.dll
1 File(s) 446,464 bytes

Total Files Listed:
2 File(s) 1,118,208 bytes
0 Dir(s) 10,055,450,624 bytes free

C:\WINDOWS>
=============================================

Now, I don't know which one is used by the odbc wizard. Is the problem?

Thanks
Raju.
.

Relevant Pages

  • RE: perl DBI on windows 64
    ... Ramakrishna Raju ... My Perl on the 64-bit windows is 32 bit. ... The name implies it's a 32bit driver. ...
    (perl.dbi.users)
  • Re: HELP: ODBC Registry Error
    ... some registry entries about sql server odbc driver was accidently ... i can not found the sql server driver in the list. ... incompatible with this version of Windows. ...
    (microsoft.public.windowsxp.general)
  • Re: Trying to figure this one out
    ... The operating system is WIndows 2000 ... It is also running SQL Server 2000 Standard ... I've never used either of those drivers, but I've had good experiences with the free jTDS driver. ...
    (comp.lang.java.databases)
  • Re: perl DBI on windows 64
    ... frustration I almost abandoned the Perl approach. ... For capturing sql server print statements see the t/20SqlServe test which contains an example. ... Ramakrishna Raju ... My Perl on the 64-bit windows is 32 bit. ...
    (perl.dbi.users)
  • Re: Accessing a SQL Server Database from a Perl Script on Linux
    ... > and not the Windows machine which has the SQL server on it. ... > For a Perl program running on a Linux box to query a SQL Server ... turn talks with SQL Server through an ODBC driver on the Windows side. ...
    (comp.os.linux.questions)