--- In firebird-support@yahoogroups.com, Mark Rotteveel <mark@...> wrote:

>
> On 4-8-2012 16:06, venussoftop wrote:
> > Hi all
> >
> > I have an app that uses FireBird is being used regularly on Windows XP pretty nicely.
> >
> > Now when I install the same app on Windows 7 I am still able to enter data as I normally would using connect string
> >
> > The problem arises when I try to print the reports via Report Manager (from sourceforge) ActiveX using connect string then it does not work.
> >
> > If I use the same report via ODBC then it works in the Report Manager designer then it works.
> >
> > The error I get is:
> > [odbc Firebird Driver] your User Name And Password Are Not Defined. Ask Your Database Administrator To Set Up A Firebird Login.
> >
> > I have even tried to create a user using FlameRobin of the Windows user name but of course the Space in the Win User Name is not possible for the user name in FireBird.
> >
> > This all in all is not an issue in Win XP so what might happen differently in Windows 7
> >
> > Please advise
>
> How do you connect, what is your connection string when it doesn't work?
>
> Mark
>
> --
> Mark Rotteveel
>

Hi Mark

Please see my other post for the conn strings. I have been testing this since then. Like I mentioned that the ODBC DSN via the RM Designer was working fine.

I then replaced the DOCB DSN with the conn. strings and tried again, I got the same error message, but if I tried again the report worked!!!

No idea why does it report an error about User Name on first run and then again if run immediately will work properly.

For the moment I have made my app do a RETRY and first test show that it should resolve the issue, but is a work around not a solution.

Any idea anyone, please advise.

Thanks and regards
Bhavbhuti