Trouble with SQLConn string

[vujjeni]

Can any one tell me what the connection string for a SQL connection should be for :--

Dim dbconn As New SqlConnection _("DataSource=C:\PROJECTS\GraphicsProject.mdb")

I am working on a standalone computer and do not know the exact name of the sql server. Do I need this and if so, how do i find it ?

Thanks a million.

[Lunatic3]

I think you need an OleDB connection instead of SqlConnection.

[Pirate]

Here it's highlighted in red . http://www.sitepoint.com/article/1005/2 too lazy to copy it here . lol

[vujjeni]

Thanks for your replies.
I have decided to go with OledbConn object for now.
I am using it for access database so I am not sure if SQLConn works there. I have a problem with oleDBDataAdapter though..when I use its fill method I keep getting this error :

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll

This was the reason why I thought of switching to SQLConnection.
Appreciate your help.

[Pirate]

This is what I always use . If your database isn't password-protected then leave MyPassword variable set to Nothing otherwise , you can type it there .

Public Shared MyPath As String = Application.StartupPath & "\AppDb.mdb"
    Public Shared MyPassword As String = Nothing
    Public Shared MyConnection As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & MyPath & ";Jet OLEDB:Database Password=" & MyPassword)

[Pirate]

aah , I hate this . Just replace that laughing face with : and D letter .