Connect To SQL Server On Another Computer?
Jun 5, 2011I have a webbased proj. What i need is to connect the vb.net app to an sql server via internet. My projects run fine in a standalone pc.
View 3 RepliesI have a webbased proj. What i need is to connect the vb.net app to an sql server via internet. My projects run fine in a standalone pc.
View 3 Replieshow can connect to sql server 2005 or 2008 by vb.net from anther computer ? and this computer donot have sql server.i made search on internet and result was use sql client tools but i made search and try to download sql client tools but i did not get any result.so how can i connect to sql server 2005 or 2008 by vb.net on anther computer or on network LAN.
View 4 RepliesWhat happen if i want connect to a database server is not my computer local host, is another computer localhost in LAN network? how it works? [code] how about i wan connect the server is another computer localhost database?
View 1 RepliesI 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.
I'm trying to develop a windows application where i can get connected to remote server and look for process state going in remote server.We have many remote servers where automatic installation of software going on. We have an xml file(installstatus.xml) where it tells us at what stage the installation is (Example : Inprogress , Completed, Failed.)
So our aim is to develop a windows application where i can get connected to that servers and look for their installation status(may be we can use installstatus.xml to look for installation status). Every time i connect to a server, the server information should get stored in XML file(i want to create a xml file where all the servers list i connect to should get stored)
The UI at left side should will have list of servers i can connect to. When i get connected to server, at right side of UI, i want to display the status of installation (In progress, failed , completed).
I am trying to connect to copy some files to another computer on LAN, but the problem is it asks for user name and password, now how do i provide user name and password through my application
View 6 RepliesI'm using vb2008 with DB Msaccess 2003 in the first my language it's not very well so I'm sorry fro bad expression I have two computer ( Pc1,Pc2)I put the program(exe) with DB on the PC1 , then I put the program(exe) on the pc2 the pc1 connect to pc2 how do I deal(connect) with DB from Pc2 ?
View 13 RepliesHow can i connect a scanning device to a computer using .net? Code 128.
View 4 Replieshow to connect to a database of another computer in same local network using vb.net? We already enable remote connection in the sql server configuration and also sql browser and we already connected with one another using wireless network. Here is our connection in vb.net
"Data Source=NEWUSER0602akzSQLEXPRESS;Initial Catalog=sample;Integrated Security=True" is there something wrong with this? because when i input a data it always show me the error "An network-related or instance-specific error occurred while establishing to SQL Server"
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 RepliesHow 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 Repliescan i in some way change the power that the usb sends to a usb device?i want to connect a computer fan to the usb and control the speed is this posible??
View 1 RepliesI created an executable file of an application done in VB Express 2010 which connects to a Access 2010 database. When installling the executable file at one of the user's computer, the file is installed correctly, but it fail's when trying to connect to the database. It says that Microsoft Dataengine cannot open the database. The user's computer doesn't have Access installed, does it need to be installed? or can I install a framework or application to avoid installing Access at the user's computer?
View 8 RepliesCurrently, i am trying to connect the EPP (Encrypted Pin Pad ) device to my computer by using mscomm control. May i know what are the possibility problems may cause the DSRHolding does not return to "True"?
View 3 RepliesAre there any good tutorials/links I can work through. I want to make my pc a file server or an ftp server through vb.net. How would I go about doing it?
View 5 Replieswhen 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]..
I am trying to make a copy of an existing database, I use .net framework data provider for SQL Server.I get error "Unable to connect to source server for Transfer" when it runs to oPackage.Execute().
oConnection = oPackage.Connections.New("what the providerID should be?")
oStep = oPackage.Steps.New
oTask = oPackage.Tasks.New("DTSTransferObjectsTask")[code]......
Have you ever use it I want to ask this question used it and i connect a specified server. Now i create other server and name it to :[URL]..
How can i remove old server on VS and connect to new server.
I always get error to connect my project in vb.net to sql server on remote computer?
View 7 RepliesHow to findout computer / server name with vb.net codes. I want to use it in connection string
[Code]...
How do I know where the other end of the NetworkStream from the 'server' computer? I have been looking at the following code that comes from a post out here, and am wondering where I can tell where I am going to send back to(URL/port)?
Private Sub DoListen()
Dim incomingClient As System.Net.Sockets.TcpClient
Do
[code]....
I've created a Http Server in VB.net.I've used the same "template", I guess you could say, for every project requiring an Http Server (quite a few recently).The problem is, this one I'm working with now requires that the computers on the LAN be able to connect to it. I can access the server directly from my computer though using: [code]Now I get an error every time when it tries to apply the prefixes: I've checked all the ports that are listening and 8002 is still open...
View 2 RepliesAn 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)
[code]...
I want to create a openfiledialog and allow user to choose which exel file to be imported into the server but this error keep coming "ODBC--connection to '{SQL Server}'TGT102 failed".
[Code]...
When I run this code from vb.net Emulator it works fine but when I run the same code from a Win Mobile 5 PDA, it doesnt work pc and pda both in same network via a wireless router and i can ping each other.
here is my connection string -
ServerName = "192.168.0.100SQLSAMI"
ConStr = "server=" & ServerName & ";integrated security=FALSE;database=NanoFood;User Id=sa;Password=nanosoft"
Here is the error-
System.Data.SqlClient.SqlException was unhandled
Class=20
LineNumber=0
[code]....
I am trying to connect to SQL Server and I am getting the following error, yet when I check the surface configuration screen, it's accepting remote connections.
View 3 RepliesI want to make an application that runs on 3 client pc's. The application has to query his data from an SQL Server-database, which is running on my Small Business Server. After some google-searching, i think my server is ready, but I don't know how I can connect my vb.net application on my client pc, to my SQL Server on my server. Here is a screenshot of my Object Explorer from SQL Server:
I don't have any idea how I have to build up my connectionstring. The name of my server is SBS2008, and it is on the same network as my client pc.
I finished a win app which user can input data off line. User can use vpn to connect server to upload data. Now, boss want me to add a feature to auto connect to server using vpn once user start the app.
View 1 RepliesIn my offline windows program, user have to do two steps to download files:
1)clicking a shortcut of vpn to connect to a server,
2)clicking a button to download files (done for this step)
How to code to connect to a server via vpn without clicking the shortcut? That is once user clicks the button will connect to the server via vpn and then download files.
I'm looking to connect to an existing ftp server, upload a file, wait while the server generates a report on it, and download that report back to the local machine in a vb.net 2.0 winforms project.Is there an existing FTP library that would be helpful to me for this? My task seems simple enough that I'd rather not get into the world of active vs. passive, sockets, etc.
View 4 Replies