vb到oracle的连接 [英] vb to oracle connectivity

问题描述

plz帮助我实现了vb与oracle之间以及vb与dbf文件之间的连接

实际上，我想从oracle拾取数据并在进行一些修改后转换为dbf格式

这怎么可能

如何从oracle

plz help me in connectivity between vb to oracle and vb to dbf file

actualy i want to pick up data from oracle and convert in to dbf format after some modificition

how this is possible

how to pic up data from oracle

推荐答案

在这里让我对以下问题深有感触:
1)您是否尝试连接Oracle?如果没有，请尝试先连接Oracle.
如果您需要有关连接Oracle的任何帮助.那么Google搜寻便是您方便的选择.
2)您使用什么"SELECT"命令提取数据?在Oracle中是否有任何存储的proc或要使用"SELECT"语句获取数据?
a)如果按存储过程，则尝试从VB调用该proc.再次使用谷歌搜索是您方便的选择.
b)如果选择，然后尝试运行从VB选择.再次使用谷歌搜索是您方便的选择.
3)您是否具有服务器名称，凭据，驱动程序以连接到Oracle. ?
浏览 www.Connectionstrings.com

希望这会有所帮助
--Rahul

Let me deep thought it by couple of question here :
1) Have you tried to connect Oracle ? If not then try to connect Oracle first.
If you need any help regarding to connect Oracle . then Googling is handy option to you.
2) What is you "SELECT " command to extract data ? do you have any stored proc in Oracle or you are going to fetch data using "SELECT " statement ?
a) If By Stored Proc then try to call that proc from VB. Again Googling is handy option to you.
b) If SELECT then try to run select from VB. Again Googling is handy option to you.
3) Do you have Server name , credential , driver to connect to Oracle. ?
Browse www.Connectionstrings.com

Hope this helps
--Rahul

我将从阅读这些内容开始.

Oracle和ADO.NET [ Google:VB.NET DBF格式 [

I would start by having a read of these.

Oracle and ADO.NET[^]

Google: VB.NET DBF format[^]

If you need more help after then please post some code and we''ll try to help you more.

如果您使用的是VB.Net，则可以使用很多DataProviders. .

还有Oracle，

用于标准安全性

oConn.Open; Provider = OraOLEDB.Oracle;"; & _
; Data Source = MyOracleDB;"; & _
;用户ID = myUsername;"; & _
; Password = myPassword";


对于可信连接

oConn.Open; Provider = OraOLEDB.Oracle;"; & _
; Data Source = MyOracleDB;"; & _
;用户ID =/;"; & _
;密码=";

''或

oConn.Open; Provider = OraOLEDB.Oracle;"; & _
; Data Source = MyOracleDB;"; & _
; OSAuthent = 1";

注意:; Data Source =";必须将其设置为所使用的命名方法已知的适当的Net8名称.例如，对于本地命名，它是tnsnames.ora文件中的别名.对于Oracle名称，它是Net8服务名称.

有关更多信息，请参见:适用于OLE DB的Oracle Provider指南

Visual FoxPro的OLE DB提供程序

oConn.Open"Provider = vfpoledb;" & _
数据源= C:\ vfp7 \ Samples \ Data \ myVFPDB.dbc;" & _
模式= ReadWrite |共享拒绝无；" & _
整理顺序=机器;" & _
密码="''"

有关更多信息，请参见: Microsoft OLE DB Provider for视觉FoxPro

注意:Visual FoxPro OLE DB提供程序不是由MDAC 2.x安装的.您必须安装 Visual FoxPro 7.0 才能获得它的OLE DB提供程序.

来源: .NET数据提供程序连接

If you are using VB.Net, there are a lot of DataProviders can be used.

There is also for Oracle,

For Standard Security

oConn.Open ";Provider=OraOLEDB.Oracle;"; & _
";Data Source=MyOracleDB;"; & _
";User Id=myUsername;"; & _
";Password=myPassword";


For a Trusted Connection

oConn.Open ";Provider=OraOLEDB.Oracle;"; & _
";Data Source=MyOracleDB;"; & _
";User Id=/;"; & _
";Password=";

'' Or

oConn.Open ";Provider=OraOLEDB.Oracle;"; & _
";Data Source=MyOracleDB;"; & _
";OSAuthent=1";

Note: ";Data Source="; must be set to the appropriate Net8 name which is known to the naming method in use. For example, for Local Naming, it is the alias in the tnsnames.ora file; for Oracle Names, it is the Net8 Service Name.

For more information, see: Oracle Provider for OLE DB Developer''s Guide

OLE DB Provider for Visual FoxPro

oConn.Open "Provider=vfpoledb;" & _
"Data Source=C:\vfp7\Samples\Data\myVFPDB.dbc;" & _
"Mode=ReadWrite|Share Deny None;" & _
"Collating Sequence=MACHINE;" & _
"Password=''''"

For more information, see: Microsoft OLE DB Provider for Visual FoxPro

Note: The Visual FoxPro OLE DB Provider is NOT installed by MDAC 2.x. You must install Visual FoxPro 7.0 in order to get it''s OLE DB Provider.

Source: .NET Data Provider Connections

这篇关于vb到oracle的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！