 |  |  |  |  |  |  |  |
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 2005 2008 access account application array arrays basic beginner browser button buttons center checkbox client code convert cuesent data database datagrid datagridview date datetimepicker designer dissertation dissertations dissertationtopic eclipse excel fade filter forms ftp generatetags gridview html images inline input insert intel internet lib listview mobile monitor net objects open panel passingparameters pdf picturebox port position print printing problem read remove save searchvb.net select serial settings shutdown soap sorting sqlserver survey table temperature textbox timer timespan transparency trim update user validation vb vb.net vb.netformclosing()eventpictureboxmessagebox vb2008 vba vbnet visual visualbasic visualbasic.net visualstudio.net visualstudio2008 web webbrowser winforms wpf wrapingcode year
