Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Pro VB 6
|
Pro VB 6 For advanced Visual Basic coders working in version 6 (not .NET). Beginning-level questions will be redirected to other forums, including Beginning VB 6.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 19th, 2004, 05:19 AM
Authorized User
 
Join Date: Nov 2003
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Default Up/downloading Files VB+MySQL

Can anyone tell me how to upload/download a file on a MS SQL Database using Visual Basic ? Are there any "special" procedures/objects ?(Hope I 'm not asking too much... :-))

Mille grazie
Mike


 
Old May 21st, 2004, 04:25 AM
Authorized User
 
Join Date: Apr 2004
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Basically there are two ways to work with MySQL in VB. ADO, which is terribly slow and a direct or slightly encapsulated useage of MySQL API. I am using the othere method and it is not so difficult to e.g. upload the whole large images into the databse and than take them out.
Simply make the whole file a variable, transfer it to byte() type and you are almost done. I may dig up some example if this is what you have been asking.

webdesign
 
Old May 21st, 2004, 04:53 AM
Authorized User
 
Join Date: Nov 2003
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes, that's what I meant.

The technology is Visual Basic 6.0 and MS SQL Server.
Are there any improvements in VB.Net ?

Thanx in advance


 
Old May 24th, 2004, 03:56 AM
Authorized User
 
Join Date: Apr 2004
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry.

I do not use Ms SQL. The title of the thread was MySQL so I replied on using MySQL, did not noticed that it was your typo.

webdesign





Similar Threads
Thread Thread Starter Forum Replies Last Post
Uploading and downloading MySQL BLOB's Marcus Maximus PHP Databases 5 March 10th, 2008 11:32 PM
Downloading files via a browser gfrank1157 ASP.NET 2.0 Basics 3 June 14th, 2006 04:13 PM
Protect Files from downloading asif_sharif ASP.NET 1.0 and 1.1 Professional 6 January 11th, 2006 01:59 AM
MySql downloading Lee Fenner MySQL 1 October 8th, 2004 03:42 AM
downloading files serge Classic ASP Professional 4 September 8th, 2003 10:36 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.