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.phpIn 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/[EMAIL PROTECTED]
