INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I always seem to find what I need in previous threads without starting my own. I have started a couple but that's it..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > EAI Distributed/Component Programming > Microsoft: Microsoft Transaction Server (MTS) Forum

Unable to Connect to DSN: Error -2147168246

Read More Threads Like This One

RevsEd (Programmer)

11 Jul 02 5:37

Hi,

can anybody help? I've just installed my application
on a client's server and am getting the following
error:

Unable to connect to DSN: DsnName
Error -2147168246, [Microsoft][ODBC SQL Server Driver]
Distributed Transaction Error

Basically, the set up is...

Windows 2000 Server (SP2) running SQL 7 - this is also running Active Directory. This holds the database.

Windows NT4 SP6a. Transaction Server. This has the Option Pack installed and is running the Component (VB6 dll).

Windows 98/NT/2000 Clients. Running exe and interface dll to MTS.

When we go to access the program I get the above error. I can see that my transaction is running (through the MMC console) and can see the active transaction count increase etc. I know that the package is running then, it just appears to have a problem finding the database. The DSN's are okay and test fine.

Any help on this subject greatly appreciated or if further info might help please shout

Darren

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft: Microsoft Transaction Server (MTS)