E
Ezaz War
Guest
yes i do have odbc inst variable set and the contents i will specify below odbc.ini [ODBC Data Sources] Progress=Progress_SQL92_Driver [Progress] Driver=/usr/dlc/odbc/lib/pgoe27.so HostName=mytest DatabaseName=testdb PortNumber=5555 QEWSD=2457141 [ODBC] InstallDir=/usr/dlc/odbc Trace=1 TraceFile=/tmp/odbctrace.out TraceDll=/usr/dlc/odbc/lib/pgtrc27.so UseCursorLib=0 odbcinst.ini [ODBC] Trace = no TraceFile = /tmp/odbctrace.out TraceDll=/usr/dlc/odbc/lib/pgtrc27.so [ODBC Drivers] Description = Progress driver [Progress OpenEdge 11 Driver] Driver=/usr/dlc/odbc/lib/pgoe27.so FileUsage = 1 and php script is $dsn = "Progress"; putenv("ODBCINI=/etc/odbc.ini"); putenv("ODBCINST=/etc/odbcinst.ini"); Print "Test ODBC Progress "; $sql="SELECT * FROM PUB.Customer"; $hostname ="mytest"; $portnumber =5555; $databaseName ="testdb"; $conn_string = "Driver={Progress OpenEdge 11 Driver}; HostName=" .@ $hostname . "; PortNumber=".@ $portnumber ."; DatabaseName=" .@ $databaseName . "; DefaultIsolationLevel=READ COMMITTED;"; if ($conn_id=odbc_connect($conn_string,"sysprogress","sysprogress")){ echo "connected to DSN: $dsn "; if($result=odbc_do($conn_id, $sql)) { echo "executing '$sql'"; echo " Results: "; odbc_result_all($result, "BGCOLOR='#AAFFAA' border=3 width=30% bordercolordark='#FF0000'"); echo "freeing result"; odbc_free_result($result); }else{ echo "cannot execute '$sql' "; } echo " closing connection $conn_id"; odbc_close($conn_id); }else{ echo " cannot connect to DSN: $dsn "; } /* phpinfo(); */ ?> following error is generated if i use the odbcinst's Progress OpenEdge 11 Driver SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in /var/www/html/dbcheck.php on line 15 cannot connect to DSN: Progress can u help me with this
Continue reading...
Continue reading...