connectivity of the db

Hi,
Want to check connectivity from IIS Server to SQL Server but without using
SQL Client .. Is there any way
Thanks
ARRFrom the command prompt
telnet IPAddress 1433
If it returns an error, connectivity can not be established, it fyou get a
blank screen, it means you are conencted. Replace 1433 with the port number
if the port number is not the default.
If
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mark" wrote:
> Hi,
> Want to check connectivity from IIS Server to SQL Server but without using
> SQL Client .. Is there any way
>
> Thanks
> ARR
>
>|||Configure an ODBC DSN and click test.
"Mark" <ajuonline@.yahoo.com> wrote in message
news:Od2b2rRYFHA.3540@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Want to check connectivity from IIS Server to SQL Server but without using
> SQL Client .. Is there any way
>
> Thanks
> ARR
>|||Hi
Just check this one. It might be useful for you
http://msdn.microsoft.com/library/en-us/xmlsql/ac_xml1_8e7t.asp?frame=true
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Mark" wrote:
> Hi,
> Want to check connectivity from IIS Server to SQL Server but without using
> SQL Client .. Is there any way
>
> Thanks
> ARR
>
>|||Thanks for the reply .
Do we get sql server driver in ODBC without installing sql server client
itself ...!
Thanks
Mark
"Danny" <someone@.nowhere.com> wrote in message
news:l9_ke.227$Pm3.128@.trnddc08...
> Configure an ODBC DSN and click test.
>
> "Mark" <ajuonline@.yahoo.com> wrote in message
> news:Od2b2rRYFHA.3540@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> Want to check connectivity from IIS Server to SQL Server but without
>> using SQL Client .. Is there any way
>>
>> Thanks
>> ARR
>|||The SQL Server drivers are part of the OS since (at least) W2K.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mark" <ajuonline@.yahoo.com> wrote in message news:unSAA4aYFHA.3620@.TK2MSFTNGP09.phx.gbl...
> Thanks for the reply .
> Do we get sql server driver in ODBC without installing sql server client itself ...!
> Thanks
> Mark
> "Danny" <someone@.nowhere.com> wrote in message news:l9_ke.227$Pm3.128@.trnddc08...
>> Configure an ODBC DSN and click test.
>>
>> "Mark" <ajuonline@.yahoo.com> wrote in message news:Od2b2rRYFHA.3540@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> Want to check connectivity from IIS Server to SQL Server but without using SQL Client .. Is
>> there any way
>>
>> Thanks
>> ARR
>>
>|||To add to Tibor's response, SQL Server connectivity components are bundled
as part of MDAC (Microsoft Data Access Components).
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Mark" <ajuonline@.yahoo.com> wrote in message
news:unSAA4aYFHA.3620@.TK2MSFTNGP09.phx.gbl...
> Thanks for the reply .
> Do we get sql server driver in ODBC without installing sql server client
> itself ...!
> Thanks
> Mark
> "Danny" <someone@.nowhere.com> wrote in message
> news:l9_ke.227$Pm3.128@.trnddc08...
>> Configure an ODBC DSN and click test.
>>
>> "Mark" <ajuonline@.yahoo.com> wrote in message
>> news:Od2b2rRYFHA.3540@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> Want to check connectivity from IIS Server to SQL Server but without
>> using SQL Client .. Is there any way
>>
>> Thanks
>> ARR
>>
>