|
Hi, I try to connect to a firebird 2 database via php - odbc driver,
but i can't. My php code is <?php $dbh = odbc_connect('bd1','',''); $res = odbc_exec($dbh, 'select * from personas'); ?> And when execute results in this error: Warning: odbc_exec() [function.odbc-exec]: SQL error: [unixODBC][ODBC Firebird Driver][Firebird]invalid database handle (no active connection), SQL state S1000 in SQLExecDirect in /media/windowsd/Informacion/Gerardo/MisPhp/Clipper/prottv/prueba1.php on line 3 Is like, the connection fails isn't it? But when I try to connect from other sources, like OpenOfficeBase or the utility "DataManager" from unixodbc i can connect. Even had some problems with the utility ODBCConfig from unixodbc. When i try use it for create de Dsn drivers, it show a error message "Could not construct a property list for (Firebird)" and fires me away. Then I create the content of the odbcinst.ini odbc.ini with a scite text procesor. Well I triying to resolve this five days ago , find documentation, the web etc. etc. and I can't solve it. Could you helpme ? Below (some aditional data about my configuration files) Thanks in advance from Uruguay Gerardo I' Using Ubuntu Linux 8.04 LTS Install unixodbc, and the firebird driver (libOdbcFb.so in /usr/lib/odbc) and restart the lighty web server. My odbcinst.ini file on /etc is [ODBC] FileDSNPath = /etc/ODBCDataSources/ [Firebird] Description = InterBase/Firebird ODBC Driver Driver = /usr/lib/odbc/libOdbcFb.so Driver64 = Setup = /usr/lib/odbc/libOdbcFb.so Setup64 = UsageCount = CPTimeout = CPReuse = My odbc.ini file on /etc is [BDBam] Description = Otra base Firebird Driver = Firebird Dbname = localhost:/media/windowsd/Informacion/Gerardo/MisPhp/Clipper/BDBam.fdb User = sysdba Password =masterkey [bd1] Description = Prototitpo TodoTv. base firebird Driver = Firebird Dbname = nicasio:/media/windowsd/Informacion/Gerardo/MisPhp/Clipper/bdProTTV.fdb User = sysdba Password =masterkey Role = CharacterSet = ReadOnly = No NoWait = No |
------------------------------------------------------------------------------ AppSumo Presents a FREE Video for the SourceForge Community by Eric Ries, the creator of the Lean Startup Methodology on "Lean Startup Secrets Revealed." This video shows you how to validate your ideas, optimize your ideas and identify your business strategy. http://p.sf.net/sfu/appsumosfdev2dev
_______________________________________________ Firebird-odbc-devel mailing list Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
