[PHP-DB] ODBTP - ODBC - FOXPRO.
Hi all, After reading your emails I installed ODBTP so I could access my ODBC server from my linux box, but i'm still getting some errors, this is my code: ? $link = odbtp_connect('172.16.4.106','Driver={Microsoft Visual FoxPro Driver};SourceDB=c:\telefonia\CDTCTL01.DBF;SourceType=DBF'); ? (the first IP is the IP of my ODBTP/ODBC server). And this is the Error i get: (part is in spanish, i'm sorry for it) Warning: [S1000][1][Microsoft][ODBC Visual FoxPro Driver]Fox Error 1 [IM006][0][Microsoft][Administrador de controladores ODBC] Error de SQLSetConnectAttr del controlador in /var/www/telefonia/registro/prueba_odbtp.php on line 2 (It says something like Error of SQLSetConnectAttr of the device in /var/www/telefonia/registro/prueba_odbtp.php on line 2) Any idea how to fix this? Thanks for the help, -- Ricardo C. Fernández de C. Fundabit - Min. de Educación, Cultura y Deporte. Caracas/Venezuela -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] ODBC
Hi, The only stuff i have found about foxpro and PHP is this: hertz:~# apt-cache search foxpro libphp-adodb - The 'adodb' database abstraction layer for php or do you mean something else? thanks for the help. On Wed, 2003-10-15 at 08:20, Luis M Morales C wrote: Hello Ricardo, I have see an litle class on phpclasses.org that open dbase files. Now on your main problem to connect foxpro data base with php via ODBC you must be made the next step: 1) Check if your Foxpro data base have ODBC drivers installed 2) Made the ODBC connex to create the DSN (you can check how to make an dsn on http://www.weberdev.com) 3) Check your php to verify foxpro api is installed (write an info php file ? phpinfo()? and find foxpro api over dump file info) 4) Try connect to the data base Regards, LM On Wednesday 15 October 2003 07:24, Ricardo C. Fernandez de C. wrote: I guess i will just read the file with the dbase funtions and convert it to psql, its not going to be real time, but oh well, thanks for the help. -- Ricardo C. Fernández de C. Fundabit - Min. de Educación, Cultura y Deporte. Caracas/Venezuela -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] ODBC
Hi all, I have been trying to connect to a windows ODBC controller with PHP, and after reading some of the documentation, I can't make the connection This is the Code I'm using: ? $conn=odbc_connect(Driver={Microsoft Fox Pro Driver};Server= 127.0.0.1;Database=telefonia,,); if(!$conn) { echo Not connected; } ? And i get this Warning Message: Warning: Wrong Parameter count for odbc_connect in c:\apache2\htdocs\od_connect.php on line 2 And of course the Not Connected echo message. Any idea why is this? any good document I can read about PHP-ODBC (ODBC in Windows) besides the official Documentation? any other idea? Thanks, c'ya -- Ricardo C. Fernández de C. Fundabit - Min. de Educación, Cultura y Deporte. Caracas/Venezuela -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php