This is going to be a long story I'm afraid ;-( I have to read some text-files into a SQL database. OLEDB.12.0" for linked server "XXXXXXX" returned message "Unspecified error".

updating ole object msaccess jdbc-46updating ole object msaccess jdbc-85updating ole object msaccess jdbc-32

SQL Server Express edition has several limitations that do not allow configuring or using Linked Servers.

A Linked Server enables the SQL Server Database Engine to execute commands against OLE DB data sources outside of the instance of SQL Server.

ODBC (Open Database Connectivity), JDBC (Java Database Connectivity), ADO. NET), and OLE DB (Object Linking & Embedding for Databases) are key data access standards used by compliant applications to connect to a wide variety of Data Sources (primarily SQL–compliant RDBMS hosted data).

These standards are critical to legacy and contemporary tools for: RDF is an abstract language for expressing observation (data) using subject, predicate, object sentences/statements.

The user who is testing is connected to the database engine with a windows AD account, also belonging to the administrator group.

But when he tries to test the connection, it throwing the same error.

First thing we need to do is set the column type as OLE Object.

While saving the data into the column of type OLE Object, save the data as byte array, while retrieving the image from the column read the value, put the value into byte array and then convert the byte array to image type and display the same.

Hi, I use Access 2013 and have a table with an 'Attachment' data type field.