This is exactly what we have done with no middleware on udt on windows, it is called the BCI and is easy to use !
However if your u2 box is on *nix, there is no native mssql driver for *nix so you have to use a bridge. However your code is just the same it is just a configuration issue. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Marc A Hilbert Sent: 15 April 2010 02:53 To: 'U2 Users List' Subject: Re: [U2] Updating SQL database from Universe 10.3 Perhaps I am not understanding some part of the issue, but we regularly update on-line SQL, Oracle or DB2 from UVBasic, using Universe 10.2 running on windows, without any middleware. It was just a question of reading the manuals regarding the steps: - Set up a System DSN - Update uvodbc.config - Test connection with CONNECT - Write the program, taking the following steps: - Allocate the environment (SQLAllocEnv) - Allocate the connection (SQLAllocConnect) - Connect to the DSN (SQLConnect) - Allocate the statement (SQLAllocStmt) - Run the statement (SQLExecDirect) - Free the statement (SQLFreeStmt) - Disconnect (SQLDisconnect) - Free the connection (SQLFreeConnect) - Free the environment (SQLFreeEnv) Regards, Marc -----Mensaje original----- De: [email protected] [mailto:[email protected]] En nombre de John Hester Enviado el: miércoles, 14 de abril de 2010 17:21 Para: U2 Users List Asunto: Re: [U2] Updating SQL database from Universe 10.3 If you need UV to initiate the update (UV is the client, SQL is the server), you're going to need 3rd party middleware to talk to SQL Server. We do this in near real-time (a batch job runs every 3 minutes with updates) from UV to SQL 2005 via OpenLink's ODBC middleware. You'll want to review the UV BCI manual for details on establishing a connection and sending the data from a BASIC program. Initiating the update from SQL Server doesn't require any add'l software. You can use the ODBC connectivity built into Windows. We don't use this in production, although I have used it before to populate Excel spreadsheets. We do have UV acting as a server for JDBC connections in production, though, and the setup on the UV side is the same. You'll want to see the UV ODBC Guide for instructions if you're going this direction. -John -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Aramaies Sent: Wednesday, April 14, 2010 12:13 PM To: [email protected] Subject: [U2] Updating SQL database from Universe 10.3 Good Day, I need to update SQL database/tables from Universe, and I was wondering if anyone has done this in production mode in real-time mode. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
