SAMPLE: JDBCBlob.exe Inserts Blob Data into SQL Server Image Field Using JDBC (298493)


The information in this article applies to:

  • Microsoft Visual Studio, Enterprise Edition 6.0
This article was previously published under Q298493

SUMMARY

JDBCBlob.exe contains a code sample written using Microsoft Visual J++ 6.0 which demonstrates how to insert binary large object (BLOB) data into a SQL Server IMAGE field using the JDBC:ODBC Bridge. The sample uses prepared statements to insert the data and then retrieves the data from the SQL Server server to verify that the data was properly inserted.

NOTE: This sample was tested on a computer with Microsoft Data Access Components (MDAC) 2.6 and SQL Server 7.0. Using this sample with later versions of these products may require code modifications.

MORE INFORMATION

The following file is available for download from the Microsoft Download Center:

DownloadDownload JDBCBlob.exe now

Release Date: August 27, 2001

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file. The JDBCBlob.exe file contains the following files:

File nameSize
JDBCBlobData.sln521 Bytes
JDBCBlobData.vjp4.45 KB
InsertBlob.java7.48 KB
Modification Type:MinorLast Reviewed:8/9/2004
Keywords:kbdownload kbdownload kbfile kbJDBC kbSample KB298493 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.