isn't this the exact opposite of what was asked ? this explains how to setup uv to sql server , the question was sql server to uv.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Witney Sent: Wednesday, October 19, 2005 03:58 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC Yes We use OpenLink ODBC drivers across to MS SQL Server 2000 No problems at all once you prise the correct driver out of OpenLink This is how you do it ODBC OpenLink Installation The installation of ODBC multi-tier software requires the following steps; Download the following files from the OpenLink website; 1.) Data Source Administrator & Samples(taz)(recommended)Web-based Data Source Administrator & JDBC Samples: ftp://download.openlinksw.com/uda/open52/a5l5adzz.taz 2.) iODBC SDK(taz) (required): ftp://download.openlinksw.com/uda/open52/a5kozzzz.taz 3.) ODBC Client only (taz)(required): ftp://download.openlinksw.com/uda/open52/a5oczzzz.taz 4.) Request Broker (taz)(required): ftp://download.openlinksw.com/uda/open52/a5brzzzz.taz 5.) SQLServer Database agent (taz)(required): ftp://download.openlinksw.com/uda/open52/a5ammzzz.taz 6.) Unix Installation Shell Script (required): ftp://download.openlinksw.com/uda/open52/install.sh Once you have download and place these file in the installation Directory, perform the following steps: a) Run the command below to install the new components in this location: sh install.sh b) Run the following command to set the necessary OpenLink environment variables for this installation: . ./openlink.sh c) Place the OpenLink oplrqb.lic license file in the bin directory of the OpenLink directory. d) Change directory to the 'bin' directory of your installation and run the command: ./oplrqb -fd to run it in the debug mode on your terminal or ./oplrqb -v to run it in detached mode The -fd option should produce output of the following form: OpenLink Request Broker Version 2.41 as of Tue Feb 01 2005 (Release 5.2 cvsid 00076). Compiled for AIX 3 (powerpc-ibm-aix4.3.3.0-32) Copyright (C) OpenLink Software. Registered to OpenLink Internal Use with product serial number opl-internal Issued by OpenLink Data Access Support (UK) This license will expire on Wed Feb 01 18:00:00 2006 GMT oplrqb: using rulebook /dbs6/openlink/32bit/v52/tsuite/tmp/bin/oplrqb.ini oplrqb: bound UDP protocol to 0.0.0.0.60001 oplrqb: bound TCP protocol to 0.0.0.0.5432 oplrqb: using UDP address 192.168.11.114.0 for IPC oplrqb: request broker started by openlink oplrqb: spawning /dbs6/openlink/32bit/v52/tsuite/tmp/bin/w3config/www_sv www_sv +debug www_sv: started http://oplusaix2.usnet.private:8765 oplrqb: started persistent www_sv (pid=30068) oplrqb: rendezvous thread started oplrqb: rendezvous registration SQLServer (oplusaix2) e) Assuming the www_sv persistence service is started successfully you should then be able to access it on the URL specified in the Broker start log above. d) You can then choose to configure a DSN to connection to SQLServer, either via the Admin Assitant interface or manually using the connection parameters oplrqb.ini and odbc.ini. To configure the odbc.ini manually, set the following parameters to; [OpenLink] Driver = /opt/OPENLINK/lib/oplodbc.so ServerType = SQLServer 2000 Username = tlogtest Password = pa55word Database = synopsys Options = -S 172.16.0.34 -P 1434 -V 8.0 FetchBufferSize = 99 ReadOnly = DeferLongFetch = Host = localhost:5000 Description = ODBC sqlserver UseSSL = NoLoginBox = SqlDbmsName = To configure the oplrqb.ini manually, set the following parameters to; [Environment SQLSERVER] FREETDSCONF = /opt/OPENLINK/bin/freetds.conf DSQUERY = SQLSERVER ; Load this section from freetds.conf TDSHOST = sql2 ; Point this to your SQLServer machine TDSPORT = 1434 TDSVER = 2000 CURSOR_SENSITIVITY = LOW ; Set to HIGH after loading oplrvc.sql To run the admin assistance; >From your browser run the following; >http://travellog.exploreworldwide.com:9002/ To test the sqlserver manually, run; /opt/OPENLINK/samples/ODBC/iodbctest You will get the following prompt; iODBC Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0205.0201 Enter ODBC connect string (? shows list): ? Then type OpenLink You should get a SQL> prompt for a successful connection, and you've then connected to the SQL server. Bob -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Cooper, Rudy Sent: 18 October 2005 23:11 To: u2-users@listserver.u2ug.org Subject: [U2] ODBC Has anyone been successful in creating an odbc connection from sqlserver to UV running on a W2k platform ? If so and you don't mind could you give a brief explanation on what you did to get it to work or direct me to a source ? I understand that I can use DTS, but I'm looking to update, delete, insert from sqlserver to UV. Thx, Rudy Rudy Cooper Information Technology Project Technical Lead Sage Publications 2455 Teller Road Thousand Oaks, California 91320 Direct (805) 410-7724 ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
