All Forums Connectivity
kinselbd 1 post Joined 09/15
29 Sep 2015
Connecting MS Access to Teradata to view BLOB

I'm attempting to connect MS Accses to a Teradata table with the intention of viewing an object in a BLOB field I have stored there. 
I'm connecting Access to Teradata through a System DSN connction using Teradata driver
My method was to link the table in Access to Teradata through this connection.
When I'm in Access I can see the rest of the fields of the table, however I cannot open the file. I get the following error:
"A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control.
Close the OLE server and restart it outside Microsoft Access. THen try the original operation again in Microsoft Access."
I'm at a loss of where to go from here, any help would be appreciated!

yvonnewatkins 2 posts Joined 11/14
30 Sep 2015

What happens when you do a SELECT FROM statement against the access table?

You must sign in to leave a comment.