Connect to .dbf table

Expand Post »

Hello guys,
im trying to connect to .dbf table every time i try to query from the table it gives a error
[Microsoft][ODBC Visual FoxPro]Operator/operand type ,mismatch

heres my sample code...

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
        Dim conn As ADODB.Connection
        Dim squery As String
        Dim rs As ADODB.Recordset
        Set conn = New ADODB.Connection
        conn.Open "Driver={Microsoft Visual FoxPRO Driver};SourceDB=" & App.path & ";SourceType=DBF"
 
        squery = "Select * from employee where Card_no=" & Format(Enrollnumber, "00000") & ""
        Set rs = New ADODB.Recordset
        rs.Open squery, conn
 
        Text1.Text = rs!Fname
        Dim conn As ADODB.Connection
        Dim squery As String
        Dim rs As ADODB.Recordset
        Set conn = New ADODB.Connection
        conn.Open "Driver={Microsoft Visual FoxPRO Driver};SourceDB=" & App.path & ";SourceType=DBF"
       
        squery = "Select * from employee where Card_no=" & Format(Enrollnumber, "00000") & ""
        Set rs = New ADODB.Recordset
        rs.Open squery, conn
        
        Text1.Text = rs!Fname

thanks..

Similar Threads

reading records from a .dbf file in Visual Basic 4 / 5 / 6
Create Table on SqlServer Through Asp.net coding in ASP.NET
foxpro help in MS Access and FileMaker Pro
Need Help connecting to a view in MS SQL

royaloba

Reputation Points: 13

Solved Threads: 1

Junior Poster in Training

Offline

54 posts
since Sep 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Controlling simple devices in VB4/VB5

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: VB6 & Access (user name, network printer, reminders)

DaniWeb Message

Cancel Changes

User Name
Password