Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

odbc call fails from .net

 
   Database Help (Home) -> Visual Basic -> ODBC RSS
Next:  Access 2003 ODBC Connect from VB 6.0  
Author Message
Utf-8BbWlrZSBkZWNr

External


Since: Apr 19, 2004
Posts: 1



(Msg. 1) Posted: Mon Apr 19, 2004 4:16 pm
Post subject: odbc call fails from .net
Archived from groups: microsoft>public>vb>database>odbc (more info?)

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 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> Visual Basic -> ODBC All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]