Eserim;162789 Wrote: > I'm having problems with the oDBC setting for MySQL - using the beta > versio 5 driver. > > The options needed are Data Source Name (I assume this can be what I > want to call it) > server (the slimserver prefs have this as the loop-back ip address of > 127.0.0.1 > User - I'm using slimserver > No password > Database - slimserver? > Port 9092? > > And yet not seeing any tables when I try and connect in MS Access. > > Any ideas? > > Cheers > > Eserim
Your port should be defined in your slimserver.pref file on the dbsource line. My port is not 9002 but something else as defined by the MySQL setup. Your Data Source Name will be "slimserver" unless you've defined something else in slimserver.pref file. You could also try the MySQL Query Browser http://dev.mysql.com/doc/query-browser/en/index.html to ensure the ODBC portion is not causing problems. When I use this on my setup I have to define the following parameters: Server host name (location where slimserver is running). Port (already mentioned) Username (dbusername as found in slimserver.pref file) Password (dbpassword as found in slimserver.pref file) Default Schema (slimserver unless otherwise definded in slimserver.pref file). HTH -- Linzer -- Linzer ------------------------------------------------------------------------ Linzer's Profile: http://forums.slimdevices.com/member.php?userid=462 View this thread: http://forums.slimdevices.com/showthread.php?t=30510 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
