Not sure if you have a multi-subnet AG configuration. Maybe this helps: note though, sqlncli11 is OLEDB and doesn't support the multi-subnet failover option. The syntax for a SqlConnection connection string is documented in the SqlConnection.ConnectionString property. Copy 'Persist Security InfoFalse Integrated Securitytrue Initial CatalogNorthwind server (local)' Use the new SqlConnectionStringBuilder to construct valid connection strings at run time. ![]() The following example illustrates a typical connection string. ![]() ![]() How can I know thatI'm trying access this from asp classicMY connection string is above You can use the ConnectionString property to connect to a database. Open the application root Web.config file shown below. Which one are you using and which version?Tara Kizer SQL Server MVP since 2007 For more information see SQL Server Connection Strings for ASP.NET Web Applications. You need to determine if the database driver in use supports it. What's not working is strconview="Provider=sqlncli11 Server=1.2.3.4.5 Database=p Uid=p Pwd=abc ApplicationIntent=ReadOnly" ![]() Is the app using database drivers that support it? Which database driver and which version?ApplicationIntent=ReadOnlyTara Kizer SQL Server MVP since 2007 I set up on sql a Read-Only Routing for an Availability GroupNow I need to connect from my asp script using read onlyit works from sql management studio but i can't get the conection in aspcan anyone advise a working connection string? We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with.
0 Comments
Leave a Reply. |