Re: ADO Connection with Postgres

--- Michael Aldor <MAldor(at)greenridge(dot)ca> wrote:
>
> I have the ADO recordset open connection working,
> however the append chunk is not inserting anything
> into the bytea field (image). I am getrting data
> into image_name and content_type. Any ideas on how
> to insert binary data to postgres?

I haven't messed with bytea. But you might get
somewhere with this:

http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-vblo

>
> rs.Open "image_table",ConnectionString, 2, 2, 2
> 'After I run rs.open the following error check gives
> me the following error:
> if err then
> response.write("<br><br>" & err.Description & "
> errorNum= " & Err.number)
> end if
> 'Object required errorNum= 424
> rs.AddNew
> rs("image_name") = nameRef
> rs("image").appenchunk fileData
> rs("content_type") = contentType
> rs.Update
> rs.Close
> Set rs = Nothing
> ' after code is run the data in nameRef and
> contentType are store in the database, however
> fileData is not.
>
>
> -----Original Message-----
> From: Michael Aldor
> Sent: Friday, July 16, 2004 6:55 PM
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] ADO Connection with Postgres
>
>
> Hello,
>
> I am trying to connect to a postgres database in ASP
> (vbscript) and insert a blob into a bytea field.
> However I cannot create an open connection via the
> following method.
>
> Any help/suggestions would be appreciated.
>
> ConnectionString =
>
"Driver={PostgreSQL};Server=<servername>;Port=5432;Database=imagedb;UID=imageUser"
>
> Set rs = Server.CreateObject("ADODB.Recordset")
> rs.Open "image_table", connectionString,
> adOpenKeyset, adLockOptimistic, adCmdTable
> 'After I run rs.open the following error eheck gives
> me the following error:
> if err then
> response.write("<br><br>" & err.Description & "
> errorNum= " & Err.number)
> end if
> 'Arguments are of the wrong type, are out of
> acceptable range, or are
> 'in conflict with one another. errorNum= 3001
> 'not sure what to change there
> rs.begintrans
> rs.AddNew
> rs("img_name") = nameRef 'name of the file
> rs("img").AppendChunk fileData 'file data being
> some binary data
> rs.Update
> rs.committrans
> rs.Close
> Set rs = Nothing
>
>
-------------------------------------------------------------------------------------------------------------------
> This communication, including its attachments, if
> any, is intended solely
> for the recipient; it is confidential and may
> contain personal or private
> information, or proprietary and/or privileged
> material. As such, any
> unauthorized use, retention, copying, disclosure or
> other distribution of
> this communication, or the taking of any action in
> reliance on its contents
> is strictly prohibited. If you have received this
> communication in error,
> please notify us immediately and delete this
> communication (and any
> attachments.)
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose
> an index scan if your
> joining column's datatypes do not match
>

__________________________________
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/