ODBC .Net Connection Question

[Guest_imported]

Has anyone managed to successfully connect to and query a Remedy server using ADO.Net?

I have used ADOBC 2.6 from VB6 plenty of times, but .Net (apparently) no longer supports v2.6 ODBC drivers across OleDB connections. I cannot get an OleDBConnection to work and I can't figure out a valid connection string for an OdbcConnection object.

Any help (and sample code) much appreciated.

Thanks

 

[Guest_imported]

Solved.

For anyone else with the same issue, you need to add the DSN to the system DSNs, rather than the default User DSNs. VB .Net doesn't mind, but ASP .Net will only access System DSNs from OdbcConnection.