Front page | perl.dbi.users |
Postings from March 2008
Re: perl DBI on windows 64
Thread Previous
|
Thread Next
From:
Martin Evans
Date:
March 14, 2008 01:40
Subject:
Re: perl DBI on windows 64
Ramakrishna Raju wrote:
> Martin,
>
> Great !! That works. I am so happy now. I went thru so much
> frustration I almost abandoned the Perl approach. Thanks, Martin.
>
> And now, I am looking for a web link or a short snippet that
> does robust error handling of SQL errors. And how to process the output
> of sql print statements. I've done Sybase db-lib programming more than
> 15 years back and I realize that are 2 channels back to the client, a
> message handler and an error handler. How is it done in perl odbc?
Glad you are working now - I will perhaps add that as a FAQ entry to
DBD::ODBC.
For capturing sql server print statements see the t/20SqlServe test
which contains an example.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
> Thanks,
> Ramakrishna Raju ( "Raju" )
> rraju@kcmoptions.com
>
> -----Original Message-----
> From: Martin Evans [mailto:martin.evans@easysoft.com]
> Sent: Thursday, March 13, 2008 12:28 PM
> To: dbi-users@perl.org
> Subject: 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.
>
> 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 o
ffice 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