Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set date format to VFPOLEDB
Message
From
14/09/2009 08:36:18
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01424074
Message ID:
01424094
Views:
83
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform