Re: Need Advice - Access XP and ADO

From: Austin (austin_at_mccracken-cpa.com)
Date: 12/23/03 

Date: Tue, 23 Dec 2003 12:11:32 -0600

Brian,

I think I found part of the problem.

I changed the ADO connection to point to a database in another directory.
When this is not found the program ends with no error message.

Now I find another problem.

My ADO Connection component is built to point to the valid and active
database in a new folder. It activates correctly. The connection string
propery in the ADO Query also shows itself pointing to the new directory.
However when I try to open the query in design mode I get an error trying to
open the database in the other older directory??

Why does this still point to an old connection string, when the ADO
connection component shows a different one???
I tried a new ADO Connection component and set the TADOQuery to use the new
connection and the same error??

Any idea on what I'm doing wrong??

Austin

"Brian Bushay TeamB" <BBushay@Nmpls.com> wrote in message
news:279fuvg75k3tqihu6q4t8ehqar0v15kvht@4ax.com...
> >Is Windows XP Pro required with Midas and client data sets???
> No
>
> >Anyone have any ideas????
> You could load delphi on the problem machine and step through the code in
debug
> to find out where it is hanging. That would give something to go on.
> --
> Brian Bushay (TeamB)
> Bbushay@NMPLS.com

Relevant Pages

  • Re: Run query using VB6 and DAO
    ... I would suggest ADO instead of DAO. ... Depending on your database, make a connection to it using the ADO connection ...
    (microsoft.public.vb.database)
  • 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)
  • Unfamilair with ADO DB connections
    ... ADO Connection Create.vi - means  Create an connection to database? ...
    (comp.lang.labview)