RE: How to check availability of SQL2000 ?

Found out the following:
Trying to create a dataconnection by VB6, no result, same error.
The same with VS.net, no result, same error.

This has to be a server issue, untill..... I tried with FrontPage 2003 via
the wizard to create a dataconnection and ..... succes.

Now I am back: this should be an issue of the clients ??? But what/where ???

So take it all together:
Apps InfoPath2003, VB6, VS.net cannot create a dataconnection to SQL2000 via
the wizards !!
Apps SharePointSites, FrontPage2003 can create !!

Help is appreciated,

Ger.


"Ger Eielts" wrote:

> Hi all, newbie of SQL2000.
>
> Running in LAN SBS2003 with SQL2000 SP3. From a client (InfoPath) I want
> to make a dataconnection to SQL2000, but access is denied.
> How can I check from the client-PC whether a connection is possible with
> SQL2000? SQL2000 is running on the server and when I fill out a form on
> the SharePoint library the application can access SQL2000 on the server,
> so there is a connection.
>
> Is there a telnet function ? Or a DB-ping ??
> Help is appreciated.
>
> gr. Ger.
>
> *** Sent via Developersdex http://www.developersdex.com ***
>
.

Relevant Pages

  • How to check availability of SQL2000 ?
    ... to make a dataconnection to SQL2000, ... How can I check from the client-PC whether a connection is possible with ... SQL2000 is running on the server and when I fill out a form on ... so there is a connection. ...
    (microsoft.public.sqlserver.connect)
  • close connection when form closes/hides?
    ... I tried to check if the connection is open before opening the connection - ... It appears that the dataConnection is no longer in scope whe I come back ... Anyway - What I want to do is close the connection when I hit the closebox ... Bill Kuhn - MCSE, MCP+I ...
    (microsoft.public.sqlserver.ce)