Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DSN Not working
Message
From
15/01/2003 17:13:21
 
 
To
All
General information
Forum:
ASP.NET
Category:
Other
Title:
DSN Not working
Miscellaneous
Thread ID:
00742132
Message ID:
00742132
Views:
72
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
Map
View

Click here to load this message in the networking platform