The UserName and Password in the DSN ODBC setup (control Panel) are the items I am after ... the ODBC appears to be stored for each user in the registry. The problem is that the password is encrypted. The idea of getting Crystal to logon using this info was my preferred option but if I could get the UserName (got that) and Password (need to unencrypt) that will do...
Regards Paul McKenzie SMSS Ltd. Wellington New Zealand ----- Original Message ----- From: "Rohit Gupta" <[EMAIL PROTECTED]> To: "NZ Borland Developers Group - Delphi List" <[EMAIL PROTECTED]> Sent: Wednesday, September 08, 2004 12:33 PM Subject: Re: [DUG] Delphi Crystal and Interbase via ODBC > Paul, > > we setup two aliases (DSN) in the odbc setup (control panel) and then > use the one required. For non-XPs, the app checks the rgeistry entries > and fixes them if the ODBC is not pointing ot the same database as the > database component in the app. > > Paul McKenzie wrote: > > >We have a Delphi App that uses Crystal to access a remote InterBase database via ODBC. > >What I want to use is the local computer ODBC Usename and Password for logon to the InterBase Database... > > > >The Crystal TypeLibrary provides a "LogOnServerWithPrivateInfo(const pDllName: WideString; privateInfo: OleVariant)" but I am unsure how to use it. The parameters are DLLName (that's ok) PrivateInfo (??? no idea). > >The only erxample on the net indicates an ODBC connection handle (I think) > >the use "SQLGetProp" which I can't find... > > > >Has anyone used "LogOnServerWithPrivateInfo" or managed to use the local computer ODBC info for Crystal logon via ODBC ??? > > > > > >Regards > >Paul McKenzie > >SMSS Ltd. > >Wellington > >New Zealand > > > > > >------------------------------------------------------------------------ > > > >_______________________________________________ > >Delphi mailing list > >[EMAIL PROTECTED] > >http://ns3.123.co.nz/mailman/listinfo/delphi > > > > > > > _______________________________________________ > Delphi mailing list > [EMAIL PROTECTED] > http://ns3.123.co.nz/mailman/listinfo/delphi > _______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
