RE: [U2] Connecting SQL server from Universe
Read or update? Doesn't matter, my experience is using SQL XML on SQL 2K. We use http from UniVerse to update MSSQL with "updategrams" (an MS term). It works well, no need to install anything that wasn't already installed. Works across port 80 &/or 443 through our firewalls. Not as fast as but reasonable performance compared with ODBC et al. Convenience overrides. You need MS SQL 2000 with IIS configured with support for SQL XML. On the UV side we just use 'EXECUTE "LIST ... TOXML" CAPTURING XML.UPDATE.DATA' to generate the XML updategrams but I understand recent versions of UV have improved support for generating XML in basic. There are risks using that method as large amounts of data in the capturing variable could blow your workspace. You can also use IIS SQL XML support to read (XML) data from MSSQL. Regards, Stuart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of "Yang, Songying, JIMS" <[EMAIL PROTECTED]> Sent: Tuesday, 26 July 2005 02:04 To: Subject: [U2] Connecting SQL server from Universe Hello all, We are trying to connect to MSSQL server from Universe Database Server (currently we are using Universe 10.1.7 on Aix 5.2). Doesn't anybody have experiences in that? Thanks, Songying Yang Johnson County Court, KS --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Connecting SQL server from Universe
We use the SQL connect facilities within UniVerse to talk to SQL Server directly. From a UV Basic program we can read and update SQL tables and call SQL stored procedures with little difficulty. Regards David Jordan ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- 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] Connecting SQL server from Universe
We are using OpenLink drivers (downloaded from the web, and with support because they are buggers to install onto aix) to talk to sql thru ODBC and also simple sockets (which we wrote ourselves) to initiate stored procedures The ODBC connections allows full access to the sql databases So you can say use database1 select count(*) from table 1 etc from the basic routines Both work OK and the ODBC allows you to use the Basic SQL functionality which means you can update. delete etc Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Yang, Songying, JIMS Sent: 25 July 2005 17:04 To: u2-users@listserver.u2ug.org Subject: [U2] Connecting SQL server from Universe Hello all, We are trying to connect to MSSQL server from Universe Database Server (currently we are using Universe 10.1.7 on Aix 5.2). Doesn't anybody have experiences in that? Thanks, Songying Yang Johnson County Court, KS --- 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] Connecting SQL server from Universe
> We are trying to connect to MSSQL server from Universe Database Server > (currently we are using Universe 10.1.7 on Aix 5.2). Doesn't anybody I've done it from UV 9.6 using the SQL api: SQLConnect() SQLExecDirect() SQLDisconnect() Etc .. Is there any reason you couldn't use these if you've installed the ODBC drivers under Unix? Contact me privately and I can send you a sample program .. -Chuck --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Connecting SQL server from Universe
We're using Easysoft ODBC-ODBC-Bridge, on our AIX using UniData connecting to MSSQL 2K, for database inquiries. I don't see why it wouldn't work for uniVerse also, you would just need write UVBASIC code to use GCI/BCI? to interface with the ODBC driver. The code is pretty simple, with BCI at least. This might be easier than trying to learn XML, if you don't already know/use it. -Arthur - - - - - - - - - - - - Arthur E. Metherall Sr. Programmer Analyst Courier Corporation - - - - - - - - - - - - -Original Message- Date: Mon, 25 Jul 2005 11:03:44 -0500 From: "Yang, Songying, JIMS" <[EMAIL PROTECTED]> Subject: [U2] Connecting SQL server from Universe Hello all, We are trying to connect to MSSQL server from Universe Database Server (currently we are using Universe 10.1.7 on Aix 5.2). Doesn't anybody have experiences in that? Thanks, Songying Yang Johnson County Court, KS --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/