Re: Connecting to a second instance of SQL

There are no invalid characters. Even so I tried enclosing in square brackets
and still no joy.

Its a puzzle !

Si

"Arnie Rowland" wrote:

Does the Instance Name contain any invalid character, such as '-'?

Try enclosing the instance name in square brackets, e.g.,
[MyServer\MyInstance].

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Simon" <Simon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A5D1AFBD-54F6-4600-A7EA-215AEFD7A1C6@xxxxxxxxxxxxxxxx
Invalid connection.Connectioopen (Invalid Instance())

Cheers

"Kevin3NF" wrote:

Please paste in the exact error message


--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
http://kevin3nf.blogspot.com


"Simon" <Simon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:356739A9-573E-4D7D-AF9B-2B0DA95CEE2E@xxxxxxxxxxxxxxxx
When I try to connect to an external SQL Server via enterprise manager
I
cannot seem to connect to a named instance. In the past this has worked
with
no problem when I do ip\instance. However when I now try I am getting
invalid
instance name. The name I am using is correct. I am connecting from
Enterprise manager to a SQL2000 instance. Any ideas why it doesn`t
connect
?


Si






.

Relevant Pages

  • Re: Nothing Generates for OleDbCommandBuilder
    ... the CommandBuilder to resolve this, possibly by enclosing the fields ... in square brackets. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: a newbie question
    ... but you can use just about any special character in ... your field or table names simply by enclosing the name in square brackets ... Prev by Date: ...
    (microsoft.public.access.adp.sqlserver)
  • Re: a newbie question
    ... but you can use just about any special character in ... > your field or table names simply by enclosing the name in square brackets ... Prev by Date: ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Problem in ODBC Query
    ... Try enclosing the table name with square brackets. ... These are unnecessary for names that do not have an embedded space but mandatory when they do. ...
    (microsoft.public.excel.programming)