--- In firebird-support@yahoogroups.com, Adriano dos Santos Fernandes
<adrianosf@...> wrote:

>
> lucipl77 escreveu:
> > Hi,
> > My configuration: Firebird 2.0.3.12981 embedded release ( or
> > 2.1.1.17910 embedded release) on Windows XP x64 SP2 , Intel CPU,
> > IBPP, Visual C++ Visual Studio 2005.
> >
> > I want to open a firebird database from the local computer and it
> > doesn't work if the database path contains unicode characters.
> > I tried several aproaches to convert the path from a widechar string
> > to ansi string:
> > - converting the path to MBCS using WideCharToMultiByte API, with
> > the CP_THREAD_ACP, CP_ACP.
> > - converting the path to 8.3 format using GetShortPathName API.
> >
> > The error:
> > when isc_attach_database is executed it returns with the following
> > error description:
> >
> > Engine Code : 335544344
> > Engine Message :
> > I/O error for file "D:\Temp\CHINES~1\test.FDB"
> > Error while trying to open file
> > The filename, directory name, or volume label syntax is incorrect.
> >
> >
> > I'd say this is a bug because the full path to DB file provided by the
> > user is certainly tampered with and not passed as it is to the :
> > CreateFile(...) win API used in:
> >
> > jrd_file* PIO_open(Database* dbb, const Firebird::PathName& string,
> > bool trace_flag, const Firebird::PathName& file_name, bool
> > share_delete) (jrd\os\win32\winnt.cpp)
> >
> > The proof of this is the following simple code (VC++ MS VStudio ):
> >
> > CStringW strWDatabasePath = _T("D:\\Temp\\Chinese

壇\\test.FDB");

> >
> > // we split the path and the filename, we want to convert the path to
> > // 8.3 format that is always composed only of ansi chars
> > CString szPath;
> > int iPos = strWDatabasePath.ReverseFind(_T('\\'));
> > szPath = strWDatabasePath.Left(iPos);
> > CString szFilename;
> > szFilename = strWDatabasePath.Mid(iPos);
> >
> > // filename to ansi chars
> > CStringA szAFilename;
> > szAFilename.Format("%S", szFilename);
> >
> > // converting to 8.3
> > CStringW szShortDatabase;
> > int iSize = GetShortPathName(szPath, NULL, 0);
> > GetShortPathName(szPath, szShortDatabase.GetBuffer(iSize), iSize);
> > szShortDatabase.ReleaseBuffer();
> > szShortDatabase += szFilename;
> >
> > // converting to MBCS, anyway in this case will contain only
> > // ansi chars because of the 8.3 format
> > CStringA strDatabasePath;
> > int nLength=WideCharToMultiByte(CP_THREAD_ACP, 0, szShortDatabase, -1,
> > NULL, 0, NULL, NULL);
> > int a = WideCharToMultiByte(CP_THREAD_ACP, 0,szShortDatabase,-1,
> > strDatabasePath.GetBuffer(nLength + 2),nLength + 2,NULL,NULL);
> > bool share_delete = FALSE;
> >
> What happens if you save a file with content "CONNECT '<this string>'
> USER ... PASSWORD ...;" and executes with "isql -i file.sql"?
>
>
> Adriano
>

Isql.exe can be used to connect to embedded firebird library ?

I tried and isql.exe fails to run because: 'This application has
failed to start because fbclient.dll was not found. Re-installing the
application may fix this problem.'

fbclient.dll is in the same directory with isql.exe, also
MyTestApp.exe is in the same place using fbclient.dll and il loads and
executes succesfully( except the case i've opened the Post, unicode
.... )

Regards
Lucian