Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unanswered: ASP.NET connection with ADO.NET SQL Anywhere 9

    I am trying to connect to a SQL Anywhere version 9 database from ASP.NET using ADO. I think that I have the connection string set up properly, but I am receiving and error when trying to open the connection. The error is:

    General error: Internal database error ??? -- transaction rolled back

    Does anyone know what this means. Why a transaction roll back on trying to open a connection?

    My code is printed below. It is in Delphi 8. An ASP.NET application.

    strConn := 'Data Source=ASA 9.0 Sample;Provider=ASAProv.90';
    objConnection := OleDbConnection.Create(strConn);
    objConnection.Open; // Seems to crash here?
    objConnection.Close;

    Thanks in advance for any assistance.

    Ryan

  2. #2
    Join Date
    Feb 2004
    Posts
    2
    Found the problem. I was trying to connect to the database through a
    personal server. This definately does not work. Made it a network server and
    POOF! It worked. From C# and Delphi 8.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •