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

["Clayton McGow" <mrwilder@xxxxxxxxxxx>]

Karl Middleton wrote:
> 
> 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.
> 
> Can anyone help?
> 

This works for me:

If you have mysql installed and running on the server side,
and Access and the ODBC drivers one the client side, you
just need to

1) make sure there is a user with access from "%" in the sql
users table on the server 

2) create a user DSN on your client computer with the
correct server IP, user name, and password of the
priviledged user ... you do this in you ODBC datasources
control panel (it's on your computer now if you have the
ODBC drivers installed) OR optionally with a third party app
like the BDE Administrator.

3) open Access, crate a blank database, select "get external
data" from the file menu... when the "open" dialog box
appears, scroll through the "files of type" drop down list
until you get to "ODBC Databases"... a "Select Data Source"
window will appear, click the "MAchine Data Source" tab at
the top of the window... look  through the list until you
find the data source you created in your control panel

4) client will connect and show available tables in database
chosen from user DSN, select it and say "OK"

5) the table is now visible in Access database


-- 
Clayton McGow
mrwilder@xxxxxxxxxxx