' The ADO Connection Object is used to create an open ...
' The ADO Connection Object is used to create an open connection to a data source. Through this connection, you can access and manipulate a database.
' Only windows
Set adoConexao = CreateObject("ADODB.Connection") adoConexao.ConnectionString = "provider=OraOLEDB.Oracle;Data Source=;User Id=;Password=;PLSQLRSet=1"
adoConexao.Open
' adStateOpen
' The object is open
adStateOpen = 1
If ( adoConexao.state = adStateOpen ) Then
' select from ORACLE - IMG_FIELD is an BLOB field
SQL = "SELECT IMG_FIELD FROM TABLE WHERE SEQUENCE="
' The ADO Recordset object is used to hold a set of records from a database table. A Recordset object consist of records and columns (fields).
' This doesn´t work with Lotus ODBC class, so we need use a ADODB RecordSet
Set adoRecordset = CreateObject("ADODB.RecordSet")
adoRecordset.Open SQL, adoConexao
If Not ( adoRecordset.EOF ) Then
' The ADO Stream Object is used to read, write, and manage a stream of binary data or text.
' adSaveCreateOverWrite
' Overwrites the file with the data from the currently open Stream object, if the file already exists
adSaveCreateOverWrite = 2
' adTypeBinary
' Binary data
adTypeBinary = 1
Set adoStream = CreateObject("ADODB.Stream")
With adoStream
.Type = adTypeBinary
.Open
.Write adoRecordset.Fields("IMG_FIELD").value
.SaveToFile "C:Temp.jpg", adSaveCreateOverWrite ' path of image
.Close
End With
Set adoStream = Nothing
Set adoRecordset = Nothing
Set adoConexao = Nothing
End If
End If
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- database connection string to mysql database on a
- section 1 creating a ups worldship import map
- ups interface setup instructions
- procedure for using ups worldship with mas 90 or mas 200
- mutual research transcript exchange mrte
- the ado connection object is used to create an open
- relational database rdbms via odbc interface to the pi
- cd financial reports crystal reports
- database connections for applications that integrate with
- ssl connection guide travelport
Related searches
- how to have an open house
- how to do an open house
- how to create an email account
- how to create an effective mission statem
- how to create an effective mission statement
- how to hold an open house
- how to create an array in java
- i want to create an email address
- how to create an amortization schedule excel
- how to create an email address
- how to create an fsa id
- how to create an etf