Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

FBStatistical does not like pathes to database with non ascii characters in it [DNET705] #656

Closed
firebird-automations opened this issue Oct 5, 2016 · 13 comments

Comments

@firebird-automations
Copy link

Submitted by: Ralf Jansen (ralf jansen)

Is related to DNET763
Is related to DNET772

Trying to use FBStatistical against a database residing in a path with non-ascii characters (like german umlauts) fails with a Exception that the database can't be opened

Sample

FbStatistical stat = new FbStatistical();
stat.ConnectionString = "server type=Embedded;character set=UTF8;initial catalog=C:\MyLovelyFolder\aö\database.fdb;user id=SYSDBA;password=masterkey;pooling=False;client library=C:\Firebird_x64\fbembed.dll"
stat.Options = FbStatisticalFlags.HeaderPages;
try
{
stat.Execute();
}
catch (FbException ex)
{
....
}

will result in an "Can't open database file C:\\MYLOVELYFOLDER\\Aö\\DATABASE.FDB" with ErrorCode 336920605 Exception.
Interesting sidenote the internal uppercasing ignored the ö umlaut.

@firebird-automations
Copy link
Author

Commented by: Ralf Jansen (ralf jansen)

I work around that problem currently with changing the path into a shortpath and hope that it will not create other problems.

@firebird-automations
Copy link
Author

Commented by: Ralf Jansen (ralf jansen)

Unfortunately using the shortpath is no workaround :( Shortpath handling can be deactivated in windows and seems to be the default in current windows versions that 8.3 format is deactivated for non-system partitions.
Can someone confirm that using non ascii characters in database pathes does not work with anything that uses the service API (via FBService)?

@firebird-automations
Copy link
Author

Commented by: Ralf Jansen (ralf jansen)

Moved to Provider version 5.5 and can only replicate the problem with FB3. FB2.5 seems ok.

Problem might be correlated CORE 5154 anf therefore be a engine thing and not a provider thing even if CORE5154 is marked as fixed.

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Link: This issue is related to DNET763 [ DNET763 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => In Progress [ 3 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Version: 5.5.0.0 [ 10783 ]

@firebird-automations
Copy link
Author

Commented by: @cincuranet

Is this still happening? On FB3.0.2 say.

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Link: This issue is related to DNET772 [ DNET772 ]

@firebird-automations
Copy link
Author

Commented by: Ralf Jansen (ralf jansen)

Just checked firebird embedded versions 3.0.2.32615 and 3.03.32749 (i don't t have the official 3.0.2 build at hand) using provider 5.5.0.0
Both fail as described above.

@firebird-automations
Copy link
Author

Commented by: @cincuranet

OK, this is actually a duplicate of DNET772, I think.

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: In Progress [ 3 ] => Closed [ 6 ]

resolution: Duplicate [ 3 ]

@firebird-automations
Copy link
Author

Commented by: Ralf Jansen (ralf jansen)

If i recall correctly i tried throwing isc_dpb_utf8_filename also into the ServiceParameterBuffer back then but with no effect. So i was under the impression that there is an underlying problem in firebird itself and not or not only in the provider.

@firebird-automations
Copy link
Author

Commented by: @cincuranet

I needs to be isc_spb_utf8_filename, because it's service_mgr. I think that will make it work fine.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants