ODBC Error

Hi All,
I am getting the following error message when I am trying to connect to SQL 2000 Server from SQL 7 Server using BCP/OSQL/ISQL etc., Can any one help me in fixing this problem.
NULL
COULD NOT CONNECT TO SQL SERVER
NULL
SQLState: 08001 Native Error: 6
Info. Message: [Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.
NULL
SQLState: 01000 Native Error: 53
Info. Message: [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile()).
Thanks & Regards
Balaji Prabhu.TBalaji,
What is the respective OS?Do you have only 'Named pipes' enabled?
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Balaji Prabhu.T" <Balaji Prabhu.T@.discussions.microsoft.com> wrote in
message news:C15C3280-F0A5-418B-912B-018EE518AF14@.microsoft.com...
> Hi All,
> I am getting the following error message when I am trying to connect to
SQL 2000 Server from SQL 7 Server using BCP/OSQL/ISQL etc., Can any one help
me in fixing this problem.
> NULL
> COULD NOT CONNECT TO SQL SERVER
> NULL
> SQLState: 08001 Native Error: 6
> Info. Message: [Microsoft][ODBC SQL Server Driver][Named Pipes]Specified
SQL server not found.
> NULL
> SQLState: 01000 Native Error: 53
> Info. Message: [Microsoft][ODBC SQL Server Driver][Named
Pipes]ConnectionOpen (CreateFile()).
> Thanks & Regards
> Balaji Prabhu.T
>

Obtain the sql server properties by code...

Hi,
a need to make a report wich contains the most of properties o an instance o
SQL Server 2000. The same information that appears on the SQL Server
Properties in the Enterprise Manager.
I have 25 servers and I wonder if I can get that information by a
Transact.SQL Server script. I try to do that and I got some information but
other like autentication mode, startup service account, audit level I can′t
.
thanks in advance...
ChevyThose settings are in the registry. You will have to get then with
xp_regread.
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/.../1/Default.aspx
"Chevy" <Chevy@.discussions.microsoft.com> wrote in message
news:230B88E2-13EE-4E33-84D5-D8FD01348B45@.microsoft.com...
> Hi,
> a need to make a report wich contains the most of properties o an instance
> o
> SQL Server 2000. The same information that appears on the SQL Server
> Properties in the Enterprise Manager.
> I have 25 servers and I wonder if I can get that information by a
> Transact.SQL Server script. I try to do that and I got some information
> but
> other like autentication mode, startup service account, audit level I
> can′t.
> thanks in advance...
> --
> Chevy|||Chevy
http://dimantdatabasesolutions.blog...er.ht
ml
"Chevy" <Chevy@.discussions.microsoft.com> wrote in message
news:230B88E2-13EE-4E33-84D5-D8FD01348B45@.microsoft.com...
> Hi,
> a need to make a report wich contains the most of properties o an instance
> o
> SQL Server 2000. The same information that appears on the SQL Server
> Properties in the Enterprise Manager.
> I have 25 servers and I wonder if I can get that information by a
> Transact.SQL Server script. I try to do that and I got some information
> but
> other like autentication mode, startup service account, audit level I
> cant.
> thanks in advance...
> --
> Chevy

Obtain the sql server properties by code...

Hi,
a need to make a report wich contains the most of properties o an instance o
SQL Server 2000. The same information that appears on the SQL Server
Properties in the Enterprise Manager.
I have 25 servers and I wonder if I can get that information by a
Transact.SQL Server script. I try to do that and I got some information but
other like autentication mode, startup service account, audit level I can′t.
thanks in advance...
Chevy
Those settings are in the registry. You will have to get then with
xp_regread.
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Chevy" <Chevy@.discussions.microsoft.com> wrote in message
news:230B88E2-13EE-4E33-84D5-D8FD01348B45@.microsoft.com...
> Hi,
> a need to make a report wich contains the most of properties o an instance
> o
> SQL Server 2000. The same information that appears on the SQL Server
> Properties in the Enterprise Manager.
> I have 25 servers and I wonder if I can get that information by a
> Transact.SQL Server script. I try to do that and I got some information
> but
> other like autentication mode, startup service account, audit level I
> can′t.
> thanks in advance...
> --
> Chevy
|||Chevy
http://dimantdatabasesolutions.blogspot.com/2007/04/whats-version-of-sql-server.html
"Chevy" <Chevy@.discussions.microsoft.com> wrote in message
news:230B88E2-13EE-4E33-84D5-D8FD01348B45@.microsoft.com...
> Hi,
> a need to make a report wich contains the most of properties o an instance
> o
> SQL Server 2000. The same information that appears on the SQL Server
> Properties in the Enterprise Manager.
> I have 25 servers and I wonder if I can get that information by a
> Transact.SQL Server script. I try to do that and I got some information
> but
> other like autentication mode, startup service account, audit level I
> cant.
> thanks in advance...
> --
> Chevy