[unixODBC-support] unixODBC to run BO XI 3.1

[Edward Berwick]

Thanks Nick,

first person who's given me any sort of direction at all in the last few
days so much appreciated.

I done as you said well not exactly but I think you may have had a few
format typo's in you email

you asked me to
dltest /home/eberwick/Desktop/bobje/mysql-odbc*/lib/libmyodbc5.so

This didn't work however this one came back OK.
[eberwick at moran lib]$ dltest
/home/eberwick/BO_3_1/bobje/mysql-odbc/lib/libmyodbc5.so
SUCCESS: Loaded /home/eberwick/BO_3_1/bobje/mysql-odbc/lib/libmyodbc5.so

Maybe I should show you the odbc.ini file (it's not pretty, I've been
fiddling with it now for a few days) - see below. That in *Bold *is the
original according to my BO documentation.

Next in your email you mentioned
"I would first try and get MyODBC working using isql and the normal unixODBC
ini files /etc/odbc.ini and /etc/odbcinst.ini
It may be something as simple as the MyODBC driver failing to find its
client libs."

[root at moran bin]# isql -v BOE120_AUDIT
Segmentation fault

Any more help greatly appreciated.

Thanks again, Ed


[ODBC Data Sources]
CRSQLServerWP=DataDirect 5.3 SQLServer Wire Protocol Driver
CRSybaseWP=DataDirect 5.3 Sybase Wire Protocol Driver
CRText=DataDirect 5.3 Text Driver
*BOE120_AUDIT=auditor*
default=portland
%SYBASEDSN%=DataDirect 5.3 Sybase Wire Protocol Driver
myodbc5-medialayers = MyODBC 5.1 Driver DSN


*[BOE120_AUDIT]
Driver=/home/eberwick/BO_3_1/bobje/mysql-odbc/lib/libmyodbc5-5.1.5.so
Description=auditor
SERVER=moran.anam.com
PORT=3306
USER=Administrator
Password=
Database=BOE120_AUDIT
OPTION=3
SOCKET=
Trace=off
stmt=SET CHARACTER SET utf8
*





#[myodbc5-MARS]
#Driver       = /usr/lib/libmyodbc5.so
#Description  = Connector/ODBC 5.1 Driver DSN
#SERVER = portland.anam.com
#PORT         = 6400
#USER         = eberwick
#Password     = monday!!
#Database     = MARS
#OPTION       = 0
#charset      = utf8
#SOCKET       = /var/lib/mysql/mysql.sock

#[default]
#Driver=/home/eberwick/BO_3_1/bobje/mysql-odbc/lib/libmyodbc5.so
#Description=mars
#SERVER=portland.anam.com
#PORT=3306
#USER=root
#Password=monday!!
#Database=MARS
#OPTION=3
#SOCKET=
#Trace=off
#stmt=SET CHARACTER SET utf8







2009/1/15 Nick Gorham <nick at lurcher.org>

> Edward Berwick wrote:
>
>  I've been rying to get my unixODBC up and running for the last week.
>>
>> I'm following some Business Objects official documentation on how to
>> install
>> configure the unixODBC. Due to versioning etc. I'm, never gonna get an
>> exact
>> match between my work and that described step by step in the document.
>>
>> The first divergence from the process was when I was instructed to
>>
>> # ./configure --prefix=/tmp/unixODBC --enable-gui=No
>>
>> I could not run this statement with the option "--enable-gui=No", likewise
>> it did not work for "--enable-gui=Yes". I had to remove it altogether
>> before
>> being able to run the configure command. I don't know whether this will
>> have
>> much of a bearing further down the track (any obvious foobar's please let
>> me
>> know).
>>
>>
>>
> Ok, its because the gui parts have been moved to a seperate project, but I
> think I will add the option back in for backwards compatibility.
>
> I would first try and get MyODBC working using isql and the normal unixODBC
> ini files /etc/odbc.ini and /etc/odbcinst.ini
>
> It may be something as simple as the MyODBC driver failing to find its
> client libs.
>
> Try
>
> dltest /home/eberwick/Desktop/bobje/mysql-odbc*/lib/libmyodbc5.so
>
> To see if if can be loaded
>
> --
> Nick
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20090115/72844d99/attachment.html>