Re: Read MySQL tables with Paaradox 8
- From: fraserr <fraserr@xxxxxxx>
- Date: Fri, 12 Dec 2008 13:59:37 -0700
Thank you for the information. Of course all of my testing was done with the MS 5.1 and Intersolv ODBC drivers. Have not digested your paper yet..
What I am doing is taking MySQL tables generated by my web store software, and adding records to make them usable by my accounting software. I am not a programmer (retired telecommunications systems designer), so it takes a while to get past the tech jargon.
Does your paper show a way to read MySQL tables with Paradox8, XPSP2 and ODBC, or must I upgrade to Paradox 11? I guess I could set up a test machine on my lan with XPSP1 to do the development if necessary...
Another alternative is to save and resave the tables after running Paradox in a backup .sql file using PHPMyAdmin built into the web store software. Would that work?
Thanks
Ross
Côme de Christen wrote, On 12/12/2008 2:56 AM:
Hi.
I believe you face the XP >= SP2 Paradox >=7 Alias problem
The Alias listbox does not work correctly with SQL alias
This is corrected starting Paradox 11 and is ok with 7 or less
You work by code or try Proview
This article I wrote can help you I hope :
http://www.clairinfo.fr/scripts/trace.php?noart=13
Côme
"Ross" <fraserr@xxxxxxx> a écrit dans le message de news:
4942145c$1@xxxxxxxxxxxxxxxxxxxxxxxxxxx
Trying to read and modify an existing MySQL database that resides on my
PC using Paradox 8. Have set up the MySQL ODBC driver and DSN of the
local MySQL server in XP, but when I try to open the tables in Paradox,
can not see the tables. I think the alias is set up in Paradox, but can
not find the tables in Paradox. Where do I look for the tables, and what
suffix will they have?
The same MySQL database can be read using Access 97 and the same ODBC
driver.
- Prev by Date: Re: Paradox and Vista problems
- Next by Date: Missing file
- Previous by thread: Can I do this?
- Next by thread: Missing file
- Index(es):
Relevant Pages
|
