Re: bug in libsqlod.so MYXDB 7.5.08 ???????

Have tested a little bit more with php (binary Version).

There are no differences between local connect and connect to other machine.

ODBC_CONNECT("<IP>:<DB>","<user>","<password"); is working
Can't use the previous one because machines are changing from time to time.

ODBC_CONNECT("<DB>","<user>","<password"); fails with following message:
PHP Warning:  odbc_connect(): SQL error: [MySQL MaxDB][LIBSQLOD SO] Data
source name not found and no default driver specified, SQL state IM002
in SQLConnect in conntest.php


In previous Versions of libsqlod.so odbc.ini in /usr/spool/sql/ini 
(linked to /var/spool ) is used but with this version it is not longer 
working.

Please tell me what has changed!!!!


regards

Albert Steckenborn



Albert Steckenborn schrieb:
> That's the PHP-Error:
> PHP Warning:  odbc_connect(): SQL error: [MySQL MaxDB][LIBSQLOD SO] Data 
> source name not found and no default driver specified, SQL state IM002 
> in SQLConnect in <path_to_indep_prog>
>
> With the same odbc.ini it is working in SAPDB 7.3/7.4 and MAXDB 7.5.05
>
> It looks as if the MAXDB don't use the odbc.ini(Data Source name not 
> found) and/or needs some more declarations(and no default driver 
> specified), but where or which??????
>
> Can't find anything about changes in ODBC at the documentation.
>
>
>
> regards
>
> Albert Steckenborn
>
> Albert Steckenborn schrieb:
>
> > hi folks,
> >
> > today we've upgraded SAPDB 7.4.30 to 7.5.08 at one of our Webservers.
> > In the past Database was not running (installation only for connect to 
> > database-machines via ODBC).
> >
> > After Upgrading we could not connect any longer to the other machines 
> > (with php).
> >
> > We need this Upgrade for replacing the MYSQL Database at this machine 
> > using the MaxDBProxy and MAXDB.
> >
> > Are there some changes needed in /var/spool/sql/ini/odbc.ini for MAXDB 
> > 7.5.08???
> >
> > [DB1]
> > DSN = 192.168.1.2:DB1
> > SERVERDB = DB1
> > SERVER = db_server1
> > SERVERNODE = 192.168.1.2
> >
> > We have recompiled php (--with-sapdb=/usr/local/sapdb/indep_prog).
> >
> > thanks for all your hints
> >
> > regards
> >
> > Albert Steckenborn


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx