Read MySQL tables with Paaradox 8

#1

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.

#2

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:

Quote:

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 (AT) cox (DOT) net> a écrit dans le message de news:
4942145c$1 (AT) pnews (DOT) 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.

#3

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:

Quote:

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 (AT) cox (DOT) net> a écrit dans le message de news:
4942145c$1 (AT) pnews (DOT) 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.

#4

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:

Quote:

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 (AT) cox (DOT) net> a écrit dans le message de news:
4942145c$1 (AT) pnews (DOT) 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.

#5

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:

Quote:

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 (AT) cox (DOT) net> a écrit dans le message de news:
4942145c$1 (AT) pnews (DOT) 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.

#6

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:

Quote:

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 (AT) cox (DOT) net> a écrit dans le message de news:
4942145c$1 (AT) pnews (DOT) 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.

#7

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:

Quote:

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 (AT) cox (DOT) net> a écrit dans le message de news:
4942145c$1 (AT) pnews (DOT) 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.

#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:

Quote:

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 (AT) cox (DOT) net> a écrit dans le message de news:
4942145c$1 (AT) pnews (DOT) 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.

#9

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:

Quote:

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 (AT) cox (DOT) net> a écrit dans le message de news:
4942145c$1 (AT) pnews (DOT) 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.

#10

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:

Quote:

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 (AT) cox (DOT) net> a écrit dans le message de news:
4942145c$1 (AT) pnews (DOT) 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.