>>HI,
>>
>>I need to create a connection to Visual Foxpro DBC database for query specific table documentos and insert the result into Cursor for creating a new table on SQL server to insert the result of my cursor.
>>This is my code:
>>
>>LOCAL loConnection
>>loConnection = CREATEOBJECT("ADODB.Connection")
>>
>>
>>SET DATE BRITISH
>>
>>lcDBCPath = Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=D:\1.Bnext_Espanha\Orozco\EMP01\gestion.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO;
>>
>>
>>
>>* Attempt to establish a connection
>>TRY
>> loConnection.Open(lcDBCPath)
>> ? "Connected to the database successfully."
>> * Now you can execute SQL commands and queries.
>>
>> * For example, retrieve data from a table
>> lcSQL = "SELECT * FROM documentos"
>> loCursor = loConnection.Execute(lcSQL)
>> ? loCursor.GetString()
>>
>> * Don't forget to close the connection when done
>> loConnection.Close()
>>CATCH TO loError
>> ? "Failed to connect to the database. Error: " + loError.Message
>>ENDTRY
>>
>>
>>But i have this error:
>>Date/datetime contains illegal characters.
>>
>>Someone could help me , please.
>
>Surround the connectstring with quotation marks. It's trying to evaluate it as an expression, and the first thing after the equal sign is delimited with curly braces, which Fox tries to evaluate as a date expression.
>
>Hi Dragon,
>
>Please could you rewrite for me in correct way?
Just this line:
lcDBCPath = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=D:\1.Bnext_Espanha\Orozco\EMP01\gestion.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO;"
Hi Dragan,
Thanks to your reply, but VFP return this Error:
Failed to connect to the database.Error: OLE
IDispatch exception code 0 from Microsoft OLE DB
Provider for ODBC Drivers:[Microsoft][Gestor de
controladores de ODBC] O nome da origem de dados não foi encontrado e não foi especificado
nenhum controlador predefinido..
Do you an idea about why this error occur?
Thanks,
Luis