When you created your DSN for your DB you already specified the driver and
the path and filename for your Access DB, so you don't need to specify this
again in your DBI connection. Also you gave a name to your DSN, so you use
this name to connect. At least this is how have used it:
DBI->connect('DBI:ODBC:myDSN', 'dbusername', 'dbpassword');
where myDSN is the name of your DSN, and of course dbusername and
dbpassword are the username and password for your database.
Hope this helps.
At 10:55 AM 10/23/2001 -0400, you wrote:
>I read on the web that I'm far from being the only one with this
>problem, and I can't find a good solution for the problem.
>
>I made an access DB, created an ODBC DNS with windows 2000 utility
>(altough I'm not sure I did everything correctly)
>
>When I try the connect string:
>
>dbi:ODBC:driver=Microsoft Access Driver (*.mdb);dbq=c:\\clients.mdb
>
>it always get me the error: ([Microsoft][ODBC Driver Manager] Invalid
>string or buffer length (SQL-S1090)(DBD: db_login/SQLConnect err=-1))
>
>I read somewhere that the max lenght was 32 or something, but just
>writing dbi:ODBC:driver=Microsoft Access Driver (*.mdb) is over 32
>chars.
>
>Is there another way of connecting? Am I doing something wrong?
>
>I can connect easily on my mySQL DB but can't get it to work with
>access.
>
>Thanks a lot
>
>Etienne
Javier Dussaillant G.
[EMAIL PROTECTED]
Departamento de Desarrollo VRWEB ltda.
http://www.vrweb.cl
