Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5
This is the forum to discuss the Wrox book Beginning Visual Basic 2005 Databases by Thearon Willis; ISBN: 9780764588945
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 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 June 14th, 2006, 03:09 PM
Registered User
 
Join Date: Jun 2006
Location: Greenbelt, MD, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default connection

I will be using the table adapter to fill my datasets from my oracle database, but what would be the proper way to add the userid and password to the connection string. That is, at design time, I've set the connection string in my datasets to everything it needs except for the userid and password. Then I have a dialog box which prompts the user for userid and password. Then I can simply append them to the connection string when I code any connection object.

But what if I am using an windows control where it uses the default connection string in the dataset.designer.vb file. Should I simply modify that objects connection property just before using it or would it be better to modify the default connection string somehow.

 
Old June 14th, 2006, 05:54 PM
Thearon's Avatar
Wrox Author
 
Join Date: Dec 2003
Location: Fuquay Varina, NC, USA.
Posts: 396
Thanks: 0
Thanked 8 Times in 8 Posts
Default

You can modify the objects connection string before the objects are used.




Similar Threads
Thread Thread Starter Forum Replies Last Post
Connection prasanta2expert ASP.NET 2.0 Basics 5 November 7th, 2006 06:21 AM
open connection in another connection adityamadisetty SQL Server 2000 1 May 4th, 2006 04:56 AM
Connection zaeem Dreamweaver (all versions) 1 May 1st, 2005 04:57 AM
Connection Help morpheus Classic ASP Basics 2 February 3rd, 2005 09:09 AM
connection through C kaushikroy C++ Programming 1 January 30th, 2004 07:30 AM





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