Server-Client Data Exchange Using MySQL (.Net)?
May 3, 2012
I developed a simple examination system with registration forms. I used VB.Net as the programming language. I haven't tried manual coding for my problem yet.Anyway this is a project for the company from which I am an intern. The plan is to get every client pc to have this examination/registration application and this application will send the personal info and the score to a central database(server pc).I used MySql as the dbms and developed the application on the same machine which means that the Database server I used is only on the local host.
Now I was about to try to implement the application to one client pc(as a beta test) and installed the necessary files(.net framework) and I also installed MySQL Server(and workbench) in the server pc.When I run the application in the client PC it didn't detect/connect to the ServerPC's MySQL server instance and therefore was not able to record the dummy values I input in the client application. Take note I changed the connection string of my app to point to the ip address of the serverPC.
Should I install the MySQL Server(and Workbench) to every ClientPC so that I can create a server instance that uses the REMOTE HOST option and configure it such that it will connect to the SERVERPC's Database?How should I setup the server so it gives access to the application I installed in all clientPCs?
View 1 Replies
ADVERTISEMENT
Jun 27, 2011
Hey 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]....
View 4 Replies
Jun 8, 2011
I would really like to know if there is anyway in which I can package two or more set up files together with my vb.net application; so that after installing the application, it automatically starts installing the other applications from the other set-up files.
In my case I want to include mysql server and client together with the application for a demo cd, that am making for a client.
View 4 Replies
Mar 26, 2012
I need to realize an app that read appointments from an exchange server or (I think it's easier) from various outlook folders.
I can retrieve datas from my own calendar using this
Dim objOLApp As Outlook.Application
objOLApp = New Outlook.Application
Dim myNamespace As Outlook.NameSpace
[Code].....
View 2 Replies
Apr 23, 2010
I'm developing a remote control program that uses a mysql database as the bound beetween the server and the client.The only problem is that cause of mysql being really varnuable to crashes i made it in a way that it checks for information every 10 seconds so things doesnt get messy. [code] For some reason after 10 seconds the connection is mysteriously aborted and the reader gives a fatal error.How can i extend the time limit to >10 seconds ?
View 3 Replies
May 9, 2009
how to create a client/server... But I couldn't... I don't want anything fancy. Just want the client to send the server 4 numbers, depending on the user's choice; after that, the server would turn off the pc, restart it, etc. It all depends on the number received. Is there a rather "simple" way to do it? If it's not to much trouble you could use Atheist's example. (Btw I don't understand the code and, yes, I've checked on [URL])
View 9 Replies
Apr 19, 2011
I have a small program which is a tcp client. I send a string from this client to a device over ethernet (it acts as the tcp server). As soon as the device recieves the input string it will respond back with response data. My problem is i am not getting the entire response data back from the server. (device).
Dim serverStream As NetworkStream = clientSocket2.GetStream()
Dim outStream As Byte() = System.Text.Encoding.ASCII.GetBytes("my-cmd")
serverStream.Write(outStream, 0, outStream.Length)
[code]....
View 4 Replies
Oct 7, 2009
I am trying to use CDO in VBScript to send email from one server to a separate exchange server
View 2 Replies
Jun 21, 2010
We are creating a Who wants to be a millionaire style game in VB. Our server is pulling information such as questions and answers from a Access Database and sending them to the contestants (Clients). All transfer of information is directly from the server to each client. One of the "Life Lines" we want to use is "Ask a friend", where one client is able to Instant message another client for a short time to get help on the question.
[Code]...
View 2 Replies
Feb 26, 2010
Can you compress data being sent from client to server and etc? If so how would i do this?
View 2 Replies
Jul 12, 2011
i am creating a software that needs to transfer data between client and server. i m storing the data in client in a database. but how does server access every clients data.
View 9 Replies
Jun 30, 2011
I have a Linq query on the server side of a Silverlight 4 Ria project that returns a number of distinct items based on a time period(Month).The problem I am getting is when the client callback fires the data has been corrupted and all the items returned from the server are duplicates of the last item in the collection.
Server Call
Public Function GetBusinessHeadCountHistory(ByVal businessUnit As String) As IEnumerable(Of EngineeringHeadCountBusinessHistory)
Return From t In ObjectContext.tblTimes
[code]....
View 2 Replies
Aug 20, 2010
I have programmed a chat application in VB but as soon as I send any data from a client the server will send it to all. It should send a reply only to a particular client. This is the function I have used.
[Code]...
View 1 Replies
Nov 12, 2011
I've been working on this project for about a year now. It's a basic clientserver chat program. After a long time of improvement, I decided to test out the strength of my server.
On the client, I fired off 200 chat messages ("FLOOD# 1"... "FLOOD# 200") to the server as fast as possible. The result: Server immediately crashes. After some slight tampering, I was able to get the server to process 135 of the 200 messages before giving up. It no longer crashes, but something different happens. The data from the client is received in order, but when I pass that message to a function (myForm.OnLineReceived), The data is completely out of order. If I add a slight delay between the calling of the OnLineRecieved function, The messages are in perfect order.
Each message from the client is first encrypted, then encoded in base64. An "-" is appended to the end so that the server can easily find the end of each data "packet".
Server Code:
Imports System.Net.Sockets
Imports System.Text
' The UserConnection class encapsulates the functionality of a TcpClient connection
' with streaming for a single user.
[Code].....
View 3 Replies
Mar 18, 2011
I use to do programs in VB5 and haven't touch VB for years, and now i just started to pick it up again, VB2010. my problem is getting data from my MySQL Server (local)
i was able to create my Data Source successfully.. however, when i click and drag my CUSTOMERS table to my form the datagridview shows nothing. I read a few online tutorials and they all said that's all i have to do not working for me..i have 9 records in the table already but nothing is showing..
View 2 Replies
Nov 15, 2011
basically i just want client to say "C: emp" ENTER
then, server must reply with all its files in c: emp
View 1 Replies
Jul 23, 2008
The problem I have is: When I click on cmdListen in the server form and cmdConnect in the client form,both programs won't respond and they crash for some reason I don't know.
Client source code:
Code:
Imports System.Net.Sockets
Imports System.Text
Public Class Form1
[CODE]...
Code:
Imports System.Net.Sockets
Imports System.Text
Public Class Form1
[CODE]...
View 3 Replies
Oct 11, 2009
I need to encrypt some basic data being sent from server to client.
I was going to open a file in bytes, convert it to chrs (Modify odd numbers by adding 2 and even numbers by adding 3) then use Base 32 (Triacontakaidecimal) or Base 16 (although base 16 will occupy twice the space). Convert the data back to bytes and after do the same with the decryptor.
About using base 32, is there some sort of class in vb.net or maybe an api?
View 3 Replies
Jul 13, 2009
For example, i installed the windows application in more than one pc. All the pc's are in network. I want to save the data in a single database. How it is possible?
View 7 Replies
Mar 28, 2012
i wanted to develop an apps that sends sends data from client to server and vice versa. i want to biuld it with
View 5 Replies
Sep 9, 2009
I need to solve the following problem:- Create a server application which generates a random number every second- Have any number of client applications access the current random number through a dll (associated to the server) at anytime How would I do this? Anyone has a prototype VB.Net code for the server which does this kind of thing? I'm pretty sure I know how to write the client code.
View 5 Replies
Oct 18, 2009
My problem is that I would like to know that if some data from client has arrived to the server, I would know its length.Now I m getting an error at: mClient.GetStream.EndRead(ar). It is saying that ar cannot be empty. [code]
View 3 Replies
Feb 21, 2012
I developed a project in VB.NET In this project I want to use data from MySQL that is resides in my WEB Server.I can communicate with the MySQL server of my localhost but can not communicate with the WEB Server.
In my CPanel I added Host from the Remote Database Access But I can't communicate with WEB MySQL Server.
[Code]...
View 3 Replies
Apr 20, 2012
I have a TCP Socket Client (using the Socket Class) that is connected to a simple TCP socket server (just for testing)I have this code snippet :
Dim aSocket as Socket
While aSocket.Connected = True
byteRead = aSocket.Receive(dataByte) 'number of bytes
[code].....
View 1 Replies
Oct 13, 2010
I'm not sure what I have done wrong, I am trying to get my program to send data (UsernamesPasswords) from client to server, then the server says if it's right or wrong.
The error is on this line:
Dim networkStream As NetworkStream = TcpClient.GetStream()
Heres the Client:
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
If TextBox1.Text = "" Then
MsgBox("You must enter UN/PW!")
[Code] .....
View 4 Replies
Feb 13, 2009
i have a site that is running in php with a mysql db and i want creat a app wiht .net 2008 to return/send values to that database what is the best way to do that? i have think in this options:
[Code]...
View 10 Replies
Jun 10, 2011
i'm working on an e-voting system for my thesis... but i'm having problem on how to output the data in all the rows in the database in a check box. so it means that the number of checkbox is equals to the row of the table. i manage to output only one data from the first row but i don't know how can i output all the succeeding rows.
this is my code so far
Private Sub LoadCandidates()
SqlString = "SELECT * FROM candidate"
'Function for searching by candidate ID number
[Code].....
View 3 Replies
Sep 21, 2011
In our project we've decided to put an exam generator using vb.net and after generate you can send it to client computer/students. *server computer/teacher will the one who will use exam generator and send it to the client computer/student*student will recieve it and then send it back again to the server computer/teacher*teachers will going to generate an exam depends on the type of exam, so i think im going to make it a wizard type environment
View 14 Replies
Aug 3, 2011
i wanted to develop an apps that sends sends data from client to server and vice versa. i want to build it with help of winsock in vb 2008 using tcp.
View 2 Replies
May 16, 2012
I have a Client/ server application where the Server is in java and Client is in Vb.net.When i send large string from client to server am not receiving complete text.code attached below.
client-- VB.net-
Try
Dim clientSocket As New System.Net.Sockets.TcpClient()
[code].....
View 1 Replies
