oracle connection string

hello experts,
i am using following statement to connect my vb application with oracle.
dim con as new adodb.connection
con.connectionstring="Provider=MSDAORA.1;User Id=scott/toger"
con.open

it is working.
please, i want to know meaning of :
Provider=MSDAORA.1
what is MSDAORA and what is .1 here.
thanks .
soodsandeepAsked:
Who is Participating?
 
assystConnect With a Mentor Commented:
You can also write like

"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=Password;"
0
 
JackOfPHCommented:
MSDAORA means Microsoft OLE DB Provider for Oracle
0
 
kaliyugkaarjunCommented:
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
soodsandeepAuthor Commented:
thanks JackOfPH and kaliyugkaarjun !
but can i write
"provider=Microsoft OLE DB Provider for Oracle;User id=scott/tiger"

and what is .1 in MSDAORA.1?
0
 
deepak_jimsCommented:
it' better u use the GUI package instead of the coe.
u have to create a data environment and then a data source in which u have to
select the OLE connector that u will be going to use . in this case it is " microsoft ole db conncector for oracle" (it is in the bottom of the list provided) . select this and press CONTINUE.

select the data base u want to use from oracle and provide the autentication mode.
after the authentication is done . TEST THE CONNECTION by pressing the button in botton most.
if the connection is OK. THEN continue and check the data source whether u have succeded or not.
also to ensure whether the connection is made or nor check the data source property of the FORM. there u will find some one as the connection string.

hope this help u..............

deepak kumar now in  IIPM
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.