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!!
Next
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