RE: ODBC error I do not understand.

[Jeff Urlwin]

Which version of DBD::ODBC are you using?  There was a bug in prior versions (which are still in ActiveState's repository) which caused a memory over-write.  I've fixed that in later versions.  You can retrieve the latest version from:

    ftp://ftp.esoftmatic.com/pub/outgoing/DBI

 

Please take BOTH the DBI and DBD::ODBC and let me know if your problem persists.  What I may need is a small, wrapped up example of the database and the script, as I don't have foxpro itself.

 

Regards,

 

Jeff

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Norris, Joseph
Sent: Friday, August 30, 2002 3:26 PM
To: Perl Database (E-mail); Perl Admin (E-mail); Perl Win32 Users (E-mail)
Subject: ODBC error I do not understand.

Here I am again with my problem of reading a FoxPro table with DBI::ODBC.

 

I am getting the following error on a simple query:

 

DBD::ODBC::st execute failed: [Microsoft][ODBC Driver Manager] Program type out of rang
e (SQL-S1003)(DBD: describe/SQLBindCol err=-1) at hr_phone_compare.pl line 134.
could not do select employee.empl_no, employee.user_ln,
                        employee.user_fn, employee.user_mi,
                        employee.aka from employee
                        where Employee.empl_no = 2671 - [Microsoft][ODBC Driver Manager
] Program type out of range (SQL-S1003)(DBD: describe/SQLBindCol err=-1)  at hr_phone_c

 

Any help would be appreciated.

 

 

Thanks.