Hi people, I have following prob

[baco1]

Hi people,

I have following problems.

1)After I installed MySQL as local server on my PC, I also installed MyODBC-Driver as interface between Paradox and MySQL. Then I created a test-table in MySQL, but if I want to open the table in Paradox, the table is getting open as a ".txt"-file.
Question: Why is it so? And how can I remove this problem?

2)I would like to export all of my tables(ca.500) from Paradox into MySQL, so that in future I can grasp at them working in Paradox. How can I realize that?

You are my last hope amigos !
Help - I need somebody
Help - not just anybody
Heeelp...;-)

Greetings
El Baco

 

[footpad]

El Baco,

This is a question more properly posted to a MySQL forum.

However, I can tell you that you need to:

a) Install myOBDC (available from the MySQL web site)
b) Use the BDE administrator to create an ODB alias that uses the MyODBC driver to connect to an existing MySQL database.
c) Verify the connection works from the BDE Administrator.

Once you've done that, you can expert your Paradox data to MySQL tables simply by copying the tables to the MySQL alias you created.

For additional information, I recommend the following articles:

--

http://www.rdaworldwide.com/pdox/odbc.pdf

This discusses how to connect Paradox to ODBC data sources.

--

http://www.ibphoenix.com/a538.htm

While this discusses the process from an InterBase standpoint, it is an excellent introduction to the overall issues.

Hope this helps...

-- Lance