VS 2010 Use An FTP Server In VB?
Nov 7, 2009I found a few free FTP hosting services and I was wondering how you implement them with your programs.
View 3 RepliesI found a few free FTP hosting services and I was wondering how you implement them with your programs.
View 3 RepliesHey guys, I am trying to send data from client to server (encrypted) and the string sent from the client is not the same as recieved from the server. I've been killing my brain for hours to get this to work but I cant manage. Im converting everything to Base64 string.
Client:
Public Sub SendMessage(ByVal msg As String)
Try
SyncLock myclient.GetStream
sw = New IO.StreamWriter(myclient.GetStream)
[code]....
With a Windows form that I would like to be a DDE server. I know that DDE is not natively supported in VS 2010/11 so I'm using the NDde.dll to add DDE functionality to this program.
Objective: Create a windows form to act as a Pop-up notification that has a textbox field. This textbox field must be selectable in order for users to copy a text string to the clipboard and paste into another program that does not support DDE.
Overview: A phone system has an on-screen agent program that triggers a pop-up form, the DDE Server, when an incomming call is presented. When the agent accepts the call the agent program, acting as a DDE Client, registers a DDE session, Application=phnserver and Topic=callerid. Then communicates an "OnExecute" command to the DDE Server followed by a number string. This string should be presented on the pop-up form in a text box. Once the call is completed the agent application will issue a command to close the pop-up form.
Below is my current code.
CODE:
posted again but this time its regarding both the webclient and the web reuqest giving me this error :S
View 1 RepliesI just got into VB 2010 with SQL 2008 Server Report. I was able to create a report as my wish and it's vieable via direct url (URL). But I want to pass login Information and Selection parameters to the report. But I don't want to pass them thru URL, So I want to load them from the application (winform) and launch the report in iexplorer.
View 1 RepliesI am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 3 RepliesI have a database is SQL Server 2008 Express. I have added this database to an ASP.NET project, now I want to add the same database to a VB.NET project, however, when I try to set it up it says I need to choose a different file because it already is in use (which makes perfect sense). So how can I set the database up so ASP and VB can use at the same time?
View 3 RepliesI'm trying to write a small app that will connect to our SQL database and run a small query.
However, my first stumbling block is the connection to SQL.
The SQL is on a server called RCSRV01, and RCSRV01 is the name of the SQL Server instance. The database is called NHD
This is my connection code...
[code...]
I'm working for a socket tcp/ip. I have a server form on Server PC and client forms on all clients. I want the clients auto find and connect to the server PC when I open connection on server form? (in common, I have to set the server IP and ports to each clients, if not they cannot connect).
View 3 Replieshow to make a server, and let my program connect to that server. My program is on books, people can go through the list of books and "favourite them". Then in a window I open I can see the most favourite overall etc. How would I do this, what type of server (srry im not pro on servers at all).
View 1 Repliesrecently ive been making a app for minecraft and im trying to add a new feature what i want it to do is ping the server and then tell me if its on or off any server using a redirector like dyndns or no-ip will ping back as online even if they are offline because the redirector isn't down or.[code]
View 6 RepliesI have an application that is on a server running. The way I have it setup is I put it on the Windows Scheduler to run at certain times. We now need to run it constantly on the server. I change the code to put in a loop until I pause or stop it. One issue I have found is that I can kick it off but when I close out of my remote session the application stops.
How do I keep my application to keep running even after I sign out of RDP?
I'm pretty new to VB.NET and connecting to SQL Server.What is considered best practice when building an app that needs to connect frequently to a SQL Server DB to fetch, write, delete and update records?Should a connection be opened at app startup (a connection at start is opened to validate the user) and left open for subsequent transactions or should a connection be opened, closed and disposed of each time a read/write to the DB is required?
View 3 RepliesAm having a hard time co be connected to sql server 2008 enterprise edition.i am using oledb in this fashion
db.connectionstring="Provider=SQLOLEDB.1;User id=helen;password=123;Initial Catalog=mydb; Data Source=server"
but it gives this error: Login failed for user 'Helen'/ Is SQLclient a must to be connected to sql server?
I'm new to this forum and have only been working with VB for the past 6 months.I am working on an ADO project, creating a home based movie directory that tracks movies, family and views(movies)I am having a problem with my "Update" from VB2010 to SQL.I am using a date time picker to view the SQL data in the dataset. In that I am not having any issues (txtYear.DataBindings.Add("Text", ds, "Movie.MovieYear")however whenever I try to update and "Send the data" back to SQL Server.[code]I keep getting an error System.Data.sqlClient.SqlException "Invalid column name 'March'.I do realize that this is a formatting issue, i'm just not sure how to format it to the proper date.
View 8 RepliesI am trying connect to a SQL Server database i have created using Visual Basic.Both reside on my local machine (PAUL-PC).Here is what i have done so far but i am missing something (or more worryingly i have got it completely wrong).[code]So i have an MDI form and i want to make a connection to SQL Server when that form loads.I do not want to use a DSN if possible so am trying to use Oledb. Not sure also of the DataAdaptor declaration as in previous versions i used many years ago it was recordset.I would like to use a trusted connection to connect.
View 5 RepliesVisual Basic Project VB 2010 B2 does not allow you to select the SQL server without specifying a local file attachment while Visual Web Developer VWD 2010 B2 does give you the option to specify either.The Enviroment VB2010 B2, OS VISTA Business, SQL2008 Express SP1 with SQL Server Management Studio.
1) In order to access the SQL server enable the TCP/IP, NamedPipes and SQLbrowser on the SQL Server.
2) The VB Project requires "imports system.data.sqlclient"
3) Using SQL Server Management Studio or VBcode in the VB Project create a Server DataBase called "dbName"
4) Using SQL Server Management Studio or VBcode in the VB Project create a Server DataTables
5) The following code updates the SQL server DataBase name dbName from the projects DataSet.
Private
Sub updateDBase(ByVal dbName As String, ByRef aDS As DataSet)
'CODE to access SQL database directly
'Before an Update sqlCommandBuilder creates
[code]....
I just finished making my project, its a Registration System using Visual Basic 2010.
How can I make a server that allows client to open the system? so they can Add, Edit, Delete, Save, etc...
P.S. I try file sharing but it doesn't work. using win7 to winXP.
I am currently learning how to program in VB and am using sample code to make a VB Winsock client and server. I beleive the sample code was from VB 6.0. [code]Overload resolution failed because no accessible 'GetData' accepts this number of arguments.I am getting the exact same error in the exact same place in the server aswell. I have tried removing the vbString, but it comes up with a warning and the program doesn't function like it should. I am programming this in Visual Basic 2010 Express.
View 3 RepliesI just started learning VB 2010 through a book. I'm learning vb to design a program which can manage customers of a small company as a homework. It'll store data (Company Name, Phone N. and Adress) at an Access Database. (I'm using Access 2007)
I have a little background with programming but none with databases. According to the book there is no way I can delete, add or update a data from an Access Database without installing SQL Server or Express. But this program should work at a computer which may or may not have SQL server or MS Access (Any computer with Windows OS).
After a little digging only thing I could find was Walkthrough: Saving Data to a Database (Multiple Tables) from MSDN and did every step and at the end, I can delete or add rows and change values of the cells but cannot save them (when I click save, close the program and re-open it, changes are gone).
I don't get that how can I view all the data from database without SQL server but can't save changes to the database file without SQL Server.
Is there a way to do this without SQL Server? If so, can you give the right code for the MSDN Walkthrough's Save button? Or point me to a page where can i learn the right code?
I'm trying to insert a row into a SQL Server table.
Using this...
cmd.CommandText = "INSERT INTO MyTable (firstname, lastname) VALUES (@firstname, @lastname)"
cmd.Parameters.AddWithValue("@firstname", "bob")
cmd.Parameters.AddWithValue("@lastname", "jones")
cmd.ExecuteNonQuery()
I get an error saying:
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@firstname".
But if I use this...
cmd.CommandText = "INSERT INTO MyTable (firstname, lastname) VALUES (?, ?)"
cmd.Parameters.AddWithValue("@firstname", "bob")
cmd.Parameters.AddWithValue("@lastname", "jones")
cmd.ExecuteNonQuery()
...it works fine. What do I need to do to make the first example work? I don't understand what the error message is telling me. How do I declare a "scalar variable"?
VWD 2010 Express SQL Server 2008 R2 I have just jumped in to this and baffled at data access that is available. I have a tabbed page with labels, textboxes and dropdown lists. The user enters data in one box, selects from a dropdown, then enters text in a textbox. On the last textbox change event, I want to do a SQL select and populate the rest of the textboxes. Used to be so simple. Do not want bound gridview, etc. I want to handle the data, and on submit, do the update/ insert.
View 9 RepliesI'm doing a small project. It works on a LAN. The working of the project is:In client side, a user would enters "username" and "password". It would sent that to the server, along with the time.The server would authenticates info on checking a db and writes some info to the db.Also, the server should be able to sent some commands or instructions to the clients.These commands on received by the client, it would invoke certain functions/subs on the client based on the command.So, would it be better to use TCP client & listener or WCF ?
View 6 RepliesI am trying to build a client/server program but not knowing where to start. Someone told me i need to use winsock.1. What is winsock?2. How do i get it? can i have a link to download it? or is it already in vs?
View 6 RepliesI have a few different databases and I need to connect to a specific database according the value of the label (whatever). This is the connectionstring:
[Code]....
I try to use my data source and setup a new connection, but i see it wont let me.Is this another features they left out of 2010 express edtions?I just want to setup a connection to sql server with vb.net express 2010?
View 2 RepliesI want to learn database programming with SQL server, so I've have installed MySQL administrator 1.1.9 and MySQL connector net 6.4.3, is it ok with these or should I change?
View 4 Repliesi'm creating an IRC server and I already have a few base classes complete like logging and Config. I was about to start with programming the socket class(es) when I realized that I have no idea how to make such a complicated socket system. I do not under any circumstance want to use any other code than my own since that would not help me learn sockets. I am familiar with a single connection socket system like most tutorials use.
[Code]...
A while back I asked about going beyond basic FTP upload/download on this thread, and the response I got about using FtpWebRequest was very helpful. Now I'm looking at something that doesn't seem to be offered in FtpWebRequest: renaming a file on the server.
My situation: several times each month I update MyConfig.csv on my website. This file is generated on my computer by Excel to control who can access which files on the site, and it runs a bit over 1 MB. The scripts on the server parse through the file to keep things running smoothly. Given that the file can take some time to transfer, I typically will upload NewMyConfig.csv to the server with a commercial FTP program, then when it is in place I rename the existing file to MyConfigBackup20100521.csv and then rename NewMyConfig.csv to MyConfig.csv. This way, if there is a problem with the upload, everything keeps running smoothly because the existing MyConfig is undisturbed, and the window when a customer might get an error from the scripts because there is no MyConfig.csv is reduced to a couple of seconds between the two rename operations.
Now I'd like to automate all of this to happen with a VB program, but it looks like FtpWebRequest only allows you to rename directories, not individual files, on the server.
Basically, what I'm trying to do is:
A) Figure out the local IP range
B) Scan those IPs for a specific open port
What i want this to do is Auto-Find a server application on the local network that has opened a TCP port (Say, 6473) Then tell the user the IP address that it's on. I have searched for hours, but to no avail. How would I accomplish this?