Just a thought, have you tested that the odbc link itself is working?
You can test it with isql DSN UID PWD options
where DSN is in your case apparently maxdb. For options: "-v" for
verbose is interesting.
If you can connect with isql; your odbc configuration is OK, if you
can't maybe these suggestions can help:
In your /etc/odbcinst.ini:
I found that the Setup variable had to point to the unixODBC template
file. Setup = /usr/lib/unixODBC/libsapdbS.so.1.0.0 Although I think this
parameter is only important for the unixODBC gui tool.
Your /etc/odbc.ini file seems OK.
What I also found out is that I need a symlink from
/etc/unixODBC/odbc.ini (or /etc/odbc.ini in your case) to .odbc.ini in
my home directory for isql to work.
But here start the problems for me too.
I want to connect to maxdb with perl using DBI and DBD::odbc but I
can't get it to work although the odbc connection is OK.
Greetz,
Filip
On Sat, 2004-01-24 at 09:35, Christian Welzel wrote:
> Good morning,
>
> i have the following problem:
>
> i'm trying to get maxdb 7.5.0.5 with Apache-SSL 1.3.26, PHP 4.1.2 and unixODBC
> 2.1.1 working. the webserver is running on a debian stable machine, the
> db-server is a debian unstable machine.
>
> after a day of work i got maxdb running with TST database.
> I installed unixodbc on our webserver and configured it:
>
> --- /etc/odbcinst.ini ---
> [ODBC]
> Trace = No
> Trace File = /tmp/sql.log
> Pooling = No
>
> [maxdb]
> Description = Max DB
> Driver = /usr/local/lib/libsqlod.so
> Setup = /usr/lib/libodbcdinst.so.1
> FileUsage = 1
> ----------
>
> The /usr/local/lib/libsqlod.so is the one from 7.5.0.5 tgz ball.
>
> --- ~www-data/.odbc.ini ---
> [maxdb]
> Description=Max-DB
> Driver=maxdb
> ServerNode=<db-server-ip>
> ServerDB=TST
> -----------
>
> Now i have written a little php-test-script:
> <?
> $conn = odbc_connect("maxdb", "test", "test");
> odbc_close($conn);
> ?>
>
> Now i can see in "x_server -i -D 3 start" :
> ---- snipp ---
> 12872 XSERVER Accepted connection, socket: 5 Id 1
> 12873 XSERVER 1 | Client node '<www-server-fqdn>'
> 12857 SERVER Forked child pid 1580
> 12874 XSERVER 1 | INFO request(51) Ref 0 Peer Ref 0
> 12875 XSERVER 1 | Service USER(0) DB TST Ref 135336024 Peer Ref 16384
> 12876 XSERVER 1 | INFO reply(52)
> 12858 SERVER Exiting pid 1580 exit code 0
> 12872 XSERVER Accepted connection, socket: 5 Id 2
> 12873 XSERVER 2 | Client node '<www-server-fqdn>'
> 12857 SERVER Forked child pid 1581
> 12874 XSERVER 2 | USER CONNECT request(61) Ref 0 Peer Ref 0
> 12875 XSERVER 2 | Service USER(0) DB TST Ref 135336024 Peer Ref 36736
> 12876 XSERVER 2 | USER CONNECT reply(62)
> 12858 SERVER Exiting pid 1581 exit code 10
> 12872 XSERVER Accepted connection, socket: 5 Id 3
> 12873 XSERVER 3 | Client node '<www-server-fqdn>'
> 12857 SERVER Forked child pid 1582
> 12874 XSERVER 3 | INFO request(51) Ref 0 Peer Ref 0
> 12875 XSERVER 3 | Service USER(0) DB TST Ref 135336024 Peer Ref 16384
> 12876 XSERVER 3 | INFO reply(52)
> 12858 SERVER Exiting pid 1582 exit code 0
> 12872 XSERVER Accepted connection, socket: 5 Id 4
> 12873 XSERVER 4 | Client node '<www-server-fqdn>'
> 12857 SERVER Forked child pid 1583
> 12874 XSERVER 4 | USER CONNECT request(61) Ref 0 Peer Ref 0
> 12875 XSERVER 4 | Service USER(0) DB TST Ref 135336024 Peer Ref 36736
> 12876 XSERVER 4 | USER CONNECT reply(62)
> 12858 SERVER Exiting pid 1583 exit code 10
> ---- snipp ----
>
> And then something dies.
> The Browser says: Connection to host www was lost.
>
> I'm new to odbc and maxdb, so my question:
> can someone tell me the reason for this behavior ?
> what does exitcode 10 mean?
> how can i fix that ?
>
> thanks in advance.
>
> --
> MfG, Christian Welzel
> (Sektionsvorsitzender und Admin AG DSN Gerokstrasse)
>
> GPG-Key: http://www.wh9.tu-dresden.de/~gawain/www.camlann.de/key.asc
> Fingerprint: 4F50 19BF 3346 36A6 CFA9 DBDC C268 6D24 70A1 AD15
--
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
* System Engineer, Verzekeringen NV *
* www.verzekeringen.be *
* Oostkaai 23 B-2170 Merksem *
* 03/6416673 - 0477/340942 *
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
