OraFAQ Forum: General » connecting oracle in VB

Home » Other » General » connecting oracle in VB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

connecting oracle in VB [message #104392]

Thu, 07 October 2004 07:58

Deepak
Messages: 111
Registered: December 1999

Senior Member

Hii� all

plz help me out in connecting VB with Oracle

Report message to a moderator

Re: connecting oracle in VB [message #104506 is a reply to message #104392]

Wed, 03 November 2004 20:26

Gopi Chand.V
Messages: 1
Registered: November 2004

Junior Member

for connecting oracle in VB, Oracle client service need to be configured on your machine.
You can use ADO to connect oracle in VB. Following is the connection string for the oracle in VB.
"Provider=MSDAORA.1;Password=manager;User ID=system;Data Source=btdbv4;Persist Security Info=True"

Report message to a moderator

Re: connecting oracle in VB [message #104863 is a reply to message #104392]

Wed, 16 February 2005 00:02

A.Paul
Messages: 1
Registered: February 2005

Junior Member

Sir,
i cannot connect oracle to visual basic .
Please suggest steps to carry out these.

Report message to a moderator

Re: connecting oracle in VB [message #104874 is a reply to message #104392]

Wed, 16 February 2005 04:03

Surendra Mishra
Messages: 1
Registered: February 2005

Junior Member

Mr Animesh,
U need to first configure ... by adding Data Source Name from Control Panel.....then Add Activex Data Control object to ur project by selecting Project> Component>Microsoft ADO control 6.0......then in properties of ADODC ... do the following...Select.... Use Data Source Name... and click on list box and select your datasource name...example may be Oratest, etc..,
Password: type Oracle User name and password
in record source : write Select * from

then specify the datasource and datafield properties for ur text box and run the project...
thats it..

U can also do wo using ADODC Control...by coding first u do this then mail...if u wanna do by coding too...
bye

Report message to a moderator

Re: Error connecting oracle in VB with adodc [message #109624 is a reply to message #104874]

Sun, 27 February 2005 06:55

Temp
Messages: 1
Registered: February 2005

Junior Member

when i place a adodc control on my form in vb6 and then provide the username/password details and then establish a connection with oracle and the connection is succeeded .

But when i try to bound a text field with that control(adodc) and click in the data source property of that text box then the error messge comes

ORA00942: table or view does not exist
and then
error loading formname.frm see formname.log for details

But this is the problem only in that project only.
When i open a new project it connection works fine.

what should i do

Its urgent

Report message to a moderator

Previous Topic:	Which is Worth ORACLE or .NET???????
Next Topic:	ORA 1036 - Oracle 8

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Mar 31 10:12:01 CDT 2023