Results 1 to 6 of 6

Thread: how to store object dataype into MS Sql?

  1. Jan 24th, 2010, 09:33 PM #1
    ebytp
    ebytp is offline

    Thread Starter
    New Member
    Join Date
    Jul 2009
    Posts
    3

    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?
    Reply With Quote Reply With Quote
  2. Jan 24th, 2010, 09:40 PM #2
    akhileshbc
    akhileshbc is offline
    Freelancer akhileshbc's Avatar
    Join Date
    Jun 2008
    Location
    Trivandrum, Kerala, India
    Posts
    7,652

    Re: how to store object dataype into MS Sql?

    Quote Originally Posted by ebytp View Post
    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....

    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

    If my post was helpful to you, then express your gratitude using Rate this Post.
    And if your problem is SOLVED, then please Mark the Thread as RESOLVED (see it in action - video)
    My system: AMD FX 6100, Gigabyte Motherboard, 8 GB Crossair Vengance, Cooler Master 450W Thunder PSU, 1.4 TB HDD, 18.5" TFT(Wide), Antec V1 Cabinet
    Social Group: VBForums - Developers from India


    Skills: PHP, MySQL, jQuery, VB.Net, Photoshop, CodeIgniter, Bootstrap,...
    Reply With Quote Reply With Quote
  3. Jan 24th, 2010, 10:10 PM #3
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    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
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  4. Jan 25th, 2010, 04:13 PM #4
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    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)
    Reply With Quote Reply With Quote
  6. Jan 27th, 2010, 10:36 PM #5
    ebytp
    ebytp is offline

    Thread Starter
    New Member
    Join Date
    Jul 2009
    Posts
    3

    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...
    Reply With Quote Reply With Quote
  7. Jan 27th, 2010, 11:58 PM #6
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    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
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width