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

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

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardQBE & SQL Topic   Print This     

Using MS SQL as back end

Using MS SQL as back end in QBE & SQL topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Using MS   Using MS SQL   back end  
simd01
Local Software
Terrigal, -- AU

I need to set MS SQL up as the back end to a large multi-user paradox 10 app and am having trouble finding discussions of the issues involved.

Can someone either point me to the relevant documents or briefly describe the various problems one is going to confront in achieving this?

Many thanks.

 Posted 11 years ago (Thread Starter)
Comment Quote
About simd01 -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About simd01
I have been programming (and earning a living) in Paradox since version 1 in 1987. It's been pretty good to me so far but things have really slowed down in the last few years!!

Post ID #14048, 2 replies
Thread Started 4/22/2010 6:13:04 PM
View Counter=3649
Last Reply Posted 5/2/2010 9:58:20 PM)
Location=Terrigal, -- AU 
Joined=13 years ago   MB Posts=8  
Anonymous Post

It has been a long time since I have used SQL data with Paradox. I remember the basic process I used was the SQL ODBC driver, setup a DSN, add an ODBC alias to the BDE that uses the DSN. I ran into some field name problems and I remember there was no way to convert formatted memo fields (rich text) so I had to manually massage all the memo fields to just straight text.

Prior to going the above route, I used Borland's SQL Links (native SQL driver in BDE as an alias) but they deprecated those back in 2001 or so and I don't think that route works any more with the newer SQL servers.

---
Robert M.
 Posted 11 years ago
Comment Quote

Post ID #14062 (Level 1.1)  Reply to 14048
Thread Started 4/30/2010 9:26:00 AM
Most Recent Post
simd01
Local Software
Terrigal, -- AU

Robert,

many thanks for that. I had been using the SQL link but that was the problem. Once I set up the ODBC DSN and then an alias as you suggested I was up and running.

Thanks again - you've made my day.

Simon

 Posted 11 years ago (Thread Starter)
Comment Quote
About simd01 -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About simd01
I have been programming (and earning a living) in Paradox since version 1 in 1987. It's been pretty good to me so far but things have really slowed down in the last few years!!

Post ID #14066 (Level 2.1)  Reply to 14062 and Parent is 14048
Thread Started 5/2/2010 9:55:50 PM
Location=Terrigal, -- AU 
Joined=13 years ago   MB Posts=8  

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 = P1111A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #14048 Counter
3649
Since 4/22/2010

Regarding...

Linked Knowledge Base Article.

This thread is linked to the following KB article.


Mike Prestwood
1. BDE SQL Links Not Maintained

I have an application in Delphi 1-7, using BDE. Is there a way that I can upgrade the BDE so the can work with MSSQL 2005 or 2008. They work fine if MSSQL2000 is is used. Am I on a dead end or there is still hope?

Posted to KB Topic: BDE
11 years ago, and updated 11 years ago
(4 KB Comments)

FAQ
Nothing New Since Your Last Visit
12441
Hits

Pascal and Delphi Coding


Follow PrestwoodBoards on: 


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