[PHP-DB] ODBTP - ODBC - FOXPRO.

2003-10-17 Thread Ricardo C. Fernandez de C.
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

2003-10-15 Thread Ricardo C. Fernandez de C.
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

2003-10-14 Thread Ricardo C. Fernandez de C.
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