From: Tim H. <th...@op...> - 2006-10-30 18:00:11
|
On 30 Oct 2006, at 17:17, Daniel Kowalewski wrote: > >> Hello all, >> >> I'm in the process of trying to set up PHP, iODBC and apache but >> I am >> getting stuck when configuring PHP to use the iODBC framework as >> opposed >> to Shared Library, here is what I am doing: >> [] >> * start apache >> >> * run test script which errors: >> >> Warning: odbc_connect() [function.odbc-connect >> <http://journalsurf.learningmedia.co.nz/function.odbc-connect> ]: >> SQL >> error: [DataDirect][ODBC 20101 driver]1220, SQL state S1 in >> SQLConnect >> in /Library/WebServer/production/journal_surf/test3.php on line 15 >> >> can not connect to DSN: Fmtest >> >> * phpinfo() matches build date but odbc still uses shared libray > > > I am having this same problem. Does anyone have a solution? I presume you mean a failure to connect? I had a response off-list from Justin to my previous suggestions saying that reinstalling the iODBC framework had worked for him. Failing that, check that you're actually picking up the right odbc.ini (if need be, use SetEnv to specify ODBCINI in httpd.conf or the PHP script) and enable tracing: [ODBC] Trace = 1 TraceFile = /tmp/odbctrace-$P-$T.log Debug = 1 DebugFile = /tmp/odbcdebug-$P-$T.log Then those file(s) should tell us more. Regards, ~Tim -- Tim Haynes OpenLink Software <http://www.openlinksw.com/> |