good afternoon all,
I am running into a problem in that a executereader command fails with no error messages. here is a snipit
i know that the odbc connection opens,then I get an error from the line
reader = command.ExecuteReader
the odbc is from sybase, and works find from access.
any ideas?
'now populate with call to synergy dns database via odbc
Dim con = New OdbcConnection("DSN=Sybase Has4win")
con.open()
Dim command As New OdbcCommand
command.Connection = con
command.CommandType = CommandType.Text
' command.CommandText = "Select * from DBA.t_patient where patientcode='" + patient_id + "'"
Dim reader As OdbcDataReader
reader = command.ExecuteReader
Do While reader.Read()
'populate datset with call
Loop
reader.Close()
con.Close()
>> Stay informed about: odbc call fails from .net