[cobalt-users] OBDC driver problem

["Paul Duffield" <paul@xxxxxxxxxxxxx>]

Already gone bald so no hair left to tear out on this one. It's kept me
going for a while not being overly familiar with Raq's and mySQL. (I am
trying at the end of the day to set up phpbb bulletin board.) I have
searched the achieves and can't find anything directly relevant and also
followed the on site instructions on setup to a T to no avail.(even
checking for mySQL packages to uninstall first etc.)

I have installed the mySQL pkg and seem to have it running OK on the
cobalt Raq 4 and managed to change the default password etc. Tried to
set up a DSN in the GUI and filled in the boxes as far as I can see
correctly (tried a few different settings just in case in desperation) 

I keep getting the following message when I click the test connection
link...

***
server - default 
Test DSN - aflpbb 
-----------------------------------------

Test connecton failed

Error: -2147418113
Description: Can not load OBDC driver 
 
****

I have slightly differing version of driver apparently from the MySQL
package and wondered if that had anything to do with it ? I can't seem
to find anyway of upgrading the driver on the RAQ though. I am not sure
that is the problem though. I think it may be a wider ranging problem
this one example and don't have any other DSN set up on this machine.



Version of mySQL package installed: MySQL Release 3.23.54-1 
(password changed from default via telnet to custom one.)


DSN:   aflpbb

Data base type:   MySQL 3.22.32-1

Description: AFLP Database DSN

Driver: /home/chiliasp/odbc/opensource/lib/libmyodbc.so

Server: localhost     (also tried IP address)

Port:  3306    (also tried blank)

Database:   aflpbb

User:    joebloggs    (user name for database)

Password:  ********

Use Cursoe Lib:  1  (also tried 0)

***

In case it is useful here is the other installed pkg's

Relational Database Server and Client tools by InterBase. Release V6.0 
MySQL Release 3.23.54-1 
Cobalt OS Release 6.0
RaQ4-All-Kernel Release 1.0.1-2.216C28III
RaQ4-All-Security Release 0.0.1-8061
RaQ4-All-Security Release 1.0.1-10098
RaQ4-All-Security Release 1.0.1-10108
RaQ4-All-Security Release 1.0.1-10125
RaQ4-All-Security Release 1.0.1-10602
RaQ4-All-Security Release 1.0.1-10750
RaQ4-All-Security Release 1.0.1-2-10014
RaQ4-All-Security Release 1.0.1-2-9847
RaQ4-All-Security Release 1.0.1-4-10628
RaQ4-All-Security Release 1.0.1-8232
RaQ4-All-Security Release 1.0.1-8532
RaQ4-All-Security Release 1.0.1-8747
RaQ4-All-Security Release 1.0.1-9100
RaQ4-All-Security Release 1.0.1-9353
RaQ4-All-Security Release 1.0.1-9531
RaQ4-All-Security Release 1.0.1-9648
RaQ4-All-Security Release 1.0.1-9844
RaQ4-All-Security Release 1.0.1-9878
RaQ4-All-Security Release 1.0.2-5-9769
RaQ4-All-Security Release 1.0.2-9077
RaQ4-All-Security Release 1.0.2-9078
RaQ4-All-Security Release 1.0.2-9353
RaQ4-All-Security Release 1.0.3-8762
RaQ4-All-System Release 1.0.1-10659
RaQ4-All-System Release 1.0.1-8-9925
RaQ4-All-System Release 1.0.1-8572
RaQ4-All-System Release 1.0.1-9259
RaQ4-All-System Release 1.0.1-9447
RaQ4-All-System Release 1.0.1-9819
RaQ4-All-System Release 1.0.1-9882
RaQ4-All-Security Release 1.0.1-9972
RaQ4-en-OSUpdateRelease 1.0
Third Party Disaster Recovery Release 1.0.2-9198 
RaQ4-en-SystemRelease 1.0.7-9229
RaQ4LE-All-SystemRelease 0.0.1-9340
PHP Release 4.1.2-3 

Any help on this much appreciated before I start growing hair again...

Regards,

Paul Duffield