build error for connection string RSS

• • Reply
  

  RManc3

  Member

  85 Points

  19 Posts

  build error for connection string

  Aug 01, 2003 06:12 PM|LINK

  Hi, I get a build error("Unrecognized Escape Sequence") for the following line; this.SqlDbConnection1.ConnectionString = "data source=RAJU\VSdotNET;initial catalog=nwind;integrated security=SSPI;persist security info=False;workstation id=RAJU;packet size=4096"; Can anyone please explain where I am going wrong. Thanks, Raj.Net
• • Reply
  

  joteke

  All-Star

  46284 Points

  6896 Posts

  ASPInsiders

  MVP

  Re: build error for connection string

  Aug 01, 2003 06:18 PM|LINK

  I think because you have RAJU\VSdotNET (\ actually) in the connection string, I believe you would need to use @ in front of the string OR optionally set the data source as RAJU\\VSdotNET . I.e

  this.SqlDbConnection1.ConnectionString =
  @"data source=RAJU\VSdotNET;initial catalog=nwind;integrated security=SSPI;persist security info=False;workstation id=RAJU;packet size=4096";

  Or

  this.SqlDbConnection1.ConnectionString = 
  "data source=RAJU\\VSdotNET;initial catalog=nwind;integrated security=SSPI;persist security info=False;workstation id=RAJU;packet size=4096"; 
  

  \ is used with escape sequences in string so therefore you need to do this so that \V in your datasource name is not mixed with escape sequence.
  Thanks,
  
  Teemu Keiski
  Finland, EU
  
• • Reply
  

  RManc3

  Member

  85 Points

  19 Posts

  Re: build error for connection string

  Aug 01, 2003 06:31 PM|LINK

  Thanks for the reply... I just did that and it runs successfully Thanks, Raj.Net