ODBC connection weird problem..seeking for help . Thanks

[ericooi1976]

My problem was it will prompt this message "An unhandled exception of type 'System.Data.Odbc.OdbcException' occurred in system.data.dll", when i click many time of a button "A" that will call the function below:

I noticed when everytime click on the button "A", the function below will run for 3 times, because got other events also call this function to get the value.

I have this function to get a single value from access table when everytime this function been call.

Dim objValue As Object
Dim cn As OdbcConnection

cn = New OdbcConnection("Driver={Microsoft Access Driver (*.mdb)};DBQ=" & pConn.Split("=")(2) & ";UID=;PWD=")

Dim cmd As OdbcCommand = New OdbcCommand(pCmd, cn)
cn.Open()
objValue = cmd.ExecuteScalar
cn.Close()
cn.Dispose()
cn = Nothing
cmd.Dispose()
cmd = Nothing

----------------------------

[ericooi1976]

hi, i found another message while i debugging....
here is the message:
"Run-time exception thrown : System.Data.Odbc.OdbcException - ERROR [08004] [Microsoft][ODBC Microsoft Access Driver] Too many client tasks.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed"

sorry...i should tell you all, that im using VB.net 2003 and MS access as DB.

Thanks for help, please

[Shashi Sadasivan]

could you please explain when you mean that abt the 3 times thing?

did you have the access file open when running the application?

cheers

[kenobewan]

You could deactivate the button when the process starts. Asp.net 2 has a cool clickonce event.