Re: MS access
"Martin J. Evans" <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.general |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected] <mailto:[email protected]>> 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