Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2015-04-22 : 13:49:35
|
| 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? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-04-22 : 13:59:07
|
| Show us your connection string. Is the app using database drivers that support it? Which database driver and which version?ApplicationIntent=ReadOnlyTara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2015-04-23 : 00:21:26
|
| what's not working is strconview="Provider=sqlncli11;Server=1.2.3.4.5;Database=p;Uid=p;Pwd=abc;ApplicationIntent=ReadOnly" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-04-23 : 13:33:21
|
| You need to determine if the database driver in use supports it. Which one are you using and which version?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2015-04-24 : 01:35:24
|
| How can I know thatI'm trying access this from asp classicMY connection string is above |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
sql connection string read only