Re: perl DBI on windows 64

Ramakrishna Raju wrote:
Hi,



I am trying to connect to SQL Server 2005 on a windows 64bit
machine from the same machine. And I get this error message:



DBI connect(xxxsql01,'sa',...) failed: [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified (SQL-IM002)
at a.pl line 10

Can't connect to dbi:ODBC:xxxsql01: [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified (SQL-IM002)
at a.pl line 10.



The Perl script is:

#=======================================================

use strict;



use DBI;



my $data_source = q/dbi:ODBC:xxxsql01/;

my $user = q/sa/;

my $password = q/xxxxxx/;



# Connect to the data source and get a handle for that connection.

my $dbh = DBI->connect($data_source, $user, $password)

or die "Can't connect to $data_source: $DBI::errstr";

#=========================================================



If I run this script from a 32-bit windows machine, it is
able to connect successfully.



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@xxxxxxxxxxxxxx <mailto:rraju@xxxxxxxxxxxxxx>




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.

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
.

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 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)
  • perl DBI on windows 64
    ... I am trying to connect to SQL Server 2005 on a windows 64bit ... Data source name not found and no default driver specified ... The Perl script is: ... Ramakrishna Raju ...
    (perl.dbi.users)
  • RE: perl DBI on windows 64
    ... I created a system DSN, and the 'sa' login is just to get things ... It seems you don't have a valid ODBC data source named xxxsql01. ... On 13.03.2008 16:42, Ramakrishna Raju wrote: ...
    (perl.dbi.users)
  • Re: Connecting to SQL Server on Windows
    ... using the ODBC Data Source Administrator on Windows. ... a trusted connection you'll need to add that attribute to the ... So given the information you've provided, the username or password ...
    (perl.dbi.users)