Not able to open MSDataShape connection

From: Live_Love_Laugh (OnlineSubscribe_at_yahoo.com)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 10:34:53 -0400

I am trying to test for compatiblity by moving SQL Server database from SQL
7.0 to SQL 2000 and at the same time, the server is being upgraded from
Windows 2000 to Windows 2003 server.

Our DNA based application which was working fine under SQL 7.0 on Windows
2000 server. With SQL2K and Windows 2003 it is not working as expected.

My application uses transaction based COM components hosted under COM+. The
application is not able to connect to the OLEDB MSDataShape provider. The
application hangs when it executes the ADO Connection's Open method with
MsDataShape connection string.

The COM+ environment is on a different machine than the Database Server. We
are using VB6 components and ADO 2.6 SP2 to connect to the database.

Are there any issues with datashape on SQL Server 2000 if components are
running under COM+ as a transaction?

Thanks,
Live_Love_Laugh

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)