.NET ODBC DataProvider never connects through the Transform ODBC driver

Question

I have a windows service that I wrote on .Net. In our current implementation, we are interacting with Transoft ODBC. I have logging, and basically when we open an ODBC connection, it just doesn't connect. Never make a mistake or nothing.

We were able to connect to the database through Access, so we know that the connection is working, and the ODBC driver is configured correctly.

I cannot find a timeout for the actual Connection object or anything else that I could configure to make the connection work.

    Dim ODBCConn As New Data.Odbc.OdbcConnection(ConnString)
    ODBCConn.Open()

Any thoughts or ideas on what might happen?

Thanks Brian Swanson

Answer 1

Try connecting:

OdbcConnection objJAMIS = new OdbcConnection("dsn=" + szDSN);

szDSN - DSN, odbc.