Adam,
Did you install DBD-ODBC ? The error message appears to be telling you
everything you need to know ...
To double check try running dbish and see if dbi:ODBC appears in the list
of available drivers.
Regards,
Rob
-----Original Message-----
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, October 30, 2002 7:34 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: ODBC module-install problem?
thanks for the reply.
i changed the line you suggested to:
$dbh = DBI->connect("dbi:ODBC:$dbname", $user, $passwd) or die
here's the new error. i trying to connect to MS SQL Server.
C:\>scripts\test_mssql.pl
Name "main::rv" used only once: possible typo at C:\scripts\test_mssql.pl
line 2
5.
install_driver(ODBC) failed: Can't locate DBD/ODBC.pm in @INC (@INC
contains: C:
/Perl/lib C:/Perl/site/lib .) at (eval 1) line 3.
Perhaps the DBD::ODBC perl module hasn't been fully installed,
or perhaps the capitalisation of 'ODBC' isn't right.
Available drivers: ExampleP, Proxy.
please advise.
-adam
--- Jeff Urlwin <[EMAIL PROTECTED]> wrote:
> Adam,
> > Two things: please always copy [EMAIL PROTECTED] You typically get
> better/faster answers there, as a rule. And, it helps others...
> > Second: The :: between dbi and ODBC is your problem...
> > Jeff
> > > -----Original Message-----
> > From: Adam Peterson [mailto:laca_adam@;yahoo.com]
> > Sent: Tuesday, October 29, 2002 4:07 PM
> > To: [EMAIL PROTECTED]
> > Subject: ODBC module
> >
> >
> > hi,
> >
> > i'm having problems installing the ODBC module. "make" and "nmake"
> didn't
> > seem to work. i'm running perl on win2000. here's my script:
> >
> > #!perl.exe -w
> >
> > use DBI;
> > #use strict;
> >
> > ######## open db
> >
> > $dbname = 'EggImport-SD';
> > $user = '';
> > $passwd = '';
> >
> > # connect to database
> > $dbh = DBI->connect("dbi::ODBC:$dbname", $user, $passwd) or die
> > $dbh->errstr;
> >
> > # set data size and ok to truncate
> > $dbh->{LongReadLen} = 10000;
> > $dbh->{LongTruncOk} = 1;
> >
> > $sth = $dbh->prepare("
> > use test2
> > select patient_control_no, patient_first_name, patient_last_name
> > from claim_data
> > where patient_control_no = '035593SKC711122'");
> >
> > $rv = $sth->execute;
> >
> > while(@now = $sth->fetchrow_array)
> > {
> > $pcn = $now[0];
> > $pfn = $now[1];
> > $pln = $now[2];
> > print "$pcn\t$pfn\t$pln\n";
> >
> > }
> >
> >
> > ######### disconnect
> >
> > $sth->finish;
> > $dbh->disconnect;
> >
> >
> > ########## HERE'S THE ERROR I RECEIVE
> >
> > C:\>scripts\test_mssql.pl
> > Name "main::rv" used only once: possible typo at
> C:\scripts\test_mssql.pl
> > line 2
> > 5.
> > Can't connect(dbi::ODBC:EggImport-SD something somewhere), no
database
> driver
> > specifi
> > ed and DBI_DSN env var not set at C:\scripts\test_mssql.pl line 13
> >
> > I Created 'EggImport-SD' under System DSN.
> >
> > any help is appreciated!
> > -adam
> >
> >
> >
> >
> >
> > __________________________________________________
> > Do you Yahoo!?
> > HotJobs - Search new jobs daily now
> > http://hotjobs.yahoo.com/
> >
> >
__________________________________________________
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
This message is intended only for the use of the person(s) ("The intended
Recipient(s)") to whom it is addressed. It may contain information which
is privileged and confidential within the meaning of applicable law. If
you are not the intended recipient, please contact the sender as soon as
possible. The views expressed in this communication are not necessarily
those held by LYNX Express Limited.
