Hi

I usually get this error when I  try something like:
Datatable tbl1 = datatablefromdataset();

If ai modify this to:
Datatable tbl1 = new datatablefromdataset();
 Works ok!

Regards,
Paul

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Robert Hollay
Sent: 16 June 2008 00:14
To: [email protected]
Subject: [Firebird-net-provider] Error: Object reference not set to an
instance of an object

Dear All,

I am new to VB.NET, and generally new to .NET programming at all.
Have installed Visual Studio 2005 on Windows XP Prof., a Firebird 2.1
server, FirebirdClient ADO.NET 2.0 Data Provider (version 2.0.1.0),
and Visual Studio 2005 DDEX Provider for Firebird (version 2.0.2.0).
Have made all settings in machine.config file (suggested by Jiri Cincura),
and configured and registered FirebirdDDEXProviderPackageLess32.reg.

I can now see .NET Framework Data Provider for Firebird in Server Explorer,
can see all the tables, views, etc, and all seem to work OK.
I have also added FbCommand, FbDataAdapter, FBConnection to Data Toolbox.

If I drag a FbDataAdapter to a new Form, configure the connection, write a
simpleSQL (like: SELECT ID, NAME, ADDRESS from EMPLOYEES), 
then generate a DataSet (named dsKataReg), so far all seem to be OK ...

But if I add a DataGridView to the form, and bind it to above mentioned
DataSet, then Run the project, it drops errors:

    One or more errors encountered while loading the designer. The errors
are listed below. 
    Some errors can be fixed by rebuilding your project, while others may
require code changes

    "Object reference not set to an instance of an object."
    at System.Data.UniqueConstraint.Create(String constraintName,
DataColumn[] columns)
    at System.Data.ConstraintCollection.FinishInitConstraints()
    at System.Data.DataTable.EndInit()

There are in fact two lines with this error in Form1.Designer.vb:

    CType(Me.dsKataReg, System.ComponentModel.ISupportInitialize).EndInit()
    CType(Me.Table, System.ComponentModel.ISupportInitialize).EndInit()

Could you please help me with this issue? Has anybody the same problem? How
can it be solved?

If I connect via ODBC driver to the same Firebird 2.1 database, all is
working OK. So the problem
should be somewhere with Firebird ADO.NET Data Provider, I suppose ... maybe
some configuration issue?

Thank you in advance for your help and best regards,

Robert




-- 
See Exclusive Videos: 10th Annual Young Hollywood Awards



-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to