Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

2017-03-23 Thread Clyde Eisenbeis
1) The filename was zzFirebirdTest.fdb. The end result is ZZFIREBIRDTEST.FDB. Here is solution converting the UPPERCASE back to the original: string stPATHFILENAME = stPathFilename.ToUpper(); System.IO.File.Move(@stPATHFILENAME, @stPathFilename); On Sun, Mar 19, 2017 at 6:07 AM, Mark

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

2017-03-19 Thread Mark Rotteveel
On 19-3-2017 11:56, Jiří Činčura wrote: >> Firebird Embedded on windows does not check for username and password, >> so you can leave them out. For a normal Firebird server, username is >> case insensitive, but password - of course - is case sensitive. > > But the grants are still followed. So

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

2017-03-19 Thread Jiří Činčura
> Firebird Embedded on windows does not check for username and password, > so you can leave them out. For a normal Firebird server, username is > case insensitive, but password - of course - is case sensitive. But the grants are still followed. So username/role is important, password not much.

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

2017-03-18 Thread Mark Rotteveel
On 18-3-2017 16:21, Clyde Eisenbeis wrote: > Mark, > > I'm not sure how to reply via StackOverflow, so I'll email. Here is fine. > Thanks! Your description creates an .fdb file. (I think .fdb is the > correct format acronym). You can choose whatever you want for the file extension, but fdb is

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

2017-03-18 Thread Jiří Činčura
> 4) I'm struggling to find details about FbConnection.CreateDatabase on > the Firebird Document site. > > Apparently the order is ... connection details (string), page size > (int), force writes (bool), overwrite (bool).

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

2017-03-18 Thread Clyde Eisenbeis
Mark, I'm not sure how to reply via StackOverflow, so I'll email. Thanks! Your description creates an .fdb file. (I think .fdb is the correct format acronym). 1) The filename was zzFirebirdTest.fdb. The end result is ZZFIREBIRDTEST.FDB. How do I keep TitleCase for the name? 2) UserID =

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

2017-03-18 Thread Mark Rotteveel
On 17-3-2017 20:38, Mark Rotteveel wrote: > As I said on stack overflow, I'll try to post a more complete answer > later this weekend. Also check the other answer posted recently, the > links in that mail handle some older versions, but should still apply in > general. I have posted on answer on

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

2017-03-17 Thread Clyde Eisenbeis
I clearly misunderstood. To be certain I understand the terminology, an embedded server is one that is accessible via the Internet? I do want this database to eventually be accessible via the Internet. I know which tables I want ... and which fields I want in each table. By dependencies, does

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

2017-03-17 Thread Mark Rotteveel
On 2017-03-17 17:26, Clyde Eisenbeis wrote: > I used "FirebirdSql.Data.FirebirdClient.dll" ... which is located in > my Debug subdir. > > The exception is "Unable to find an entry point named > 'isc_create_database' in DLL 'FirebirdSql.Data.FirebirdClient.dll". You are missing a crucial point,

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

2017-03-17 Thread Wolfgang Riedmann
. März 2017 17:26 An: For users and developers of the Firebird .NET providers Betreff: Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File I used "FirebirdSql.Data.FirebirdClient.dll" ... which is located in my Debug subdir. The exception is "Unable t

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

2017-03-17 Thread Clyde Eisenbeis
I used "FirebirdSql.Data.FirebirdClient.dll" ... which is located in my Debug subdir. The exception is "Unable to find an entry point named 'isc_create_database' in DLL 'FirebirdSql.Data.FirebirdClient.dll". On Thu, Mar 16, 2017 at 2:07 PM, Jiří Činčura wrote: > If you are not

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

2017-03-16 Thread Clyde Eisenbeis
t) I've tried FbConnection.CreateDatabase ... using info from StackOverflow: int pageSize = 4096; bool forcedWrites = true; bool overwrite = false; var connectionString = new FbConnectionStringBuilder { Database = stPathFilename, ServerType =

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

2017-03-15 Thread Jiří Činčura
> FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's. To be precise, it's provider, not Firebird. > 1) Was the the correct procedure? Yes. > 2) How do I create a Firebird database file? ... as I did with SQLite > ...