Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • 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.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

ODBC Error from a component running inside MTS

ODBC Error from a component running inside MTS

ODBC Error from a component running inside MTS



 What I've done ?
 - I've developed an MTS component that open a connection
 to a database and execute a simple statment ( Insert Into etc... )
 - I've created two System DSN, one for a Informix 7.31.UC5
 and another for Informix 9.20.

 What I'm trying to do ?
 - I'm trying to execute this -> cnn.open "DSN=IFX920"
 What his happening ?
 - I get this error :
 err.Description : No such interface supported
 err.Source :  Provider
 err.Number - vbObjectError : -245758

 What I've done ?
 - I've already tryed the same thing with the component
 outside of MTS and everything works fine, I mean the connection
 it's establihed.
 - I've use the same component in the MTS enviroment but
 with the follwing line -> cnn.open "DNS=IFX731" and
 everything works fine.

 What I'm asking ?
 Does anyone know what has to be made for a component inside MTS
 can establish a connection to a 9.20 Informix Server ?

 Tanks for further help,
 Hugo Leitão

RE: ODBC Error from a component running inside MTS

The server has to be configured to support transactions. If it is not correctly configured you will get the interface not supported error. There should be some Info in the manuals if you search for XA (not sure about this).

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

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! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close