odbc connectivity

Arun Kuamr

Hi All,

I went through code of a project and i observe that a odbc adapter fill dataset sucessfully but connection is closed or only connection string provided.

I am confuse how it work , I think connection should be open other wise exception should be throw.

Kindly clear my confusion.

Below are the code: -

Dim dbconn As Odbc.OdbcConnection

dbconn = New Odbc.OdbcConnection(connectionstring)

If dbconn.State <> ConnectionState.Open Then

dbconn.Open()

End If

dbconn.Close()

Dim dbAdapter As Odbc.OdbcDataAdapter

dbAdapter = New Odbc.OdbcDataAdapter("select * from studdent where id=5", dbconn)

Dim ds As New DataSet

dbAdapter.Fill(ds)

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Arun Kuamr10y ago
No , i have mention all code above
i have enforce close connection to check that is ensure connection is closed.

Dim dbconn As Odbc.OdbcConnection
dbconn = New Odbc.OdbcConnection("Driver={SQL Server};Server=192.168.55.127;Database=o2ms_dev_28March;Uid=abcd;Pwd=ssdfrt@1234#")
If dbconn.State <> ConnectionState.Open Then
dbconn.Open()
End If
dbconn.Close()
Dim dbAdapter As Odbc.OdbcDataAdapter
dbAdapter = New Odbc.OdbcDataAdapter("select DATASETNAME,DBType,DBIPaddress,Port from OmsDatasetMaster where DATASETID=5", dbconn)
Dim ds As New DataSet
dbAdapter.Fill(ds)
Chandu Kumawat10y ago
ya but u must use using keyword like

using(odbcConnection con = new odbcConnection (pass here connectionString))
{
code here....
}
Arun Kuamr10y ago
but we are not assign connection like refer link.
my connection string like this :
Driver={SQL Server};Server=192.168.55.127;Database=abcd;Uid=abcd_login;Pwd=abcd1234
Arun Kuamr10y ago
but in the case of sql connection with data adapter we have to open connection first otherwise we will get exception .
Chandu Kumawat10y ago
if ur use odbc dataAdapter then dont use open and close connection.... the odbc DataAdapter automatically handles that connection

refer this

http://www.c-sharpcorner.com/UploadFile/8ef97c/odbc-dsn-using-in-Asp-Net/
Ranjit Powar10y ago
DataAdapter is disconnected architecture. When you use DataAdapter, you don't need to open and close connection manually.