> 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
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
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
> 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
>
> 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
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
> 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
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.";
>
$::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
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
10 matches
Mail list logo