Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB How-To
|
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To 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 October 9th, 2006, 11:43 AM
Authorized User
 
Join Date: Jul 2004
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to connect remote databse using DSN Less

Hi,

I want to connect to remote database using DSN Less, how can I do that and also how to setup a connection string on the App.config? I'm using VB.NET 2005 Pro.

TIA

jrd
__________________
jrd
 
Old October 9th, 2006, 12:03 PM
Authorized User
 
Join Date: Jul 2004
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

oConn.Open "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};" & _
           "Server=myMachineName;" & _
           "Database=devserver:C:\POS\Data\Mydb.gdb;" & _
           "Uid=SYSDBA;" & _
           "Pwd=m*s***k*y"

I want to put the above code in an APP.CONFIG file, can someone show me how?


jrd





Similar Threads
Thread Thread Starter Forum Replies Last Post
Connect SQL Server 2k with VB from DSN and DBQ ayan.mukherjee SQL Language 0 February 12th, 2008 02:26 AM
how to connect to remote machine using nant kalpana2009 NAnt 0 October 8th, 2007 07:25 AM
Using DSN To Connect Access Dabase hunzian78@yahoo.com ASP.NET 1.0 and 1.1 Basics 0 March 22nd, 2006 07:26 AM
can't connect to remote server alyeng2000 ASP.NET 1.0 and 1.1 Basics 4 February 9th, 2004 11:24 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.