UltraDev4 Problems Connecting to Paradox 9 Database

[Bystander]

Hi,

Has anyone been able to use Dreamweaver UltraDev 4 with Paradox 9? Everytime I try to get a connection via ODBC I get a message saying that there are no tables in the database even though there are several. I want to publish a database to a web site for staff data entry purposes.

Has anyone got any tips? Is there some special ODBC driver or something that I am missing?

Many thanks

Regards

Bystander

 

[mlawson]

Hi Bystander,

(Great name, apt for your issue!)

The issue with Paradox and Filemaker is that while they use the same ODBC drivers and you can get a 'connection' to the database, the fact is that they don't use a table and field structure like that of Access. There is no fix for this I'm afraid, the only way around the Filemaker issue is to use a custom programmed interface that acts as interpreter between the two apps. Paradox, it would appear, acts in pretty much the same way, while it allows for fairly complex scripting, the manner in which stores and recalls information is unique to the application.

Sorry it's not good news, but if there is a web publishing facility (like Filemaker has) you may wish to choose that route for publication of records.

M

 

[Bystander]

Hi M,

Thanks for the response. I am deeply disconcerted seeing as I can use virtually every other ODBC compliant application with Paradox.

I am sort of hoping that tomorrow there will be a post saying "gotcha April fools etc etc"

Oh well I think I am going to have to use Access after all and capture data from there to Paradox.

Many thanks again.

Bystander

 

[mlawson]

Sorry B,

April fool's tricks are fun, but not for this!!

If it's any consolation (probably not) I too had to make the swap, but it's been a blessing in diguise as there are a lot of forums out there worth looking at. One worth looking at is the discussion forum at

http://www.access-programmers.co.uk.

This has help at every level and is particularly good. Of course Tek-Tips too has a fine collection of individuals, they get shirty when you use the term Motely Crew!

Have fun!

M

 

[Bystander]

M,

Just a quick update to say that I am now able to connect using an Intersolv OEM 2.12 32-Bit ParadoxFile driver. It is only a trial version but it works perfectly except for an annoying message telling me to buy a licence within 30 days. I might succeed with Paradox and Ultradev yet.

Regards

Bystander

 

[mlawson]

Hi Bystander,

Now this is interesting, a lot of third party vendors are compiling ODBC bridges for fairly unique db systems, there is one available for FileMaker but I would have to sell a kidney to finance it, hence my rather rapid learning curve of Access and SQL. How much are they charging for this product?

M

 

[Bystander]

Hi M,

I haven't checked the price yet. I want to take a bit of time to go through my various developer CDs and check to see if I have a full version. I understand that it should be on the Paradox developers cd or free with the Paradox BDE.

I'll let you know how I get on.

Regards

Bystander