 |  |  |  |  |  |  |  |
Proper Oracle connection syntax
Please support our VB.NET advertiser: Intel Parallel Studio Home
 |
Dim OraStr As String = "Data Source=Oracle8i;Integrated Security=yes"
OR
dim OraStr As String = "Provider=""MSDAORA.1"";User ID=dev;Data Source=testdb;Password=dev"
I am using oracle8i but that should be provider shouldn't it? the MSDAORA.1 is for the OLEDB so I assume it is wrong also. Any Ideas?
OR
dim OraStr As String = "Provider=""MSDAORA.1"";User ID=dev;Data Source=testdb;Password=dev"
I am using oracle8i but that should be provider shouldn't it? the MSDAORA.1 is for the OLEDB so I assume it is wrong also. Any Ideas?
Here is an awesome site for Connection Strings (under Technology)
MVP
Here is the ODBC Method:
On the MVP site there is a like to an Oracle Add-in for .NET for use...check it out.
MVP
Here is the ODBC Method:
' VB.NET Imports System.Data.Odbc ... Dim oODBCConnection As OdbcConnection Dim sConnString As String = _ "Driver={Microsoft ODBC for Oracle};" & _ "Server=OracleServer.world;" & _ "Uid=myUsername;" & _ "Pwd=myPassword" oODBCConnection = New Odbc.OdbcConnection(sConnString) oODBCConnection.Open()
On the MVP site there is a like to an Oracle Add-in for .NET for use...check it out.
•
•
•
•
Originally Posted by Robert Walker
Dim OraStr As String = "Data Source=Oracle8i;Integrated Security=yes"
OR
dim OraStr As String = "Provider=""MSDAORA.1"";User ID=dev;Data Source=testdb;Password=dev"
I am using oracle8i but that should be provider shouldn't it? the MSDAORA.1 is for the OLEDB so I assume it is wrong also. Any Ideas?
|
Similar Threads
- Trying to use a variable as a range reference in an excel chart (Visual Basic 4 / 5 / 6)
- problem! serious! help pleaase (Visual Basic 4 / 5 / 6)
- beginning oracle (Oracle)
- Connecting C++ to Oracle (C++)
- Oracle Connection (Java)
- odbc administrator (Visual Basic 4 / 5 / 6)
Other Threads in the VB.NET Forum
- Previous Thread: Exception when trying to use a ActiveX control
- Next Thread: sql help
| Thread Tools | Search this Thread |
Latest VB.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for VB.NET
.net .net2008 2008 access advanced application array basic beginner browser button buttons center click client code combo convert cuesent data database datagrid datagridview date datetimepicker designer dissertation dissertations dissertationtopic eclipse excel exists fade filter forms function html images input lib listview map mobile module monitor msaccess net number objects open panel pdf picturebox picturebox2 port position print printing problem read regex remove right-to-left save search serial settings shutdown socket sorting sqldatbase sqlserver survey temperature textbox timer timespan transparency txttoxmlconverter user usercontol validation vb vb.net vb2008 vba vbnet visual visualbasic visualbasic.net visualstudio.net visualstudio2008 web webbrowser winforms winsock wpf wrapingcode xml year
