message file C:\WINDOWS\SYSTEM32\firebird.msg not found

[Aurel Bartmann]

Hello,

i connected firebird with IBExpert and now i am getting this error message. I tried to add the path of the firebird.msg with the enviorment variables and i also added the file at the system32 path but it all didnt help. Also i get these error messages if they might help. It also cant find the table after i created it.

[Karol Bieniaszewski]

Hi

 

You have probably created case sensitive table name.

If you careate object in double quotes „Leser” you must always use quotes.

This is why i always use upper case when create object then i can call it in any char case...

 

Regards,

Karol Bieniaszewski

 

Od: Aurel Bartmann
Wysłano: sobota, 6 kwietnia 2024 23:02
Do: firebird-support
Temat: [firebird-support] message file C:\WINDOWS\SYSTEM32\firebird.msg not found

 

Hello,

i connected firebird with IBExpert and now i am getting this error message. I tried to add the path of the firebird.msg with the enviorment variables and i also added the file at the system32 path but it all didnt help. Also i get these error messages if they might help. It also cant find the table after i created it.

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/c88421a2-1685-4815-be29-512a8b138cfcn%40googlegroups.com.

 

[Vlad Khorsun]

Hello,

i connected firebird with IBExpert and now i am getting this error message.

  You should specify fbclient.dll (with full path) in the connection settings, not gds32.dll

Regards,

Vlad

[Mark Rotteveel]

On 06/04/2024 23:02, Aurel Bartmann wrote:
> Hello,
> i connected firebird with IBExpert and now i am getting this error
> message. I tried to add the path of the firebird.msg with the enviorment
> variables and i also added the file at the system32 path but it all
> didnt help. Also i get these error messages if they might help. It also

> cant find the table after i created it. datenbanken.pnginsert_into error.png

Is IB Expert 32-bit or 64-bit? If it is 32-bit, you need to ensure
firebird.msg exists in C:\Windows\SysWOW64. The error mentions System32,
because when 32-bit applications ask for C:\Windows\System32, they
actually see the content of C:\Windows\SysWOW64 (at least, on 64-bit
Windows).

Mark
--
Mark Rotteveel

[Aurel Bartmann]

Thanks for your help! Yeah it was actually the Problem that IBExpert is a 32-bit application. However i still cant create tables and they dont get saved in the database.  In an online compiler it is actually working creating the table with the same commands however doing it in IBExpert gives me errors.  I says it created the table but it actually didnt. I also cant find it in Isql tool.

[Aurel Bartmann]

My professor specifically told us to install gds32.dll. So I don't think we're allowed to do that

[Dimitry Sibiryakov]

Aurel Bartmann wrote 07.04.2024 12:33:
> However i still cant create tables and they dont get saved in the database.

"Program Files" is virtualized folder.
It was extremely bad idea to create a database there.


https://learn.microsoft.com/en-us/previous-versions/windows/it-pro/windows-10/security/threat-protection/security-policy-settings/user-account-control-virtualize-file-and-registry-write-failures-to-per-user-locations

--
WBR, SD.

[Dimitry Sibiryakov]

Aurel Bartmann wrote 07.04.2024 12:35:
> My professor specifically told us to install gds32.dll.

Ask your professor to be here. They is either dumb or do something wrong.

--
WBR, SD.

[Aurel Bartmann]

He also did that in the lecture but the problem doesnt seem to be the database itself more the connection between IBExpert and the database cause i can create tables inside the database with ISQL tool:

[Dimitry Sibiryakov]

Aurel Bartmann wrote 07.04.2024 13:06:
> He also did that in the lecture but the problem doesnt seem to be the database
> itself more the connection between IBExpert and the database cause i can create
> tables inside the database with ISQL tool

So the professor is stupid. Don't be like him and read documentation by link
to understand why it works this way. It is not Firebird problem.

--
WBR, SD.

[Karol Bieniaszewski]

I missed the first error, the table could not be created.

I focused on the last window with the insert message, so Vlad is right here.

 

Regards,

Karol Bieniaszewski

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/4VBrGK69tvzlWM%40smtp.poczta.onet.pl.

 

[Vlad Khorsun]

воскресенье, 7 апреля 2024 г. в 13:33:09 UTC+3, aurelb...@gmail.com:

Thanks for your help! Yeah it was actually the Problem that IBExpert is a 32-bit application. However i still cant create tables and they dont get saved in the database.  In an online compiler it is actually working creating the table with the same commands however doing it in IBExpert gives me errors.  I says it created the table but it actually didnt. I also cant find it in Isql tool.

Don't put database into virtualized folder. Don't put data into 'program files'.

Learn about user accounts control and file system virtualization.

Regards,

Vlad

[Aurel Bartmann]

I created a new database not inside a virtualized folder and i also changed in the client libary file to fbclient.dll but still got the same error.

[Karol Bieniaszewski]

Are you sure that this tool execute multiple scripts at once?

 

 

Regards,

Karol Bieniaszewski

 

Od: Aurel Bartmann
Wysłano: niedziela, 7 kwietnia 2024 14:56
Do: firebird-support
Temat: Re: [firebird-support] message file C:\WINDOWS\SYSTEM32\firebird.msgnot found

 

I created a new database not inside a virtualized folder and i also changed in the client libary file to fbclient.dll but still got the same error.

fbv...@gmail.com schrieb am Sonntag, 7. April 2024 um 14:32:23 UTC+2:

воскресенье, 7 апреля 2024 г. в 13:33:09 UTC+3, aurelb...@gmail.com:

Thanks for your help! Yeah it was actually the Problem that IBExpert is a 32-bit application. However i still cant create tables and they dont get saved in the database.  In an online compiler it is actually working creating the table with the same commands however doing it in IBExpert gives me errors.  I says it created the table but it actually didnt. I also cant find it in Isql tool.

 

Don't put database into virtualized folder. Don't put data into 'program files'.

Learn about user accounts control and file system virtualization.

 

Regards,

Vlad

--

You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/143c6e9f-8082-48f3-b281-88bc6791a99fn%40googlegroups.com.

 

[Aurel Bartmann]

I also executed them separately and used the function "execute and fetch all" but it still doesnt know the token INSERT. Do  you have any idea how to fix this?

[Dimitry Sibiryakov]

Aurel Bartmann wrote 07.04.2024 16:49:
> I also executed them separately

No, you didn't. Firebird cannot execute batches and IBExpert has two
different tools: "Execute SQL" and "Execute Script" learn the difference between
them.

--
WBR, SD.

[liviuslivius]

Or simply change the tool ;-)

Use better flamerobin

Regards,

Karol Bieniaszewski

-------- Oryginalna wiadomość --------

Od: 'Dimitry Sibiryakov' via firebird-support <firebird...@googlegroups.com>

Data: 7.04.2024 17:27 (GMT+01:00)

Do: firebird...@googlegroups.com

Temat: Re: [firebird-support] message file C:\WINDOWS\SYSTEM32\firebird.msgnot found

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/45d2416f-bee7-4041-9fba-c6b2c395d225%40ibphoenix.com.

[Aurel Bartmann]

I would love to change to tool but my professor said we should use this so i have no other option. :/  It actually worked thank you! I was able to do it now with the script.

[Aurel Bartmann]

Is there a different way to execute sql in ibexpert with firebird database without a script? My professor said we should execute it first without a script and then with one.

[Dimitry Sibiryakov]

Aurel Bartmann wrote 07.04.2024 22:48:
> Is there a different way to execute sql in ibexpert with firebird database
> without a script?

Yes, that's exactly what I said: IBExpert main menu "Tools->SQL Editor" and
"Tools->Script Executive" are two completely different things.
You don't need to change IBExpert, you must learn how to use it.

And once again I suggest you to invite the professor here.

--
WBR, SD.

[Karol Bieniaszewski]

I do not beleve in that 😉 Better is using opensource tool which work without problems and with known source code

https://github.com/mariuz/flamerobin/releases/tag/0.9.10

 

Regards,

Karol Bieniaszewski

 

Od: Aurel Bartmann
Wysłano: niedziela, 7 kwietnia 2024 22:41
Do: firebird-support
Temat: Re: [firebird-support] message file C:\WINDOWS\SYSTEM32\firebird.msgnotfound

 

I would love to change to tool but my professor said we should use this so i have no other option. :/  It actually worked thank you! I was able to do it now with the script.

--

You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/ae91a8a9-90da-40c6-ade8-32df35034970n%40googlegroups.com.