On 02/11/15 07:51, Ismail Chamseddine wrote:
I am using Active Perl 5.18.4 64 bit on Windows 7 64 bit
The connect string code
my $dbh = DBI->connect('dbi:ODBC:driver=microsoft access driver (*.mdb);
database= C:\Users\User\Documents\Mydb.accdb');
On Fri, Oct 30, 2015 at 4:07 PM, Martin J. Evans > wrote:
On 30/10/2015 13:21, Ismail Chamseddine wrote:
I am trying to connect to MS access database on my PC. I am getting an
error message of failure, data source not found, (ODBC driver manager) no
default driver is mentioned . please help
Please try and help us help you and post more information. What Perl are
you using, on what operating system? Show the extract of perl script calling
DBI's connect method with the arguments. What data sources have you defined in
the driver manager? Are they user or system DSNs? Are you using 32 or 64 bit
platform (on Windows they use different ODBC administrators. What versions of
DBI and presumably DBD::ODBC are you using?
Martin
Please don't reply just to me - keep it on the list.
Try DRIVER= instead of driver= and put {} around the driver name e.g.
'dbi:ODBC:DRVIER={microsoft access driver
(*.mdb)};database=C:\Users\User\Documents\Mydb.accdb'
Martin
