VS 2008 .NET And Configuring Remote Sql Server?
Apr 14, 2010
I've been messing around with my Sql Server all day and i still cant get a remote computer to connect to it. I've looked at various resources but really, i don't know where to properly look.
I've configured my Sql Server Express 2005 from the Sql Server Configuration Manger:
- Started Server Browser
- Enabled TCP/IP
- Changed my Sql Server Properties to Network Service
Then for my connection string in Visual Studio using VB.NET is:
ConnectionString = "Integrated Security=SSPI;" + "Initial Catalog=mydb;" + "Data Source=VAIOSQLEXPRESS;"
I am unsure about my connection string especially my Data Source. May someone tell me how to find my Data source? Or if there is anything I'm missing?
View 6 Replies
ADVERTISEMENT
Aug 19, 2010
My.Settings.ConnectString = "Data Source=123.132.123.123,3306;
Network Library=DBMSSOCN;
Initial Catalog=Authorities;
User ID=AppUser;
Password=mypassword;"
View 19 Replies
May 20, 2010
I have a vb.net app that is installed on server 2008 and registered as a remote app with approximately 70 users accessing it. There is an issue that when I put a new version of the app on the server, every user must remote desktop in and run setup.exe before the app will update to the newest version. If they try to run it without doing this step first, the app just runs the previously installed version under their login.
View 2 Replies
May 16, 2012
I'm using ReportExecutionService to create file on a different server on the network. The application does the required job if I run it locally, but fails to create file when I publish it. The error I get is- Access to the path '\servernameapth..xyz' is denied. The folder has full access to Domain users. Here is my code to create a report file on a different server via an ASP.net app.
[Code]...
View 6 Replies
Dec 22, 2011
I've been working on a tcp online chat. I heard that you need to configure your router to allow other pc to connect or something?
Server :
Imports System.Net, System.Net.Sockets
Public Class frmServer
Dim serverSocket As Socket
Dim clientSocket As Socket
[Code] .....
View 8 Replies
Jul 2, 2011
I'm developing a online document management application for my client using the following technologies
Front End - VB.Net 2010 (Windows Forms)
Back End - SQL Server 2008 R2 Express (FILESTREAM enabled to level 3)
I wanted to store the files (*.pdf, *.doc, *.exe, .) using the FILESTREAM feature in SQL Server 2008 R2.I prefer FILESTREAM because sometimes the file size exceeds 2GB.I'm able to save and retrieve file with FILESTREAM (using Windows Authentication/Integrated Security).But my client wants to save or retrieve the file from different PC.So I'm in need of accessing the FILESTREAM BLOB from remote systems.
View 1 Replies
Oct 16, 2010
I need some pointers on which .NET technology to use for a project I'm working on. I'm building a "dashboard" digital signage WPF program that will display various things on a large monitor mounted high up in the ceiling of my office.What I need to be able to do is control certain aspects of this program from my desktop. For example, there will be a TV window in the application with signal being provided by a TV tuner on the mini-computer connected to the monitor in the ceiling. What I want to be able to do is make a remote control to be able to change the channel etc. I'm confused at what technology to use. I've read about remoting, WCF, and simple TCPclient classes but I'm confused at which one would be better. I'm thinking it may be better to use WCF because what I think I need to do is make a function that will change the channel and accept channel numbers, etc from the remote control program. Am I on the right path?
View 5 Replies
Oct 19, 2009
I've made this script to read the lines from the txt. But when I try to login I just get this " The remote server returned an error: (530) Not logged in." Even I "logged in" at the link.
vb Private Sub Refresh_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Refresh.Tick
TextBox1.Text = GetWebSiteSource("ftp://<myusername>.<mypass>/<serverip>/<serverIP>%20port%2027016/Server%20Documents/log.txt")
Dim lines As New List(Of String)(IO.File.ReadAllLines(TextBox1.Text))
Tname1.Text = lines(0)
[Code]...
View 1 Replies
Mar 2, 2012
I want a quick and easy way of sending stuff from my window forms to my remote SQL server, my remote sql server allows remote connections to my IP address. How can I do this? I also need to return a result, either true of false.
View 6 Replies
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
Jun 6, 2012
I am trying to copy upload files to remote server i get below exception.[code]...
View 1 Replies
Feb 19, 2010
the remote server returned an error: (503) server not available m getting this error...wen i m trying to extract email id from a webpage...
View 2 Replies
Oct 27, 2011
remote server returned an error:(503) server not available-vb.net
View 5 Replies
Jun 8, 2012
I want to build an application, which can remote access to SQL Server in Server Machine.I used to build one, and it also can access to SQL Server in other pc. But when i promote it to become a Server(to become a Domain Controller). My application has never access to SQL Server. I don't know what to do now?
remember: I want to build an application, which is accessing to SQL Server in Window Server(Client/Server Application).
View 2 Replies
Jan 23, 2009
Is there a way for my program to send Linux Console Commands to a remote Linux server?
View 4 Replies
Jun 14, 2010
Trying to POST a username & password to my PHP script at www.example.com/web-service.php which gets that info and echos true or false.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Connect to web-service
Dim hwrRequest As HttpWebRequest = HttpWebRequest.Create("http://www.example.com/web-service.php")
[code]....
Am I missing anything? It stops and throws that error on the line that calls GetResponse()?
View 6 Replies
Dec 5, 2010
posted again but this time its regarding both the webclient and the web reuqest giving me this error :S
View 1 Replies
Apr 16, 2009
I've found a few examples of using vb.net to access an sql database, so far none of them have worked . They all involve using DataReaders. Maybe its the fact that the sql db is not on the same machine as the application.I was just wondering if anyone had a more comprehensive example of using VB.NET to access a remote sql server.
EDIT:I've received a few helpful comments an replies already. So far my connection string looks like:
"server=sqlblah.myhost.com;uid=myuser;pwd=pass;database=testdb"
Probably also good to mention their is no editing of the tables a this point, just reading.
View 2 Replies
May 5, 2008
How can I connect to a database using sql server 2000 and stored in another PC with vb net (still in 1 LAN)?So that PC only stores the database, and another PC store the user interface and business logic.Is it related to the connection strings, on the datasource, we just put the IP address for that remote sql server?
View 3 Replies
Nov 20, 2009
* Using windows application i am trying to connecting remote server(PC), for this i have servername,uid/pwd.
View 1 Replies
Feb 2, 2010
I 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 Replies
Apr 17, 2010
I'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 Replies
Feb 25, 2010
i 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 Replies
Jan 16, 2009
I have looked into this for a while now with no success. out or lead me in the right direction. I am trying to control my application from an apache web server either locally or remotely.
View 3 Replies
May 22, 2012
i'm trying to connect to a website using httpwebrequest() in a VB.NET application
It is working fine for facebook website.
But when i try to connect to jsp coded sites. it is displaying "The remote server returned an error: (404) Not Found."
View 4 Replies
Feb 10, 2012
Busy with vb2010 and we are busy to communicate with a server on a certain ip address. This server is sometimes sleeping and we can't communicate with the server in this situation.
View 2 Replies
Mar 20, 2012
I have SQL Server 2008 setup to remote connection. and it works perfect. I can access it from public IP address. [code]...
View 7 Replies
Nov 10, 2010
I want to create a simple console application that has two input files and one output file. The code is very straightforward. The question is that I want to execute the application from the remote server or unix/dos batch etc instead of local machine.
View 1 Replies
Dec 9, 2010
how to send a log using vb.net console app to a external server? I have the application sitting in a store oulet, then I need this application to send over a log file.
I have a couple of ideas.. one is using a tcp listener and sender, then the listener logs it over in the server.
Another is using a ftp send.
but I would prefer it to be coded in the program itself.
View 2 Replies
Jun 2, 2010
I have a site map configured as such:
[Code]....
For some reason, even though in the sitemap, the url is defined as "[URL]" or "home.aspx", the currentNode.URL always has the domain attached to the URL, creating bad urls like "[URL]" I've tried to figure out where [URL] was coming from by search my project and inside of my web.config file, but I can't seem to find it.
View 1 Replies
