Make Client Server Without Installing Sql Server?
Nov 6, 2009
I have an application in which i have a database .mdf file in directory which i use a connection string to give a path of to access it, which means without installing sql server i can access database. Connection string below to access this database(.mdf) which placed in the directory.
dim con as sqlconnection = New SqlConnection("Data Source=.SQLExpress;integrated security=true;attachdbfilename=|DataDirectory|Universal_data.mdf;user instance=true")
Now the question is that if i access this .mdf file without installing sql server, i also want to access to this .mdf file on other computer(client) after creating DSN or any other connectivity tool.
Let me know you that when i install sql server 2000 or 2005 i create SA user name and password which i use to create DSN on client computer and give SA username and password in the connection string that successfully works and client get access to sql server, connection string is below.
Dim serv = "MY-LAPTOP"
dim con as sqlconnection = new sqlconnection("Data Source=" & serv & ";Initial Catalog=clinic;Persist Security Info=True;User ID=sa")
I only need to know that my application access .mdf file without installing sql server works fine on a single computer, and i want to give access to this .mdf file on other clients without installing sql server on server computer (like i mentioned above paragraph) how will do it.....
View 1 Replies
ADVERTISEMENT
Sep 24, 2010
How to make clients on sql server i mean when i will install my application on clients how i will connect it with sql server?
View 6 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
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 18, 2011
how to make Autorun installing for win Applicatin Visual studio that installing .net framework and sql server or all needed?
View 1 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
Mar 30, 2009
I've basically made a basic tcp server/client application. The thing is that I'm behind a router and so will be the other people that use my clients. I've had to use port-forwarding or the software "rinetd"to run quite a few applications online.
Let me explain: I'm on a lan network that connects to the internet. Whenever I want to host a server - for instance a basic ftp or http server. If I give my external IP to anyone, they won't be able to access my server. Even if I portforward, it doesnt work. I have to use rinetd here. For other applications, portforwarding works. I'm not sure how these things work at all.
Anyway, my issue now is that I have created this server/client application. I'm having serious doubts that if I run the server, I'll have to either a) portforward or use rinetd to get people to connect to my server. IF I need to portforward, that's fine. However, using rinetd would really suck... My 2nd concern is as follows: IF the person running the client is in a similar situation as me (i.e he's on a lan that has a router which connects to the net), will he have to portforward or use rinetd as well? If he portforwards that's fine. But I don't think I could get people to use rinetd.... Also, if there are more than 1 person on a lan trying to connect to my server, there is a big problem when they try to portforward: they will only be able to allocate one of their internal ip to that port, and the others won't be able to connect, right? How does this work? I mean, I use many softwares like msn/skype/(some games)/firefox that do not need portforwarding/rinetd. Yet they work. My housemates(other people on the lan) use the same softwares, and it works fine. There's no clash/probs watsoever How come these run fine?
Anyway, back to my issues. Given I have no knowledge about how the above work, I was wondering whether there was a way to host a vb .net server application on an external website (external to my house) so that I might *avoid* the above mentioned problems, and to what extent that would be a sound solution.
View 11 Replies
Dec 21, 2010
anyone can teach me how to make billing system which is server - client.i will put the sql database to one pc then clients - the gui system.i want to run may system from other pc then connect to sql database which in another pc..
View 1 Replies
Jul 19, 2011
I'm trying to make a client and a server connected in vb 2010. how to make a client and server connected? There is only vb2008 in the codebank and if my vb2010 tries to convert it to vb 2010 it will error.
View 1 Replies
Apr 7, 2011
I really need to know if its possible because I'm making a messaging client since me and my friend find believe MSN is getting buggier. I've looked on how to do it but none of them worked for me, or were server to client. I want to make it client to server to clients but I don't know how! I know I shouldn't tell you to give me code but maybe give me a few tips on this. Me and my friend share files nearly everyday.
View 11 Replies
Sep 8, 2011
links or Procedure how to build a client/server and file sharing through lan because my friends needs a reference for That
View 4 Replies
Apr 16, 2010
how i can make a udp server that waits client to communicate with him and the server answer them back even if the server doesn't know the ip of the client in vb.
View 3 Replies
Jun 22, 2010
I use Microsoft Visual Basic 2008 Express Edition and I am begginer in computer networks. I want to make two PCs communicate via network using server/client I followed the example from this site: [URL] (VB.NET TCP Client/Server Socket Commmunications) When I run the applications server and client in one computer then is possible the client to connect with server.
[Code]...
View 2 Replies
Aug 10, 2009
Multi-User Chat Program (Server & Client) with Main Server?
View 1 Replies
May 13, 2011
i have 2 application clinet/server the server broadcast media files to client i used tcp/ip protocol the server code is work good but i have a problem in client code i need ineed someone to correct the code .iwll show where the error is in the code note: i call the class in the main form dim a as recive in the starter of the main form class to be gloable .
[Code]...
View 4 Replies
Apr 6, 2012
Case : I'm creating an application (desktop application) with VB.NET (actually windows form), and using SQL Server Express 2008 for its database.
[Code]...
View 1 Replies
Nov 28, 2009
This emailing code wont seem to work in my program. I get an exception "The SMTP server requires a secure connection or the client was not authenticated. The server response was 5.5.1 authentication required."
Imports System.Net.Mail
Public Class emailStudent
Private Sub sendEmailButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles sendEmailButton.Click
SendMail()
[code]....
View 12 Replies
Jul 9, 2009
I wrote a VB code to call a sp in sql server 2005, which returns a recordset as follows:Dim objRecordset As ADODB.Recordset Set objComm = New ADODB.Command
Set objRecordset = objComm.Execute If Not objRecordset.BOF And Not objRecordset.EOF Then
Set objRecordset = objRecordset.NextRecordset I need to continue to get next recordset since there are many select statements inside the sp which I need to get the data. The code works fine when I create the DSN using SQL Server but it does not work when using the connection string or SQL Server Native Client DSN. It either breaks at Set objRecordset = objComm.Execute ( connection string )or at If Not objRecordset.BOF And Not objRecordset.EOF Then(SQL native client )
I have worked on this for a couple of days now and could not figure it out.Is this a bug in SQL Native Client or something related to some configuration on the database side? IS there a way I can change the connection property to get this working using SQL native client or connection string?
View 1 Replies
Oct 26, 2011
I made a simple TCP server (I've found the example on the web) in VB to receive data from about 40 TCP clients.The clients are not synchronized but sends data about every 18 minutes; the problem is sometimes several clients sends data at the same moment, so I can't receive data.I also made a second program that reads the data (server program writes data on a file, read from the second program) scheduled.
My question is this: I've seen on the web examples about Multithreaded Server Socket Program, so I suppose this could manage my 40 clients (but now the clients are syncronized and send data at the same time in client mode) or is better get data (I have a central client that asks data to all 40 devices in server mode)?
Second question: can I make a single program where I run both TCP client and TCP server at the same time?
View 1 Replies
Sep 27, 2010
I was wanting to make a simple client-server program.I saw some code for it and it was easy to understand but it was with winsock.
The program is:
Client: Clicks button.
Server: Recieves Text written in clients textbox.
Is there a reasonably easy way to do this?Maybe Net.Sockets or something similar?
View 3 Replies
Jan 6, 2011
Im trying to make a basic Client/Server. The server can handle multiple clients and each client can send /recieve messages from the server.It works fine with just 1 client. but as soon as i connect with a second client. The first one no longer works. Anything sent from the first client is ignored by the server and when running the server in debug mode it gets errors from the client 1 stream.
Its as if the server will only hold one stream at a time and whenever another client joins the other streams are shut but the new client works fine. Even though i never close a stream.
[Code]...
Edit: FINALLY FOUND IT! Stupid mistake i forgot to put the ClientN variable up by one for each new client.So i was creating a new space in the array but erasing the first slot for the new client
View 2 Replies
Aug 18, 2011
I'm currently "trying" to make an app that gets a certain text from the client and sends it to a server and the server sorts it out every text that he gets from the client into a different label every time he gets a text from a client. For example :
Client1 sends certain text to Server and server puts it in label1.text
Client2 Sends different text to Server and server puts it in label2.text
Client3 sends different text than 1 and 2 to Server and server puts it in label3.text
and so on.
View 3 Replies
Oct 4, 2009
Im trying to make my client send the users Account and IP to the server. And the server puts them on a list box?
View 3 Replies
Oct 26, 2009
i'm newbie in this programming..i need some references or a starting guide to build an sql server and vb.net application.
View 3 Replies
Jul 16, 2009
I am creating small application (desktop search engine) which uses sql server as back end. Sql server is used to store huge data using indexing (for quick search). Is it necessary that client should have sql server on his machine to run the application? I don't want to install sql server on client's machine, because my application is just a small utility.Is there any other way so that I can store huge data using indexing?
View 2 Replies
May 28, 2012
I have a tcp client and tcp server.How do I ping the server from the client, by specifying the ip and port of the server?
View 1 Replies
May 31, 2009
I want to make a basic winsock chat server and client, and I just need to know the basics, like.How do you determine where to send the data?How do you determine where to receive data from?How to actually send and receive the data?I just don't want to read from a website that has a lot of extra information. I just want to start off with the basics so I can actually learn.
View 2 Replies
Sep 7, 2011
The problem im having is that I have a table that when a user click on a button it adds a row to the table via javascript, which works fine. The problem is that if a user need to update other data the user click another button which refreshes the page and all rows the user created in the table are deleted. My question is what can I do to make the rows not to be deleted once the page is refreshed? I know some might think, just not refresh the page, but there is to much data that has to be displayed and a new query has to be generated to grab the data.
[Code]...
View 3 Replies
Nov 13, 2011
Ive been working recently on a chat. Ive been using FTP to comunicate through both forms but it need to constantly download the new data and make the application freeze. Even with a Backgroundworker. So my question is : is there a way to keep a constant connection between the form and the host? And not LAN ,I mean that doesnt need to be on the same router.
View 1 Replies