Odbcconnection in webservice

Feb 17 2005 8:57 AM
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?