dbTalk Databases Forums  

Read MySQL tables with Paaradox 8

Go Back dbTalk Databases Forums Databases comp.databases.paradox Read MySQL tables with Paaradox 8

comp.databases.paradox comp.databases.paradox


Discuss Read MySQL tables with Paaradox 8 in the comp.databases.paradox forum.



Reply
Page 3 of 3 < 1 2 3
 
Thread Tools Display Modes
  #21  
Old   
Robert Wiltshire
 
Posts: n/a

Default Re: Read MySQL tables with Paaradox 8 - 12-13-2008 , 12:50 AM






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















Reply With Quote
  #22  
Old   
Robert Wiltshire
 
Posts: n/a

Default Re: Read MySQL tables with Paaradox 8 - 12-13-2008 , 12:50 AM






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















Reply With Quote
  #23  
Old   
Rick Rans
 
Posts: n/a

Default Re: Read MySQL tables with Paaradox 8 - 12-13-2008 , 01:33 PM


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" <fraserr (AT) cox (DOT) net> wrote

Quote:
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" <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.


Reply With Quote
  #24  
Old   
Rick Rans
 
Posts: n/a

Default Re: Read MySQL tables with Paaradox 8 - 12-13-2008 , 01:33 PM


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" <fraserr (AT) cox (DOT) net> wrote

Quote:
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" <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.


Reply With Quote
  #25  
Old   
Rick Rans
 
Posts: n/a

Default Re: Read MySQL tables with Paaradox 8 - 12-13-2008 , 01:33 PM


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" <fraserr (AT) cox (DOT) net> wrote

Quote:
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" <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.


Reply With Quote
  #26  
Old   
Rick Rans
 
Posts: n/a

Default Re: Read MySQL tables with Paaradox 8 - 12-13-2008 , 01:33 PM


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" <fraserr (AT) cox (DOT) net> wrote

Quote:
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" <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.


Reply With Quote
  #27  
Old   
Rick Rans
 
Posts: n/a

Default Re: Read MySQL tables with Paaradox 8 - 12-13-2008 , 01:33 PM


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" <fraserr (AT) cox (DOT) net> wrote

Quote:
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" <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.


Reply With Quote
  #28  
Old   
Rick Rans
 
Posts: n/a

Default Re: Read MySQL tables with Paaradox 8 - 12-13-2008 , 01:33 PM


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" <fraserr (AT) cox (DOT) net> wrote

Quote:
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" <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.


Reply With Quote
  #29  
Old   
Rick Rans
 
Posts: n/a

Default Re: Read MySQL tables with Paaradox 8 - 12-13-2008 , 01:33 PM


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" <fraserr (AT) cox (DOT) net> wrote

Quote:
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" <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.


Reply With Quote
Reply
Page 3 of 3 < 1 2 3

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top