Wrox Programmer Forums
|
Visual Basic 2008 Essentials If you are new to Visual Basic programming with version 2008, this is the place to start your questions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Basic 2008 Essentials 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 July 13th, 2008, 04:19 PM
Registered User
 
Join Date: Jul 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Connection Strings

I defined a simple DB using Visual Studio 2008 Express.

I tried all kinds of connection strings, the latest being:
"server=(local); Database=C:\CoveredCallsDev\TestConnection\TestCon nection\Database1.sdf; Integrated Security = SSPI"

I get an "provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server".

I went to the SQL Server Config Manager. I enabled Named Pipes and TCP/IP. Rebooted the system. Stopped and restarted the services.

Same Error

I'm stumped!!!

Fletch



 
Old July 14th, 2008, 09:42 AM
Registered User
 
Join Date: Jul 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Some progress. I added the local server instance name (server=localhost\SQLExpress), and it can now find the server. Now my problem is "Login failed for 'Fletchers-PC\Fletchers'". I have tried a UID and PW. I have tried Trusted_COnnection = Yes ... and a bunch of other things!






Similar Threads
Thread Thread Starter Forum Replies Last Post
Securing connection strings haines ASP.NET 2.0 Basics 1 March 2nd, 2008 04:28 PM
Using Connection Strings - App.config testsubject Visual Studio 2005 1 July 16th, 2007 01:08 AM
Connection Strings WillyWonker BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003 3 January 25th, 2005 10:40 AM
Connection Strings hcweb Classic ASP Basics 6 September 23rd, 2004 03:29 AM
Multiple DSN's using connection strings hcweb Classic ASP Basics 1 February 23rd, 2004 02:42 AM





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