Read MySQL tables with Paaradox 8

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
> 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.
>
>
>
>
 >> Stay informed about: Read MySQL tables with Paaradox 8 

Thank you for the information. Of course all of my testing was done with
the MySQL 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:
> 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
> 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.
>
>
>
>
 >> Stay informed about: Read MySQL tables with Paaradox 8 

To expand on what was already said

You are encountering a known problem,
which was cause by XP SP2,
and cause certain dialog boxes in pdox to stop working.

Recommendations include :

1 ) Try Proview, a project viewer alternative

2 ) Code your queries/sql and run in script or form.

3 ) Sometimes I was able to back door into a query using the data model

4) Possibly use notepad to create a blank query with one field picked, then
open with query, design

5 ) Upgrade to Pdox X3


With a small piece of code you coudl try something like this,

var
stTable string
tview tableview
endvar

stTable = ":work:claimsall"
tview.open(stTable)

Possibly that woudl pop the table open on the screen if the alias is
correct.

Just a few midnight ideas to add to the brainstorm session.

Good luck

Robert Wiltshire
 >> Stay informed about: Read MySQL tables with Paaradox 8 

Ross

Proview is a free with a small fee to unlock all of the developer features
found at
http://vmsoft.org/
The free version provides all of the feature of the Paradox Project Viewer
for access to SQL databases. It should solve your problem in Paradox 8.

HTH - Rick

"Ross" wrote in message

> Thank you for the information. Of course all of my testing was done with
> the MySQL 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:
>> 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
>> 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.
>>
>>
>>
 >> Stay informed about: Read MySQL tables with Paaradox 8