Forums

This topic is locked

Access with MySQL

Posted 29 Jul 2001 01:33:48
1
has voted
29 Jul 2001 01:33:48 Patrick Meunier posted:
Hi everybody,<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

I decide to get Access 2000 to administrate my db. First I've installed MyODBC. After, I make my DSN to ISP...All is okay,I can retrieve db from ISP. But when I want esport it to my ISP it tell me there was an error #0...

Is anyone know how to correct that???


Patrick
-------------------
Reset! The one magical button!!

Patrick
------------
Reset! The one magical button!

Replies

Replied 29 Jul 2001 12:03:52
29 Jul 2001 12:03:52 Bruno Mairlot replied:
I suggest you to download binaries of MySQL for Windows.

In the package you'll find the executable "mysql" that you can configure to connect to your ISP db.

If error there is, you'll find much better error message.

The message you've got with Access are Access's message, you won't find any useful info for your connection. And furthermore, ODBC doesn't let you alter table.

You still have PHPMyAdmin, wich is a very powerful web-based mysql client. But you'll have to have PHP installed.

Then, post the error message you have, so we could help you.

"First they laugh at you, then they fight you, then you Win..." Ghandi
Replied 31 Jul 2001 02:32:19
31 Jul 2001 02:32:19 Tim Green replied:
Also, it should be noted that MyODBC doesn't yet support Access 2000.

Tim Green

Extension & PHP TalkZone Manager

------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
------------------------------------------
Replied 31 Jul 2001 06:07:56
31 Jul 2001 06:07:56 Patrick Meunier replied:
Hi,

I finally abandon for the moment the access gesiton on mysql.....Access 97 doesn't change anything...I will continu with command line in phpmyadmin...
Thanks all


Patrick
----------------------
Reset!The one magical button!!!


Patrick
------------
Reset! The one magical button!

Reply to this topic