Visual Basic :: Uploading Textfile Into SQL Server

Trouble Uploading .jpg To Ftp Server
ok, i am using the following vbcode in hopes of uploading a .jpg file to my ftp web server. This code lets me upload a smaller .txt file but the .jpg doesn't transfer.. any ideas?

Public Function UploadFile(ByVal HostName As String, _
ByVal UserName As String, _
ByVal Password As String, _
ByVal LocalFileName As String, _
ByVal RemoteFileName As String) As Boolean
Dim FTP As Inet
Set FTP = New Inet
With FTP
.Protocol = icFTP
.RemoteHost = HostName
.UserName = UserName
.Password = Password
.Execute .URL, "Put " + LocalFileName + " " + RemoteFileName
Do While .StillExecuting
DoEvents
Loop
UploadFile = (.ResponseCode = 0)
End With
End Function

---the button is on a MS Access form----

Private Sub Command54_Click()
Dim b As Boolean
Dim filename, filename1 As String
filename = Me!txtImageName ' the full path of the image file from my form
filename1 = Me!ImageFileName ' the image file name
b = UploadFile("ftp.mysite.com", "username", "password", filename, filename1)

If b Then
MsgBox "Upload transfer completed"
Else
MsgBox "File not transfered"
End If
End Sub

Uploading File To Server
Hello. I need some code. What is the code for a client and server to upload file to server and then run the file using the client? Thank you in advance!

Uploading Images Using VB And MS-SQL SERVER
hi,

I want to upload images into the SQL SERVER database using
VB. I want images to be stored in the database and not the path of where images are located on the hard-disk

how can I do it

VJK

Uploading A File To A Server
I have a document (MS WORD) that has to be sent to a web server. How can i send this doc to my web server using VB .

I tried getting a file from any server page using the "Internet transfer control"
. Can i use "Internet controls" and wppost function to post my file back to the server, if so kindly help me to do.

Uploading And Downloading To/from Server
I have created an application in VB6 that uploads and downloads data files to a folder which I created on a website server. I use a utility called FTP Client Engine to do the file transfers. It work most of the time. Unfortunately, that's not good enough.

The issue is that I need a way to do this that has bullet-proof, industrial strength reliability. I will have customers who will depend on downloading data on a daily basis to update their financial charts.

I am considering upgrading to Visual Studio 2005 and using VB.Net with it's built-in file transfer functions.

I am working with two file sizes. One type of file is about 200MB, the other is about 0.1MB.

I would appreciate suggestions from anyone who has experience with doing this kind of thing.

Uploading Files To Server
Hiya
I am writing an application in which several users at different locations need to be able to upload their files (in excel) everyday at a website ( to my server) and then I am going to read those files and retrieve data to transfer to sql server for other applications.
Can anyone tell me how to provide such a feature for uploading files and then posting it to server? I guess something using ASP and VB script.

Thanks !
Zee

Uploading Pictures To Server With ASP - PLEASE HELP!
Hi, please help me, i need to figure out how to upload a picture file (jpg, gif) or whatever (wav, etc) to the server from an asp page..

1. Is it possible to bring out a select file dialog and then the user selects the file and an upload starts (JUST LIKE UPLOADING MP3S ON MP3.COM)..

2. And how do i figure out when such file transfer is finished so i can redirect the page or something.

I need this badly, so if you have any idea or a piece of code please reply!

---------------------------------
The Decayed - the_decayed@hotmail.com

Uploading File To Ftp Server
Hi there,
Can anybody tell me how to upload a file to a ftp suerver using any control (itmay be ITC or MSWinsock control). If code available then I will be very grateful to you.
Thanks in advance

Prashant J.

Uploading Files To Linux Server. Pls Help Me Out.
I am using MsProject Component and on a button click it should upload the MSProject (MPP)file on to the server(linux).. is it possible ! !

Automatically Uploading A File To A Server
I'm new to server management. 1) What is the VB code to automatically upload a file, such as the results of a test, to a web server online? 2) What must I do and have on my web server to get this to work?

Here's some code I found that I think will do the trick. I want the user to click a Submit button so it submits the results of a quiz to the WEb server:

Will this work in 6.0? From: http://support.softartisans.com/docs...g_simplevb.htm

A Simple Visual Basic Upload

To use XFile from Visual Basic, add XFile to your list of VB references.
Exercise 3: A Simple Visual Basic Upload

1. Create a new, standard, Visual Basic project.

2. Open the Project menu, select References, and check "SAXFile 1.0 Type Library".

3. Create a command button on your form, name it cmdSendFiles, and give it an appropriate caption (such as, "Upload").

4. Enter the following code in the code section of your form.

Private Sub cmdSendFiles_Click()

'--- Create an instance of the XFRequest object, XFile's principal object
Set XFile = New XFRequest

'--- Set the Server to which you are uploading
XFile.Server = "localhost"

'--- Set the specific script to which you are uploading
XFile.ObjectName = "/SAXFileSamples/asp/post/onefile/formresp.asp"

'--- Set a file to upload
XFile.AddFile "C:oot.ini", "File1"

'--- Begin transferring the files
XFile.Start

'--- Destroy the XFRequest Object
Set XFile = Nothing

End Sub

5. Run the project and click on the upload button. Boot.ini will be uploaded to the local server.

Understanding the Script

* Set XFile = New XFRequest creates an instance of the XFRequest object. XFRequest is XFile's principal object. XFRequest sends the HTTP request (Get, Post, or Put) to the server.

* SAXFile.Server sets the domain to which the file will be posted. In this example we use "localhost." If we were posting through the Internet, we would use the format "www.domain.com."

* SAXFile.ObjectName specifies the exact page to which our request will be posted. In this case, it is formresp.asp, located in /saxfilesamples/asp/post/onefile. Formresp.asp uses SoftArtisans FileUp to process the upload.

* SAXFile.AddFile presets a file to upload. Addfile takes two parameters: the path and file name on the client, and an item name for reference to the file on the server.

* SAXFile.Start initiates the file transfer.

* Set XFile = Nothing destroys the project's instance of the XFRequest object. This prevents draining of your resources.

Uploading Excel Data To SQL Server
Hi, I want to upload datas from Excel to SQL server through backend, i may have more than 1 worksheets.
Please help me............

Uploading Images Into SQL SERVER Database
hi,

I want to upload images into the SQL SERVER database using
VB. I want images to be stored in the database and not the path of where images are located on the hard-disk

how can I do it

VJK

Uploading Data On Remote Ftp Server Using VB6.0
Dear All

I want to do the following using VB 6.0.Any help will be highly appreciated.

1.Establish connection to the remote FTP host.
2.Authenticate the user. (Ex:-Username anonymous pwd abs@xyz.com)
3.Upload all zip files to the FTP server (ex:172.10.5.9/Folder/) from the local system.(c:*.zip)
4.Rename the uploaded zip files or move to another folder on local system.

This should happen everyday at 1:00 AM (Schedule)
If anybody hv sample program then pls forwrad it to me.

Thanks

Waiting for a +ve response

Uploading Images Into SQL SERVER Database
hi everybody,

I want to upload images into SQL SERVER database. I want images to be stored in the database and not the path of the images.

how can I

I am using VB 6.0

Need To Know How To Uploading VB+access Database To Web Server
i am at present working on a project that is using access tables and forms and vb code behind it and i looking to put an asp front end on it so i can access it through the web can someone tell me if this can be done and if so how

Regarding File Uploading To Remote Server
Hi,

In my Project I need to upload/Download files to/from remote server,
That i did it using third party OCX.It is working in our site
But when i test it by connecting to our clients site ,it is not working.
any one have any idea Why it is not working?
Regarding this If i need to tell U more details ,send me What I should tell u in detail ?

Thanks in advance
Sav2p1y

Uploading In Visual Basic 6 In Sql Server 2000
can you pls. teach me how to upload in sql server 2000 using visual basic 6. thanks.

FTP Connection To Remote Server And Uploading File
Hello Dears Gurus

I am VB developer and I need ur assistance in the following context

FTP (Uploading and Downloading File)

I am working on different web sites and now I need to connection to my remote server upload some notepad file to my remote server, download some note pad file and delete some notepad file in my remote server I think I can do this through FTP but I donot now how I do this in my Visual basic Codes I need u help I shall be very thankful to u
Secoundly how can I came to know that conection of internet is connected or disconnected

Ok Bye

Tamoor

Connection Resets When Uploading Files From A Client-server Application
Hi, hope someone could help me out on this.

I am debugging an existing client-server application written in vb 6. This application basically uploads files from the client app to the server. The post will be handled by an ASP page that calls an IIS Application(Web Class). It seems to work fine, but when I tried doing uploads for files greater than 4MB, a timeout error was returned. When I looked at the IIS log, it has an sc-status 200 and sc-win32-status 64.

The server app resides in win 2k3 enterprise ed. sp 1 that acts as a domain controller. I have a client app running on win xp professional sp 2. When uploading files from winxp to win 2k3, even up to 6MB, no timeout error was returned. But when trying to simulate the action by uploading a file in client app in win2k3 to the server app that resides in the same machine, the error occurs.

Based on my researches, sc-status 200 means that the request have been successfully done by the IIS. According to microsoft, the sc-win32-status 64 message means that "The specified network does not exist", meaning the client resets the connection after receiving the final response from IIS.

I've done many configuration tweaking, such as increases in IIS connection timeouts, ASP file buffering, etc, even installed hotfixes (Microsoft KB898708) but to no success. I've also tried monitoring the activity thru TracePlus Winsock but I couldn't pinpoint exactly where the connection resets because the application hangs after clicking the upload button.

I'm looking at the angle that the problem has something to do with the client program, which was written using Microsoft Internet Transfer Control (MSINET), a wrapper class for WinInet. Thus, I would like to have a good monitor that oversees the client request-response activity while connected to the server so that I would be able to catch the reset error. Can someone direct me to the appropriate mechanism may it be a software, approach, whatever! Moreover, can you shed some light why does this happen? I am desperate as I have already spent 3 weeks and counting solving this bug.

Please please PRETTY PLEASE?!?!

Many thanks!

Uploading Any File Via FTP To A Ftp Server - INCLUDES WORKING SOURCE CODE
I'm just wondering is there any way to do this in VB without the extremely long API or extra modules or anything - like using components such as Winsock or Inet (I've heard it is possible, but maybe that's rubbish).

I haven't got a problem with API or extra modules. It's just that I'm going to need this for a college project which is going to be examined, and I'd rather go through the hassle (if it's worth the time) of learning how to use the control and then using it in my own project. I'd rather not use someone else's code since

1) I'm going to have to reference that in my coursework, which might make examiners go "oh, this person doesn't know real solid programming. He's just copied and pasted anything he could find off the internet. Even a baby can do that!"

2) I could just not reference that, but thats really wrong and they'd probably suspect with all the commenting like

VB Code:
'FTP Transfer via API'(c) John Smith 2005. You can freely distribute this code'Website: [url]http://www.planetsourcecode.com[/url]'Email: [email]johnsmith@someisp.com[/email]'...

If you could come up with something, then that would be absolutely brilliant. I've tried PlanetSourceCode already and have searched the forums. By the way, I am handing reps out

kregg

File Uploading To Ftp Server: Internet Transfer Control Vs CftpClient Class
I am develping an application which will upload the files to ftp server.
(My application will upload image files to ftp server)

What I found is that there are two ways to do this:

1. By using : Internet Transfer Control
2. By usging:CftpClient class/ ftpFiles and related classes

I got sample code on both of these.

But: "Which one is better and effcient. Which method should I use."
Please help and guide and if you can tell the difference between these two methods.

Please help and guide.

Saving Server Variables To Local Textfile
Hi

I wonder if someone could please give me some suggestions about the following problem i have:

I have a web application that uses VB6 COM-compoents for handling the business logic. I want from the web page give the user the possibility to save some page variables to a text file located on his local machine. I also want to give him the possibility to choose where on the local computer the file will be created (with some sort of file save dialog).

Can someone help me with this I would be very greatful

regards
Helmut

Using The Do While Loop To Read 2 Textfile And Save The Results In The 3 Textfile(vb)
Hi there

can you please help me with the vb code that will open 2 textfiles and save the data into the third one.the first file contains the agentcode and the second one contains the 12 products.Each agentcode must be given the 12 products and save the results into the third one.

AGENTCODES
AQ/01/000
AQ/01/001
AQ/01/002
AQ/01/003
AQ/01/004
AQ/01/005
AQ/01/006
AQ/01/007
AQ/01/008
AQ/01/009
AQ/01/010

THE PRODUCTS FILE

ALE12151620
GAP50257050
GRO55607090
HPP120150120100
HVP55807563
MBB83607520
MFB665599100
PRO781008945
RFM200300555990
RHP8845044566
RPG607088755
RPV66907863

THE RESULTS MUST LOOK LIKE THIS
Agent CodeProdS-RateA-CommO-Comm1O-Comm2
AQ/01/000ALE12151620
AQ/01/000GAP50257050
AQ/01/000GRO55607090
AQ/01/000HPP120150120100
AQ/01/000HVP55807563
AQ/01/000MBB83607520
AQ/01/000MFB665599100
AQ/01/000PRO781008945
AQ/01/000RFM200300555990
AQ/01/000RHP8845044566
AQ/01/000RPG607088755
AQ/01/000RPV66907863
AQ/01/001ALE12151620
AQ/01/001GAP50257050
AQ/01/001GRO55607090
AQ/01/001HPP120150120100
AQ/01/001HVP55807563
AQ/01/001MBB83607520
AQ/01/001MFB665599100
AQ/01/001PRO781008945
AQ/01/001RFM200300555990
AQ/01/001RHP8845044566
AQ/01/001RPG607088755
AQ/01/001RPV66907863

I'VE TRIED THE DO WHILE LOOP BUT I DON'T GET THE RESULT THAT I'M LOOKING FOR

Set f = fso.OpenTextFile(path, ForReading)
Dim line As StringA
Dim final_file As String
Dim sh_string As String
Dim file As String
Dim file_final As String

file_final = text_write.Caption

line = "a"
Do While line <> ""

line = f.ReadLine

Open file_final For Input As #2
file = "a"
Do While file <> ""

file = f.ReadLine
Line Input #2, inputdata
file = inputdata & vbCrLf

final_file = line & Space(5) & file
str = ""

show_string = show_string & final_file & vbCrLf
'**************************
final_file = ""

Loop

Loop
MsgBox show_string
Call write_2_file(show_string)

Part Of Textfile Content To Another Textfile
Quote:

Help please.

This is in VB6. I want to transfer the content or make a duplicate copy of a textfile (e.g. C:UploadSales.txt) to another textfile (e.g. C:UpdateSales.txt), the textfile is saved in different directory. How can I do this? Thanks!

Above is the first scenario of the textfile. My follow up question is: how will I code this? I want to put just a part of the content of C:UploadSales.txt, let's say I want to put the content dated 05/01/2006 to 05/15/2006 to C:UpdateSales.txt?

Example content(content of C:UploadSales.txt):
05/01/2006, 2, Black
05/02/2006, 10, grey
05/03/2006, 5, white
05/05/2006, 3, yellow
05/10/2006, 4, red
05/15/2006, 1, pink
05/16/2006, 7, green
05/18/2006, 8, blue
05/25/2006, 9, brown

Textbox To Textfile To Print Textfile
I need help. I am a newbie at VB, and I am creating a program in which I need the text from a textbox to be put into a textfile and then the textfile to print, all with just the click of a button or menu item. I have used the Shell command to open Notepad, and I have used SendKeys to take the information from the textboxes and put it into the textfile, and I can even print it out. But the thing i cannot do is close the Notepad and return focus to the form that the command came from. Do I need to save the file and then print it later? Any help would be much appreciated.

Watyeag the newbie

Let me explain myself more. What I am making is a recipe program that is connected to a database, for entering recipes, viewing them, stuff like that. I want to allow the user to print the recipe that is being viewed on the form. I have been able to send the text from the textboxes to a new text file, and have gotten the textfile to print. It opens a new file in notepad and prints it. The only thing is that I cannot close the file after it prints. I need to close it so that if the user wants to print out the next recipe, it doesn't create a new notepad instance. If i try to close the notepad, it will not print. If anyone thinks that they can help, I can send the code via email and let you ponder it. Feel free to keep it and modify it in any way. Also, i am using a Access database to store the recipes. Is there an easier way to do this, like creating an Access report form the form and printing it out?

Thanks for all of the previous help.

Watyeag the newbie

[Edited by watyeag on 12-29-2000 at 10:36 AM]

Help Uploading
I need some help using FTP to upload...

I've tried a few diffrent thing i've found on Planet Source Code but can't seem to get any of them to work.. what i want to do is have my program autmatically upload a file to a FTP server on a timer...... i'm really bad at explaing things so if it doesn't make any sense then just ignore me but if anyone could help it would be appreciated

Help Uploading
hi, im only just starting to learn visual basic(i have vb6)
this is my project so far Car Racing
it is a game, i was wondering if someone could help me...
firstly it is a car racing game and a car that gets faster and faster, the record is saved to a .dat file. Does anyone know how i could posibly get it to upload the .dat and put them on the net for like a comparision, i know its kind of a combination of vb6 and .php but anyone know how i could do this?
(P.S. sorry bout the sloppy programing i havent had a chance to clean it all up yet :-P)

Need Help With FTP Uploading
Hello.
I got my ftp uploader 50% finished but 1 problem,

current code:

Code:
ITC.Protocol = icFTP
ITC.URL = "no"
ITC.username = "not"
ITC.Password = "funny"
ITC.Execute ITC.URL, "PUT C:lol.txt"

The thing is, PUT C:lol.txt MUST be inside " "
I have tried "PUT", "c:lol.txt" but that doesnt work.
I really need a working code that can have variables inside like:
"PUT", app.path & and so on...

Uploading To FTP
Hi Guys ... I'm triying to make an App to Upload files on FTP..

but i receive an error which is getting me crazy ...

Ok this is the code :

Quote:

Private Sub Connect_Click()

With Inet1

Inet1.AccessType = icUseDefault

Inet1.Protocol = icFTP

Inet1.RemoteHost = Text1.Text

Inet1.RemotePort = Text4.Text

Inet1.Password = Text3.Text

Inet1.UserName = Text2.Text

Inet1.RequestTimeout = "180"

End With
End if

Private Sub Upload_Click()
Dim strRemote As String
Dim strLocal As String
strRemote = Text6.Text
strLocal = Text5.Text
Inet1.Execute , "PUT """ & strLocal & """ " & strRemote'Here is the PROBLEM
End Sub

Anyone . anyidea how to fix it ?

Uploading
Hi guys, I got a computer that I want to be like a ftp server.

Like I have a folder on the desktop to hold these files. I want to make a program that gives people the ability to upload to it. Like theres a form with a text box and a button to browse and another to upoad the file in the text box to the folder on my computer. The IP would need to be entered in another textbox.

Can anyone help because I dont know how to code a program to upload something.

all help is apprecaited

FTP Uploading
I want that when a user clicks on a command button that the program then automatically uploads a folder, that is located in the application path, into my web server using FTP! Can anybody help me?

FTP Uploading
Hi,

I am using Inet to upload a file via FTP however when I check the file on the server, the file is there but the size is only 0 bytes.

I am using:

VB Code:
Inet1.Execute "ftp://j2k:j2k@ftp.myserver.com" , "put C:IcdpSystemfile.htm received/files/file.htm"

Any ideas?

Thanks

>>>Uploading Ftp<<<<
Hi

in this code,

VB Code:
Inet1.URL = "ftp://ftp.geocities.com/"Inet1.UserName = "USERNAME"Inet1.Password = "PASSWORD"Inet1.Execute , "PUT App.Path & IPAddress.txt IPAddress.txt

in this line

VB Code:
Inet1.Execute , "PUT App.Path & HDfile.txt Webfile.txt

Im uploading the contents of HDfile.txt to Webfile.txt on a webspace provider. Is this the right order in which they go in? The hard drive file first, and then the webfile? or vice versa?

thanks in advance

FTP Uploading
i want to be able to upload a page automatically from a file created by VB, which control should i use? does anyone have any exampke code?

Regards
~Chenko

Uploading Via FTP
Hi, basically I would like to know;

Is it possible to launch the DOS FTP client, connect to a server then, upload a file from the hard drive, and then disconnect again?

And if it is, how do I go about doing it?

Thanks for any help you can offer.

Uploading
I need to know how to get my program to upload a simple text file to a server. I've tried several things but they have all failed. What i've got is a rich text box and a command button. I want to be able to upload the contents of the rich text box onto a server in text format. What I tried was basically when i click on the command button it saves the data in the rich text box to the hard drive as foo.txt, and then uploads it to the server. I havent been able to get it to work, so any help would be appreciated. I hope i've given enough detail as to what im trying to do.

thanks, stephen

Uploading
Ok, ppl have tried to help me by giving me already writen source. But everything that is prewriten is WAY too complicated for what i want to do.
Can someone PLZ whip up code that will upload a file (location is in Text4.Text) and upload it to "public_ftp" on an already connected too ftp.
Thank You

FTP Uploading From VB
I have looked all through tek-tips and all over the web and am
having problems creating a simple solution to upload a file to
my website. I have VB code inside an Excel module that does
multiple things. Saves, prints Adobe files, imports data to
Access, e-mails, etc... Now I want to upload a pdf to my
website automatically through FTP.

The directory I want to put everything at is
ftp://truthbenefits.com/public_html/Forms. I can obviously fill
in my User ID & Password.

Below is a simple Sub routine. Can anyone add the appropriate
code to upload the file?

Uploading Textfile Into SQL Server

Hi, I want to upload a Text file into SQL Server, without using ODBC (using open function). IF my text file has 8000thousand lines, then it will take too much time to readline by line and writing into a database. Help me out to resolve this problem.

Hi, I want to upload a Text file into SQL Server, without
using ODBC (using open function). IF my text file has 8000
thousand lines, then it will take too much time to read
line by line and writing into a database. Help me out to resolve this problem.