Way To Connect Remote SQLServer?
May 24, 2010What is the best way to connect a remote SQLServer via window based application?
View 8 RepliesWhat is the best way to connect a remote SQLServer via window based application?
View 8 RepliesI can connect to VPN and I can access Sql Server using RDP. Now, I want to access the Sql Server programmatically.
I connected to the VPN and then have the following connection string set up[code]...
I have a web site that connects to a remote SQLServer, and is running just fine.I have some pretty simple 'batch' type tasks that I want to run (as a Windows application) on a scheduler (I'm more comfortable with VB so I prefer that).
Looks like VB Express won't allow me to access the remote data. Everything seems to be pointing to having to buy VS Professional for $545 (I don't have an original one to upgrade). Is there a more economical VB option?
Rather than use an Entry name of an existing VPN connection, is it possible to connect to a remote network by creating a temporary connection on the fly by using the remote IP/Host name, username and password?
View 6 RepliesI have made a form to connect to a SqlServer but i have hit a dead end as the PHPMyAdmin password table is encrypted so the Login only works when you enter the encrypted password in. Is they anyway to decode the password so the password can be read?
View 10 RepliesI'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'm trying to use LINQ to SQL in Visual Basic 2010 Express.
It allows me to create the .dbml file, but in order to drag items from the Database Explorer window to the design surface, I first have to get my database listed in the Database Explorer!(this is a remote SQL Server database - not a local .mdf)
I already have a good, working connection string to the remote SQL Server database, but that doesn't help me when I'm trying to generate the DBML at design time.
Can anyone tell me how to get my remote SQL Server database identified in the Database Explorere window? When I try the "Add Connection", I am limited to Access, SQL Server Compact, or SQL Server Database File. If I try to enter the IP address & port of my DB Host I get a 'database file does not exist' message. Doesn't seem to want to let me point to a remote DB server...
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 Replieshow to enable remote database
View 2 Replies* Using windows application i am trying to connecting remote server(PC), for this i have servername,uid/pwd.
View 1 RepliesI am having a small problem with my VB.NET and VC#.net programs. I am creating a spider program in VB.NET which parses a URL and stores data in my database. The list of URL to be parsed are included in my database. Right now the program is working fine as I am using a local database lying on my hard drive, but I want to use database lying on a remote server (ex. [URL]). How do I do that in VB.NET application?
View 1 RepliesScenario: I want to develop an application.The application should be able to connect to my remote server and download data to the local disk , while downloading it should check for new files and only download the new ones simultaneously creating the required(new) folders. What am i doing?: The app first checks for internet connection , if available pings the server to check if the server is active.Then it has to download the new files.
Problem: I have no idea how to compare the files in the server with the ones in the local disk.How to download only the new files from the server to the local disk? What am thinking?: If i can create the exact folder structure(hierarchy) in the local disk as it is in the server...than i can download the new files accordingly to folders by maintaining some index file in both server and local disk.
I am able to connect remote MS SQL Server 2005 using vb.net-->
Imports System
Imports System.Data
Imports System.Data.SqlClient
[Code]....
But my app is takes more than 2 second for refresh the data..... Sometimes it getting hanged.
Finally i just want to know if their any method available to connect the remote MS SQL Server Database for faster calculation. Like UDP or Proxy....
I have connected VB.net and mySQL on a the same PC before, but I have no Idea how to connect VB.net to a remote PC(LAN)[code]...
View 12 RepliesIm trying to connect to a remote mysql database, and im having alot of crazy issues, i have checked connectionstrings.com for information, im used to doing this in vb6, but times are changing and im trying to rewrite my apps for vb.net. anyone able to help with the new connection string to get it setup so i can connect to a remote database? i already installed and added mysql.data MSI isntaller on there and its version 6.0.4 i beleive, how can i make this thing connect to the database now?
View 24 Repliesi connect to a remote pc via terminal services, when i print with the Microsoft Office Word i get the print in my local printer fast, but when i try to print with my own application the print take 10 seconds.
I use to print the control PrintDocument.
I have a following details provided by our mssql2005 database provider
Server IP : 100.20.255.34
Databaase name : insss
User: nas0
[code]....
I want to know how to connect to the webservice in remote machine
View 5 RepliesI need to read a command from a .html file. To do this I use:[code]My application constantly loops to check the .html file for commands. I need it to do this, even if the internet is off. Obviously, it wont read commands if its off.. I just need it to resume reading when it comes back on WITHOUT crashing my application.Any code to ignore timeouts so where my application will still TRY to read and not crash.
View 3 RepliesSystem.Net.Mail.SmtpException: Failure sending mail. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A socket operation was attempted to an unreachable network 184.xx.xxx.xx:25 at
[code].....
Using SMO To Find - Connect to Remote SQL Server?
View 2 Replieswith vb.net OLEDB (not DSN- ODBC) + access03 + winxp please specify the connection string to connect to a .mdb file on a remote machine with OS winxp .i am confused what is the data source to be used in my connection string
View 4 RepliesMy remote MYSQL allows remote connections so I should be able to connect to it via a VB code.
View 12 RepliesI have an app, that is going to connect to a remote MYSQL DB.I've look around online, and didnt find any good resources. I've seen some where you have to download an odbc driver etc
View 10 RepliesI have created my asp.net website using database ASPNETDB.MDF but when I try to host my site on server ...
The SQL Server 2005 hosting provider issue me the
database name dobriyalji
server ip : 69.112.222.220
database username : XXXX
[Code].....
I want connect my linux remote system using ip address and port through .net. and want run a command to run a file inside the remote system
View 5 RepliesWhen I to connect to remote host to retrieve sql record...
it execute to few minute will get his error message... but there is already work perfectly and get connected... it loop it a few record only will occur this error...
"Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host."
Client form need an access to the ms access database located at the Server. I've just created a database in MS Access in the format .mdb, 2000 version. Forms created in the platform Visual Basic 2010. Kindly post procedure or source code to do it. I preferred to use OleDB connection since i used it on a stand-alone access to database.
View 4 RepliesI've came across a little problem with my tcp / ip server. My client can connect to it with 127.0.0.1 ( localhost ), and 192.168.0.X, but every remote connection fails to connect.
Here's the connection rituals:
Server
listener = New System.Net.Sockets.TcpListener(System.Net.IPAddress.Any, Port)
listener.Start()
listenThread = New System.Threading.Thread(AddressOf doListen)
listenThread.IsBackground = True
listenThread.Start()
Client
client = New System.Net.Sockets.TcpClient(IP, Port)
client.GetStream.BeginRead(readBuffer, 0, BYTES_TO_READ, AddressOf DoRead, Nothing)
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.