Configuration Error

I am trying to connect to my Access Database. Is this the correct way my "web.config" should be setup? The error is " Unrecognized element." and it is referent to Line 1 "<configuration>" All help is appreciated. Thank You.

<configuration>
   ConnectionString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE="d:\DZHosts\LocalUser\thesilvagroup\tsgits.somee.com\database\itss.mdb")
   Set DbConnection = Server.CreateObject("ADODB.Connection")
   DbConnection.Open ConnectionString

<system.web>

        <customErrors mode="Off"/>
    </system.web>
   </configuration>

Re: Configuration Error

No.

http://www.mikesdotnetting.com/Article/78/AccessDataSource-SqlDataSource-and-connecting-to-Access-databases-in-ASP.NET
http://www.mikesdotnetting.com/Article/26/Parameter-Queries-in-ASP.NET-with-MS-Access

Re: Configuration Error

Ok. I'm sorry I am still a beginner, I looked at the pages you posted so how would it be setup?

Re: Configuration Error

eric.silva
I looked at the pages you posted so how would it be setup?

I think you should read them again....

Re: Configuration Error

eric.silva

I am trying to connect to my Access Database. Is this the correct way my "web.config" should be setup? The error is " Unrecognized element." and it is referent to Line 1 "<configuration>" All help is appreciated. Thank You.

<configuration>
   ConnectionString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE="d:\DZHosts\LocalUser\thesilvagroup\tsgits.somee.com\database\itss.mdb")
   Set DbConnection = Server.CreateObject("ADODB.Connection")
   DbConnection.Open ConnectionString

<system.web>

        <customErrors mode="Off"/>
    </system.web>
   </configuration>

Sorry you are definately wrong You CANNOT write any C# or Visual Basic codes there

You should do something like this following in the web.configHere's a full complete xml contentsand you can refer to the bold one

<?xml version="1.0" encoding="utf-8"?>
<configuration>
<connectionStrings>
    <add name="Your Connection Name here" connectionString="Your connection string here" />
</connectionStrings>
<system.web>
    <compilation debug="true" targetFramework="4.0">
      <assemblies>
        <add assembly="System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
      </assemblies>
    </compilation>
</system.web>
<system.webServer>
    <defaultDocument>
      <files>
        <add value="WebForm1.aspx" />
      </files>
    </defaultDocument>
</system.webServer>
</configuration>

For more about Access's db connection string, please have a look at this Connection String Searching web site at

http://www.connectionstrings.com/

Re: Configuration Error

@ Decker Dong-MSFT:

I'm sorry I still don't understand would it look like the web.config code below? When I launch the application I recieve the following error:

"Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/authentication/new_user_form.asp, line 130"

LINE 129: set conn_buildings = Server.CreateObject("ADODB.Recordset")
LINE 130: conn_buildings.ActiveConnection = MM_conn_itss_STRING

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <connectionStrings>
    <add name="itss" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\DZHosts\LocalUser\thesilvagroup\tsgits.somee.com\database\itss.mdb" />
  </connectionStrings>
  <system.web>
    <compilation debug="true" targetFramework="4.0">
      <assemblies>
        <add assembly="System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
      </assemblies>
    </compilation>
  </system.web>
</configuration>

Re: Configuration Error

eric.silva
Data source name not found and no default driver specified

Hello

Suspecting whether you've installed OleDb driver successfullyPlease re-install it and have a try

http://www.microsoft.com/download/en/details.aspx?id=13255

Re: Configuration Error

Decker Dong - MSFT

Suspecting whether you've installed OleDb driver successfullyPlease re-install it and have a try

http://www.microsoft.com/download/en/details.aspx?id=13255

The link you provided is dealing with the new ACE driver, which is needed for .accdb (access 2007 and above) files only. The oledb 4.0 driver is installed by default on any windows system. But this is not the problem at all!

eric.silva

I'm sorry I still don't understand would it look like the web.config code below? When I launch the application I recieve the following error:

"Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/authentication/new_user_form.asp, line 130"

You're mixing up classic asp (.asp) and ASP.NET (.aspx). The connectionstring section in web.config is part of ASP.NET, but you're writing a classic asp page. So what do you want? If you want to learn classic ASP, you'll need to ask your questions elsewehere, since these forums are dealing with ASP.NET related questions only. If you want to learn ASP.NET, go to the Get Started section in this website and start at the beginning

Re: Configuration Error

hans_v
The link you provided is dealing with the new ACE driver, which is needed for .accdb (access 2007 and above) files only. The oledb 4.0 driver is installed by default on any windows system. But this is not the problem at all!

Hello

In my mind, it has included *.mdbFrom the file I saw

Overview

This download will install a set of components that facilitate the transfer
of data between existing Microsoft Office files such as Microsoft Office Access
2010 (*.mdb and *.accdb) files and Microsoft Office Excel 2010 (*.xls, *.xlsx,
and *.xlsb) files to other data sources such as Microsoft SQL Server.

Correct me If I took you wrong kindly.

Best reguards

Re: Configuration Error

Decker Dong - MSFT
In my mind, it has included *.mdbFrom the file I saw

Decker, you can connect to mdb files with the new ACE driver also, but that isn't necessary at all, because the oledb 4.0 driver can do that. In his connection string he's not even using the ACE driver, so how could you think this would be the problem?

But you didn't read the next part of my reply! Whatever connectionstring or driver he would use, it will not work when mixing classic ASP and ASP.NET.

Re: Configuration Error

hans_v
But you didn't read the next part of my reply! Whatever connectionstring or driver he would use, it will not work when mixing classic ASP and ASP.NET.

Thanks for telling meand the questioner's codes really wrongBut I have to correct his mistakes one by oneat least I was to do sobut since you began to helpWellThanks