Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DSN Not working
Message
De
15/01/2003 17:13:21
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Titre:
DSN Not working
Divers
Thread ID:
00742132
Message ID:
00742132
Vues:
73
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
Fil
Voir

Click here to load this message in the networking platform