RE: perl DBI on windows 64

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?

Thanks,
Ramakrishna Raju ( "Raju" )
rraju@xxxxxxxxxxxxxx

-----Original Message-----
From: Martin Evans [mailto:martin.evans@xxxxxxxxxxxx]
Sent: Thursday, March 13, 2008 12:28 PM
To: dbi-users@xxxxxxxx
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 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.
.

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: Perl 6 DBI API ideas
    ... Though I didn't raise my hand when you asked for people to contribute to a DBI module for Perl 6, I've had some ideas that I thought about sharing. ... I would also love to see some standardization on the driver names ("mysql" when it's normally written ... DBI is supposed to be query language agnostic, even if SQL is the most commonly used group of languages, and if a user can declare this explicitly, it saves the driver from having to guess what they were given, which might be ambiguous. ...
    (perl.dbi.users)
  • Re: perl DBI on windows 64
    ... My Perl on the 64-bit windows is 32 bit. ... It's a System DSN entry and references the SQL Server driver ... The name implies it's a 32bit driver. ...
    (perl.dbi.users)
  • Re: use of DBI; I am getting multiple error messages mixed in with the correct output.
    ... T> expected a mature library like DBI to behave like this. ... I learned plenty about the perl side of things from her posts. ... closely represent the SQL idea of a null. ... trivially easy to perform bulk loads using the DB's particular ...
    (comp.lang.perl.misc)
  • ANNOUNCE - Muldis::DB v0.0.0 released, in p5+p6
    ... I am pleased to announce the release of Muldis::DB version 0.0.0 for Perl 5 on CPAN. ... If you want to read all the Muldis::DB documentation that exists now, I recommend doing so in this order: ... Muldis::DB implements a D language as defined by Hugh Darwen and Chris Date, and presents a superior interface for working with the relational model of data, contrasted with SQL. ...
    (perl.dbi.users)