Your full service technology partner! 
-Collapse +Expand
Search PHP Group:

-Collapse +Expand PHP Store

Prestwood eMagazine

August Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyPHP & Delphi for PHP BoardPHP Topic   Print This    All Groups  

PHP connecting through ODBC for Paradox table(.db)

PHP connecting through ODBC for Paradox table(.db) in PHP topic (part of our PHP & Delphi for PHP group).

Quick Search: connecting   through   Paradox   PHP connecting   PHP connecting through   ODBC Paradox   table( db)  
-- --

Hi, I am trying to connect to a Paradox table in PHP using the INTERSOLV 3.11 32-BIT ParadoxFile (*.db) driver. I have the DSN setup properly; however I am not able to connect with the following code:

if (!$connect = odbc_connect($dsn, "", "")) {
        $messages .= "Failed connected to ODBC. DSN ".$dsn.". Error - ".odbc_errormsg().".";
} else {
        $messages .= "Successfuly connected to ODBC. Database ".$dsn.".";
echo $messages."<br>";

and I receive the following error: SQL error: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed, SQL state IM004 in SQLConnect

I have tried restarting the server as well as reinstalling the MySQL ODBC Driver. I am able to connect to these tables using the set up DSNs through classic ASP, so I am confussed as to why I am not able to connect through PHP. Any help would be greatly appreciated. Thank you.

 Posted 42 months ago (Thread Starter)
Comment Quote
About Yesid.B -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17425, 1 replies
Thread Started 2/13/2019 7:43:54 AM
View Counter=870
Last Reply Posted 2/17/2020 12:41:38 AM)
Location=-- -- 
Joined=6 years ago   MB Posts=4  
Most Recent Post
Solutions Corporation
-- USA

It is a file-based database system with each table in a separate file or files.

high-performance metal detector

 Posted 30 months ago
Comment Quote
About Suleman -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17901 (Level 1.1)  Reply to 17425
Thread Started 2/17/2020 12:40:52 AM
Location=-- USA 
Joined=30 months ago   MB Posts=2  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1126A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #17425 Counter
Since 2/13/2019
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site:

©1995-2022 Prestwood IT Solutions.   [Security & Privacy]