End of statement expected error

[momo]

Help please
I am getting this error: BC30205: End of statement expected.

Here is the code:

public shared function GetMsAccessOledbConnection(ByVal dbPath As String,
ByVal dbID As String, ByVal dbPassword As String)
Dim dbConn As OleDbConnection
Dim dbConnStr As String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Da ta
Source={0};User ID={1};Password={2}", dbPath, dbID, dbPassword);
return new OleDbConnection(dbConnStr);
End function

[Norman Yuan]

VB/VB.NET does not use ";" to end a line of code.

"momo" <ma***@seeourweb.com> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...

Help please
I am getting this error: BC30205: End of statement expected.

Here is the code:

public shared function GetMsAccessOledbConnection(ByVal dbPath As String,
ByVal dbID As String, ByVal dbPassword As String)
Dim dbConn As OleDbConnection
Dim dbConnStr As String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Da ta
Source={0};User ID={1};Password={2}", dbPath, dbID, dbPassword);
return new OleDbConnection(dbConnStr);
End function

[Erik Funkenbusch]

On Mon, 20 Mar 2006 16:56:02 -0500, momo wrote:

Help please
I am getting this error: BC30205: End of statement expected.

Here is the code:

public shared function GetMsAccessOledbConnection(ByVal dbPath As String,
ByVal dbID As String, ByVal dbPassword As String)
Dim dbConn As OleDbConnection
Dim dbConnStr As String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Da ta
Source={0};User ID={1};Password={2}", dbPath, dbID, dbPassword);
return new OleDbConnection(dbConnStr);
End function

Several major problems with that code.

First, your fucntion doesn't define a return value type.

Second, the code your using for dbConnStr is invalid. You have to say:

Dim dbConnStr As String = String.Format....