sql connection

[marvinklein]

i am trying to create a new sql connection

Dim mySqlConnection As New SqlConnection(conString)

what should be the value of conString if my database is C:\myDB.mdb (local)

also, can you create a DataAdapter that is not specific to a single table in the DB?
so that when I say

myDataAdapter.Fill(myDataSet)

it fills myDataSet with the entire DB, not just the single table designated by
Dim DataAdapter As New SqlDataAdapter("SELECT * FROM myTable", conString)


any answers?

[kovan]

sqlconnection is for sql server
you need to use OleDbConnection object.


here is a c# example,

public void openAccess2KDB()
{
	OleDbConnection conn = null;
	string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + GlobalStuff.AccessDBPath;
	conn = new OleDbConnection(strDSN);
	conn.Open();
}

[kovan]

and vb example..
(NOT TESTED)
Dim conn As New Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + GlobalStuff.AccessDBPath)
conn.Open()

[sw_is_great]

if u r using odbc
then "data source = name"