RE: Migration between NewEra2.x and NewEra3.0

Hi all >David Bonnici wrote: > >Hi all... > > I need to convert a NewEra v2.x app to NewEra v3. I managed to get > >through the SYSPG migration utility so therefore I have a nice project > >created just for me to compile. > > Compilation is ok. However at execution time, I get a "Database Connect > >Failure" error. > > Note that the ixConn_Connection is defined as being of type > >ixSQLConnect. Should this not be ixSQLConnectINFX ? I am sorry, did not spot that right away, the migration tool, does not seem to convert the connection object to it's correct class. ixSQLConnect is now the base class and ixSQLConnectINFX is the implicit driver class. Trawl through your code, doing a search for ixSQLConnect and replace this with ixSQLconnectINFX - I am refering to variable declarations, instantiations, prepares, opens, closes etc... This should get rid of your problem below, if it does not, mail back to the list and include the code again ,sorry I can't seem to find the original message :) >>S1000 >>-1801 >>FORMS statement error number -1801. >>Multiple-server transaction not supported. >>I set the connectClass to 'implicit' using the WindowPainter and set the >>datasource. I used the same datasource in crystal reports just to check >>if it works and it does. I hope that helps Ciao David > > >david@west.co.za >Senior Software Consultant >The West Solutions Group >Friends help you move...REAL friends help you move bodies! >