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 October 11th, 2007, 09:24 PM
Registered User
 
Join Date: Oct 2007
Location: Evansville, Indiana, USA.
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Connection - Chapter 9

I never could make the connection to the SQL Server work in Chapter 8. I went ahead and created a new database in SQL and I am able to connect to it from within Visual Studio 2005. The SQL Database is setup using Windows Authentication so there is no User ID or Password. I was able to create the Stored Procedures in the ProjectTimeTracker database from within Visual Studio.

I followed instruction for Section 2 page 195 and Section 5 on 196 to setup for connection to SQL Server when running the Time Tracker application.

Values entered for User ID and Password under the "Settings" tab in the Properties of Time Tracker Project are set to 'Nothing'

The Error Message I get when I test the Time Tracker application is:
"Login failed for user 'Nothing'. The user is not associated with a trusted SQL Server connection."

Yet when I test the connection to the SQL Server 'ProjectTimeTracker" database in Server Explorer in Visual Studio the test connection works.

I am sure that it is something to do with the Windows Authentication of SQL Server, but not sure what code to enter to make connection work.

Thanks in Advance

M. Finch
pgafinch@wowway.com
 
Old October 12th, 2007, 04:25 AM
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

Please search this forum using the key words 'SQL Connection' and use the advanced search feature to restrict your search to this forum only.

You are not the only reader who has run into this problem and there are many who have posted their experiences and resolutions.

Thearon
 
Old October 23rd, 2007, 12:46 AM
Registered User
 
Join Date: Oct 2007
Location: Paranaque, , Philippines.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to norwild
Default

If you are using mssql server 2000.

You can change the Authentication to SQL Server and Windows,
Instead of Windows Only.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 11 Connection Issue justin000 BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 3 August 4th, 2008 06:14 AM
Connection Chapter 11?! workidoo BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 3 July 15th, 2008 04:01 AM
Chapter 16 Sql connection error flashmanTom BOOK: Beginning Visual Basic 2005 ISBN: 978-0-7645-7401-6 1 May 22nd, 2008 05:04 PM





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