Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
| Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics 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 28th, 2007, 11:22 PM
Registered User
 
Join Date: Mar 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Having problems connecting VB to SQL

I'm using VB 2005 Professional and SQL 2005 Developer Center w/ SP2, I tried to connect my VB application to a database via "Tools-->Connect to Database..." I change the datasource in "Advanced" setting from .\SQLEXPRESS to .\MSSQLSERVER then browse for the database. It times out and gives me error 25 - connection string is not valid.

I have enabled things like TCP/IP, Named Pipes, Shared Memory and even Start ALL SQL services. I don't know what else i can do at this point. I'm checking settings from inetmgr.exe (IIS) to SQL Server Configuration Manager, still no good. I should be able to at least browse for a database in the "Server Explorer" in VB .NET 2005, but that isn't not working.

My friend's connection work and we can't figure out why and what's causing it on my machines both laptop and desktop. If someone can maybe help me out here I'd greatly appreciate it.




Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems connecting to SQL Server - correct post KW C# 2005 4 September 3rd, 2007 11:53 AM
problems connecting to SQL Server KW C# 2005 0 August 31st, 2007 05:59 PM
Connecting to SQL server 2000 with VB 2005 Express ericgelders Visual Basic 2005 Basics 0 February 20th, 2007 06:15 PM
Problems with connecting tumb SQL Server 2000 1 December 22nd, 2005 04:16 PM
Problems connecting SQL Server from VB 6 mikko SQL Server 2000 6 February 12th, 2004 05:37 AM





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