The subject says it all...I have (by now) a pretty decent amount of

experience with ASP 2.0 and  SQL 7.0 but I have a potential client whose

database is Paradox and I need to know if ASP can be used to access a

Paradox database and is there a good book on this?  Or can I use my ASP

knowledge and just pick up a Paradox book to learn the equivalent

expressions, schema, etc. corresponding to what I know in T-SQL?



Thanks,



Ben



--- 

FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

INSIGHTS IN YOUR INBOX!

Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb?s

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

I have recently been working with ASP and Paradox databases.



I am by no means an authority of ASP and databases.



The system I developed worked perfectly when I tested on my server (PWS)

but failed when I uploaded it to my website (which uses IIS 4.0).



I could read the Paradox files but could not update them.



The two of the most frequent error messages I encountered were:-



----------------------------------------------------------------------------------------------------------------------





Microsoft OLE DB Provider for ODBC Drivers error '80004005' 





[Microsoft][ODBC Paradox Driver] Operation not supported on a Paradox

table with no primary key.



---------------------------------------------------------------------------





Microsoft OLE DB Provider for ODBC Drivers error '80004005' 





[Microsoft][ODBC Paradox Driver] External table is not in the expected

format.



---------------------------------------------------------------------------





Both these error messages did not indicate the true cause of my problem.

The files were back loaded from the website and tested ok on my server.



After much research, with no help from my website host who claim that they

fully support Paradox databases, I found the following links which shed

some light on the troubles I had experienced.





http://support.microsoft.com/support/kb/articles/Q237/9/94.ASP?LN=EN-US&SD=SO&FR=1







http://support.microsoft.com/support/kb/articles/Q230/1/26.ASP







It appears that the latest version of the Microsoft Jet Database Engine

(JDE) does not fully support Paradox unless the Borland Database Engine

(BDE) is also installed.





As I use Paradox databases in other applications the BDE is installed on

my system and thus the JDE handles Paradox OK.





On my website host?s server the BDE is not installed and therefore the

Paradox files are read-only. They are not willing to install the BDE so I

have been unable to persue the matter further. Unfortunately I have found

it necessary to use Microsoft Access databases on the web and convert them

back into Paradox databases on my system. I prefer to use Paradox as I

have better support and knowledge for Paradox than I have for Access.





My interpretation of the information contained in the above links, and

others that I followed from them, is that Microsoft Access databases

(*.mdb) are the only ones fully supported without other third party

drivers.



I hope this information is of some help and saves you the problem of

interpreting error messages that do not indicate the true problem.



Should you wish to discuss this further my email is barry@g...



regards



Barry





---

FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS

IN YOUR INBOX!

Get the latest and best HTML, XML, and JavaScript tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb's

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com