Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
| Search | Today's Posts | Mark Forums Read
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 20th, 2005, 10:03 PM
Registered User
 
Join Date: Dec 2005
Location: Chitwan, Narayani, Nepal.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to krajdyal
Default Connect Remote SQLServer Database

Hi, I am Kamal

I want to Connect Remote SQLServer Database exists on the IP 70.85.218.228 Could it possible or not using Viusal Basic 6 and ADO?

If yes Please help me how to connect to the Remote SQL Server.

Krajdyal
 
Old December 21st, 2005, 02:47 PM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

You can connect to a MSSQL server over any IP connection as long as the right port is open and you have the right credentials. You just make the connection string use the IP address as the 'server' (instead of a local server name). This should work fine for any technology that allows you to connect to MSSQL.

-Peter




Similar Threads
Thread Thread Starter Forum Replies Last Post
How to connect a PDA to a remote mysql database? baburman .NET Framework 2.0 2 November 24th, 2008 12:59 PM
connect to remote acccess database aasheesh_jha Pro VB Databases 1 October 30th, 2007 01:57 PM
how to connect to sqlserver database file bhaveshsanghani BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 1 May 3rd, 2007 04:44 PM
connect from web server to remote database Durwood Edwards Classic ASP Databases 0 June 24th, 2004 01:03 PM
Connect to remote database sankar Pro VB Databases 0 July 31st, 2003 01:43 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.