Front page | perl.dbi.users |
Postings from March 2008
RE: perl DBI on windows 64
Thread Previous
From:
Ramakrishna Raju
Date:
March 13, 2008 09:56
Subject:
RE: perl DBI on windows 64
I created a system DSN, and the 'sa' login is just to get things
right, so I don't run into permission issues. Eventually I will use the
appropriate login. Thanks for the concern.
Ramakrishna Raju ( "Raju" )
rraju@kcmoptions.com
-----Original Message-----
From: Alexander Foken [mailto:alexander@foken.de]
Sent: Thursday, March 13, 2008 11:23 AM
To: Ramakrishna Raju
Cc: dbi-users@perl.org
Subject: Re: perl DBI on windows 64
It seems you don't have a valid ODBC data source named xxxsql01. If you
are running your script from a web server, it has to be a system data
source, else it may also be a user data source.
And by the way: Are you sure you want to connect as "sa"? That account
usually has too many privileges. Create a distinct user for your
application.
Alexander
On 13.03.2008 16:42, 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@kcmoptions.com <mailto:rraju@kcmoptions.com>
>
>
>
>
> 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.
>
--
Alexander Foken
mailto:alexander@foken.de http://www.foken.de/alexander/
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