Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC Error #123 - Not A File
Message
 
 
À
08/04/2005 08:38:06
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01002572
Message ID:
01002589
Vues:
19
This message has been marked as the solution to the initial question of the thread.
Jim,

The VFP ODBC driver has not been updated since VFP6SP5. It doesn't support any new table and DBC feature introduced in VFP7 and later. You can use VFP OLE DB provider which is up to date.

>I am trying to insert/update a row on a VFP table using the VFP ODBC driver from VFP9. I make the connection to the database (.DBC) and get back a handle of 1. I can then query the target table and get data back with no problem. But when I submit a SQL UPDATE or INSERT command against the same table SQLEXEC() returns a value of -1. Using AERROR() it is shows me that the ODBC error returned to me is:
>
>AODBCERROR Pub A
> ( 1, 1) N 1526 ( 1526.00000000)
> ( 1, 2) C "Connectivity error: [Microsoft][ODBC Visual F
> oxPro Driver]Not a table."
> ( 1, 3) C "[Microsoft][ODBC Visual FoxPro Driver]Not a t
> able."
> ( 1, 4) C "S0002"
> ( 1, 5) N 123 ( 123.00000000)
> ( 1, 6) N 1 ( 1.00000000)
> ( 1, 7) C .NULL.
>LCERROR Pub C "Connectivity error: [Microsoft][ODBC Visual F
> oxPro Driver]Not a table."
>
>My VFP ODBC driver is version 6.00.8167.00 dated 7/28/2004.
>
>In case you're wondering why I'd want to access a VFP table from VFP via ODBC it's because I'm working on a data manager that my application can switch between a VFP database and a MS SQL Server database without having to change my application.
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform