如何将SQL Server数据库与Universe Basic连接 [英] How to connect SQL Server Database with Universe Basic

问题描述

如何使用Universe Basic代码连接Sql Server数据库以及如何使用Universe Basic执行选择，插入和更新操作.请提供示例代码.

在此先感谢

How to connect Sql Server database using Universe Basic Code and to perform Select, Insert and update operation using Universe Basic. Please provide me sample code.

Thanks in Advance

推荐答案

Step 1: Open Universe Shell prompt.

step 2:
 Add connection string in config file which resides in  C:\U2\UV/uvodbc.config
 as

     <stud>
     DBMSTYPE = ODBC
     network = LAN
     service = ABC\SQLEXPRESS
     host = localhost

Step 3: enter command "CONNECT stud" in Universe Shell prompt.

  Now Shell propt will ask for
     Enter username for connecting to 'stud' DBMS [DOMAIN_Name\User_name]:
     Enter password for DOMAIN_Name\User_name:
 (Press enter if it is windows authentication)

Step 4: If SQLState = 00000 then data source connected successfully.

Step 5: Enter SQL Queries.

Step 6: To exit enter ".q" and press "ENTER"

如果您指的是U2服务器，则可以使用ODBC.例如: http://www.easysoft.com/applications/ibm-universe-unidata/odbc .html [^ ]

If you''re referring to U2 servers, you could use ODBC. For example: http://www.easysoft.com/applications/ibm-universe-unidata/odbc.html[^]

这篇关于如何将SQL Server数据库与Universe Basic连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！