Tim;
I believe you have to use an OLE DB driver rather than ODBC.
Tom
>cannot seem to get a system DSN to work for me for my VisualFoxPro
>Database. I am using the following code which works fine in my Windows App.
>
>Dim cn As New OdbcConnection("DSN=VAM")
>Dim cmd As New OdbcCommand("select nprice from icitem where citemno =
>'A20001'", cn)
>Dim da As New OdbcDataAdapter(cmd)
>Dim ds As New DataSet()
>cn.Open()
>da.Fill(ds, "Price")
>lblTest.Text = ds.Tables("Price").Rows(0).Item(0)
>cn.Close()
>
>I am getting an error in ASP.Net. I do not have any other DSN's with the
>same name (User or file), I am running under administrator's identity for my domain in the
>web.config file. Still I get this error:
>
>ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open file
>g:\vam\data\nps\amw.dbc. ERROR [IM006] [Microsoft][ODBC Driver Manager]
>Driver's SQLSetConnectAttr failed ERROR [01000] [Microsoft][ODBC Driver
>Manager] The driver doesn't support the version of ODBC behavior that the
>application requested (see SQLSetEnvAttr).
>
>
>
>ANY HELP!!
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only