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!!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement