Re: BDE to ADO

From: Jeremy Collins (jd.collins_at_ntlworld-not.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 09:17:06 +0100

Sam G. wrote:

> Hi,
> I am somewhat confused regarding defining ADO connections. I am moving an
> app from BDE to ADO. With BDE I do not have to code server and database
> information in the app. I could use BDE Administrator or and ODBC data
> source.
>
> I have started to understand ADO components but is there a way to define the
> database connection outside of the application similar to the BDE admin
> tool. Do I use the ODBC management tool and define ODBC data sources?

Avoid ODBC, it adds an extra layer which impedes performace
and brings its own problems.

If you want to store the connection info outside of the app,
create a data link file. Just create new text file, and change
the extension to "UDL". Double-click it to set the connection
properties.

The connection string for your ADO connection can simply
be "FILE NAME=your_data_link_file.udl;", and the connection
will read the info from the file.

You can also build a connection string at runtime based on
user input (opening an Access file; selecting an SQL server
etc etc).

> Is there an ADO Administration Tool that comes with Windows (and what
> versions).

No, ADO is a data access layer and database admin is done with
the tools that come with your database (SQL Server, Access,
Oracle etc). 

-- 
jc
Remove the -not from email

Relevant Pages

  • Re: C++ support for ADO
    ... TESTHR(pConn.CreateInstance(__uuidof(Connection))); ... In answer to your question I'm interested in ADO not the ADO.net. ... data classes for working with ADO/OLE DB. ... You can also use the OLE SDK. ...
    (microsoft.public.data.ado)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.data.ado)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.inetserver.asp.db)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.data.oledb)
  • Re: How to make the app run?????
    ... throwing an error if the connection never was opened, ... How can i tell if i'm using ADO as in VB or .Net ADO ?? ... First of all, it was not shown to my customer, I took it to a very nice ... How do you get in "installed" on client computer? ...
    (microsoft.public.dotnet.general)