Unix Technical Forum

helps required in postgresql and visual basic 6.0

This is a discussion on helps required in postgresql and visual basic 6.0 within the pgsql Hackers forums, part of the PostgreSQL category; --> hello sir I am software engineer. i have a problem in postgresql. i am using postgresql 8.2.4 version and ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-15-2008, 10:48 PM
Vishnu Aggarwal
 
Posts: n/a
Default helps required in postgresql and visual basic 6.0

hello sir

I am software engineer. i have a problem in postgresql. i am using
postgresql 8.2.4 version and i have save image in table by java program
my table fields as id-integer ,image -bytea

i insert image by java in prepared statement by setbinarystream() its
running perfects.
i can retrieve image by java application also.

but when i used this in visual basic 6.0 its gives problem

Dim Chunk() As Byte
Open imagename For Binary Access Write As #1
ReDim Chunk(1 To RS("FImage").ActualSize)

Chunk() = RS("FImage").GetChunk(RS("FImage").ActualSize)
Put 1, , Chunk()
Close #1


its says when its comes in image field its gives errors

operation is not allowed in this context

helps me out


regards
vishnu aggarwal

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-15-2008, 10:48 PM
Heikki Linnakangas
 
Posts: n/a
Default Re: helps required in postgresql and visual basic 6.0

Vishnu Aggarwal wrote:
> I am software engineer. i have a problem in postgresql. i am using
> postgresql 8.2.4 version and i have save image in table by java program
> my table fields as id-integer ,image -bytea
>
> i insert image by java in prepared statement by setbinarystream() its
> running perfects.
> i can retrieve image by java application also.
>
> but when i used this in visual basic 6.0 its gives problem


This mailing list is for discussions regarding development of PostgreSQL
server. Please post your question on a more appropriate list.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:51 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com