UN and PW not defined ... error message on Windows 7 (not XP)

Discussion:

venussoftop

2012-08-04 14:06:23 UTC

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

Thanks and regards
Bhavbhuti

Mark Rotteveel

2012-08-05 08:05:26 UTC

Permalink

Post by venussoftop
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.
[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

venussoftop

2012-08-06 13:56:25 UTC

Permalink

Post by Mark Rotteveel

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

venussoftop

2012-08-07 07:38:55 UTC

Permalink

Post by Mark Rotteveel

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