Re: Failure of ODBC connection with Access

2002-09-02 Thread Liu Haifeng
MAIL PROTECTED]> Sent: Friday, August 30, 2002 10:39 PM Subject: RE: Failure of ODBC connection with Access > Ahh...thanks John. I forgot that BINARY_LOCATION needs to be passed when > doing perl Makefile.PL, not when doing nmake... I fixed my script and the > one up on the ft

RE: Failure of ODBC connection with Access

2002-08-30 Thread Jeff Urlwin
Ahh...thanks John. I forgot that BINARY_LOCATION needs to be passed when doing perl Makefile.PL, not when doing nmake... I fixed my script and the one up on the ftp site. Regards, Jeff > > > Jeff Urlwin [EMAIL PROTECTED] wrote: > > > >> > >> 2. The perl I use is also Activeperl build 633. I

Re: Failure of ODBC connection with Access

2002-08-30 Thread John
Jeff Urlwin [EMAIL PROTECTED] wrote: > >> >> 2. The perl I use is also Activeperl build 633. I have no idea why I >> cannot install dbd::odbc succesfully. > > I don't know. It might be a flag in the ppd file, but the ppd is > generated by MakeMaker directly. It also says, in the ppd file, that

RE: Failure of ODBC connection with Access

2002-08-30 Thread Jeff Urlwin
cross-post to dbi-users (which I did here) as you will get a more broad level of support. I don't know everything :) Jeff > - Original Message - > From: "Jeff Urlwin" <[EMAIL PROTECTED]> > To: "Liu Haifeng" <[EMAIL PROTECTED]>; "Jeff

RE: Failure of ODBC connection with Access

2002-08-28 Thread Jeff Urlwin
quot;foo"; print '$dsn'; #prints $dsn vs. print "$dsn"; #prints foo Jeff > -Original Message- > From: Liu Haifeng [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 28, 2002 10:34 PM > To: Jeff Urlwin; [EMAIL PROTECTED] >

Re: Failure of ODBC connection with Access

2002-08-28 Thread Liu Haifeng
t; <[EMAIL PROTECTED]>; "Jeff Urlwin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 29, 2002 10:17 AM Subject: RE: Failure of ODBC connection with Access > I have a few questions: > > What's the error message? > What version of t

RE: Failure of ODBC connection with Access

2002-08-28 Thread Jeff Urlwin
where "newgene" is a system DSN I have added. > > I do use DBD::ODBC 0.28. Any more suggestions? > > Regards > Haifeng > > - Original Message - > From: "Jeff Urlwin" <[EMAIL PROTECTED]> > To: "Liu Haifeng" <[EMAIL PROTECTED]>

Re: Failure of ODBC connection with Access

2002-08-28 Thread Liu Haifeng
Liu Haifeng" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, August 28, 2002 8:32 PM Subject: RE: Failure of ODBC connection with Access > > > > Hi, > > > > I am wondering how to successfully connect to Microsoft Access > > database using DB

RE: Failure of ODBC connection with Access

2002-08-28 Thread Jeff Urlwin
> > Hi, > > I am wondering how to successfully connect to Microsoft Access > database using DBD::ODBC. Here is the snippet of my code: Use perldoc DBD::ODBC and you will see an example of a DSN-less connection, which is what you are trying to do. Otherwise, setup a system DSN and use DBI->conne

Re: Failure of ODBC connection with Access

2002-08-28 Thread Simon Oliver
> my $dbn="driver=Microsoft Access Driver (*.mdb);dbq=\\\genethon\\data > ^ need another backslash here! -- Simon Oliver