From: fraserr@cox.net
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" a écrit dans le message de news:
> 4942145c$1@pnews.thedbcommunity.com...
>> 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.
>
>
>
>
--- SoupGate-Win32 v1.05
* Origin: you cannot sedate... all the things you hate (1:229/2)
|
