how to store object dataype into MS Sql?

Printable View

Jan 24th, 2010, 09:33 PM
ebytp

how to store object dataype into MS Sql?

Please help me on how to store a visual basic 6, object datatype variable's value, into Ms Sql...
Is there any apecific datatype or smething that can be used?
Jan 24th, 2010, 09:40 PM
akhileshbc

Re: how to store object dataype into MS Sql?

Quote:

Originally Posted by ebytp

Please help me on how to store a visual basic 6, object datatype variable's value, into Ms Sql...
Is there any apecific datatype or smething that can be used?

Can you explain it.... :confused:

If are asking about how to to do database programming with VB6 and MS SQL, you can use ADO..... Tutorials can found be in here:
* http://www.vbforums.com/showthread.p...7051#SQLServer
* http://www.vbforums.com/showthread.php?t=337051#ado

Regards,
- Akhilesh :wave:
Jan 24th, 2010, 10:10 PM
techgnome

Re: how to store object dataype into MS Sql?

the type would be varbinary... and then you'll need to use appendchunk and getchunk to save/retrieve the data.

-tg
Jan 25th, 2010, 04:13 PM
si_the_geek

Re: how to store object dataype into MS Sql?

Thread moved to 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums)
Jan 27th, 2010, 10:36 PM
ebytp

Re: how to store object dataype into MS Sql?

c i wnt to knw what datatype can be used to store a data of type 'object' into sql...
Jan 27th, 2010, 11:58 PM
techgnome

Re: how to store object dataype into MS Sql?

the SQL datatype is "varbinary" .... and in code you'll need to use the GetChunk to get it out of the database and AppendChunk to get it into the database.

-tg