~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Cecil Westerhoff" <DecebalComputing@x...>
Subject: [asp_databases] Re: Good idea to change DNS to ADO?


: Op vrijdag 10 mei 2002 03:54, schreef u:
: >
: > DNS - Domain Name System. I think you are thinking about DSN :-)
:
: You are right.
:
:
: > As a general rule OLEDB provides faster data access than ODBC. It is a
: > newer technology than ODBC.
:
: The connectionstring used is:
: strConnection = "DSN=newteldb2;UID=xxx;PWD=xxx"
:
: How do I get the connectionstring to be used with ADO?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

http://www.able-consulting.com/ado_conn.htm has a list of many (if not all)
ODBC and OLEBD connection strings. You need to use the correct one for the
database that you want to connect to.

Secondly, when you use either ODBC or OLEDB you are using ADO to get to them
(actually you can use OLEDB or ODBC directly, but I've never seen anyone do
that in an ASP page).

www.adopenstatic.com/faq/whyOLEDB.asp might help (there's a little diagram
that shows the relationship between ADO/OLEDB/ODBC)

Cheers
Ken

Op vrijdag 10 mei 2002 03:54, schreef u:
> 
> DNS - Domain Name System. I think you are thinking about DSN :-)

You are right.


> As a general rule OLEDB provides faster data access than ODBC. It is a
> newer technology than ODBC.

The connectionstring used is:
	strConnection = "DSN=newteldb2;UID=xxx;PWD=xxx" 

How do I get the connectionstring to be used with ADO?

Thanks,


Cecil.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Cecil Westerhoff" <cwesterh@w...>
Subject: [asp_databases] Good idea to change DNS to ADO?


: For a client I have updated there website and made some tools to
: update there content database. (Untill know the company that made
: the website did all the updating of the database.) I saw that every
: conection to the database is made bij DNS (and so by ODBC). In
: BegASP there is written that it is better to update DNS to ADO.
: Why is this and how is this done?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DNS - Domain Name System. I think you are thinking about DSN :-)

Also, you are correct that when you use a DSN you are using ODBC. However to
use either ODBC or OLEDB (which are low level data access technologies) in
an ASP page, you usually have to use ADO, which provides a higher level way
of accessing these lower level technologies:

<%
strOLEDBConnect = _
    "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source=c:\db1.mdb;"

strODBCConnect = _
    "Driver={Microsoft Access Driver (*.mdb)};" & _
    "DQ=c:\db1.mdb"

' Instatiate an ADO Connection Object
Set objConn = Server.CreateObject("ADODB.Connection")

' Using ODBC
objConn.Open strODBCConnect

' Using OLEDB
objConn.Open strOLEDBConnect
%>

As a general rule OLEDB provides faster data access than ODBC. It is a newer
technology than ODBC.

Cheers
Ken

For a client I have updated there website and made some tools to update there content database. (Untill know the company that made the website did all the updating of the database.) I saw that every conection to the database is made bij DNS (and so by ODBC). In BegASP there is written that it is better to update DNS to ADO. Why is this and how is this done?