Error with ASP.NET opening OleDb/ODBC database

Error with ASP.NET opening OleDb/ODBC database

Post by gdelia » Thu, 17 Jul 2003 01:28:57


Hi there,

I got a problem using an MS Access database through ASP.NET.

After updating my system from .NET Framework 1.0 to 1.1, my existing
application gives me the following error when opening a connection
with the code below:

"Unspecified error" (ErrorCode: -2147467259)

string connectionStringKey = "LocalDBConnectionString";
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\InetPub\wwwroot\IS_Italy_2003\IS.mdb";

OdbcConnection connection = new OdbcConnection(connectionString);
try
{
connection.Open();
}
catch (OdbcException ex)
{
string error = ex.Message;
}
finally
{
connection.Close();
}

What's really strange is that:
1. The same application works on some of my colleagues' computers with
the .net Framework 1.1
2. The very same code works on my computer when creating a brand new
application with VS.NET 2003
3. The same application was working with .NET Framework 1.0

The same thing happens (including the two cases above) when using ODBC
classes instead of OleDB ones. In this case the connection string is:

"FIL=MS Access;DSN=AIS_Local"

and the error is:

"ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Disk or
network error.\r\nERROR [IM006] [Microsoft][ODBC Driver Manager]
Driver's SQLSetConnectAttr failed\r\nERROR [HY000] [Microsoft][ODBC
Microsoft Access Driver] Disk or network error."

Need HELP!!!
tks
 
 
 

Error with ASP.NET opening OleDb/ODBC database

Post by Chuck Grim » Thu, 17 Jul 2003 08:11:57


I don't do C#, so I'm not sure if the code is good or not, but I don't
see a "User ID=" statement in your connection string. Try adding it
in and see if it helps:

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"User ID=Admin;Data Source=C:\InetPub\wwwroot\IS_Italy_2003\IS.mdb";

(Note that there is a space in "User ID=".)

I also tend to add in "Mode=Share Deny None" at the end, but I'm not
sure that is your problem. Here's one that I use:

"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=somedb.mdb;Mode=Share Deny None"




--
Error: Error: Error: Error: Error: <Smack> C:\>