I.T. Discussion Community!
-Collapse +Expand
Search PHP Group:

-Collapse +Expand PHP Store

Prestwood eMagazine

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

   ► MB LobbyPHP & Delphi for PHP BoardPHP Topic   Print This     

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)  
Most Recent Post
-- --

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 9 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, No Replies Be the first!
Thread Started 2/13/2019 7:43:54 AM
View Counter=264
Location=-- -- 
Joined=39 months ago   MB Posts=4  

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 = P1145A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #17425 Counter
Since 2/13/2019

Follow PrestwoodBoards on: 

©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech