I have used basic Perl quite extensively but I'm new to DBI and I'm having
problems connecting to an old dBase IV database using a dbi:ODBC connection.
I'm running Windows 2000 Professional and have set up a DSN to connect to my
target database using the Data Sources (ODBC) applet in the Windows Control
Panel. If I open up MSQuery and use this DSN I can view the data in the
dBase database OK. The DSN uses the
Microsoft dBase Driver (*.dbf). However when I try and use DBI the line in
my program
my $dbh = DBI->connect("dbi:ODBC:$dsn_name");
produces the following error:
failed: [Microsoft][ODBC Driver Manager] Invalid string or buffer length
(SQL-S1090)(DBD: db_login/SQLConnect err=-1) at TestODBC.pl line 45.
I've had a look at what is in the .dsn file and there is an entry
"MaxBufferSize=2048" and I wonder if for some reason this is the entry
that's causing the problems in DBI although not is MSQuery.
Can anyone suggest why my connection won't work?
