Search results for query: *

I get a Error Message when I get to intRecordAffected. The Error Message is Syntax Error. Here is the code for Update: Dim cmd As ADODB.Command Set cmd = New ADODB.Command cmd.ActiveConnection = cn 'cmd.CommandText = strSQL 'Declare and Set the RecordSet Dim rs As...

The ERROR MESSAGE is between the ************ ************ Set cn = CreateObject("ADODB.Connection") cn.ConnectionString = "Provider=vfpoledb.1;Data Source =D:\PerCap1\percap2.dbf" cn.Open 'Formatting Date strSTR =...

Access foxpro database with VB 6.0. I get error message when I get to this code: Set rs = cmd.Execute The error message is: The connection cannot be used to perform this operation. It is Either closed or invalid in this context. This is the code to connect: Dim cn As New...

Connection to foxpro databases use vb 6.0. I'm getting a error message: The connection cannot be use to perform this Operation. It is either closed or invalid in this context. This is the code: Dim cn As New ADODB.Connection cn.Open "Provider=vfpoledb.1;" & _...

Problem installing vfpoledb.exe

ACCESS FOXPRO DATABASE WITH VB6 I get a error message: [Microsoft][odbc.driver manger] data source not found and no default driver specified. Set cn = New ADODB.Connection cn.Open "Driver={Microsoft dBase Driver(*.dbf)};" _ & "DriverID=277;" _ &...

Using VB6.0 and need to access FoxPro database. I downloaded vfpoledb. It still doesn't work.

How to access foxpro database using visual basic 6.0. I get a error message: Unrecognized database format.

How to change Access Database to Foxpro Database