![]() ![]() Open the application root Web.config file shown below. Not sure if you have a multi-subnet AG configuration. For more information see SQL Server Connection Strings for ASP.NET Web Applications. ![]() Maybe this helps: note though, sqlncli11 is OLEDB and doesn't support the multi-subnet failover option. ![]() How can I know thatI'm trying access this from asp classicMY connection string is above If it is an instance you need to specify the servername\instance name. You need to specify the following: Driver - this is the driver to connect to SQL Server ODBC Driver 17 for SQL Server Server - is the SQL Server name. For an ODBC database connection, you use the ODBC driver for SQL Server. The following shows how to connect using ODBC. Which one are you using and which version?Tara Kizer SQL Server MVP since 2007 ODBC Database Connection String Examples for SQL Server. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |