VB与orcale数据库连接
请教一下大家VB与orcale数据库怎么样连接(用代码),
还有我在网上查了一下好象要安装orcale客户端,是否可以不用安装orcale客户端也能连接
最好能给出步骤和连接字符和说明
说明:我是连接远程orcale数据库。
[解决办法]
'需要安装oracle客户端dim conn as new adodb.connectionWith conn If .State = adStateOpen Then .Close .CursorLocation = adUseClient .ConnectionString = " Provider=OraOLEDB.Oracle;" _ & " Password=登录密码;" _ & " User ID=登录账号;" _ & " Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) " _ & " (HOST =服务器名)(PORT=1521)))" _ & " (CONNECT_DATA=(SERVICE_NAME=数据库名)));" _ & " Persist Security Info=True " .CommandTimeout = 0 .OpenEnd With