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

Advanced
-Collapse +Expand PHP Store
PRESTWOODSTORE

Prestwood eMagazine

June 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)  
Yesid.B
-- --

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>";
exit;


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 16 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=505
Last Reply Posted 2/17/2020 12:41:38 AM)
Location=-- -- 
Joined=46 months ago   MB Posts=4  
Most Recent Post
Suleman
Solutions Corporation
-- USA

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

high-performance metal detector

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

Follow PrestwoodBoards on: 


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