Re: IDS 7 -> 11 upgrade problems


They have a .net web service which sits on a Windows 2003 server.  It
couldn't connect at all with CSDK 2.9.  We've installed the latest CSDK
(3.5) instead.

3.5? I thought the latest was 3.00. Anyway, it includes an ADO.Net 2.0
driver. Is the application written in .Net 1.1 or .Net 2.0 (or later)?
If you are using a 1.1 Informix driver, I wouldn't be surprised if it
was buggy connecting to 11.10. The 1.1 driver came out in the 9.3 or
9.4 time period. And it was buggy then. I wouldn't expect it to play
well with an engine that hadn't even come out yet. It seems to me that
the .Net drivers from IBM/Informix have been less used and somewhat
more problematic than other connection technologies. That said, we
used the 1.1 and 2.0 drivers for production applications at my last
employer.

If we point the Web Service at a v7.31 database that we can call it 5000
times without an error.

If we point the Web Service at v11, and call the service 500 times, it
errors 60 times approx.  Each time it errors a connection is left on the
database. The error returned is:

To me, it looks like the error is in the prepare. (That is the part of
the call stack where it starts to call error handling routines.) I
wonder if some new query caching could be involved? Are you seeing any
errors on the server side? Have you turned on the query tracing (or is
that 11.5?) to see if the database is throwing an error to the client?

One other thing comes to mind. There is a cdotnet.sql procedure in the
Client SDK that has to be executed against the sysmaster database. Has
that been done on the new engine?

I don't know that I really helped, but maybe something will lead to a
real solution...

Sean
.

Relevant Pages

  • RE: Exception: permission of type System.Security.Permissions.Sec
    ... Changing to Unsafe resulted in the following error ... I have a test.udl connection wizard thatI test a connection to the database ... ODBC driver need to call some unsafe ... Database, and change "Permission Level" to Unsafe. ...
    (microsoft.public.sqlserver.programming)
  • Re: Syntax error in UPDATE statement.
    ... This is not an issue dealing with your database connection, it is your actual update SQL statement. ... Microsoft OLE DB Provider for ODBC Drivers ... > The following error message comes from the database driver software; ...
    (microsoft.public.frontpage)
  • Re: Syntax error in UPDATE statement.
    ... This is not an issue dealing with your database connection, it is your actual update SQL statement. ... Microsoft OLE DB Provider for ODBC Drivers ... > The following error message comes from the database driver software; ...
    (microsoft.public.frontpage.client)
  • Re: Accessing a Remote Database
    ... > access a MySQL database at my friend's server in another town. ... > the database driver and then connecting, ... For a jdbc connection, ... Suse Linux Professional 8.1 on Athlon 1.1 Ghz 512 Mb ...
    (comp.lang.java.databases)
  • Re: What driver is connecting to my database?
    ... Is it possible to determine the driver / type of connection that is ... connected to the database with ODBC, JDBC, OCI, or any other driver. ... It links the app to the instance. ...
    (comp.databases.oracle.server)