Start Updating ole object msaccess jdbc

Updating ole object msaccess jdbc

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

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.

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

This database is on a SQL 2008 R2 x64 database server. I did this on my local machine and after I created my linked server I had some trouble reading text files. (Microsoft SQL Server, Error: 7303) After some research, I found that the SQL Service was running under the NETWORKING SERVICE-account.

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.

I'm now trying to use SQL Server 2012 Express as a back end to just store the attachments.