Mike, Sorry I did not specify. We have Universe on unix (hpux to be specific).
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: Monday, April 14, 2008 6:29 PM To: [email protected] Subject: RE: [U2] Reading data from an SQL Server Database from Universe {unclassified} Harold, If your UniVerse server is Windows, it's not too hard at all:- Install the UniVerse ODBC Client from the U2 Clients CD on your server On the server, do to Start > Settings > Control panel > Administrative Tools > Data Sources (ODBC) From the System DSN tab, select Add, choose 'SQL Server', follow the prompts The entry you make in the 'Name' box is the one you put in the uvodbc.config file (instead of "<mysqldb>") If your UniVerse server is *ix, then I think you need a thing called an "ODBC-ODBC Bridge" which will cost you money and which will need configuring. But I'm on Windows, so ... HTH Regards Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold Sent: Tuesday, 15 April 2008 11:43 a.m. To: [email protected] Subject: [U2] Reading data from an SQL Server Database from Universe I am simply trying to read data from a SQL Server database into Universe. It's all supposed to be explained in the document "BASIC SQL Client Interface Guide", but am missing one key point, it seems... One defines the ODBC data source in the uvodbc.config file. According to the documentation the only information one puts into this parameter file are data source name and dbms type. For example: <mysqldb> DBMSTYPE = ODBC are two lines in this file. This says the data source name is 'mysqldb' and it's an ODBC type of database. OKfine. That's it! For sources which are Universe databases, one also enters a service type and host. That makes sense. Well - the SQL Server database I am interested in reading is on another server. WHERE do I specify the name of the server and the database name? Is it even possible in Universe to connect to a SQL Server database on another server? Thanks for any help on this. Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
