Problems with connection string

Problems with connection string

Post by John » Mon, 03 Apr 2000 05:00:00

I have a web application with several ASP pages that access SQL Server.  On
all but one page, I use a certain connection string that works fine.  But on
one page I get the following error:

"Microsoft OLE DB Provider for ODBC Drivers error '8004d00a'

[Microsoft][ODBC SQL Server Driver]Distributed transaction error"

This error occurs on the connection string line, before it executes the
stored procedure, so I'm guessing it is independent of the actual data
command, which comes on a line after the error.  I know the connection
string is the same, because I've pasted it from another ASP page that works
twice (just to make sure).  I'm using Studio 6.0 Enterprise edition and
editing in Interdev 6.  I am working from a remote machine, although the
actual web files are on the web server, of course.

any ideas?




1. Problem with connection string of an Ado object

For first Sorry for my bad english but i'm italian and i'm
a beginner programmer with Vb 6.0
My problem is: how can I realize a dinamic connection with
an adodc object. I want to change the ado connection
string with the proprety "Path" of a file list box" and i
don't how.
Thanks to everyone can help me.
Please can you answers at my e-mail box.

2. Select question

3. dbmssocn problem in connection string

4. Measures

5. Problem with Connection String and Workgroup Information File

6. Latvian company offers OLAP solutions and Data Mining Tools

7. connection string problem using dsn

8. Free SQL Server Tools ?!

9. Change connection string problems

10. Problem opening a query in ACCESS through workgroup connection string

11. Problem while changing the connection string in Data Environment

12. Connection String Problems

13. Problems using SHAPE command when building Database connection string using UDL File