Error 42000 microsoft odbc visual foxpro driver syntax error

broken image
broken image
broken image

I'm trying to access an MS-Access database and using an Odbc dataAdapter and a datset fill an asp:repeater controlĭim m圜onn As New OdbcConnection(ConfigurationSettings.AppSettings('my_Connectionstring'))ĭim mySQL As String = 'SELECT Shout_User, Shout_Message, Shout_Date FROM Shout ORDER BY Date DESC'ĭim m圜md As New OdbcCommand(mySQL, m圜onn)ĮRROR Too few parameters. Try cn = New OdbcConnection( 'Driver= Dbq=\\192.168.1.7\e$\microzone backup\microzone.mdb' )Ĭn.Open()cmd = New OdbcCommand( 'select * from customerproduct where ClientNumber=' + ComboBox1.Text + '', cn)ĮRROR Too few parameters. Private Sub ComboBox1_SelectedIndexChanged( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged