Client Server Application - How To Make Clients On Sql Server
Sep 24, 2010How 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 RepliesHow 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 RepliesCase : I'm creating an application (desktop application) with VB.NET (actually windows form), and using SQL Server Express 2008 for its database.
[Code]...
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 3 RepliesI'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.
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 RepliesI 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.....
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 RepliesI 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 RepliesI have been struggling to find a solution for this problem. What I need to do is build a server application that accepts tcp client requests from different clients running on same port say:1003. I experimented by using asynchronous mode call backs etc. but it disconnects once connection is established and does not respond for further requests from the same client.
View 1 Replieshow 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 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]....
basically i just want client to say "C: emp" ENTER
then, server must reply with all its files in c: emp
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]...
i am creating a client server application using vb.net with odbc as my data source to sql server 2005.send me a code that will enable the application running on a client machine to connect to a remote server.the application is to run on LAN and other client machines are on same domain.
View 1 RepliesIm planning to create a Remote Desktop Application and I'm having problem with viewing other computers monitor or screen.
Im not asking for the code on how to do it. and one more thing is it safe to use winsock in creating a client/server application?
I use VB.NET for a Windows application.
How can I find out if the application is now running on a server or client (programmatically)?
i currently have a project. The application created in this project will be located in a server, and some machines can access this application at the same time. The problem is, i don't know what's needed to connect that application to several machines. I know how to build this application and run it in a single machine, but i have no idea about running this on server.
View 3 RepliesI have developed 2-3 standalone windows application using VS2008(vb.net) + Sql server (2008,2005) and quite comfortable with stand alone windows application. Now i am trying to make a windows app which will share a server database on LAN. I googled alot about this but still no success. So i decided to make that as stand alone app and i just changes the connection string to use remote server database. Everything is working fine still. All the insert, update and delete query are same as stand alone n me not getting any problem while testing through one more remote client system. But while googling i heard abt "CONCURRENCY" control.So please guide me is anything wll b wrong in future wid my this application when i will deploy this to my users? What about locks and how can i implement this to my Insert, update and delete queries to control concurrency and maintain integrity ?Please guide me step by step becoz i m new be to client/server application.
View 7 RepliesI made one client-server chat application using vb.net. I want to know how can i change the form/icon color when a client sends a message and vice versa.
for eg: like in yahoo messenger or msn messenger,etc, How i user knows when he receives an message.
I am trying to create a a server and client application. All that I want to do is have a client that has a picture box. The server will send an image to the picture box and the client will display it. I have looked online to find some tutorials but most of them just show how to do a connection and usually only with a console application.
View 3 RepliesCreate an UDP Server/Client Application?
View 3 RepliesFirst of all, I want to say sorry if this is not a correct forum. I have built several standalone applications up until now. But now I need to create a server client application, the only database is on the server. The application itself is installed on all the client computers but not all of them are granted the same level of access to the database.
[Code]...
SERVER
Im using this code:
Imports System.Threading
Imports System.Net.Sockets
[code]....
but when i tried to run the application, it hangs even if i wait several minutes.., is there something wrong with the code..
I want to create a server client application in which The server will communicate with the client and give them commands. I did the same in visual basic 6.0 using Winsock component.Now I want it to implement using Visual Basic 2008, how to do it and which component to use.
View 5 Repliesanyone 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 RepliesI'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 RepliesI 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 Replieslinks or Procedure how to build a client/server and file sharing through lan because my friends needs a reference for That
View 4 Replieshow 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 RepliesI 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]...