Access Databases and AccessDataSource Control

Re: how do i use a UDL file?

hans_v — Wed, 01 Jul 2009 15:29:54 GMT

chandu2chandu1:
I am not sure that oleDb works for access or not.

A common Connectionstring would look something like

Provider=Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|myDB.mdb

Also, th AccessDatasource control uses the OleDb provider

http://msdn.microsoft.com/en-us/library/8e5545e1.aspx

Re: how do i use a UDL file?

chandu2chandu1 — Wed, 01 Jul 2009 14:52:55 GMT

hans_v:
ODBC - Access - ASP.NET

Not a very good combination, always use OleDb

I am not sure that oleDb works for access or not. That's why I provided the sample example.

Re: how do i use a UDL file?

hans_v — Wed, 01 Jul 2009 13:20:48 GMT

chandu2chandu1:
string myConnString=ConfigurationaManager.ConnectionString["myConn"].ToString();

using(ODBCConnection conn=new ODBCConnection())

{

       //Do your database processing here.

}
string myConnString=ConfigurationaManager.ConnectionString["myConn"].ToString();
using(ODBCConnection conn=new ODBCConnection())
{
       //Do your database processing here.
}

ODBC - Access - ASP.NET

Not a very good combination, always use OleDb

Re: how do i use a UDL file?

hans_v — Wed, 01 Jul 2009 13:15:15 GMT

Why would you use a UDL? Just connect the .NET way:

AccessDataSource, SqlDataSource and connecting to Access databases in ASP.NET

Re: how do i use a UDL file?

chandu2chandu1 — Wed, 01 Jul 2009 10:11:00 GMT

You open the UDL file with the notepad. There you can find the connection string, then you can copy the connection string to your web.config file and from there you can call the connection string and connect to your database using the connection object. See the web.config files snippet,

<connectionStrings>
        <add name="myConn" connectionString="String From your udl file"/>
    </connectionStrings>

Now, in your application file (C#) you can call the connection string as follows,

string myConnString=ConfigurationaManager.ConnectionString["myConn"].ToString();
using(ODBCConnection conn=new ODBCConnection())
{
       //Do your database processing here.
}

Re: how do i use a UDL file?

Ambran — Wed, 01 Jul 2009 09:50:34 GMT

Hi Y.

Found an old guide for using an UDL file for database access:
http://aspalliance.com/434_Database_Access_Using_UDL_Files.all

Hope this helps

Amit

how do i use a UDL file?

young345 — Wed, 01 Jul 2009 07:00:03 GMT

I have a udl file which I want to use so I can connect to the database.

I have written the code in the webconfig file so it will link to this udl file.

However, I don’t think that is enough, I think I have to write in the code somewhere that I want to use this UDL file.

I have never done this before, does anyone know how I can do this, is there some kind of techinique?

I am using c# and visual studio 2005.

Thank you