, April 08, 2005 8:07 PM
To: Moreno, Javier; dbi-users@perl.org
Subject: Re: Accessing MS Access
From: Moreno, Javier [EMAIL PROTECTED]
Date: 2005/04/08 Fri PM 03:44:40 CDT
snip
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
On Apr 11, 2005 12:35 PM, Moreno, Javier [EMAIL PROTECTED] wrote:
Ok. I have tried ADO as well with no luck. Please help!
snip
# Include CPAN modules for DB communication
use DBI;
#use DBD::ODBC;
use DBD::ADO;
#use Win32::OLE;
# Use these pragmas to code correctly
use strict;
#
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!
snip
my ($path_to_mdb_file) = '\\slpmxwtstandclu\testdata$\Data_2.mdb';
Aha!
You are
Hi all,
This is probably a more DB oriented question, but it came out of the DBI. 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. What I had to end
up doing was create a DTS that runs every 5 minutes
From: Moreno, Javier [EMAIL PROTECTED]
Date: 2005/04/08 Fri PM 03:44:40 CDT
snip
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.
snip
I was wondering if there is a better way to get information
from
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?
If
, 2005 6:45 PM
To: Moreno, Javier
Cc: dbi-users@perl.org
Subject: Re: Accessing MS Access through the DBI ODBC
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
, Javier
Cc: dbi-users@perl.org
Subject: Re: Accessing MS Access through the DBI ODBC
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
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 =
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
Hi all,
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.
Regards,
Javier Moreno
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
12 matches
Mail list logo