Hi Bob.
I think that you should NOT supply username and pw when youre using
embedded. Try without.
HTH
Best wishes
Kai Bohli
Kameleongruppen AS
Norway
[EMAIL PROTECTED]
www.kam-sys.com
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Bob K.
Sent: 19. juli 2007 15:30
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] Visual C# and Firebird embedded
databaseconnection failure
i'm unable to connect to a firebird embedded database. any help would be
appreciated.
bob k.
i have the following setup, and i'm getting an error as follows:
* the database is in the same folder as the software.
* installed embedded firebird.
* moved the appropriate firebird embedded files to the same directory
as the application executable.
* the system dsn entry connection successfully
tested.
versions:
=========
Firebird - AD0.NET 2.0 provider 2.0.0.0
Firebird embedded 1.5.3
Microsoft Visual C# codename Orcas Version 9.0 Beta 1
Microsoft .NET Framework 2.0
the c# code:
=============
string connStr;
connStr = "User=SYSDBA;" +
"Password=masterkey;" +
"Database=C:/Photography/Software/rak-photography/rak-photography/rak-photog
raph\y.fdb;"+
"ServerType=1";
FbConnection conn = new FbConnection(connStr);
conn.Open();
the error:
==============
System.DllNotFoundException was unhandled
Message="Unable to load DLL 'fbembed': The specified module could
not be found. (Exception from HRESULT: 0x8007007E)"
Source="FirebirdSql.Data.FirebirdClient"
TypeName=""
StackTrace:
at
FirebirdSql.Data.Client.Embedded.FbClient.isc_attach_database(Int32[]
statusVector, Int16 dbNameLength, Byte[] dbName, Int32& dbHandle,
Int16 parmBufferLength, Byte[] parmBuffer)
at
FirebirdSql.Data.Client.Embedded.FesDatabase.Attach(DatabaseParameterBuffer
dpb, String dataSource, Int32 port, String database)
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()
at FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create()
at FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut()
at FirebirdSql.Data.FirebirdClient.FbConnection.Open()
at rak_photography.FormMain..ctor() in
C:\Photography\Software\rak-photography\rak-photography\FormMain.cs:line
42
at rak_photography.Program.Main() in
C:\Photography\Software\rak-photography\rak-photography\Program.cs:line 17
at System.AppDomain._nExecuteAssembly(Assembly assembly,
String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile,
Evidence assemblySecurity, String[] args)
at
Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext
executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException:
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
