Re: Accessing MS Access

2005-04-11 Thread amonotod
> From: Kevin Carothers <[EMAIL PROTECTED]> > Date: 2005/04/11 Mon PM 03:06:59 CDT > On Apr 11, 2005 12:35 PM, Moreno, Javier <[EMAIL PROTECTED]> wrote: > > Ok. I have tried ADO as well with no luck. Please help! > > my ($path_to_mdb_file) = '\\slpmxwtstandclu\testdata$\Data_2.mdb'; > > Aha! > Y

Re: Accessing MS Access

2005-04-11 Thread Kevin Carothers
On Apr 11, 2005 12:35 PM, Moreno, Javier <[EMAIL PROTECTED]> wrote: > Ok. I have tried ADO as well with no luck. Please help! > > > > # Include CPAN modules for DB communication > use DBI; > #use DBD::ODBC; > use DBD::ADO; > #use Win32::OLE; > > # Use these pragmas to code correctly > use stric

RE: Accessing MS Access

2005-04-11 Thread Moreno, Javier
TTWeb/cgi-bin/Welcome.pl Regards, Javier Moreno -Original Message- From: amonotod [mailto:[EMAIL PROTECTED] Sent: Friday, April 08, 2005 8:07 PM To: Moreno, Javier; dbi-users@perl.org Subject: Re: Accessing MS Access > From: "Moreno, Javier" <[EMAIL PROTECTED]> > Dat

Re: Accessing MS Access

2005-04-08 Thread amonotod
> From: "Moreno, Javier" <[EMAIL PROTECTED]> > Date: 2005/04/08 Fri PM 03:44:40 CDT > I posted a question and have tried several solutions on how to open > up an MS Access DB from the DBI::ODBC but so far have been unable to. > I was wondering if there is a better way to get information > from

RE: Re: Accessing MS Access through the DBI ODBC

2005-04-03 Thread Jeff Urlwin
> > Just my opinion, but I don't think this is good advice. For > one, it creates extra administration on the system, by > forcing the user/programmer /sysadmin/webadmin to create an > ODBC DSN setting for every new setup. For two, DBI and ODBC > both support dynamic DSNs, so why not use them

Re: Accessing MS Access through the DBI ODBC

2005-03-31 Thread Kevin Carothers
Hi Javier, [---] > And on the log I get: > [Thu Mar 31 07:12:56 2005] [error] [client 151.110.117.153] DBI > connect('CLUCTR','',...) failed: [Microsoft][ODBC Microsoft Access Driver] > The Microsoft Jet database engine cannot open the file '(unknown)'. It is > already opened exclusively by

Re: Re: Accessing MS Access through the DBI ODBC

2005-03-31 Thread amonotod
> From: Kevin Carothers <[EMAIL PROTECTED]> > Date: 2005/03/30 Wed PM 06:44:48 CST > 1. Create an ODBC connection via %SystemRoot%\system32\odbcad32.exe > Call the database connect name "ODBCName" > > 2. In your Perl code add: > [---] >use DBI; > [---] >$dbh = DBI->connect("db

RE: [dbi] RE: Accessing MS Access through the DBI ODBC

2005-03-31 Thread Martin J. Evans
utput the DBI error string which should be available > print "$DBI::errstr\n"; > > # Before dying attempt a database disconnect just in case > $::rc = $::dbh->disconnect or die "FATAL ERROR. Unable to disconnect from > database."; >

RE: Accessing MS Access through the DBI ODBC

2005-03-31 Thread Moreno, Javier
$::rc = $::dbh->disconnect or die "FATAL ERROR. Unable to disconnect from database."; } # Unable to continue. We know why so just die die; } Regards, Javier Moreno -Original Message- From: Kevin Carothers [mailto:[EMAIL PROTECTED] Sent: Wednesda

Re: Accessing MS Access through the DBI ODBC

2005-03-30 Thread Kevin Carothers
Hi Javier, > I am trying to access an MS Access database via perl DBI and I am unable to. > I checked the security and there is only one 'Admin' user with no password > and I use that in my connection string. However, I cannot connect. Please > help. > 1. Create an ODBC connection via %Sys