sql server msde: connect database with localhost -- sql server msde

connect database with localhost

Jerry
8/25/2004 8:49:03 PM

sql server msde: Dear All,

I have installed MSDE2000sp3 on a XP Professional with the
default instance name equal to the computer name (e.g
COMP1). I have created a database in the local server. I
want to connect the database by using "localhost" in the
connection string(e.g. jdbc:inetdae7:localhost), but it
was unsuccessful and the name "localhost" seems not to be
recognized.

For testing, I also try to setup a ODBC DSN
with "localhost" as the server but also not success. I can
only use COMP1 to connect. Please tell me how can I

connect database with localhost

afkir
9/2/2004 10:00:18 AM

try

"(localhost)"

[quoted text, click to view]

Re: connect database with localhost

William (Bill) Vaughn
9/2/2004 11:55:22 AM

Nope. "(localhost)" is used for IIS. "(local)" or "." addresses the default
SS instance on the local system. This assumes that you installed MSDE as the
default instance and did not name the instance when it was installed.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server msde group.