OLEDBProvider->Provider by UniConnection designer

[FredS]

SVN tells me that provider is being reset to an invalid value by the uniConnection designer:

'SQL Server.Authentication=auWindows'
'InterBase.Role=RDB$ADMIN'
'SQL Server.ForceCreateDatabase=False'
- 'SQL Server.OLEDBProvider=prSQL')
+ 'SQL Server.Provider=prSQL')
Options.KeepDesignConnected = False


When opening the project in XE7 using UniDac 6.0.2:
[Window Title]
Error
[Content]
Error creating form: Error reading uniConShareAudit.SpecificOptions.Strings: "Provider" is not a valid option name for SQL Server UniProvider.
[OK]

[AlexP]

Hello,

We have introduced a check for SpecificOptions and their values. Now, when you try to use a non-existent option, or assign an invalid value, you will receive an error message.
To solve the issue, open your DFM file in the text editor and replace the code

SQL Server.OLEDBProvider=prSQL

with

SQL Server.Provider=prSQL

[FredS]

HI,

OK, but I get the error while opening the project with XE7 and UniDac 6.0.2.
Is "SQL Server.Provider=prSQL" valid for 6.0.2?

Hello,

We have introduced a check for SpecificOptions and their values. Now, when you try to use a non-existent option, or assign an invalid value, you will receive an error message.
To solve the issue, open your DFM file in the text editor and replace the code

SQL Server.OLEDBProvider=prSQL

with

SQL Server.Provider=prSQL

[azyk]

Starting from UniDAC 6.1.3 the Provider option is used instead of OLEDBProvider. However, for backward compatibility, the OLEDBProvider value is supported as well.

So, for projects using UniDAC 6.0.2, the correct value will be:

Code: Select all

SQL Server.OLEDBProvider=prSQL

and starting from UniDAC 6.1.3 - both values will be correct:

Code: Select all

SQL Server.OLEDBProvider=prSQL
SQL Server.Provider=prSQL

[FredS]

and starting from UniDAC 6.1.3 - both values will be correct:

Code: Select all

SQL Server.OLEDBProvider=prSQL
SQL Server.Provider=prSQL

Thanks azyk, however once you open the designer in 6.1.4 it forces the change and breaks 6.0.2. A valid change if 6.1.4 was usable.. but so far I can't create a SQL Server db with it.

Anyhow, will revert that setting to default and make changes Uni version specific in code.

[azyk]

After you open the project form in the designer, UniDAC 6.1.4 automatically replaces the deprecated OLEDBProvider option name with the new one - Provider - in the DFM file. In order for the project to be opened correctly in UniDAC 6.0.2 after this change: in a text editor, open the DFM file, for which you are getting the specified error message, and replace all the entries:

Code: Select all

SQL Server.Provider

with

Code: Select all

SQL Server.OLEDBProvider

After that, the project must open in UniDAC 6.0.2 correctly.