Connect To SQL Server From Client?

May 28, 2012

Which should be selected?

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

or

Data Source=190.190.200.100;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

ADVERTISEMENT

Client App Connect To Web Server Database?

Jun 8, 2010

Im a beginner at vb.net, and just wanna ask if it is possible to make a vb.net app/client app that can connect to a database on an online web server???The app is locally on the client computer and the database is uploaded on the web server/host together with its website.

View 4 Replies View Related

Creating A IRC Client That Will Connect To A IRC Server?

Aug 10, 2011

I am wondering if anyone has a tutorial or source code to help me get started with creating a IRC Client that will connect to a IRC Server.I just want to make a pretty GUI to modernize it a bit and add some more features etc purely for educational reasons & because I need a new project.This is a couple of steps up from my last project so I will need a guide to get me started etc. I have been searching on various sites etc but have found nothing so far.

View 7 Replies View Related

Connect As A Client To The Server Using The Command Line?

Jun 25, 2010

I am trying to open a socket server, I have the code below but my problem is that when I try to  connect as a client to the server using the command line (telnet ip port), i only get to type 1 letter and that's it, i can't do anything else, how can I make it so that the client can send anything until they hit or type EXIT?

Here is my code:

Imports System.Net.Sockets
Imports System.Text
Imports System.Threading

[Code].....

View 1 Replies View Related

Connect To Oracle 10g Server From Client Machines?

Mar 9, 2010

I have installed Oracle 10g in one of my office's computer. I want to keep this as database server. I am developing a .net project which will communicate with the database server from client machine and from the server machine. I success to communicate with oracle from server machine but not from client machine using the .net project. The connection code is as follows:

Public OraConn As ADODB.Connection
OraConn = New ADODB.Connection
OraConn.Provider = "OraOLEDB.Oracle"

[code].....

View 1 Replies View Related

Connect VB Client Application With SQL Server Using TCP Connection (LAN)?

Feb 15, 2012

I've been Searching the Net for hours now, and i can't really seem to find anything clear and straight to the point.

I need to create a Server/Client application using VB.net 2008, it's actually my first time to have a database on another computer. So I first searched the internet for the things i need to make this software.

[code]...

View 5 Replies View Related

Program That Uses Sockets To Connect Server To Client

Aug 2, 2010

i made a program that uses sockets to connect the server to client but there is a problem with it when i try it on this ip"127.0.0.1"wich is not a real ip just a loopback to my computer it works just fine when i use my local ip it works as well when i use my main ip from http:whatsmyip.org it doesnt work at all i dont know why it doesnt say an error or an exception but its not connecting so i gave the server to a friend of mine i tried using both his real ip and his local but still not working i dont know why?i mean i am 100% sure of my code...

View 7 Replies View Related

DB/Reporting :: Connect Database In Server From A Client Computer?

Feb 24, 2008

I wrote a program in VB2005. It is a program that is supposed to run in a client computer accessing an MS Access .mdb file stored in the server. The program itself is stored and run in the clients computer. I am not good in networking at all. The way I do it now is:

1. Have a directory made in the server to hold the MS Access .mdb file, and have the directory to be shared.

2. Have the same directory accessed and mapped in the client computer (say to Z:)

3. Then have the program in the client computer simply access the database as if it is in the same computer (as the directory already mapped into the client computer). In the VB 2005, this is done when we set the connection string of the database connection.

However, my user is complaining that by doing so, the database is basically exposed to the operator of the client computer (through the mapped directory), hence more vunerable for any bad intentions from persons who may have access to the client computer but not the server. He insists that he used to have a program that does exactly the same thing like my program, but the database is shielded in the server, where it cannot be seen in the client computer (I have other people who confirm that this can be done, though they can't tell me how, since they are not programmers themselves). Now, I have no idea on how to connect a database that way, and I don't even know where to start looking.

View 1 Replies View Related

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 View Related

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 View Related

Connect Client Machines With Sql Server Machines?

Dec 7, 2011

How to connect client machines with sql server machines ?Vb.Net as front end.

View 8 Replies View Related

Client-Server-Client Multithreading - Instant Message Another Client

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 View Related

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 View Related

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 View Related

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 View Related

Writing A Program With 1 Client And Server Where Client Side Creates A Text File

Dec 1, 2008

I have been reading through Atheists posts in regards to client-server and TCP client/server connection's. But how do i go about writing a program with 1 client and server where the client side creates a text file.Once the server sees there is a text file it connects and downloads it to itself or the client pushes the text file to the server.Once on the server i will read the text file and put its info into a sql db.

View 14 Replies View Related

VS 2008 Chat Server/client - After The Client Clicks Disconnect Or Closes By Task Manager, Looses Connection

Aug 18, 2009

Im using the code from [URL] as a starter, most of the code is the same. the chat system works fine but on the client a added a disconnect button "clientSocket.Close()" and as soon as i click that i get errors, on the client, this is the code...

Private Sub getMessage()
For infiniteCounter = 1 To 2

[CODE]...

And this line...

serverStream.Read(inStream, 0, buffSize)
gives me "Unable to read data from the transport connection: A blocking operation was interrupted by a call to WSACancelBlockingCall."

Now im talking the server, after the client clicks disconnect or closes by task manager, looses connection, etc the server crashes and gives me.

View 5 Replies View Related

Chat Client To Client Without Server Just Use IP Address For It?

Apr 19, 2012

Chat Client to Client Without Server Just Use IP Address For it?

View 1 Replies View Related

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 View Related

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 View Related

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 View Related

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 View Related

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 View Related

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 View Related

Why Client Cannot Connect Remotely With External IP

Apr 1, 2012

I have a server and a client working with sockets. I run the server at my laptop, sending its internal IP to my Hotmail account and I run my client at my desktop. I enter the internal IP and connect fine! But when I tried to connect with my cousin's PC, which is not in my network, I entered its external IP and the client couldn't connect.

Here is the code for the Server (consists of 2 forms):
Form 1 (Server):
Imports System.Net
Imports System.Net.Sockets
Imports System.IO
Imports Microsoft.Win32
Imports System.Net.Mail
[Code] .....

View 1 Replies View Related

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 View Related

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 View Related

.Net Desktop Client Cant Connect To Offsite Webservice?

Aug 6, 2010

I have written a vb.net app that runs in multiple hospital networks. THe vb client periodically contacts a off-site webservice for datatransfers.The issue I am getting at a particular hospital is that the client PC's are not on the hospital's domain.  So they are sort of off the radar.  They do use the hospital network for internet access.  When the user opens a web browser they are asked for domain

userid and password.  If not are provided then they cannot proceed.  What do I need to do with my vb.net code to make the webserver calls prompt for and use the proper domain user id and password?

View 10 Replies View Related

Communications :: Allow The Client To Connect To Multiple Servers

Oct 24, 2008

I have this code below for a client module, to allow the client to connect to multiple servers, though a IP list. The problem is that it is connecting ok to the servers, and it is sending messages to servers, but is not receiving messages FROM servers.

[Code]...

View 1 Replies View Related

OP3 Client To Connect To Gmail And Download Messages

May 10, 2012

I am using Peter Huber's POP3 client to connect to gmail and download messages.The inboxes being accessed are transactional inboxes used only for code-access. That is, a message comes in with a order file attached, code will process it and then delete the message. One stipulation of the code though was a DEBUG flag, which if set would prevent the code from deleting the message so that you can run the program again later without the debug flag and reprocess the message. So, in my code I have If Not Arguments.Debug Then pop.DeleteEmail(eid)

This works fine. Problem is, even when not deleting the message, running the program a second time will not re-retrieve the message, even though if I login to gmail and look at the inbox, it is still there. The only way I can get the program to see the message again is to forward the message back to the same inbox. But in Peter's code I do not see anywhere where he is keeping track of seen messages between sessions.

Is this something that is done on gmail's end? Refusing to deliver a message to the same client a second time? If so, is there any way I can change my gmail account so that it will always show all messages in the inbox to a client when retrieving the list of messages, even ones already "seen"? I don't see anything in the gmail settings screen.adding a method to send a RSET command to the server, as per this comment on the codeproject page.

View 1 Replies View Related

Develop An Application Which Can Connect Any Remote Server And Pick The Configuration Information From Server And Show It In Desktop?

Feb 10, 2010

I planing to develop an application which can connect any remote server and pick the configuration information from server and show it in my desktop.

View 4 Replies View Related

Careful Steps To Connect To A SQL Server 2005 Database On Server

Dec 7, 2010

How can I write a connection string? I has four different computer that can be connect via ethernet.How can I maintain a inserting data if to computer insert on same table at a single time..??

View 1 Replies View Related

TCP Server/Client "Individual Send To Conected Client"?

Jul 4, 2009

I have got the server app an the Client app Both Working to what i can see But My issue is i was only asked 4 days ago if i could add a Private msg and Whisper Feature as well as admin controls I have Done what i could to it then realised i have no idea how to only send the data to the selected client.

View 14 Replies View Related

VS 2008 : TCP Server/Client "send Hashtable To Client App"?

Jul 15, 2009

i have been working on a chat program Server side and client side i have most of the features i was asked to put in but then once i got most of the bugs out i noticed something the server admin could send whispers and alerts to single users but then when you try do do it on the client side it wont work so i looked through it all and found my issue the user list on the client is only a list of the names in server hash table so i was wondering how do i send the hashtable and all of its data E.G. user connection information to the client so that it can send commands to individual users like the server side can

vb
Public clients As New Hashtable()
' This subroutine checks to see if username already exists in the clients
' Hashtable.  If it does, send a REFUSE message, otherwise confirm with a JOIN.

[code]....

i tried to send the hashtable over the same method used to send the user names to the client but it cannot convert the hashtable to a string so that wont work so my question is How do i send the hash table to the user from the server then display the username on the client ??

View 39 Replies View Related

Connect To Oracle (Linux) Without Installation Of Client Or TOAD?

Dec 14, 2011

How to connect to oracle (Linux) without installation of Oracle Client or TOAD .....?

View 2 Replies View Related

Connect With Same Type 2 Servers On Different Destination From Single Client?

Apr 7, 2012

connect with same type 2 servers on different destination from single client

View 8 Replies View Related

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 View Related

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 View Related

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 View Related

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 View Related

C# - Connect With Same Type 2 Servers On Different Destination From Single Client By .NET Remoting?

Aug 31, 2011

I have to connect same type of remote objects on different destination using .net remoting. For example, I have a database access middle layer on a remote server and local server. But both are same type object. but the remote destination addresses are different. So how to connect it using .NET Remoting?

View 1 Replies View Related

Detect Connected Computers In A LAN Using Visual Basic And Connect It Using A Client Application?

Mar 10, 2009

I would like to ask how to connect our application to connected computers in a LAN.Will I use the winsock control?How can I run queries using a server database?Any answers are welcome.

View 3 Replies View Related

Server Response Was Successfully Sent To Client Without Client Response Back?

Apr 21, 2010

i made a tcp/ip application using the .NET TcpListener class, my problem is that sometimes (about 30 / 4000) the connection between the client and the server got interrupted in the middle and the server response to the client is lost.is there a way to know if the server response was successfully sent to the client without the client response back?

View 9 Replies View Related

Connect To Oracle Without Oracle Client On Client's PC

Jul 2, 2010

i Use "Imports System.Data.OracleClient .. Private conn As New OracleConnection()" to connect to my Oracle database..but when i put my program to another PC I need install Oracle Client on it...is there some other way how to connect to Oracle DB without installing oracle client to client PC?? (Database is on Server an program is on client´s PCs)

View 2 Replies View Related

Connect To Server - Error "Cannot Connect To SOFTCITYEIMPRESSION"

Jun 5, 2011

when connecting to sql server i get getting this error . please help how to resolve this problem

[Code]..

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

[Code]..

View 2 Replies View Related

ADVERTISEMENT