VB FoxPro 2.6 table(dbf) SQL and Unrecognized Verb:/
- From: "Grzesiek Mrozu" <chicagomotherfucker@xxxxx>
- Date: 29 Sep 2005 11:22:09 -0700
Hi
I made small app, which have to get data from FoxPro 2.6 table(dbf),
and export it to Excel work***. I wrote code to connect:
Dim cnn As New adodb.Connection
Dim rs As New adodb.Recordset
'cnn.ConnectionString = "Provider=MSDASQL.1;Persist Security
Info=False;Extended Properties=Driver={Microsoft Visual FoxPro
Driver};UID=;SourceDB=c:\mrc\TABLE;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=No;Deleted=Yes;"
cnn.ConnectionString = "Provider=MSDASQL.1;Persist Security
Info=False;Extended Properties=Driver={Microsoft Visual FoxPro
Driver};UID=;SourceDB=C:\FIRM0007;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=No;Deleted=Yes;"
cnn.Open
Set rs = cnn.Execute("select * from dokument")
cnn.Close
And unfortunately it is bad:/ I have error "[Microsoft][Visual FoxPro]
Unrecognized command verb"
Can anyone help me?? I don't understand where is mistake.
Thanks
Mrozu
.
- Prev by Date: Re: bind HTML table to ADO persisted recordset client-side
- Next by Date: ADO connection question
- Previous by thread: bind HTML table to ADO persisted recordset client-side
- Next by thread: ADO connection question
- Index(es):