Re: Error Connecting ADO from a Service Application

From: Stefano Campanella (campanella_at_fastwebnet.it)
Date: 05/23/04

  • Next message: Brian Bushay TeamB: "Re: Problem using tadostoredproc.parameters.createparameter" 
    Date: Sun, 23 May 2004 14:53:55 +0200

    "Kevin Frevert" <Work@drinkingcoffee.com> wrote in message
    news:40b08d74@newsgroups.borland.com...
    > "Stefano Campanella" <campanella@fastwebnet.it> wrote in message
    > news:40b06ee4$1@newsgroups.borland.com...
    > > Hello!
    > > I can connect at design time an ADO connection from the form of a
    Service
    > > Application but when I go to start the service I get an error.
    > > I tried many things unsussefully including coInitiate... can somebody
    give
    > > me an hint on this?
    > > Thanks,
    > > Stefano Campanella
    > >
    >
    > The error message is a good start.
    >
    > krf
    >
    Thank you !!!
    Sense of humor is always appreciated by me and you solved my problem too!
    Infact
    I set the connection to 'Use Windows NT Integrated Scurity' and did not work
    run time (but it worked design time).
    I had to set up the connection with a user and a password...the error (wich
    I didn't record on my log) was e.message:'the user is not authorized...'

  • Next message: Brian Bushay TeamB: "Re: Problem using tadostoredproc.parameters.createparameter"

    Relevant Pages

    • ADOConnection - odd problem solved but why?
      ... I have a form with an ADOconnection and two tables. ... Set to True at design time, ... Maybe an application cannot handle more than one ADO connection at once ...
      (alt.comp.lang.borland-delphi)
    • Re: Using TADOConnection with MSSQL, login failure
      ... My connection string had a username but no password. ... When I connected at design time it prompted me for the password so I typed it in. ... Apparently between then and when I hit F9 I changed it to loginprompt:= False; So when I tried to run all I would get is the error and no login prompt. ... You are using NT-Authentication and running the app on a machine (or user login) that does not have access to the target SQL server? ...
      (borland.public.delphi.database.ado)
    • Re: how to parameterize a dts package?
      ... The global parameters can be mapped to properties of your connection tasks. ... At design time a file must exist in order to save any changes to the ... >>> simply pass information just as file paths into the package. ...
      (microsoft.public.sqlserver.dts)
    • Re: Setting the Connectionstring of sqlconnection at design time
      ... I would like to set the connections string property of a sqlconnection object at design time to something other than a static string. ... I need it at design time because design time behavoir of other controls on my form depend on a connection object with a configured connectionstring property. ... I have tried setting up a connection via server explorer that allows me to use the dropdown on the connectionstring property to select it, however, all that does is pull in the generated connection string. ...
      (microsoft.public.vstudio.development)
    • Re: Connected := False {does not close the connection}
      ... >process is idle. ... >This is seen even at design time: ... >Drop a TADOConnection and connect to the database. ... >You will see the design-time connection in the list. ...
      (borland.public.delphi.database.ado)