If your UV is on windows then this can be done as the DSN/drivers will be on the UV server. Whereas on Linux/Unix you need a ODBC driver manager and drivers installed to use the BCI functionality if going to a non-UV database.
> -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Marc A Hilbert > Sent: Thursday, 15 April 2010 2:00 p.m. > 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
