Subject | Re: [IBO] connection question |
---|---|
Author | Helen Borrie |
Post date | 2001-01-12T10:45:53Z |
At 10:16 AM 12-01-01 +0000, you wrote:
object JediMDB: TIBODatabase
DatabaseName = 'Jedi'
Params.Strings = (
'PATH=F:\jedi\root\gdb\jedi.gdb'
'USER NAME=SYSDBA'
'PASSWORD=masterkey')
Left = 16
Top = 8
end
object qryMemberNames: TIBOQuery
Params = <>
DatabaseName = 'Jedi'
IB_Connection = JediMDB
SQL.Strings = (
'Select NameCode, Surname, FirstName, Email,'
'FirstName || '#39' '#39'||Surname as MemberName '
'from Members'
'order by NameCode')
Left = 680
Top = 8
As you see, the iboquery has the object name of the database object as its
IB_Connection property. Is that how it is in yours?
Helen
Helen
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________
>I'm not entirely sure that I know what you mean here. I have numerousHere's an excerpt from the dfm file of an app that I converted from the BDE:
>IBOQuery components in my app and they all have the DataBaseName
>property set, they also have the IB_Connection proprty set
>(automatically by the conversion process) - I am assuming that this is
>not what you are referring to.
object JediMDB: TIBODatabase
DatabaseName = 'Jedi'
Params.Strings = (
'PATH=F:\jedi\root\gdb\jedi.gdb'
'USER NAME=SYSDBA'
'PASSWORD=masterkey')
Left = 16
Top = 8
end
object qryMemberNames: TIBOQuery
Params = <>
DatabaseName = 'Jedi'
IB_Connection = JediMDB
SQL.Strings = (
'Select NameCode, Surname, FirstName, Email,'
'FirstName || '#39' '#39'||Surname as MemberName '
'from Members'
'order by NameCode')
Left = 680
Top = 8
As you see, the iboquery has the object name of the database object as its
IB_Connection property. Is that how it is in yours?
Helen
>I only have one TIBODataBase component which is on my "mainform" andYes, that happens with my app too, but it is not saved to the dfm.
>everything points to this. I tried the steps you outlined below but it
>still gave me the error. Incidentally, even though I have the
>PasswordRemembered property set to False the SavedPassword property
>still gets poulated as soon as I enter the password into the params
>property - I assume I have to do this still, like I did with BDE.
Helen
>PaulAll for Open and Open for All
>
>Helen Borrie wrote:
> >
> > At 08:35 AM 12-01-01 +0000, you wrote:
> > >Simply removing these two things gave no improvement at all. It seems
> > >that the only way I can connect cleanly is to have nothing in the Params
> > >property, set PasswordRemembered to false, LoginPrompt to true and let
> > >the user login via the dialogue box.
> > >
> > >I did really want to avoid this (I know, I know) so if anyone has any
> > >more suggestions I'd be glad to hear them.
> >
> > I wonder whether you have any TIBOQueries around the place that are
> > attached to an implicit TIBODatabase.
> > You could check that by searching the dfm file(s) for 'Database' to
> > discover whether you have some old legacy there from your BDE app.
> >
> > If you don't find anything there, this should do it:
> >
> > Delete the TIBODatabase.
> > Save and close the project.
> > I think this should remove any stray Registry entries.
> >
> > Reopen the project.
> > Drop on a new TIBODatabase and set it all up from scratch.
> >
> > This time, don't use the two password saving properties.= **at all**.
> >
> > Helen
> >
> > All for Open and Open for All
> > InterBase Developer Initiative · http://www.interbase2000.org
> > _______________________________________________________
>
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________