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

Client Server Application - How To Make Clients On Sql Server

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

VS 2008 TCP Server / Client - Client To Send The Server 4 Numbers - Depending On The User's Choice

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

VS 2010 : Send Data From Client To Server (encrypted) And The String Sent From The Client Is Not The Same As Received From The Server?

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

Make Autorun Setup For Win Application Visual Studio To Installing Sql Server And .net Framework?

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

Create Client-server App, In Which Client Can View Files On Server?

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

Communications :: Client-server Communication Program - Click On CmdListen In The Server Form And CmdConnect In The Client Form

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

Server/Client - Basic Tcp Server/client Application

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

How To Make A Server / Client Billing System

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

Make A Client And A Server Connected In Vb 2010?

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

Make A Client To Server File Transfer?

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

Make A Client/server File Sharing Through Lan?

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

Make A Udp Server That Waits Client To Communicate

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

Make Two PCs Communicate Via Network Using Server / Client

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

VS 2008 Multi-User Chat Program (Server & Client) With Main Server?

Aug 10, 2009

Multi-User Chat Program (Server & Client) with Main Server?

View 1 Replies

Clinet/server The Server Broadcast Media Files To Client I Used Tcp/ip Protocol?

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

SQL Server 2008 Configuration For Client Server (Windows Form) Application

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

The SMTP Server Requires A Secure Connection Or The Client Was Not Authenticated. The Server Response Was 5.5.1 Authentication Required

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

Difference Between SQL Server Native Client And SQL Server DSN To Support SP Execution?

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

Info: Multithreaded Server Socket Program Or Client/Server?

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

VS 2005 Make A Simple Client-server Program?

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

VS 2010 Attempting To Make Basic Client/Server?

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

TCP Client/Server App That Sorts Out Text That Is Recieved From Server?

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

VS 2008 Make The Client Send The Users Account And IP To The Server?

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

Build Client-server And Sql Server Application?

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

Client Needs To Have Sql Server On His Machine If Application Uses Sql Server?

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

Ping Server From Client By Specifying Ip And Port Of Server?

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

Combobox Unhandled Exception - Make A Basic Winsock Chat Server And Client?

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

Javascript - Client And Server Side - Make The Rows Not To Be Deleted Once The Page Is Refreshed?

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

VS 2008 Client / Server - Constantly Download The New Data And Make The Application Freeze

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







Copyrights 2005-15 www.BigResource.com, All rights reserved