paulW
Posts: 24
|
| Posted: 04/15/2009, 10:54 AM |
|
I am using CCS from a dev server, publishing to a prod server, and trying to set up the DB connection to a MSSql server. I had trouble finding a config that would work properly in the editor, and when the pages are viewed in the browser. I finally used a connection string, and that has ALMOST worked out. When the page is viewed, I get
"Database error: Escaping not implemented
ODBC Error
Session halted."
Is this something in the sql server, or a CCS issue?
|
 |
 |
materix
Posts: 161
|
| Posted: 04/16/2009, 7:33 AM |
|
This is an CCS issue concerning odbc-support. But I do not think that you have to use ODBC for connecting to a SQL Server.
|
|
|
|
tru
Posts: 9
|
| Posted: 04/30/2009, 4:04 PM |
|
edit your connection string in web.config to something like this:
<add key="connectionname" value="Provider=SQLNCLI.1;Persist Security Info=False;User ID=sa;Initial Catalog=employee;Data Source=yourservername;User ID=sa;Password=1234567"/>
|
|
|
|
|
