Here is the error reported by .Net:
I/O error for file CreateFile (open) "D:\WORK\Logger\Database\Firebird\MCSCRE.FDB" Error while trying to open file However, no other process has the file open. - A _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean Harding Sent: Monday, January 01, 2007 8:09 PM To: 'For users and developers of the Firebird .NET providers' Subject: Re: [Firebird-net-provider] Connection string for embedded firebird Personally, I prefer the use of the FbConnectionStringBuilder class, the following works: FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); cs.ServerType = FbServerType.Embedded; cs.Database = fileName; Calling ToString() on this returns: "Initial Catalog={fileName}; Server Type=Embedded" Notice that you don't need to specify a user name/password - there is not security in embedded mode. Also, you can use the text of the enumeration for Server Type ("Embedded" is more readable than "1") What is the error that you get? It could be a file system permissions thing. Also remember that embedded mode acts like super server - meaing you cannot open the same database file from different processes. This is important if you're trying to run in embedded on a web farm or something (you basically can't do it); it also proves problematic in the event of worker process recycling in IIS6 (in fact, I wouldn't recommend embedded mode at all in a website). Dean. _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Chalk Sent: Tuesday, 2 January 2007 12:56 pm To: [email protected] Subject: [Firebird-net-provider] Connection string for embedded firebird Could someone give me or refer me to some example connection strings for the embedded version of Firebird? My string below gets an error opening the file. <add key="DBConnectionString" value="Data Source=local; Charset=ASCII; Database=D:\\WORK\\Database\\Firebird\\ABC.FDB; User Id=sysdba; Password=masterkey; ServerType=1"/> Many thanks. __________________________________ Communications Solutions 7000 Independence Pkwy., Ste. 160-227 Plano, TX 75025 USA (972) 377-9074 www.magnacartasoftware.com <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
image001.gif
Description: GIF image
------------------------------------------------------------------------- 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
