OdcbConnection Open throws InvalidOperationException

  • Thread starter Thread starter John Mairs via .NET 247
  • Start date Start date
J

John Mairs via .NET 247

(Type your message here)

--------------------------------
From: John Mairs

Hi Folks,

I just found and fixed this problem and I wanted you all it know about it.
I'm leaving at details cuz there not important

conn = new OdbcConnection
setup selectCmd
dataAdapter = new OdbcDataAdapter(selectCmd, conn)
cmdBuilder = new OdbcCommandBuilder(dataAdapter)

conn->Open

The Open call would throw an InvalidOperationException which means there's more than 1 connection open.

Problem is this code worked great in Development and then broke when installed on an NT machine and then a 2000 box.

I installed Microsoft's MDAC v2.8 and all problems went away with the same code.

The NT box had MDAC v2.5
 
Back
Top