Hi,

At February-21-11, 5:13 PM, Sebastian wrote:


> Hi,

> I installed the Firebird .NET provider 2.6 and the VS 2010 integration.

> Now I want to create a new connection in the IDE, and so I select the
> firebird provider als the correct provider and set the options for the
> connection (database name, etc).

> When I click on 'Test connection' I always get a 'IndexOutOfRangeException'
> from the provider. The stack trace points to the GetServerVersion() call.

> In fact, it looks very like this issue here:
> http://tracker.firebirdsql.org/browse/DNET-330
> But that issue says it's fixed in 2.6 (which I use).

> I also installed the DDEX integration.
> I have the latest Firebird server and the 2.6 ADO.NET provider installed.

> Firebird itself runs fine (I can connect to the database using IBExpert).
> This small sample code here totally fails though:

>                         try
>                         {
>                                 FbConnection conn = new
> FbConnection(@"Server=127.0.0.1;User=SYSDBA;Password=masterkey;Database=C:\Users\smartBugs\Documents\PCTRADE.gdb");
>                                 conn.Open();
>                         }
>                         catch (Exception ex)
>                         {
>                                 this.Text = ex.Message;
>                         }

> Please help me, this is somewhat urgent.

> Thanks,

>    Sebastian

Could you try:
 FbConnection conn = new FbConnection("data source=127.0.0.1;User 
id=SYSDBA;Password=masterkey;Initial 
Catalog=C:\Users\smartBugs\Documents\PCTRADE.gdb");

I usually write this way:
  FbConnection conn = new FbConnection();
  conn.ConnectionString = "data source=127.0.0.1;User 
id=SYSDBA;Password=masterkey;Initial 
Catalog=C:\Users\smartBugs\Documents\PCTRADE.gdb";

-- 
Best regards,
 Daniel Rail
 Senior Software Developer
 ACCRA Solutions Inc. (www.accra.ca)
 ACCRA Med Software Inc. (www.filopto.com)


------------------------------------------------------------------------------
Index, Search & Analyze Logs and other IT data in Real-Time with Splunk 
Collect, index and harness all the fast moving IT data generated by your 
applications, servers and devices whether physical, virtual or in the cloud.
Deliver compliance at lower cost and gain new business insights. 
Free Software Download: http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to