472,805 Members | 862 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,805 software developers and data experts.

Error Locating Server/Instances Specified (VS to SqlSvr)

I am running VS.net 2005 Express and Sql Server 2005 Express. The DB
and VS are both on the same PC.

I cannot connect to a database from within VS.

In Database Explorer I click Connect To Database to add an existing DB
to the DB Explorer.
In the dialog box I navigate to the MDF of my DB and after I click Test

Connection it takes some 20 seconds before giving the error ..."Error
Locating Server/Instances Specified" (error 26).
However I can access the DB fine using Sql Server Management Studio
I have followed the advice I got from
http://www.datamasker.com/SSE2005_NetworkCfg.htm and added c# to my
solution to read data from the DB via a SqlDataReader. This works
However I still can't get at the DB via my Database Explorer.
One link from the above URL mentions Using Visual Studio 2005 to
Connect to SQL Servers by Name but I do not get the option to connect
to a server. I only get the option to connect to a Sql Server DB file
or an Access DB file.
Have anyone any idea what I need to do to be able to see my DB in the
Database Explorer?
Please post all replies to the newsgroup
Email address no longer valid

Jul 9 '06 #1
0 1174

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: mrwoopey | last post by:
Hi, I am using the example "Authenticate against the Active Directory by Using Forms Authentication and Visual Basic .NET": http://support.microsoft.com/default.aspx?scid=KB;EN-US;326340 ...
by: karim | last post by:
My computer (connected to a domain) is having trouble connecting to the local MSDE when using 'local' or '(local)' as server name. The only way I can connect to server through Visual Studio or DTS...
by: hfk0 | last post by:
Hello, I'm a newbie here and was wondering anyone could help me with this. I have a simple ASP.NET 2 web application running perfectly fine with IIS and SQLServerExpress installed locally on...
by: steve1rm | last post by:
Hello, I have a problem trying to connect a remote sql server. The error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may...
by: snowman | last post by:
I have vb and sql server express 2005 installed locally. I cannot add a data connection in vb express. I keep getting the error "An error has occured while establishing......26 - Error Locating...
by: jobs | last post by:
Works great on my client when I test from vs.net 2005. Howevever, when I deploy to the web server, I get this error: remotely and local from the web server. An error has occurred while...
by: misogsk | last post by:
Hi All, i'm using Sql Server 2005 Standard, IIS 6.0 an Windows 2003 Server. I deployed my project on IIS (Default web site) everything goes well, but i created new web site on IIS called MCSite and...
by: VB Programmer | last post by:
I have an ASP.NET 2.0 site i'm creating in VS.NET. I left it a few days ago, after I had implemented membership, worked on some db tables, etc... Today I go to open the Data Connection to the...
by: =?Utf-8?B?UGV0ZXI=?= | last post by:
I'm trying to get a list of SQL Server Instances thru a VB.NET application. I have tried GetDataSource and SMO. I have also tried using ListSQLSvr.exe from...
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.