Using ODBC Remote View into Paradox

[MdotButler]

I am running into an issue trying to establish a remote connection to a Paradox database. I setup an ODBC driver pointint to the database directory. I then use that connection and setup a remote view as with any other remote database. The view works fine. I can browse the database, setup a parameterized view...

The problemn is that if anyone using the parent application, written in Delphi, I get an error when I try to access the database. The AERROR() returns a 1526, and a message stating a 11270 error being returned from the ODBC driver.

BTW the remote view is set to no update and the exclusive checkbox in the ODBC setup is not checked.

Anybody have any wisdom to share on this one?

TIA
Mark

 

[Mike Lewis]

Mark,

I'm not sure I can help, except to say that I have been in exactly the same situation. The only difference is that I was trying to access the Paradox database from Crystal Reports rather than VFP, but otherwise the symptoms were the same.

I complained to the people who had written the Delphi application, and they admitted it was because they had some sort of exclusive use of the database (I didn't get all the details from them). They said it would be technically possible for them to solve the problem, but not commercially worthwhile. So I was stuck with it.

The best thing you can do is to contact the people who wrote the Delphi application, and hope they are more helpful than mine were.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)