Help!Please!

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hello! I am a brazilian girl and I need help to solve some problems with SQLServer.

I have an image on a buffer and a pointer to it. I would like to save this image on a SQLServer field with Visual Basic. The fact, is that I don't want to keep this pointer in the field. I want to save "the image" itself. Would you please, help me sending some examples of how I could solve this problem?

I would be very grateful.

Thank you very much.

Carmen

-- Anonymous, October 06, 1997

Answers

Re: Image manipulation

Carmen,

I think you have to use an SQL_LONGVARBINARY data type and use an ODBC interface to your SQL Server (rather than VBSQL). It seems that the SQL_LONGVARBINARY type is new for SQL Server 6.X, that is I don't think this datatype exists for SQL Server 4.21a.

Hope this helps,

Eric Kohnen Client Registry Database Manager Washington State Dept. of Social & Health Services, Research & Data Analysis Olympia, WA USA sqldba_eric@kohnen.com

-- Anonymous, October 07, 1997


Re: Visual Basic, SQLServer6.5, Image

Carmen,

I think you need to use ODBC to call SQLPutData.

I will email you a couple of articles from SQL Server Books Online which include a C language example. The titles of the articles are "SQLPutData (Extension Level 1, ODBC 1.0)" and "Data-at-Execution Parameter Limitations".

Eric

-- Anonymous, October 08, 1997


Visual Basic, SQLServer6.5, Image

Dear Eric,

I am very grateful for receving your answer. But the answer you gave me was not exactly what I needed. I know that SQLServer 6.5 has an image data field. The problem is how to save this image into this field with VB.

Would you still help me?

Thank you very much.

Carmen

-- Anonymous, October 08, 1997


Hi Carmen, Just wanted to say hello to a distant cousin. I am a IT recruiter in Dallas who is originally from NYC. Have a great day :-)

-- Anonymous, January 26, 2000

u may used the adodb.stream on saving the image on your database. using this u can save picture as image on database.

-- Anonymous, July 26, 2002


Moderation questions? read the FAQ