Transoft DSN cannot see DAT file from .NET

[kfleeman]

I'm trying to connect to flat files using a Transoft DSN connection in ASP.NET. I can connect to and see the files using the exact same System DSN from Win U/SQLi32. The error occurs when I try to execute the ODBCDataReader.

The error I receive is: ERROR [HY000] [Transoft][TSENG32](log: 2840-121835) File does not exist: filename.DAT

Does anyone know how to correct this?

 

[kfleeman]

I tried something today. I made a new MS Access Database, linked to the table I needed using the Transoft ODBC connection I had made previously. I then changed the Connection in my code to open an ODBC connection to the Access Database. Slightly modified my query, then executed the page. Now I get:

ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] ODBC--call failed

Here is my code:

        Dim conn As OdbcConnection
        conn = New Odbc.OdbcConnection("DSN CONNECTION STRING HERE")
        conn.Open()
        Dim strSql As String
        strSql = "SELECT STATEMENT HERE"
        Dim cmd As Odbc.OdbcCommand
        cmd = New Odbc.OdbcCommand(strSql, conn)
        Dim rs As Odbc.OdbcDataReader
        rs = cmd.ExecuteReader

Any help would be greatly appreciated.


-------------------------------------
Karl R. Fleeman
Shotgun Programming
Scatterbrained, but effective