DataEnviorment in VB cannot connect to MS SQL Server 2000

From: Imry (Imry_at_discussions.microsoft.com)
Date: 06/28/04 

Date: Mon, 28 Jun 2004 08:42:01 -0700

I have a VB 6.0 application that uses MS DataEnviornment in order to connection to an MSQ SQL 7.0 database.
This database was just converted into an SQL Server 2000 database.
After the conversion, that VB application is no longer able to connect to the DB.
Are there any permission or user issues that might be affecting the connection?
(The problem occurs when I try to open a recordset of a command of the connection to the DB).

Relevant Pages

  • DataEnviornment Connection to SQL Server 200
    ... I have a VB 6.0 application that uses MS DataEnviornment in order to connection to an MSQ SQL 7.0 database. ... After the conversion, that VB application is no longer able to connect to the DB. ...
    (microsoft.public.sqlserver.connect)
  • Re: DataEnviorment in VB cannot connect to MS SQL Server 2000
    ... connection to an MSQ SQL 7.0 database. ... > This database was just converted into an SQL Server 2000 database. ... > After the conversion, that VB application is no longer able to connect to ...
    (microsoft.public.sqlserver.programming)
  • Re: DataEnviorment in VB cannot connect to MS SQL Server 2000
    ... It's something about not having enough "select permissions". ... > connection to an MSQ SQL 7.0 database. ... >> After the conversion, that VB application is no longer able to connect to ...
    (microsoft.public.sqlserver.programming)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (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)