Connecting MS Access to Teradata to view BLOB

Connectivity

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 15.10.00.00.

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!

Tags (3)
1 REPLY

Re: Connecting MS Access to Teradata to view BLOB

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