Double back slashes in OLE DB connection string
I am looking for clarification on what is happening. My reports are working. I am running SQL 2012 Developer Edition. I am working in SSDT. When I created a shared data source to an Access database file by clicking the Edit button, the connection string that is created has two backslashes at each location. If I delete them and click OK, they are back the next time. I assume this is some sort of escape sequence, but I have never seen this documented anywhere and was curious to know why it was happening. Thanks. Ann Weber
May 26th, 2012 11:45am

This one may help. http://msdn.microsoft.com/en-us/library/ee478730(v=winembedded.60).aspx Regards, Dave Patrick .... Microsoft Certified Professional Microsoft MVP [Windows] Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2012 1:24pm

I assumed it was doing an escape of the backslash like your article states, but this did not happen in previous versions of SQL Server Reporting services, and since your document has to do with Windows CE and the registry, it still does not explain why this is now happening in Reporting Services.Ann Weber
May 26th, 2012 4:13pm

Assuming they are system DSN this would be how they're stored in the windows registry. This may also be a new display "feachure" of 2012 and cosmetic only. If its causing an issue and or not working then that's another issue. Regards, Dave Patrick .... Microsoft Certified Professional Microsoft MVP [Windows] Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2012 4:26pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics