I use ODBC data source to connect vb.net application to MS ACCESS database.When I have to install it in my clients PC,I have to manually make ODBC connection
from(Control Panel ->Administrative Tools->Data source(ODBC)).
Now what I want to do is,include odbc connection string in vb.net code itself so that I dont have to manually create odbc connection in clients PC.Is it possible to do so??
If no,then is there any other alternative?
Thanks in advance.

Not 100% if this answers your question but I wrote this code for a car game in college.

Pass the sql command to the function and it executes on the database it is set up to access.
Hope it helps.

    Public Sub sqlCmd(ByVal SQLText As String)
        Dim retVal As Integer = 0

        Dim myConnection As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=CarGame.accdb")
        myConnection.Open()
        Dim myCommand As OleDbCommand = myConnection.CreateCommand()
        Dim myTrans As OleDbTransaction

        ' Start a local transaction 
        myTrans = myConnection.BeginTransaction(IsolationLevel.ReadCommitted)
        ' Assign transaction object for a pending local transaction  
        myCommand.Connection = myConnection
        myCommand.Transaction = myTrans
        Try
            myCommand.CommandText = SQLText
            retVal = myCommand.ExecuteNonQuery()
            myTrans.Commit()
        Catch er As Exception
            MessageBox.Show(er.Message)
            myTrans.Rollback()
        Finally
            myConnection.Close()
        End Try
        'This sub is a generic routine that allows SQL commands to be sent
    End Sub

Make sure the Database is in the resources folder before exporting as an installable program.

Edited 3 Years Ago by RockJake28: Additional information

This article has been dead for over six months. Start a new discussion instead.