Ah you just reminded me. There is a script that I execute when the Azure instance spins up.
It was a few years ago, but I think I had to use a webrole, not a website, so that I could execute a script to register some email dlls. start /w pkgmgr /iu:IIS-ASP I think websites support classic asp, but webroles don't (by default, but the script enables that). I think I needed to do this so I could register the dll's that were being used for sending emails. Might help you find the answer. Sorry I sound vague, it was some years ago. Didn't have decent access to the source as I was on my phone. cheers, Stephen ________________________________ From: ozdotnet-boun...@ozdotnet.com <ozdotnet-boun...@ozdotnet.com> on behalf of Victor Samson <victor.sam...@gmail.com> Sent: Friday, 18 November 2016 8:13:13 AM To: rand...@voyageconnect.com; ozDotNet Subject: Re: Azure, Classic ASP and the road less traveled Thanks Stephen / Rob, Upon further digging, it seems I might be wrong in thinking the connection string is to blame. I have found this article: https://khailiangtech.wordpress.com/2011/06/03/windows-azure-how-to-enable-classic-asp-support/ It details the need to run a little script to enable Classic ASP. As it's dated 2011 I'm not sure if it still stands today. No harm in trying! Regards, Victor On Thu, Nov 17, 2016 at 6:41 PM, Rob Andrew <rand...@voyageconnect.com<mailto:rand...@voyageconnect.com>> wrote: http://connectionstrings.com/ ? From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> [mailto:ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com>] On Behalf Of Stephen Price Sent: Thursday, 17 November 2016 6:31 PM To: ozDotNet <ozdotnet@ozdotnet.com<mailto:ozdotnet@ozdotnet.com>> Subject: Re: Azure, Classic ASP and the road less traveled I've done that before. Only real gotcha I had was that I had to add primary keys to each table as Azure won't play otherwise. The connection string from memory was in the code. I'll see if I can find the connection string as there are so many different possible strings that it justifies a website for connection strings. cheers, Stephen On 17 Nov. 2016 2:24 pm, Victor Samson <victor.sam...@gmail.com<mailto:victor.sam...@gmail.com>> wrote: Afternoon folks, I am in the process of migrating a Classic ASP + MS-SQL Database from a web host to Azure. The reason is financial. This setup is costing my client an arm every month to keep running. So far I have: * Migrated all website files into an Azure Web App * Migrated database schema + data to Azure SQL Database v12 So far, so good. The final piece of the puzzle is updating the connection string to point to the new database, and this is where I'm stuck. I have tried the supplied ADO.NET<http://ADO.NET> connection string that the Azure Portal so kindly supplies, but it is my understanding that Classic ASP does not support the ADO.NET<http://ADO.NET> driver. Perhaps someone has been down this road before? I have read of people running their Classic ASP in a VM with "SQL Server Native Client" installed can get around this, however, VM is not an option in my case. Any thoughts? Regards, Victor Samson -- M: 0438 036 160 P: (03) 8394 4473 -- M: 0438 036 160 P: (03) 8394 4473
