Subject Re: UN and PW not defined ... error message on Windows 7 (not XP)
Author venussoftop
--- 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
>


Thanks Mark. The following are the connect strings on that are passed for conenctivity:

If the app is installed as a node:
Driver=Firebird/InterBase(r) driver;Uid=SYSDBA;Pwd=masterkey;DbName=servername:fdbaliasname;

If the app is installed as a server:
Driver=Firebird/InterBase(r) driver;Uid=SYSDBA;Pwd=masterkey;DbName=C:\ProgramData\appfoldername\datafoldername\databasename.fdb;

The issue is the same for both the above string. These same strings work on the XP Machine though

The database files are physically present I have confirmed that.

Please advise.

Thanks and regards
Bhavbhuti