Re: Migration between NewEra2.x and NewEra3.0

Posted in 1997

Topics: Stored Procedures & SPL, Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing, Migration, Import/Export & Data Conversion

Ciaran Kelly — Wed, 23 Jul 1997 11:44:38 +0100 — source: Informix-list mailing list archive (1991-1998)

David Bonnici wrote: > >> Compilation is ok. However at execution time, I get a "Database Connect > Failure" error. Here is my main block (which is generated by the WP) > Hi David, Four suggestions :- 1) Can you connect to the ODBC datasource with any other program? 2) NE3 defaults to using an INET connection for it's implicit connection object. To switch to using ODBC edit the registry - HKEY_CURRENT_USER\\Software\\Informix\\Newera\\3.0 and change the Connection key to "ODBC" 3) Cast the implicit connection to an ixSQLConnectODBC object and use driver/browse connect method. 4) There is no logon name and password specified in the ixSQLConnect connect method. HTH, Ciaran email: kellyci@rte.ie > IF ixConn_Connection.getConnectionType() = 1 THEN > CALL ixConn_Connection.connect("wenza") > DISPLAY "wenza" --- Ok.. passes through here > ELSE > CALL ixConn_Connection.connect("data") > END IF > IF ixConn_Connection.getODBCErrorCode() <> ixSQLConnect::SQL_Success > THEN > DISPLAY ixConn_Connection.getODBCErrorCode() --- > DISPLAYS a -1 !?!