perl DBI on windows 64

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 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
    ... I am trying to connect to SQL Server 2005 on a windows 64bit ... Data source name not found and no default driver specified ... Ramakrishna Raju ... 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. ...
    (perl.dbi.users)
  • Re: Clustering - how can I.......
    ... the data source for the web server is an NFS file location stored on a Windows server using RAID5. ... Because the cluster is of DS10Ls, using local IDE storage and the only simple, cheap way I can have a single source for the web server is to have it come from an NFS source. ... The data source size is greater than the IDE disks inside the DS10Ls - and yes, this is on a hobbyist license. ...
    (comp.os.vms)
  • Re: directory doesnt merge records w/o next record field
    ... connection to the data source is made. ... attempted to merge to a new document - all from the mail merge toolbar. ... Does anyone know if this could be cause by a compatibility or update ... I'm running Windows 2000 Pro and MS Office 2003. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Burning file to disc and reading it on another computer
    ... *.xlr = Microsoft Works Spreadsheet ... *.wks = OLD Microsoft Works Spreadsheet ... Take Ownership of a File or Folder in Windows XP ... the data source that contains the data source you want to merge. ...
    (microsoft.public.windowsxp.help_and_support)
  • Kind of a head scratcher...
    ... My Windows 2000 is in Portuguese language because I am from Brazil, ... We have developed an Access System that dynamically configures an ODBC ... Data Source on the ODBC configuration. ...
    (microsoft.public.access.queries)