Re: Need Advice - Access XP and ADO

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

  • Next message: Eugene V. Goldberg: "Trouble with Key.Columns.Count in Delphi 5" 
    Date: Tue, 23 Dec 2003 12:40:42 -0600

    Found the problem - linked tables in Access!!

    Austin

    "Austin" <austin@mccracken-cpa.com> wrote in message
    news:3fe8855d@newsgroups.borland.com...
    > 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
    >
    >

  • Next message: Eugene V. Goldberg: "Trouble with Key.Columns.Count in Delphi 5"

    Relevant Pages

    • Re: Need Advice - Access XP and ADO
      ... I changed the ADO connection to point to a database in another directory. ... My ADO Connection component is built to point to the valid and active ...
      (borland.public.delphi.database.ado)
    • 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)