Re: An OLE DB Provider was not specified in the ConnectionString

Tech-Archive recommends: Fix windows errors by optimizing your registry

This is my
Stack Trace:


[ArgumentException: An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.]
System.Data.OleDb.OleDbConnectionString.ValidateParse() +767
System.Data.Common.DBConnectionString..ctor(String connectionString, UdlSupport checkForUdl) +144
System.Data.OleDb.OleDbConnectionString.ParseString(String connectionString) +98
System.Data.OleDb.OleDbConnection.set_ConnectionString(String value) +11
System.Data.OleDb.OleDbConnection..ctor(String connectionString) +158
www.joenewlin.com.Guest.GetDataSource(String sql) in \\xxxxweb\joenewlinxxxx\book.vb:75
www.joexxxx.com.book.BindGrid() in \\xxxxxweb\joenewlinxxxx\book.aspx.vb:85
www.joexxxx.com.book.Page_Load(Object sender, EventArgs e) in \\xxxxxweb\joenewlinxxxx\book.aspx.vb:73
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750



"Paul Clement" <UseAdddressAtEndofMessage@xxxxxxxxxxxxxx> wrote in message news:t46td1tm7f088mua1u8u2k8rot2u8auib2@xxxxxxx:

On Wed, 20 Jul 2005 15:00:11 +0000, "Joe Newlin" <joenewlin@xxxxxxxxxxxxx> wrote:

¤ I am getting an error:  Server Error in '/' Application.  An Ole Db
¤ Provider was not specified in the ConnectionString.  An example would
¤ be, 'Provider=SQLOLEDB.
¤ My Function is this:  Public Function GetDataSource(ByBal sql As String)
¤ As DataView
¤ Dim ds as DataSet
¤ Dim cnn as OleDbConnection
¤ Dim cmd As OleDbDataAdapter
¤ Cnn = New OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;Data
¤ Source=e:\Book.mdb")
¤ Cnn.Open()
¤ Cmd = New OleDbDataAdapter(sql, cnn)
¤
¤ I Get this error even if I comment out the entire function.

On which line of code does the exception occur?


Paul
~~~~
Microsoft MVP (Visual Basic)


.

Relevant Pages

  • Re: An OLE DB Provider was not specified in the ConnectionString
    ... after playing around with this some I have found that when commenting out code or even delete out entire functions or even commands the web site continues to function as if changes have not be made. ... I have check to make sure that changes have been saved to the server and have deleted all cache on the client, ... An OLE DB Provider was not specified in the> ConnectionString. ... An Ole Db>> ¤ Provider was not specified in the ConnectionString. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SqlConnection - Timeout Property is read-only?
    ... that you understand when we talk about a ConnectionString that we mean you ... Those properties that are read/write are listed as "Gets or Sets blah blah ... ¤ THanks but that's a read-only property of the SqlConnection object. ... Try either Connect Timeout or Connection Timeout. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: An OLE DB Provider was not specified in the ConnectionString
    ... get an exception coming from inside it. ... > System.Data.Common.DBConnectionString..ctor(String connectionString, ... >> ¤ Provider was not specified in the ConnectionString. ... >> ¤ Dim cnn as OleDbConnection ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle and ADO and example
    ... ¤ Hello, how can I write records to an Oracle table in VB 6.0. ... connectionstring, how to open the recordset and rs.addnew. ... The AddNew and Update methods are not any different for Oracle than they ... Prev by Date: ...
    (microsoft.public.vb.database.ado)
  • Re: Retrieving Data From Web Database
    ... SQL domain is correct. ... I had a question regarding the RDS tutorial, but I think it may be related ... refer to SQL Server on our web site? ... > ¤ site's database (which points to the SQL Server on our corporate ...
    (microsoft.public.vb.database.ado)