RE: [U2] Connecting SQL server from Universe

2005-07-27 Thread Metherall, Arthur
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

RE: [U2] Connecting SQL server from Universe

2005-07-26 Thread David Jordan
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

RE: [U2] Connecting SQL server from Universe

2005-07-26 Thread Bob Witney
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

RE: [U2] Connecting SQL server from Universe

2005-07-26 Thread Chuck Mongiovi
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

RE: [U2] Connecting SQL server from Universe

2005-07-25 Thread Stuart . Boydell
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