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

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

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

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox to/from Other Data Sources Topic   Print This     

Paradox & Custom ODBC Driver

Paradox & Custom ODBC Driver in Paradox to/from Other Data Sources topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Paradox   Paradox &   Paradox & Custom   ODBC Driver  
PS_1743
-- USA

Does Paradox support connecting to 3rd party or custom ODBC data sources? I have one installed, see it in the BDE Administrator, but can't find where I can connect to it from within Paradox.

 Posted 8 months ago (Thread Starter)
Comment Quote
About PS_1743 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
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 #17267, 7 replies
Thread Started 9/27/2018 10:44:09 AM
View Counter=635
Last Reply Posted 10/3/2018 1:47:51 PM)
Location=-- USA 
Joined=8 months ago   MB Posts=3  
Moderator
Steven.G
Myrtle Beach, SC USA

sorry, it's been a long time since I've done that.. it's probably in the Database type.. open a database, run a sql transaction/queery?

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 7 months ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17270 (Level 2) and Parent is 17267
Reply Posted 10/1/2018 11:09:47 AM
Location=Myrtle Beach, SC USA 
Joined=32 months ago   MB Posts=264  
Moderator
Mike Prestwood
Prestwood IT
Prestwood IT office in Citrus Heights, CA

To add an ODBC data source, first define its DSN.  Once defined (created), you'll see it listed when you create a Database alias in the Database Driver Name dropdown (default's to STANDARD).

--
Mike Prestwood
Prestwood IT Solutions

 Posted 7 months ago
Comment Quote
About Mike Prestwood -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Mike Prestwood

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Web Presence
Facebook, Prestwood IT Facebook page -- fan page. (Visit Me)
Twitter, Follow Prestwood IT on Twitter. (Visit Me)
LinkedIn, Prestwood IT company page on LinkedIn. (Visit Me)
YouTube, Prestwood IT YouTube Channel (Visit My Channel)
Website, My drum website where I sell my drum books. (http://www.play-drums.com)

Post ID #17271 (Level 3) and Parent is 17267
Reply Posted 10/1/2018 11:32:05 AM
Location=Prestwood IT office in Citrus Heights, CA 
Joined=19 years ago   MB Posts=1410   KB Posts=1805   KB Comments=75   BLOG, Topics=4  
Moderator
Steven.G
Myrtle Beach, SC USA

that makes way more sense than what I suggested :-)

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 7 months ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17272 (Level 4) and Parent is 17267
Reply Posted 10/1/2018 11:52:32 AM
Location=Myrtle Beach, SC USA 
Joined=32 months ago   MB Posts=264  
PS_1743
-- USA

When I go to the Alias Manager and choose the "Driver Type" drop down, it only shows me STANDARD, DB2, FOXPRO, INFORMIX, INTRBASE, Microsoft Access, Microsoft dBASE, Microsoft Excel, MSACCESS, MSSQL, ORACLE, and SYBASE.

None of those are one of the 3rd party ODBC drivers I'm looking for that I have installed.  I can see the driver I'm looking for via the 32-bit ODBC Data Sources on either the "User DSN" or "System DSN" tabs.  I can also see these drivers via the BDE Administrator tool.

Is Paradox hard-coded to only know about the specific ODBC drivers listed above?

 Posted 7 months ago (Thread Starter)
Comment Quote
About PS_1743 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
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 #17273 (Level 5) and Parent is 17267
Reply Posted 10/2/2018 6:03:04 PM
Location=-- USA 
Joined=8 months ago   MB Posts=3  
Moderator
Steven.G
Myrtle Beach, SC USA

yes, those are the other drivers / platforms that existed back in 2003, and the driver versions by default are from the "latest and greatest" versions of those platforms, at that time

that's the list in "Drivers\NATIVE".. have you looked in "Drivers\ODBC", below that?

again, I'll defer to others for suggested current alternatives

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 7 months ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17276 (Level 6) and Parent is 17267
Reply Posted 10/3/2018 8:28:48 AM
Location=Myrtle Beach, SC USA 
Joined=32 months ago   MB Posts=264  
rum
Frankfort, KY USA

I haven't tested these suggestions,  but have you looked into this website?

http://mc-computing.com/Databases/BDE.html

 Posted 7 months ago
Comment Quote
About rum -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 #17277 (Level 7) and Parent is 17267
Reply Posted 10/3/2018 8:33:34 AM
Location=Frankfort, KY USA 
Joined=23 months ago   MB Posts=79  
Most Recent Post
PS_1743
-- USA

Thanks for the quick responses.  The link to the BDE helped me get the ODBC driver setup and I can now see it in Paradox.

Thanks!

 Posted 7 months ago (Thread Starter)
Comment Quote
About PS_1743 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
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 #17278 (Level 8) and Parent is 17267
Reply Posted 10/3/2018 1:47:16 PM
Location=-- USA 
Joined=8 months ago   MB Posts=3  

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 = P1261A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #17267 Counter
635
Since 9/27/2018
Follow PrestwoodBoards on: 


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