RE: [U2] connection from UniBasic to a SQL database
Kathy 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/a5ko.taz 3.) ODBC Client only (taz)(required): ftp://download.openlinksw.com/uda/open52/a5oc.taz 4.) Request Broker (taz)(required): ftp://download.openlinksw.com/uda/open52/a5br.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 -vto 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 Vance, Kathy Sent: 18 October 2005 16:52 To: u2-users@listserver.u2ug.org Subject: RE: [U2] connection from UniBasic to a SQL database Hi Bob, I hope I did not miss your reply. We have the problem to make SQL 2000 communicate with Universe 10 or 11 with IBM Universe ODBC driver. Based on its document, this driver seems do not support the SQL server. Could you share your experience on the way of using OpenLink ODBC driver for SQL server? Thanks, Kathy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Gonzalez Sent: Friday, October 14, 2005 12:25 PM To: u2-users
RE: [U2] connection from UniBasic to a SQL database
Hi Bob, I hope I did not miss your reply. We have the problem to make SQL 2000 communicate with Universe 10 or 11 with IBM Universe ODBC driver. Based on its document, this driver seems do not support the SQL server. Could you share your experience on the way of using OpenLink ODBC driver for SQL server? Thanks, Kathy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Gonzalez Sent: Friday, October 14, 2005 12:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] connection from UniBasic to a SQL database Hello Bob. I would like to see a sample of how you do that. You don't have to give away your source, but giving us an ideal of how it works. thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Thursday, October 13, 2005 11:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified} Wendy: We talk to ms sql all the time thru OpenLink ODBC drivers using the BCI It works fine and the only problems we had was with the ODBC driver Have routines that do it if you'd like to look Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of gerry-u2ug Sent: 14 October 2005 01:48 To: u2-users@listserver.u2ug.org Subject: RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified} things are not this simle on unix - 3rd party odbc drivers need to be purchased , installed configured. I have never worked with a client who has gone this route, it never seems to be worth the bother expense. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of HENDERSON MIKE, MR Sent: Thursday, October 13, 2005 06:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified} Wendy -Original Message- From: [EMAIL PROTECTED] On Behalf Of Wendy Smoak Sent: Friday, 14 October 2005 09:10 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [AD] What are you using to develop your web pages? JavaScript? PHP? .Net? From: Symeon Breen [EMAIL PROTECTED] it is easy to read/write mysql from your Unibasic. Really? So far we have not been successful getting a connection from UniBasic to a SQL database. What are you using? (My guess is that you're on Windows.) I've written stuff to read from a SQL database into UniBasic using the BCI. There's no conceptual difference between reading writing, it's just a matter of using a SQL INSERT or MODIFY instead of a SELECT in the string passed to SQL. I do have some doubts about how to set up transactions to allow simultaneous SQL UV updates, but that's functionality we don't need yet. The BCI documentation is sparse and the example code execrable, but it does work and performance is not too bad, either. UV 10.0.15 to MS SQL Server 2000, all on Windows, using the MS SQL Server driver. Mike We're on HP-UX. At the moment I'm reading from Sybase with their JDBC driver then using UniObjects for Java to write records into UniData. It's working fine, but it would be *really* nice to connect directly to Sybase from a UniBasic program. -- Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org 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 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/ __ 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
RE: [U2] connection from UniBasic to a SQL database {Unclassified}
HP-UX on Itanium? I didn't think HP had actually sold any of those! Now I begin to understand your problem, Wendy, it's that you happen to be in a tiny portion of what was already a bit of a niche market. Might be quite hard work finding software that works, especially if you don't want to pay gazillions of dollars. Sorry Mike P.S. I'm sure your friendly local Sun salesdroid would give you a really sharp price on a an AMD Opteron box running Solaris, but maybe that's a rather drastic way of getting an ODBC-ODBC bridge! :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak Sent: Saturday, 15 October 2005 08:35 To: u2-users@listserver.u2ug.org Subject: Re: [U2] connection from UniBasic to a SQL database From: Metherall, Arthur [EMAIL PROTECTED] We're running AIX and have found Easysoft ODBC-ODBC Bridge software to be great! (granted we're only pulling information from MS SQL into UniData, but that's ALL we need it for.) As soon as I hear from someone for whom it works on HP-UX on Itanium, we'll be there. :) -- Wendy --- u2-users mailing list u2-users@listserver.u2ug.org 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] connection from UniBasic to a SQL database
As others have said - we are communicating both ways between UniVerse on AIX (unix) and MS SQL using the BCI and the OpenLink ODBC drivers. As part of the same communication we also send data to Oracle also on AIX - i.e. we are updating two different databases when a change happens in UniVerse. We did need to make some changes when Oracle was upgraded to 9i as regards date processing but apart from that it has been relatively painless. Regards, Sara Burns Sara Burns (SEB) Integration Manager Public Trust Phone: +64 (04) 978 4534 (DDI) Mobile: 027 457 5974 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Information contained in this communication is confidential. If you are not the intended recipient the information should not be used, disclosed, copied or commercialised. The information is not necessarily the views nor the official communication of Public Trust. No guarantee or representation is made that the communication is free of errors, virus or interference. Ask us about our hot home loan rate - 7.90 percent per annum fixed for one year. To find out more, call 0800 371 471. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified}
Wendy: We talk to ms sql all the time thru OpenLink ODBC drivers using the BCI It works fine and the only problems we had was with the ODBC driver Have routines that do it if you'd like to look Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of gerry-u2ug Sent: 14 October 2005 01:48 To: u2-users@listserver.u2ug.org Subject: RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified} things are not this simle on unix - 3rd party odbc drivers need to be purchased , installed configured. I have never worked with a client who has gone this route, it never seems to be worth the bother expense. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of HENDERSON MIKE, MR Sent: Thursday, October 13, 2005 06:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified} Wendy -Original Message- From: [EMAIL PROTECTED] On Behalf Of Wendy Smoak Sent: Friday, 14 October 2005 09:10 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [AD] What are you using to develop your web pages? JavaScript? PHP? .Net? From: Symeon Breen [EMAIL PROTECTED] it is easy to read/write mysql from your Unibasic. Really? So far we have not been successful getting a connection from UniBasic to a SQL database. What are you using? (My guess is that you're on Windows.) I've written stuff to read from a SQL database into UniBasic using the BCI. There's no conceptual difference between reading writing, it's just a matter of using a SQL INSERT or MODIFY instead of a SELECT in the string passed to SQL. I do have some doubts about how to set up transactions to allow simultaneous SQL UV updates, but that's functionality we don't need yet. The BCI documentation is sparse and the example code execrable, but it does work and performance is not too bad, either. UV 10.0.15 to MS SQL Server 2000, all on Windows, using the MS SQL Server driver. Mike We're on HP-UX. At the moment I'm reading from Sybase with their JDBC driver then using UniObjects for Java to write records into UniData. It's working fine, but it would be *really* nice to connect directly to Sybase from a UniBasic program. -- Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org 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 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/ __ 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/
Re: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified}
gerry-u2ug wrote: things are not this simle on unix - 3rd party odbc drivers need to be purchased , installed configured. I have never worked with a client who has gone this route, it never seems to be worth the bother expense. Price shouldn't be a problem with mysql: *MySQL Connector/ODBC* (also known as MyODBC) allows you to connect to a MySQL database server using the ODBC database API on all Microsoft Windows and most Unix platforms, including through such applications and programming environments such as Microsoft Access, Microsoft Excel, and Borland Delphi. Features *Standards compliant* The production-ready version of Connector/ODBC is compliant with the ODBC 2.50 specification, Level 0 (with some Level 1 and 2 features). The stable version, is compliant with the ODBC 3.51 specification, Level 1 (complete Core API and Level 2 features). *Cross-platform* Connector/ODBC is available for Microsoft Windows, as well as many Unix systems (including Linux, Sun Solaris, HP-UX, IBM AIX, and Mac OS X). Downloads, Licensing, and Support Two versions of MySQL Connector/ODBC are available for download: * MySQL Connector/ODBC 3.51 http://dev.mysql.com/downloads/connector/odbc/3.51.html is the production-ready version of the driver, and is available under the GPL. * MySQL Connector/ODBC 2.50 http://dev.mysql.com/downloads/connector/odbc/2.50.html is the old production-ready version of the driver, and is available under the LGPL. MySQL Connectors are available under the MySQL AB dual licensing model. Under this model, users may choose to use MySQL products under the free software/opensource GNU General Public License http://www.mysql.com/company/legal/licensing/opensource-license.html (commonly known as the GPL) or under acommercial license http://www.mysql.com/company/legal/licensing/commercial-license.html. from www.mysql.com/products/connector/odbc -- mats --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified}
MySql is easy - i understand it is perhaps not as easy if you are talking MS sql and your U2 is on unix - as said above third party drivers are required or an odbc bridge ! On 10/14/05, Mats Carlid [EMAIL PROTECTED] wrote: gerry-u2ug wrote: things are not this simle on unix - 3rd party odbc drivers need to be purchased , installed configured. I have never worked with a client who has gone this route, it never seems to be worth the bother expense. Price shouldn't be a problem with mysql: *MySQL Connector/ODBC* (also known as MyODBC) allows you to connect to a MySQL database server using the ODBC database API on all Microsoft Windows and most Unix platforms, including through such applications and programming environments such as Microsoft Access, Microsoft Excel, and Borland Delphi. Features *Standards compliant* The production-ready version of Connector/ODBC is compliant with the ODBC 2.50 specification, Level 0 (with some Level 1 and 2 features). The stable version, is compliant with the ODBC 3.51 specification, Level 1 (complete Core API and Level 2 features). *Cross-platform* Connector/ODBC is available for Microsoft Windows, as well as many Unix systems (including Linux, Sun Solaris, HP-UX, IBM AIX, and Mac OS X). Downloads, Licensing, and Support Two versions of MySQL Connector/ODBC are available for download: * MySQL Connector/ODBC 3.51 http://dev.mysql.com/downloads/connector/odbc/3.51.html is the production-ready version of the driver, and is available under the GPL. * MySQL Connector/ODBC 2.50 http://dev.mysql.com/downloads/connector/odbc/2.50.html is the old production-ready version of the driver, and is available under the LGPL. MySQL Connectors are available under the MySQL AB dual licensing model. Under this model, users may choose to use MySQL products under the free software/opensource GNU General Public License http://www.mysql.com/company/legal/licensing/opensource-license.html (commonly known as the GPL) or under acommercial license http://www.mysql.com/company/legal/licensing/commercial-license.html. from www.mysql.com/products/connector/odbc -- mats --- 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/
RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified}
Bob, I'd like to see those routines, Thanks, Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Thursday, October 13, 2005 11:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified} Wendy: We talk to ms sql all the time thru OpenLink ODBC drivers using the BCI It works fine and the only problems we had was with the ODBC driver Have routines that do it if you'd like to look Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of gerry-u2ug Sent: 14 October 2005 01:48 To: u2-users@listserver.u2ug.org Subject: RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified} things are not this simle on unix - 3rd party odbc drivers need to be purchased , installed configured. I have never worked with a client who has gone this route, it never seems to be worth the bother expense. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of HENDERSON MIKE, MR Sent: Thursday, October 13, 2005 06:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified} Wendy -Original Message- From: [EMAIL PROTECTED] On Behalf Of Wendy Smoak Sent: Friday, 14 October 2005 09:10 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [AD] What are you using to develop your web pages? JavaScript? PHP? .Net? From: Symeon Breen [EMAIL PROTECTED] it is easy to read/write mysql from your Unibasic. Really? So far we have not been successful getting a connection from UniBasic to a SQL database. What are you using? (My guess is that you're on Windows.) I've written stuff to read from a SQL database into UniBasic using the BCI. There's no conceptual difference between reading writing, it's just a matter of using a SQL INSERT or MODIFY instead of a SELECT in the string passed to SQL. I do have some doubts about how to set up transactions to allow simultaneous SQL UV updates, but that's functionality we don't need yet. The BCI documentation is sparse and the example code execrable, but it does work and performance is not too bad, either. UV 10.0.15 to MS SQL Server 2000, all on Windows, using the MS SQL Server driver. Mike We're on HP-UX. At the moment I'm reading from Sybase with their JDBC driver then using UniObjects for Java to write records into UniData. It's working fine, but it would be *really* nice to connect directly to Sybase from a UniBasic program. -- Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org 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 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/ __ 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/
RE: [U2] connection from UniBasic to a SQL database
Hello Bob. I would like to see a sample of how you do that. You don't have to give away your source, but giving us an ideal of how it works. thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Thursday, October 13, 2005 11:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified} Wendy: We talk to ms sql all the time thru OpenLink ODBC drivers using the BCI It works fine and the only problems we had was with the ODBC driver Have routines that do it if you'd like to look Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of gerry-u2ug Sent: 14 October 2005 01:48 To: u2-users@listserver.u2ug.org Subject: RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified} things are not this simle on unix - 3rd party odbc drivers need to be purchased , installed configured. I have never worked with a client who has gone this route, it never seems to be worth the bother expense. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of HENDERSON MIKE, MR Sent: Thursday, October 13, 2005 06:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified} Wendy -Original Message- From: [EMAIL PROTECTED] On Behalf Of Wendy Smoak Sent: Friday, 14 October 2005 09:10 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [AD] What are you using to develop your web pages? JavaScript? PHP? .Net? From: Symeon Breen [EMAIL PROTECTED] it is easy to read/write mysql from your Unibasic. Really? So far we have not been successful getting a connection from UniBasic to a SQL database. What are you using? (My guess is that you're on Windows.) I've written stuff to read from a SQL database into UniBasic using the BCI. There's no conceptual difference between reading writing, it's just a matter of using a SQL INSERT or MODIFY instead of a SELECT in the string passed to SQL. I do have some doubts about how to set up transactions to allow simultaneous SQL UV updates, but that's functionality we don't need yet. The BCI documentation is sparse and the example code execrable, but it does work and performance is not too bad, either. UV 10.0.15 to MS SQL Server 2000, all on Windows, using the MS SQL Server driver. Mike We're on HP-UX. At the moment I'm reading from Sybase with their JDBC driver then using UniObjects for Java to write records into UniData. It's working fine, but it would be *really* nice to connect directly to Sybase from a UniBasic program. -- Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org 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 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/ __ 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] connection from UniBasic to a SQL database
From: HENDERSON MIKE, MR [EMAIL PROTECTED] I've written stuff to read from a SQL database into UniBasic using the BCI. UV 10.0.15 to MS SQL Server 2000, all on Windows, using the MS SQL Server driver. I hear it does work on Windows. On HP-UX, however, no one I know of has found the magic combination of driver manager and driver that actually works. -- Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified}
Wendy, Not sure I cut your original message out of the messages correctly, but here goes. As someone else mentioned for unix you need to 'acquire' 3rd party software in order to access non-unix databases from unix, i.e., MS SQL, Oracle, Sybase, etc. We're running AIX and have found Easysoft ODBC-ODBC Bridge software to be great! (granted we're only pulling information from MS SQL into UniData, but that's ALL we need it for.) Check out their website at www.easysoft.com, their inexpensive especially compared to certain other 3rd parties. It's easy to install and setup. Contact me off list if you have any questions. Hope this is helpful, Arthur Arthur Metherall Courier Corporation -Original Message- From: [EMAIL PROTECTED] On Behalf Of Wendy Smoak Sent: Friday, 14 October 2005 09:10 To: u2-users@listserver.u2ug.org Subject: RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified} We're on HP-UX. At the moment I'm reading from Sybase with their JDBC driver then using UniObjects for Java to write records into UniData. It's working fine, but it would be *really* nice to connect directly to Sybase from a UniBasic program. -- Wendy Smoak --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] connection from UniBasic to a SQL database
From: Metherall, Arthur [EMAIL PROTECTED] We're running AIX and have found Easysoft ODBC-ODBC Bridge software to be great! (granted we're only pulling information from MS SQL into UniData, but that's ALL we need it for.) As soon as I hear from someone for whom it works on HP-UX on Itanium, we'll be there. :) -- Wendy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified}
Wendy -Original Message- From: [EMAIL PROTECTED] On Behalf Of Wendy Smoak Sent: Friday, 14 October 2005 09:10 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [AD] What are you using to develop your web pages? JavaScript? PHP? .Net? From: Symeon Breen [EMAIL PROTECTED] it is easy to read/write mysql from your Unibasic. Really? So far we have not been successful getting a connection from UniBasic to a SQL database. What are you using? (My guess is that you're on Windows.) I've written stuff to read from a SQL database into UniBasic using the BCI. There's no conceptual difference between reading writing, it's just a matter of using a SQL INSERT or MODIFY instead of a SELECT in the string passed to SQL. I do have some doubts about how to set up transactions to allow simultaneous SQL UV updates, but that's functionality we don't need yet. The BCI documentation is sparse and the example code execrable, but it does work and performance is not too bad, either. UV 10.0.15 to MS SQL Server 2000, all on Windows, using the MS SQL Server driver. Mike We're on HP-UX. At the moment I'm reading from Sybase with their JDBC driver then using UniObjects for Java to write records into UniData. It's working fine, but it would be *really* nice to connect directly to Sybase from a UniBasic program. -- Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified}
things are not this simle on unix - 3rd party odbc drivers need to be purchased , installed configured. I have never worked with a client who has gone this route, it never seems to be worth the bother expense. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of HENDERSON MIKE, MR Sent: Thursday, October 13, 2005 06:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified} Wendy -Original Message- From: [EMAIL PROTECTED] On Behalf Of Wendy Smoak Sent: Friday, 14 October 2005 09:10 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [AD] What are you using to develop your web pages? JavaScript? PHP? .Net? From: Symeon Breen [EMAIL PROTECTED] it is easy to read/write mysql from your Unibasic. Really? So far we have not been successful getting a connection from UniBasic to a SQL database. What are you using? (My guess is that you're on Windows.) I've written stuff to read from a SQL database into UniBasic using the BCI. There's no conceptual difference between reading writing, it's just a matter of using a SQL INSERT or MODIFY instead of a SELECT in the string passed to SQL. I do have some doubts about how to set up transactions to allow simultaneous SQL UV updates, but that's functionality we don't need yet. The BCI documentation is sparse and the example code execrable, but it does work and performance is not too bad, either. UV 10.0.15 to MS SQL Server 2000, all on Windows, using the MS SQL Server driver. Mike We're on HP-UX. At the moment I'm reading from Sybase with their JDBC driver then using UniObjects for Java to write records into UniData. It's working fine, but it would be *really* nice to connect directly to Sybase from a UniBasic program. -- Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org 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 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/