Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Fox 2.6 free tables memo field
Message
De
18/10/2005 12:21:20
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Titre:
Fox 2.6 free tables memo field
Divers
Thread ID:
01059945
Message ID:
01059945
Vues:
58
I have a problem with using the code below on a table with a memo field. I get and error that the table was in an unexpected format. It works as expected if I change the field to a char field. I am guessing I need a different driver and connection string that will recognize memo fields.

thanks
 Try

            Dim lcsql As String = "Select * from Margin where pk_id = " & "4"
            Dim lcconstr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\data;Extended Properties=dBASE IV;User ID=Admin;Password="
            Dim ocon As New OleDb.OleDbConnection(lcconstr)
            Dim oda As New OleDb.OleDbDataAdapter(lcsql, ocon)    '

            oda.Fill(ds, "Margin")
            ocon.Close()

        Catch EX As Exception
            MsgBox(vbCr & vbLf & Date.Now & "---Error message---" & EX.Message & "--Stack Trace----" & EX.StackTrace)

        End Try
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform