OLEDB Provider database connectivity

[Viswanathan S]

Hi All,

I am using oracle provider in my VB.NET application.

The connection string value in config file is "user
id=myusername;password=mypwd;data source=myservice;"

I read the connection string from config file and add the provider string in
the front of the string". In my machine the Microsoft OLEDB Provider for
oracle works fine if i am adding the string

str = "provider=MSDAORA;" + str like this (or) str = "provider=MSDAORA.1;"
+ str

The string is hotcoded. Is there any different name for provider in MSDAORA?
In my application i used this but in client place it is not working? what is
the problem? and how to rectify it?

If i use the Oracle provider for OLEDB like as below.
"Provider=OraOLEDB.Oracle.1

it is not working in my machine. but is design time if i binds test
connection succeded.


I attached the connection entries in the following sample code:

Dim str As String =
System.Configuration.ConfigurationSettings.AppSettings("ConnectionString")
str = "provider=MSDAORA;" + str
'str = "Provider=OraOLEDB.Oracle.1;" + str
conn = New OleDb.OleDbConnection(str)
conn.Open()

 

[MasterGaurav]

I may not be able to tell the exact issue but here is something to try:

http://www.connectionstrings.com


--
Cheers,
Gaurav Vaish
http://mastergaurav.blogspot.com
http://mastergaurav.org
--------------------------

 

[Paul Clement]

¤ Hi All,
¤
¤ I am using oracle provider in my VB.NET application.
¤
¤ The connection string value in config file is "user
¤ id=myusername;password=mypwd;data source=myservice;"
¤
¤ I read the connection string from config file and add the provider string in
¤ the front of the string". In my machine the Microsoft OLEDB Provider for
¤ oracle works fine if i am adding the string
¤
¤ str = "provider=MSDAORA;" + str like this (or) str = "provider=MSDAORA.1;"
¤ + str
¤
¤ The string is hotcoded. Is there any different name for provider in MSDAORA?
¤ In my application i used this but in client place it is not working? what is
¤ the problem? and how to rectify it?
¤
¤ If i use the Oracle provider for OLEDB like as below.
¤ "Provider=OraOLEDB.Oracle.1
¤
¤ it is not working in my machine. but is design time if i binds test
¤ connection succeded.
¤
¤
¤ I attached the connection entries in the following sample code:
¤
¤ Dim str As String =
¤ System.Configuration.ConfigurationSettings.AppSettings("ConnectionString")
¤ str = "provider=MSDAORA;" + str
¤ 'str = "Provider=OraOLEDB.Oracle.1;" + str
¤ conn = New OleDb.OleDbConnection(str)
¤ conn.Open()
¤

What is the error you are getting?


Paul
~~~~
Microsoft MVP (Visual Basic)