Problem to connect Paradox with ODBC 
Author Message
 Problem to connect Paradox with ODBC

Hello!
I'm trying to connect a Paradox table to an HTML page through ODBC with Perl
(Win32::ODBC)

Everytime, the error I get when trying to make a SQL request is:
[-5016] [1] [0] "[Microsoft][ODBC Paradox Driver] Unexpected error from
external database driver (11265)."

My code is:

if ($db->Sql("SELECT * FROM mytable;")) {print "\nError: " . $db->Error()}
else {print "\n SQL OK"}

I have checked that mytable exist with the TableList function, and there is
no problem with the connection to the Paradox System DSN I defined.
if I don't choose any table I have that message:
[-3024] [1] [0] "[Microsoft][ODBC Paradox Driver] Query must have at least
one destination field."

If in ODBC, I don't choose to work in the current directory, and choose a
specific one, I can't load the Paradox drivers.

Is that a know issue with Paradox? should I get a latest version of the ODBC
drivers (and where?)

I will try to give you all the information I have:

I just download the latest stable version of Perl, and the last Microsoft
Data Access Drivers (including ODBC).

Here is my full Perl code for information (very simple):

use Win32::ODBC;

if (!($db = new Win32::ODBC("Paradox")))
   {
   print "Error connecting to Paradox\n";
   print "Error: " . Win32::ODBC::Error() . "\n";
   exit;
   } # no problem at that stage

# the error occur here:
if ($db->Sql("SELECT * FROM mytable;")) {print "\nError sql: " .
$db->Error()} else {print "\nSQL OK"}

while ($db->FetchRow())
   {
   print "process result";
   undef %data;
   %data = $db ->DataHash();
   }
$db->Close();

Here are my Paradox driver information:
Microsoft Paradox Driver (*.db ):
UsageCount=2;APILevel=1;ConnectFunctions=YYN;DriverODBCVer=02.50;FileUsage=1
;FileExtns=*.db;SQLLevel=0;CPTimeout=;

Thanks a lot for any help.

Franck



Tue, 03 Sep 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Problem to connect Paradox with ODBC

2. Problem connecting to Paradox DBs from ODBC

3. Problems connecting to network Paradox database via ODBC

4. OLEDB for ODBC - trying to connect to Paradox files - PLEASE HELP

5. DTS using OLEDB for ODBC - trying to connect to Paradox files - PLEASE HELP

6. OLEDB for ODBC - trying to connect to Paradox files - PLEASE HELP

7. OLEDB for ODBC - trying to connect to Paradox files - PLEASE HELP

8. Connecting to a Paradox db via ODBC

9. Trouble connecting to a Paradox table throught ODBC

10. Connecting to paradox database via ODBC client application

11. Connecting Paradox Databases to the Web using PERL and ODBC, FYI

12. ODBC Error connecting to Paradox database


 
Powered by phpBB® Forum Software