Hi everyone,

This error what i get when i run the code below
 "An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll"

after this error message i chose "breake" then the cursor indicates to this line with green line

 objConnection.open()

is this error from dll files or sql setting or ...
with using vb.net & sql server 2000
-----------------------------
Imports System.Data
Imports System.Data.OleDb
Public Class Form1
    Inherits System.Windows.Forms.Form
    Dim objConnection As OleDbConnection = New _
    OleDbConnection("Provider=SQLOLEDB.1" & _
    "Data Source =HOMEPC;Initial Catalog=pubs;" & _
"Integradted Security=SSPI;")
    Dim objDataAdapter As New OleDbDataAdapter
    Dim objDataSet As DataSet = New DataSet


 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        ' Set the SelectCommand properties...
        objDataAdapter.SelectCommand = New OleDbCommand
        objDataAdapter.SelectCommand.Connection = objConnection
        objDataAdapter.SelectCommand.CommandText = _
            "SELECT au_lname, au_fname, title, price " & _
            "FROM authors " & _
            "JOIN titleauthor ON authors.au_id = titleauthor.au_id " & _
            "JOIN titles ON titleauthor.title_id = titles.title_id " & _
            "ORDER BY au_lname, au_fname"
        objDataAdapter.SelectCommand.CommandType = CommandType.Text
        objConnection.Open()
        objDataAdapter.SelectCommand = New OleDbCommand
        objDataAdapter.SelectCommand.Connection = objConnection
        objDataAdapter.SelectCommand.CommandText = _
        "SELECT au_lname, au_fname; title, price " & _
        "JOIN titleauthor ON authors.au_id = titlauthor.au_id " & _
        "JOIN titles ON titleauthor.title_id = titles.title_id " & _
        "ORDER BY au_lname,au_fname"
        objDataAdapter.SelectCommand.CommandType = CommandType.Text
        objDataAdapter.SelectCommand.ExecuteNonQuery()
        objDataAdapter.Fill(objDataSet, "authors")
        objConnection.Close()
        objDataAdapter = Nothing
        objConnection = Nothing
        grdAuthorTitles.DataSource = objDataSet
        grdAuthorTitles.DataMember = "authors"
-------------------------------------------------------

Why are you using OleDB with SQL Server?

Thanks for reply
Why i use OleDb with SQl really i dont know
but this code is in the beginning vb.net book

Try using Imports System.Data.SqlClient and changing all OleDB to SQL in your code.

Proper connection string.
http://www.connectionstrings.com/

Hi again,

With this declaration

Dim myConnection As SqlConnection = New _
        SqlConnection("server=HOMEPC;database=pubs;Integra ted Security=SSPI;")
    Dim myDataAdapter As New SqlDataAdapter
    Dim myDataSet As DataSet = New DataSet


 AND THIS IS THE ERROR MSG



An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

Additional information: System error.


When i using sql rather than OleDb,in the OleDb the cursor indicate o
objConnnection.open ()

but with sql the cursor indicate to

myDataAdapter.SelectCommand.ExecuteNonQuery()