Connection string error: Un-recognized escape sequence ...

[rahmanjan]

Hi all,

I am trying to connect to a MS-access 2000 database. I have come from VB background. I used OLEdbConnection control and created the following connection string but C# raises the error "Un-recognized escape sequence".
What can go wrong here?

"cnnStr="Provider=Microsoft.Jet.OLEDB.4.0;Password=;User ID=Admin;Data Source=D:\Inetpub\

http://wwwroot\myweb\dblinks.mdb;Mode=Share

Deny None;Extended Properties=;Jet OLEDB:System database=;Jet OLEDB:Registry Path=;Jet OLEDBatabase Password=;Jet OLEDB:Engine Type=5;Jet OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False";"

Do i really need all of this craps anyways?

any comment will be highly appreciated,

raman

 

[tful282]

yamjan
Your connection string does not have to be that long. The escape sequence problem is because your backslashes should be forward slashes-cnnStr="Provider=Microsoft.Jet.OLEDB.4.0;Password=;User ID=Admin;Data Source=D:/Inetpub/

http://wwwroot/myweb/dblinks.mdb"

 

[shildebrand]

I believe your slashes were correct the first time around... you need to prefix your connection string with an @ symbol.

cnnStr=@"Provider=Microsoft.Jet.OLEDB.4.0;Password=;User ID=Admin;Data Source=D:\Inetpub\

http://wwwroot\myweb\dblinks.mdb"