Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB.NET 1.0 > BOOK: Beginning VB.NET Databases
|
BOOK: Beginning VB.NET Databases
This is the forum to discuss the Wrox book Beginning VB.NET Databases by Thearon Willis; ISBN: 9780764568008
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning VB.NET Databases 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 March 5th, 2009, 01:19 PM
Authorized User
 
Join Date: Jan 2009
Posts: 21
Thanks: 4
Thanked 0 Times in 0 Posts
Question Chapter 10 (#298) Data Connection Wizard Question

Help,

I have made it to chapter 10 page 298. The instructions ask that you create SQLDataAdapter and set the new connection. I do this and get stuck when the wizard asks for certain information. EX..
I am in VB 2008 Express:
1) The Data Source uses MicroSoft SQL Server Database File
2) I have gone to the default SQL Server 2005 Express Directory selected my database(ProjectTimeTracker)
3) I can not establish a connection
4) Can you help me ?
5) I have been able to get thru all the differences so far and I am up to chapter 10 and trying to finish the book. It has been a great learning experience..........
6) Thanks
 
Old March 7th, 2009, 09:06 AM
Thearon's Avatar
Wrox Author
 
Join Date: Dec 2003
Posts: 396
Thanks: 0
Thanked 8 Times in 8 Posts
Default

How did you connect to SQL Server Express in the previous chapters?

Thearon
 
Old March 9th, 2009, 11:02 AM
Authorized User
 
Join Date: Jan 2009
Posts: 21
Thanks: 4
Thanked 0 Times in 0 Posts
Default SQLDATAADAPTER CONNECTION

Earlier in the chapters I was able to use sql connections no problem. I was unable to use the wizard to create a data connection. But I found the solution on Google.

DELETE THE SQLEXPRESS FOLDER LOCATED AT THE DEFAULT PATH
(C:\Documents and Settings\username\Local\Settings\Application\Data\ MicroSoft\MicroSoft SQL ServerData\SQLEXPRESS

This allowed me to create connections using the Data Source Wizard an proceed with the project. THANKS





Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 10 (P 367) Connection Problem sookarama BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 1 September 6th, 2006 07:59 AM
automate connection wizard olambe VB How-To 2 May 5th, 2005 03:54 PM
Another chapter 10 question. czambran BOOK: Beginning CSS: Cascading Style Sheets for Web Design ISBN: 978-0-7645-7642-3 4 April 3rd, 2005 09:12 PM
Question on chapter 10 - overriding RobMeade BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003 4 August 12th, 2004 11:56 AM





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