Front page | perl.dbi.users |
Postings from March 2008
>
>
> I applied the latest DBD-ODBC 1.15 version (Martin J
Evans)
> and it still is a problem. Is there any fix or work around for this
> issue?
>
>
>
>
>
> Appreciate your time,
>
>
>
> Thanks,
>
> Ramakrishna Raju ( "Raju" )
>
> rraju@kcmoptions.com <mailto:rraju@kcmoptions.com>
>
>
Are you sure you have created a 64bit data source called xxxsql01. In
Windows 64 there are 2 odbc driver managers - one for 32bit and one for
64bit. If you Perl is 64bit you'll need to create a 64bit ODBC data
source and if you Perl is 32bit you'll need to create a 32bit data
source.
Of course, it may just be you created a user DSN and you are not logged
in as that user.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
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.
DISCLAIMER: NOTICE REGARDING PRIVACY AND CONFIDENTIALITY
This e-mail, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail, you are hereby notified that any dissemination, distribution or copying of this e-mail, and any attachments thereto, is strictly prohibited. If you have received this e-mail in error, please immediately notify me and permanently delete the original and any copy of any e-mail and any printout thereof. E-mail transmission cannot be guaranteed to be secure or error-free. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. TJM Proprietary Trading, LLC ("TJMPT") may, at its discretion, monitor and review the content of all e-mail communications. TJMPT is a registered joint back office broker dealer with the Chicago Board of Options Exchange "CBOE". TJMPT's office is located at 318 W. Adams Floor 9, Chicago, IL 60606. For more information about TJMPT, please call us at (312)-432- 5100 or fax (312)-432-4498.
Thread Previous
|
Thread Next