RE: [cobalt-users] What's needed to run MyODBC ??

["Tony" <isplists@xxxxxxxxxxxx>]

+Subject: [cobalt-users] What's needed to run MyODBC ??
+
+
+I'm trying to connect a database on a Windows 98 PC to the MySql database
+on a RAQ4 system.
+
+On the Windows PC I've a choice between Foxpro and Access. I've also
+installed the MyODBC driver on the windows PC.
+
+What do I need to install / run on the RAQ4 to allow connections ?
+I can't find any useful info in the archives or in the RAQ4 manuals.



Open ODBC in Windows Control Panel
Verify that the MyODBC driver is installed on the Driver Tab
Select either the USER DSN or SYSTEM DSN tab
You want to add a DSN.
Click 'Add' and it will bring you to a scroll window to select a driver.
Scroll down and select 'Mysql'
Next window will bring up the TCX Data AB MySQL info window.
It will ask you for:
-a DSN name, (your choice)
-MySQL Host: enter the Raq's domain or preferably the IP address
-MySQL DB Name: The name of the MySQL database on the Raq
-User: This is the MySQL user name you created
-Password: The MySQL user password.
-Port: 3306 is the default.

Click OK and you're done.
Then you can use your Access or Foxpro Windows database to connect to
the MySQL server version.
This is assuming you've properly set-up the MySQL database, user and
privleges.


Tony