Harold, The data.source in ODBC terms is usually a file that contains connection string information, or it is a connection string. On windows, you can see your data sources by running odbcad32.exe (use start, run, odbcad32.exe).
The data.source, which on Unix would have to be a file, would normally include the following information: - Which ODBC Driver - Which server - Connection info (Port, IP or DNS name, etc...) - User authentication info - Other info On a Unix platform you will need an ODBC environment. There are ODBC driver managers for Unix and there are ODBC drivers that you can connect to directly. Not all databases have Unix ODBC drivers. HTH, -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold Sent: Tuesday, April 15, 2008 9:23 AM To: [email protected] Subject: RE: [U2] Reading data from an SQL Server Database from Universe David: Thanks for your response. We have Universe running on hp's version of unix, "hpux". The MS SQL Server is running on a Windows NT-based server. Here is a simple test to see if one is connecting: >From Universe TCL one is supposed to be able to issue the CONNECT command: CONNECT data.source [options] where "data.source" is the name of the source database, naturally. Can that data.source database be an SQL Server database on another server? If so, then there somewhere needs to be a way to say that it resides on the server 'NT99' or whatever, and the database name on that server is 'MySQLdbName'. Another response mentioned 3rd-party software. Perhaps that is required to make this all work... Harold -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 8:31 AM To: [email protected] Subject: RE: [U2] Reading data from an SQL Server Database from Universe Harold, Can you give your environments as this will make the replies easier and more to the point. What is your Universe running on? What is your "sql" server running on? For my clarification .. you said ... "I am simply trying to read data from a SQL Server database into Universe..." I am getting from this that you want to connect to a server (MS Sql so on windows?) and simply access data from the server. Not the other way around. I just want to be clear about this as some of the replys don't seem to go this way. DSig David Tod Sigafoos SigsSolutions, Inc. -------- Original Message -------- Subject: [U2] Reading data from an SQL Server Database from Universe From: "Oaks, Harold" <[EMAIL PROTECTED]> Date: Mon, April 14, 2008 4:43 pm To: <[email protected]> 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/ ------- 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/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
