Unable to connect bundled embedded database on macOS
Key: DNET-744
URL: http://tracker.firebirdsql.org/browse/DNET-744
Project: .NET Data provider
Issue Type: Bug
Components:
1) It's not obvious to me where to put the 'using' with 'try'. Could
you provide an example using the code in my first email?
2) Is this what you recommend?
where stSql = "CREATE TABLE TableOrg ( fstPriority VARCHAR(10),
fstInfo VARCHAR(x) CHARACTER SET UNICODE_FSS, fiKeyID INTEGER PRIMARY
1) I think it would be
string stOpenConn = new FbConnectionStringBuilder {
Database = stPathFilename,
UserID = stUserID,
Password = stPassword,
ServerType = FbServerType.Embedded,
ClientLibrary = stCLIENT_LIBRARY
}.ToString();
using
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
> 1) Is it correct to have multiple fbCmd.ExecuteNonQuery() commands ...
> followed by one fbTransaction.Commit()?
Yes. Also use `using` block for disposable resource.
> 2) I want to be able to handle German vowels, such as umlauts, for
> fstInfo. I don't think VARCHAR is the correct choice as