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 connection string that the Azure Portal
so kindly supplies, but it is my understanding that Classic ASP does not
support the 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

Reply via email to