Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Set date format to VFPOLEDB
Message
De
14/09/2009 08:36:18
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01424074
Message ID:
01424094
Vues:
85
>You can send SET DATE TO DMY command after openning ADO connection

Sergey, I get the error indicated below
Local loConn as "ADODB.Connection", loCmd as "ADODB.Command"
***
loConn = CreateObject("ADODB.Connection")
loConn.ConnectionString = "Provider=VFPOLEDB.1;Data Source='Base\Scd4.dbc';Password='';Collating Sequence=MACHINE"
loConn.Open()
***
loCmd  = CreateObject("ADODB.Command")
loCmd.ActiveConnection = loConn
loCmd.CommandText = "SET DATE TO DMY" && You can send SET DATE TO DMY command after openning ADO connection
loCmd.Execute() && OLE IDispatch exception code 0 from Microsoft OLE DB Provider for Visual FoxPro: Occurs one or more errors on the processing command...
loConn.Close()
***
* loConn.Execute("SET DATE TO DMY") && do the same error
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform