I'm making a OLE DB connection in code and was wondering if anyone
could identify what the syntax errors would be in this just as it is
pasted (I tried putting & _ at the end of the first line and that
only brought up other errors):

New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" & Server.MapPath(~/App_Data/Lowes.mdb) & ";" & _
"Initial Catalog=Assets;Integrated Security=SSPI")


Thanks!!

Hi,
Below code is working perfectly well in my machine:
Dim conn As OleDbConnection = New
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data " & _
"Source=" & Server.MapPath("~/App_Data/Lowes.mdb") & ";" & _
"Initial Catalog=Assets;Integrated Security=SSPI")
--
Hope this helps.
Thanks and Regards.
Manish Bafna.
MCP and MCTS.



"slinky" wrote:

> I'm making a OLE DB connection in code and was wondering if anyone
> could identify what the syntax errors would be in this just as it is
> pasted (I tried putting & _ at the end of the first line and that
> only brought up other errors):
>
> New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=" & Server.MapPath(~/App_Data/Lowes.mdb) & ";" & _
> "Initial Catalog=Assets;Integrated Security=SSPI")
>
>
> Thanks!!
>
>