libsqlod.so is not using the same path as php binary and as module in apache
in binmode
/usr/spool/sql/ini/odbc.ini
or
~/.odbc.ini
or
/etc/odbc.ini
are working
as module in apache
only
/etc/odbc.ini
ist working
regards
Albert
Albert Steckenborn schrieb:
> Hi folks,
>
> is fixed now.
> Problem is related by spaces in odbc.ini like
> ServerDB = DBNAME --> does not work
> ServerDB=DBNAME --> DOES WORK !!!
>
> Thanks for all hints
>
> regards
>
> Albert
>
> 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
>>>
>>
>
