odbc--connection to 'odbc' failed

[tekkerguy]

I have an access database that uses linked tables to connect to a sql server through a dsn connection. This program worked fine on our one server.

We then changed the odbc to connect to a web server (located at a telco building), and the connection tests passed. Now when I use the access database to save text to a record, it works. But when I delete a record, it gives me the 'odbc--connection to 'odbc' failed' error message, where 'odbc' represents the dsn name.

Any clues as to what may be causing this issue?

 

[tekkerguy]

Ignore this thread, I figured it out. In case anyone is curious, the problem was that all update procedures were performed by the vbscript code in access, but the delete function was being done by a stored procedure.

I updated the connection string in the stored procedure and that fixed the whole issue.