Additional information: Object reference not set to an instance of

[Brad]

Receive the following error when stepping into the FILL (see last line).
Being a newbie I cannot see anything obvious.

Error message:
An unhandled exception of type 'System.NullRef erenceException ' occurred in
system.data.dll
Additional information: Object reference not set to an instance of an object.
Code:
Function JobConsol()

MsgBox(selected JobNo, MsgBoxStyle.Def aultButton2, "Starting the JOB
CONSOL function")

'Connection string
myConnectionStr ing2 = "Database=c:\Pr ogram Files\Ezijobz
SME\Database\De mo\EJDB.FDB;Use r=SYSDBA;
Password=master key;Dialect=3;S erver=localhost ;Pooling=False"
myConnection2 = New FbConnection(my ConnectionStrin g2)
myConnection2.O pen()

myTxn2 = myConnection2.B eginTransaction ()

Dim ConsolCmd As String ' The SQL command for OPERATIONS
Dim dataAdapter2 As FbDataAdapter ' The FB Data Adapter
Dim DS2 As New DataSet ' The dataset
dataAdapter2 = New FbDataAdapter ' Set the data adapter

'Load dataset with OPERATIONS records where @JOBNO
ConsolCmd = "SELECT jobno, squences, opername, uniid FROM operations
WHERE jobno = @JOBNO ORDER BY jobno"
mycommand2 = New FbCommand(Conso lCmd, myConnection2, myTxn2) 'Set
the SQL
mycommand2.Para meters.Add("@JO BNO", FbDbType.Char)
mycommand2.Para meters("@JOBNO" ).Value = selectedJobNo
dataAdapter2.Se lectCommand = mycommand2 'Set the Data Adapter
dataAdapter2.Fi ll(DS2, "Operations ") 'Fill the Dataset with
OPERATIONS records

--
Brad
Sydney, Australia

[Cor Ligthert]

Brad,

Checking it, I did not see a simple error that can be the reason.

This error can be everywhere in your code, the earliest real execution is
the fill.
When you do this you will probably get more information.
Try
dataAdapter2.Fi ll(DS2, "Operations ") 'Fill the Dataset with
Catch ex as exception
messagebox.show (ex.tostring)
End try

I do not know that firebird dataadatapter, maybe there are more errors to
catch.

And because this is a not standard adapter, command etc. I advice you to ask
this question when this will not give the solution as well in the newsgroup

microsoft.publi c.dotnet.framew ork.adonet

There you have more change for people used to non standard database
providers.

I hope this helps anyway something

Cor

"Brad" <Br**@discussio ns.microsoft.co m>

Receive the following error when stepping into the FILL (see last line).
Being a newbie I cannot see anything obvious.

Error message:
An unhandled exception of type 'System.NullRef erenceException ' occurred in
system.data.dll
Additional information: Object reference not set to an instance of an
object.
Code:
Function JobConsol()

MsgBox(selected JobNo, MsgBoxStyle.Def aultButton2, "Starting the JOB
CONSOL function")

'Connection string
myConnectionStr ing2 = "Database=c:\Pr ogram Files\Ezijobz
SME\Database\De mo\EJDB.FDB;Use r=SYSDBA;
Password=master key;Dialect=3;S erver=localhost ;Pooling=False"
myConnection2 = New FbConnection(my ConnectionStrin g2)
myConnection2.O pen()

myTxn2 = myConnection2.B eginTransaction ()

Dim ConsolCmd As String ' The SQL command for
OPERATIONS
Dim dataAdapter2 As FbDataAdapter ' The FB Data Adapter
Dim DS2 As New DataSet ' The dataset
dataAdapter2 = New FbDataAdapter ' Set the data adapter

'Load dataset with OPERATIONS records where @JOBNO
ConsolCmd = "SELECT jobno, squences, opername, uniid FROM
operations
WHERE jobno = @JOBNO ORDER BY jobno"
mycommand2 = New FbCommand(Conso lCmd, myConnection2, myTxn2) 'Set
the SQL
mycommand2.Para meters.Add("@JO BNO", FbDbType.Char)
mycommand2.Para meters("@JOBNO" ).Value = selectedJobNo
dataAdapter2.Se lectCommand = mycommand2 'Set the Data Adapter
dataAdapter2.Fi ll(DS2, "Operations ") 'Fill the Dataset with
OPERATIONS records

--
Brad
Sydney, Australia

[Herfried K. Wagner [MVP]]

"Brad" <Br**@discussio ns.microsoft.co m> schrieb:

Receive the following error when stepping into the FILL (see last line).

If you don't get an answer here, give the folks in
microsoft.publi c.dotnet.framew ork.adonet or a similar group that is related
to database questions a try.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>