This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 94%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKR%3C/text%3E%3C/svg%3E)
My ASP classic pages are having intermittent issues connecting to my SQL Azure database with error code -2147467259. ASPX pages are working just fine. This problem started happening this week.
An Azure relational database service.
What does you connection strings for your ASP and ASPX pages look like? Intermittent errors are not uncommon in the cloud as there can be network glitches, or you may arrive in the middle of a failover. So it is always a good idea for having redunancy for those situations.
What is the error message that goes with the error code?
Below is my connection string where xxx is redacted data. Most of the time it does not work now. err.number returns -2147467259. This worked perfectly for years until recently.
Set rs = Server.CreateObject("ADODB.RecordSet")
Set cnn=Server.CreateObject("ADODB.Connection")
cnn.open "Provider=SQLNCLI10.1;Server=tcp:xxx.database.windows.net,1433;Database=xxx;User ID=xxx@xxx;Password=xxx;Encrypt=True;Connection Timeout=30;"
I'm glad to hear that you were able to find a solution!
Thanks for asking about the connection string. Copilot said the provider I'm using was deprecated. I replaced it with Driver={ODBC Driver 17 for SQL Server} and this seems to have fixed the issue.