sql connectionstring for mdb database ?[Resolved]

[Pirate]

Can I use this to connect to mdb database ?? if yes , how ?

myConnection.ConnectionString = "Persist Security Info=False;Integrated  
Security=SSPI;database=northwind;server=mySQLServer;Connect Timeout=30";

edit : I mean where do I have to put the path and password if it's protected ?

Thanks

[Memnoch1207]

The connectionstring above is to SQL Server not an Access mdb database.

try this

For OLEDB Connection

Dim oOleDbConnection As OleDb.OleDbConnection
Dim sConnString As String = _
         "Provider=Microsoft.Jet.OLEDB.4.0;" & _
         "Data Source=C:\myPath\my.mdb;" & _
         "User ID=;" & _
         "Password=" 
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()

For ODBC Connection

Dim oODBCConnection As Odbc.OdbcConnection
Dim sConnString As String = _
         "Driver={Microsoft Access Driver (*.mdb)};" & _
         "Dbq=c:\somepath\mydb.mdb;" & _
         "Uid=;" & _
         "Pwd="
oODBCConnection = New Odbc.OdbcConnection(sConnString)
oODBCConnection.Open()

[Pirate]

I know it's for SQL but I was wondering if I can use SqlConnection object instead of OleDbConnection to open mdb database . Is this possible ???

[Memnoch1207]

AFAIK, no you can't...The OleDbConnection object can be used to with either SQL Server or Access, but SqlConnection object can only be used for SQL Server.

[nswan]

i'll back that up as well. SQLclient namespace stuff can only be used with SQL sever 7 and 2000

[Pirate]

oh damn ,

Thanks guys.