odbc open problem
-
I'm trying to read a CDD file using a ODBC driver. When I try to Open the file it bombs-out. The error messeage I get is as follows: System.Data.OleDb.OleDbException: Connection Failure Unable to find CDD. File not found. (L:\CONNX_LICENSE\CDDFiles\schwanMgntWeb.cdd) Win32 Error(3) UserName=(*****) Here's the strange part, it works on a windows application, but fails to open the file in a web base application. The logic is exactly the same. Yes, I did register the DSN, and it's pointing to the proper location. Here's the snippet of code: Dim connDF As New OleDbConnection() connDF.ConnectionString() = (GetConnectionString("SchwanMgntWeb")) connDF.Open() 'bombs out here The connection string is: m_sConn = "Provider=CONNXOLEDB;DSN=SchwanMgmtWeb;UID=admin;PWD=;NODE=;APPLICATION=;"