Re: VB App on SQL Server 7 machine cannot connect to SQL Server 2000 Database

First, test to see if you can connect to it at all, using another
tool. If the answer is no, then that's the problem. If the answer is
yes, then look at the VB code that you're using. A Profiler trace can
also come in handy here as you troubleshoot what is happening on the
server.

--Mary

On 8 Jan 2007 08:23:10 -0800, hemantpa@xxxxxxxxx wrote:

I have VB app which is on a machine running SQL Server 7.0. This VB App
is not able to make a connection to a Database another server which is
running SQL Server 2000. Can anyone please help me with this issue and
guide me.
.

Relevant Pages

  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Re: Replacing tables in SQL EXPRESS
    ... I tried the whole day to access the Hitchhiker's Guide support site. ... An application error occurred on the server. ... Hitchhiker's Guide to Visual Studio and SQL Server ... SQL EXPRESS database file by tables of the same name in another ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: TNS could not resolve the connect identifier
    ... This database resides on Machine A. ... The Web server is running on Machine B. ... Using tnsping is not as good as using a real connection such as via ... client (note that this is terminology that appears in the 10g R2 ...
    (comp.databases.oracle.server)
Loading