Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
|
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 May 4th, 2008, 11:19 PM
Authorized User
 
Join Date: Jan 2008
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to connect to remote database with vb net?

Hi

I am using win form application (VS 2005, VB NET and SQL SERVER 2000).
I want connect the application to remote database, how can i do this?
Client is only for user interface and business logic and
Server is for database only. (2 tier).
Can I do like that?

Thanks

 
Old May 5th, 2008, 08:03 AM
planoie's Avatar
Friend of Wrox
 
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

You certainly can.

What do you mean by "remote database"? How remote is it? On another server on your private network or on a non-private network?

-Peter
compiledthoughts.com
 
Old May 7th, 2008, 08:11 PM
Authorized User
 
Join Date: Jan 2008
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yeah..
It is still in our private network (LAN).

have we to change the connection strings?

 
Old May 8th, 2008, 05:37 PM
planoie's Avatar
Friend of Wrox
 
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

You need to set a connection string somewhere. It sounds like this is a very new topic for you. Do you have a book with some introductory information on connecting to databases?

-Peter
compiledthoughts.com
 
Old May 8th, 2008, 08:11 PM
Authorized User
 
Join Date: Jan 2008
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hmm.. I haven't connect to remote PC in LAN.
But I think that I have to set/put that remote PC's IP address in connection string so then I can connect to that.







Similar Threads
Thread Thread Starter Forum Replies Last Post
connect to remote acccess database aasheesh_jha Pro VB Databases 1 October 30th, 2007 01:57 PM
How vb.net connect to the MySQL server database? cwliong2508 VB.NET 0 May 29th, 2006 07:58 PM
Connect Remote SQLServer Database krajdyal ADO.NET 1 December 21st, 2005 02:47 PM
how vb.net connect access database abbee99 ADO.NET 1 April 29th, 2005 04:21 AM
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.