I created application database by vb.net and sql server 2005 now I have some computer on the one of them I installed sqlserver 2005 and other (Clients) computers I installed Application how I can connecting my application to sql server on the pc1 or how I can using connection string.
View 2 RepliesI posted this code in another thread as an example of how to listen for connecting clients using TcpListener.it is a small part of a larger project, its all my own work,
Imports System.Net
Imports System.Net.Sockets
Public Class Server[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 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 3 Repliesi want to designe a simple program that have one server and multiple clients.i program with vb.net,but dont know anything about winsock, can you send me a sample code for start.
View 1 RepliesActually I have created a chat application is it possible to send data to particular client only?
View 1 RepliesI've got a game I would like to build, it will require a central game server where peoples data (game data :-)) will be sent to and shared with other players - how is the done. Is it remoting? TCP? something else - I need to study up on it but want to make sure I'm learning the right thing.
View 3 RepliesI'm new to network programming and i'm trying to write a server that can communicate with multiple clients through tcp/ip, the clients need to communicate with the server to and with the other clients. Currently i've got a client server program that works fine for only one client:
[Code]...
I'll guess to accept multiple clients i have to create some clienthandler class at server side, but i have no idea which code it has to contain, i've already spend hours searching on google but didn't find anything usefull. Can somebody help me with this ?
Basicly I want to create a server that can read data sent by multiply clients and give feedback to them I have found some tutorials before but its only oneway trafic (Client>>>>Server) and the server crashes as soon as the client is disconnected
ps. If its a tutorial with VB it will be nice other visual codes are also good
I am facing a problem in VB .net Client/Server application where I am successfully able to talk between them using TCPListener and TCPClient class usage. However, when I try to connect another Client to the same server on the same welcome port, it errors out throwing an exception or behaves very unexpectedly.Isn't it true that the Server connection is on a WELCOME PORT for all the clients, and that each client connected gets a new port to carry on its communication with the server AUTOMATICALLY (according to the Tomcat webserver working)
View 2 RepliesI made a simple chat system that connects to a server with a client one on one. I'm not really sure how to get multiple clients with the server so that you can see everyone's messages. Here is the source code. The Server only accepts one client at a time.
View 3 RepliesI am developing project on cyber cafe using vb .net 2005 and winsock i don't know how to accept connections from multiple clients to a server having winsock control
View 2 RepliesI have 2 clients connected via a server program.When 1 client hits an arrow key, a picturebox moves on client1 and on client2.Before adding this network functionality, the picturebox on client1 moved fast with each click.Now, there is a delay of like 2-3 seconds.I know the code isn't optimal, but i'm not a networking wizard.What i'm doing is when pressing a key on client 1, it passes a text to a textbox in client 2 which then has the picturebox move in client 2 depending on the text.The slowdown occurs on client 1, which is odd because the picturebox isn't directly connected to the network code.[code]
View 3 RepliesI am writing a small VB 2008 application which connects to a SQL Server 2008 database,which is hosted with Fasthosts in the UK. The connection string I am using is;"connectionString="Data Source=xxx.xxx.xxx.xxx;Initial Catalog=xxxxxxxxxx;User ID=xxxxxxxxxxx;Password=xxxxxxxxxxxx"I can connect to the remote data using the "add data source" within Visual Studio and can preview thehosted data without anyssues however when I try to run the application I get an error stating;"The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
View 1 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 RepliesI have this connection string (IP and port number changed)Public ConnectString As String = "Data Source=207.167.717.614,8711;Network Library=DBMSSOCN;Initial Catalog=TableName; User=User; Password=Password;"It does not all a connection, i've opened this port for port fowarding and have unlocked the TCP port of the firewall what else could be wrong?
View 24 RepliesI am bignner in vb.net and i have develo[ed a small application of vb forms in which i have use a service based sql server databas(.mdf)i want to make its msi installer last time i have made it and after installation application giving error for connecting to sql server
View 1 RepliesI am using this code to connect to my exchange server using POP3.
I am trying to retrieve an inbox of basically emails that have not been read however, i am just getting a bunch of gibberish and its reading an email.
modify my code to just read the most recent messages.
Try
tcpClient.Connect(hostName, 110)
Dim networkStream As NetworkStream = tcpClient.GetStream()
[Code].....
its been a long time but sincerely, am happy to be back. now i've got a problem on my mind and that is; am trying to develop a database application but i want it to be a console application. the major issue is that i dont know how to go about connecting vb.net console application to sql server or if its possible at all, but am sure its possible in this world of ours...
View 2 RepliesI would like to create a OPC Client... But fist of all how do I connect a OPC-Server to me application. anyone who have done this? and maby hade some sample code??
View 8 Repliesim using SQL Server 2005 as my back end for an information system im currently developing. Im a total beginner with SQL, so i came across a huge blockade.An error appeared while i was configuring my server,"Login failed for 'username'. Reason: Account disabled".i tried searching EVERYWHERE in the net, but nothing helped me.
View 1 RepliesI have installed Visual Basic 2008 express edition, but I didn't get SQL server. Therefore, I installed SQL server 2008 separately, and it works fine..But I want to use the SQL server in Visual Basic, but it doesn't show up when i click Add New Item. Is there some way of connecting VB to SQL server?
View 5 RepliesI want to understand the concept of connecting to a remote PC or server. I'm working on an app that will connect to a remote server. Read a value from a registry key and then display the results in a text box. It will also connect and search for a specific log file on a server. I understand how to read the files. I'm just not sure how to connect to a machine remotely if I have valid credentials. There seems to be sever ways to accomplish this. I want the most efficient way using vb2008.
View 3 RepliesI'm been learning about connection strina I have been able to succesfully connect to a sql database stored locally on my Pc.The next logical step would be to connect to a database stored on a remote server. My question is does anyone of a sql database ( or any other type of database ) which can be openly accessed by the general public. Does anyone know if a web hosting service would allow me to remotely connect to a sql database ? Could I for instance upload my database onto a web hosting service and try connect to a remote database that way
View 1 Repliesi am having alot of trouble finding the source code to establish a connection to a remote sql server ( at my university) for vb. All i have is the IP adress and the username and password to the database. I tried coding it with a sqlconnection, sqlreader and a command to execute the statement with no luck.
View 2 Repliesi am trying to develop a multi user application. this is the first time i am doing it. my database is sql server 2005. and using vb.net as the programming language.i have few questions,
1. my database is in one computer. this computer is not actually a database server. it is just a computer. and the database is created in local drive (e:) of the computer. when i develop the application. so, if i am writing an application for the computer where the database is created. i can give the location of the database as my connection string (is there any better way to do this. because there might be problems, if the database location is changed). how can i connect to the database from the other computers in the same network?
2. this is my second question. i have a table which stores customer details (customer id is primary key and its auto number). one customer can have many hobbies. so i took it as a separate table (customer ID as the foreign key of that table) . when i enter data, i use single form to enter the customer details and their hobbies. so when i insert the record into two tables, will the second table take the new customer ID automatically into dat tables customer ID which is a foreign key.
I'm building an application that connects to a SQL Server 2008 database via connection string. The thing is, since the computer loading the app (or the user, in either case) is outside the Active Directory domain, I can't use Windows Authentication to connect to the DB. But when I include the database credentials, it won't let me connect either, telling me that since the computer logging in is from an untrusted domain, access is denied.
The connection string goes like this:
connectionString = "Data Source=" + ServerName + ";Initial Catalog=" + DatabaseName + _
";Integrated Security=SSPI;User ID=" + UserID + ";Password=" + Pwd
[code]......
I always get error to connect my project in vb.net to sql server on remote computer?
View 7 RepliesI am trying to connect with SQL Server Database using VB.Net. In Datasource of Binding Source, I selected 'Add project datasource' Clicked 'Database and New Connection in Choose Connection Wizard.
In New Connection, what to select 'SQL Server' or SQL server Database? I tried both but when Tested Connection, it failed to connect.Also, what type of password to be chosen, Windows based or SQL Server based?
Am having a hard time co be connected to sql server 2008 enterprise edition.i am using oledb in this fashion
db.connectionstring="Provider=SQLOLEDB.1;User id=helen;password=123;Initial Catalog=mydb; Data Source=server"
but it gives this error: Login failed for user 'Helen'/ Is SQLclient a must to be connected to sql server?