I would suggest that your connection string is a bit complex as well, all
you need is this:
cs = new FbConnectionStringBuilder();
cs.ServerType = FbServerType.Embedded;
cs.Database = fileName;
Security and port numbers and so on are not needed, and may possibly be
confusing it?
Just a guess.
Dean.
_____
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
AAbend (gmail)
Sent: Saturday, 23 December 2006 8:09 am
To: [email protected]
Subject: [Firebird-net-provider] Embedded on windows
I am trying to get embedded running on windows with my app (.net2, firebird
2). I have it running on embedded 1.5 with no problems. I also have it
running on Firebird 2 server with no problems. I renamed the DLLs and set
"servertype=1" in my connection string, but it says it cannot open the
database and the only message I can see is a
"Index was outside the bounds of the array."
My code looks like this..
gsConnection="User=SYSDBA;Password=masterkey;Database="+dbfile+";Port=3050;D
ataSource=localhost;Dialect=3;Charset=NONE;Role=;Connection
lifetime=10;Pooling=false;MinPoolSize=0;MaxPoolSize=150;Packet
Size=16384;ServerType=1";
gIDbConn = new
FirebirdSql.Data.Firebird.FbConnection(gsConnection);
gIDbCommand = new
FirebirdSql.Data.Firebird.FbCommand();
gIDbCommand.Connection =
gIDbConn;
gIDAdapt = new
FirebirdSql.Data.Firebird.FbDataAdapter();
and it worked fine for 1.5.
Thoughts on where to start debugging this?
Thanks
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
