Developer forum

Hi Aki

We will look into it and get back.

BR Nicolai

Its a database that is converted from DW9 to DW10 but that shouldn't matter?

It also works to connect to the Azure DB from a local solution. 

/Aki 

Hi Aki,

I was unable to reproduce this with a clean application (deployed a new DW10 suite application with a new azure sql database - following the documented steps for setup in azure). Maybe you have some custom functionality which could cause this issue?

1. Ensure that the azure web app is configured correctly with Runtime stack: .NET 8, OS: Windows
2. Check nuget package dependencies. Do you have any dependency on System.Data.SqlClient 4.9.0? Try to downgrade that to System.Data.SqlClient 4.8.6.
3. Check custom functionality (assemblies in /bin folder, add-ins in /Files/System/AddIns/Installed)? Ensure that they all target .NET 8 and check for any System.Data.SqlClient dependency.

/Morten

Hi,

Thanks for your input Morten. 

The stack settings are .NET8. The only reference to System.Data.SqlClient is in the Dynamicweb.Core. 

The two projects in the solution targets .NET8 and we dont have anything in /Files/System/AddIns/Installed.

We get the error during the setup.

>> The stack settings are .NET8.

Are you running this as an App Service? If so, is your OS Windows? You can find it on the overview screen:

Imar

Hi Imar,

Here it is

That looks pretty Windows-y to me :-)

Could it be an old version of System.Data.Client that got deployed somehow? Can you see that file's version number in the app service?

It also seems to be correct.

Hi Aki

Have you checked the database level of the old database? Set it to 150.

Can you install a clean database?

Are you sure you do not have any custom dlls in your /bin from the old solution - that you are using a clean DW10?

BR Nicolai

We'll check the database level. Thanks.

In this case we cannot install a clean DB, but it is upgraded to DW10. 

And in regards of custom DLLs. There is one class library targeting NET8 that is added to new solution for DW10. It has two small helpclasses without any database functionality. 

Regards / Aki 

It is to try to figure out what is wrong. So you need to try to install a clean DB - if that works, we would know it is the DB. Also try to install without any custom DLL - just a totally clean DW installation and see if that works. If that works, we would know you have something in your solution.

BR Nicolai

Yes. We'll try with a clean solution. 

/Aki 

We are up and running with the Azure solution. We could just skip the step with the Database Setup by manually typing the next step in the URL. The database setting are already in the config files. And everything works fine with the same setup that we have been working with. 

Have you tried to do the Datebase Setup and test the connection in that step in a Azure environment. 

/Aki