Odbcconnection in webservice
Hi,
bad english...
when i run this webmethod in IE using the invoke button:
_
Public Function opendb() As Boolean
Dim oConn As New Odbc.OdbcConnection
oConn.ConnectionString = "DSN=EPO;Uid=myUsername;Pwd=;"
oConn.Open()
'do database stuff
oConn.Close()
Return True
End Function
i get a "internal server error 500"
when i step through the code, the error raises at the "oConn.Open()" function.
when i tested the same function with a "SqlConnection" object, there was no error, and i saw the function returning "true" in XML code.
can anyone help me or does anyone has the same problem?