Hi folks,

I've installed 4.6 on a SLES 10 server and it works ok flat files.

I've compiled mysql, imported tables, setup bbdb.cfg but it doesn't work.

The underlying configuration -

unixodbc

odbcinst -j

unixODBC 2.3.1

DRIVERS............: /usr/local/etc/odbcinst.ini

SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini

FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources

USER DATA SOURCES..: /root/.odbc.ini

SQLULEN Size.......: 4

SQLLEN Size........: 4

SQLSETPOSIROW Size.: 2

mysqlodbc driver

/usr/local/bin/cmake -G "Unix Makefiles" -DWITH_UNIXODBC=1

Driver then added -

./myodbc-installer -s -a -c2 -n "bbro" -t "DRIVER=/mysql-connector-odbc-5.1.11-src/lib/libmyodbc5.so;SERVER=localhost;DATABASE=bbro;UID=user;PWD=pwd"

/usr/local/bin/isql -v bbro

Success!

/usr/local/etc/odbc.ini

[bbro]
Driver=/mysql-connector-odbc-5.1.11-src/lib/libmyodbc5.so
SERVER=localhost
UID=user
PWD=pwd

DATABASE=bbro
PORT=3306

I've set USEDB in bbdef-server.sh

bbdb.cfg

DATA_SOURCE="bbro"

SAVEALL_DB="yes"

I've also tried setting USER_DB, PASSWORD_DB

ODBCINI="/usr/local/etc/odbc.ini"

LIBODBC_PATH="/usr/local/lib"

BBSVR_NAME="localhost"

But always

processing db configuration file: /home/bb/bb4.60-bbpe/etc/bbdb.cfg --- done

database enabled

Failed to connect database

*** BBSERVER STARTUP FAILED ***

Is there anything more I can test to get whats wrong, or any clues as to what I've missed ?

Thanks

Elaine