Error updating batch microsoft odbc sql server driver
I downloaded an informix 64bit driver 3.00FC then set system dsn which works fine when i apply and test the connection.
I tried to create a new linked server using Microsoft OLE simple provider against the odbc when I get this error Does anyone have any suggestions?? Connection Info) ------------------------------ Cannot initialize the data source object of OLE DB provider "MSDAOSP" for linked server "CERP".
:) Siggy _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/odbc_connect ERRO at DB2_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/To Solve the problem with DB2 PHP folow this steps! -- DB2 --Install the Data Bank Install Application Tools-- END DB2 ----- APACHE ---cd ../mod_ssl-2.8.5-1.3.22/./configure --enable-module=so --with-apache=../apache_1.3.22/ --with-ssl=../openssl-0.9.6c/cd ../apache_1.3.22/makemake certificate TYPE=custommake install--- END APACHE ----- PHP --cd ../php-4.1.1/./configure --with-apxs=/usr/local/apache/bin/apxs --with-pgsql --with-mysql --with-ibm-db2=/usr/IBMdb2/V7.1makemake install-- END PHP ----- LIB --vim /etc/confadd line: /usr/IBMdb2/V7.1/libexecute: ldconfig-- END LIB --To Solve the error ODBC_CONNECT exec the db2profile at the apachectl!!! -- APACHE EDIT TO RUN DB2 --vim /usr/local/apache/bin/apachectladd line: .
/usr/home/db2inst1/sqllib/db2profile-- END APACHE EDIT TO RUN DB2 --NOW run /usr/local/apache/bin/apachectl startssl DONE !!!!! Enjoy s Helio Ferenhof We've tried hard to connect from php to our IBM DB2 RS/6000 Server.
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified If you keep running into this on the 64 bit versions of windows, ie server 2008, and none of the other solutions helped.
In a 64 bit windows server operating system, there are TWO odbc managers.
All I got is this message: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path.
My workaround was to design my script exit entirely after a the database update had completed.
I wrote a script using the PHP5 CLI binary that monitors a directory for changes, then updates a Network Server SQL Anywhere 8 database when a change was detected.
Idealy, my program would run indefinately, and issue odbc_connect()/odbc_close() when appropriate.
However, it seems that once connected, your odbc session is limited to 30 seconds of active time, after which, the connection becomes stale, and no further queries can be executed.
Instead, it returns a generic "Authentication violation" error from the odbc driver.