Re: ADO Connections at runtime

"Larry Dew" <larrydew@xxxxxxx> wrote in message news:43924d38$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> Thanks,
> After I have the list of names, how do I build the connectionstring or
> can I directly assign the DNS name to an ADO Connection property?
> Sorry to be so slow to understand.
>
Hi Larry,

I suggest that you download my freeware components for ADO and look through that code - you can either use the component directly or modify some of the code that generates the Connection string for your purpose.
You can find my component set at http://members.ozemail.com.au/~abaylis

Cheers,
Andrew
.

Relevant Pages

  • Re: Data Provider Could Not Be Initialized
    ... I'm trying to set up a separate ADO connection for a form's recordset. ... Dim cnn As ADODB.Connection ... Dim rst As ADODB.Recordset ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Data Provider Could Not Be Initialized
    ... I'm trying to set up a separate ADO connection for a form's recordset. ... Dim cnn As ADODB.Connection ... Dim rst As ADODB.Recordset ...
    (microsoft.public.access.adp.sqlserver)
  • Data Provider Could Not Be Initialized
    ... I'm trying to set up a separate ADO connection for a form's recordset. ... Dim rst As ADODB.Recordset ...
    (microsoft.public.access.adp.sqlserver)
  • Re: ADO Connection.Execute Method leaves Open SQL Process
    ... your first paragraph where it talks about "a VB6 app". ... requesting only one connection from a single ADO Connection ... ' at this point a new SQL process HAS been created!! ...
    (microsoft.public.vb.database.ado)
  • Re: ADO Connection.Execute Method leaves Open SQL Process
    ... Have the App create a single ADODB.Connection object, ... requesting only one connection from a single ADO Connection ... Pool, thus if all requests are sequenced and not over-lapping ...
    (microsoft.public.vb.database.ado)