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

Click here to load this message in the networking platform