PHP ODBC VFP9
The table code for accessing VFP using ODBC is as follows
The table used to manipulate the VFP6 everything is ok but the VFP9 table is not a table. Because VFP9 's table has more than one field that is automatically incremental, it can be accessed by removing the field.
What should I do if I want to access a table with an AutoIncrement field?
Someone on the web said that using OLE DB I also downloaded olddb VFP, but did not know how to use
Reply to discussion (solution)
Latest developments, using ADODB is also a failure
$STRSQL = "SELECT * from ' xxku1 '";
Only MySQL can write like this.
So no matter how you use the VFP version, you won't get the right results.
Download a Vfpodbc.msi (package name Vfpodbc.rar) to install it.
$STRSQL = "SELECT * from ' xxku1 '";
Only MySQL can write like this.
So no matter how you use the VFP version, you won't get the right results.
Download a Vfpodbc.msi (package name Vfpodbc.rar) to install it.
Vfpodbc.msi has installed the
This kind of writing in the VFP 6 table is working normally, just change the VFP9 under the table containing the self-increment field will be an error
The self-increment field is only valid in the library (DBC)
So your ODBC source should be the library (DBC) instead of the free table (DBF)
The self-increment field is only valid in the library (DBC)
So your ODBC source should be the library (DBC) instead of the free table (DBF)
The self-increment field is used the same as in a free table.
I changed this ODBC source to DBC and put this table in and try again. Report the same mistake
Then you'll have to install a vfpoledb to try.
Then you'll have to install a vfpoledb to try.
Installed this
But I don't know how to use it.
Open ($CONNSTR); # $conn = &adonewconnection (' VFP '); # $dsn = "Driver={provider=vfpoledb.1}; SOURCETYPE=DBF; SOURCEDB=F:/DFXT/XJJ; Exclusive=no "; # $conn->connect ($DSN); $strSql = $conn->execute (" SELECT * from Xxku ");? >
Error hints
Error hints
Fatal error:uncaught exception ' com_exception ' with message '
Source:ADODB. Connection
Description:The provider was not found. The program may not be installed correctly. ' In D:\chinaz.com\WebSite\dfxt\TESTADO2. Php:6 Stack Trace: #0 D:\chinaz.com\WebSite\dfxt\TESTADO2. PHP (6): Com->open (' Provider=vfpole ... ') #1 {main} thrown in D:\chinaz.com\WebSite\dfxt\TESTADO2. PHP on line 6