I get this error when i try and open a connection with my database.
Here is the error below
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] The Microsoft
Jet database engine cannot open the file '(unknown)'. It is already
opened exclusively by another user, or you need permission to view
its data. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC Microsoft
Access Driver] The Microsoft Jet database engine cannot open the
file '(unknown)'. It is already opened exclusively by another user,
or you need permission to view its data.
The same DSN works in ASP but not in ASP.NET. I have set the folder
that the Database is in to allow access to IUSR and ASPNET, and it
still does not work. Any suggestions?
Here is my code below
protected void Page_Load(Object sender, EventArgs e)
{
OdbcConnection albrechtConn = new OdbcConnection("DSN=albrechtdb");
String mySelect;
mySelect = "SELECT * from shipping";
OdbcDataAdapter myAdapter = new OdbcDataAdapter();
myAdapter.SelectCommand = new OdbcCommand(mySelect, albrechtConn);
}
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Microsofts_C_Sharp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
