HomeHome Product Discus... Product Discus...SmithCartSmithCartHelp needed for smith cart module installationHelp needed for smith cart module installation
Previous
 
Next
New Post
7/3/2012 6:48 PM
 
Bing Han
No Ranking


Joined: 6/13/2012
Posts: 10

Got below error messages when installing 5.0.0 release with DNN 6.0

  1. The databaseOwner is "dnn60", I have tried many ways and got no luck. Any sugguestion would be appreciated.

 

Created - 01.00.00.SqlDataProvider
Info Executing 01.00.00.SqlDataProvider
Info Start Sql execution: 01.00.00.SqlDataProvider file
Failure ExceptionSystem.ArgumentException: Format of the initialization string does not conform to specification starting at index 0. at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue) at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.SqlClient.SqlConnection..ctor(String connectionString) at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script) at DotNetNuke.Services.Installer.Installers.ScriptInstaller.ExecuteSql(InstallFile scriptFile, Boolean useTransaction) at DotNetNuke.Services.Installer.Installers.ScriptInstaller.InstallScriptFile(InstallFile scriptFile) at DotNetNuke.Services.Installer.Installers.ScriptInstaller.Install()

 
 
New Post
7/3/2012 7:15 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Bing,

Please confirm that you have the following 2 sql connection strings in your web config:

<|connectionStrings|>
<|add name="SiteSqlServer" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=xxxx;User ID=xxxx;Password=xxxx"/|>
<|/connectionStrings|>

<|appSettings|>
<|add key="SiteSqlServer" value="Data Source=.\SQLEXPRESS;Initial Catalog=xxxxcart;User ID=xxxx;Password=xxxxxxxxx"/|>
<|/appSettings|>
 
New Post
7/4/2012 6:18 AM
 
Bing Han
No Ranking


Joined: 6/13/2012
Posts: 10

Thanks Kevin,

I did have those settings in the web.config. and I am using same Initial Catalog in both places.

The database is sql server 2008 R2.
 
New Post
7/4/2012 4:30 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Is this a fresh install of DNN 6.0?

The error appears to be related to the specification of the database connection string(s) in Web.Config. Please check this and if you are still having problems post the following:

1. DNN Version
2. Database - SQL Server or SQL Server Express
3. Connection string definition nodes from Web.Config. There are two connection strings, one under the and the other under .

If you are attempting this setup on shared hosting/production server, be sure to change database passwords to "xxxxx" before posting.

Thanks,
 
New Post
7/5/2012 8:09 AM
 
Bing Han
No Ranking


Joined: 6/13/2012
Posts: 10
Kevin wrote:
Is this a fresh install of DNN 6.0?

The error appears to be related to the specification of the database connection string(s) in Web.Config. Please check this and if you are still having problems post the following:

1. DNN Version
2. Database - SQL Server or SQL Server Express
3. Connection string definition nodes from Web.Config. There are two connection strings, one under the and the other under .

If you are attempting this setup on shared hosting/production server, be sure to change database passwords to "xxxxx" before posting.

Thanks,

DNN : 6.0 (not a fresh install.)

Database : SqlServer 2008 R2

3. web.conf

  <connectionStrings>

             <add connectionString="Data Source=xxx\DNNDB;Initial Catalog=DNN_ENT_dnn60_fresh;User ID=dnn60;Password=xxxx" name="SiteSqlServer" providerName="System.Data.SqlClient" />

</connectionStrings>
<appSettings>
              <add key="SiteSqlServer" value="Data Source=xxx\DNNDB;Initial Catalog=DNN_ENT_dnn60_fresh;User ID=dnn60;password=xxxx;" />
</appSettings>
<data defaultProvider="SqlDataProvider">
         <providers>
                   <clear />
                   <add name="SqlDataProvider" type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider" connectionStringName="SiteSqlServer" upgradeConnectionString="SiteSqlServer" providerPath="~\Providers\DataProviders\SqlDataProvider\" objectQualifier="" databaseOwner="dnn60" />
         </providers>
</data>
 
Progress:
       First of all, I installed smithcart modules successfully with fresh dnn installation with "run as db owner" checked ("dbo" will be the schema name in this case) .  but our current dnn database has a "dnn60" as schema name.
 
        a. The "upgradeConnectionString" was set to "SiteSqlServer" which is a wrong value in our previous web.config. this setting caused the original exception being thrown "ExceptionSystem.Argument Eexception: Format of the initialization string does not conform to specification starting at index 0" 
        b. After I set "upgradeConnectionString"=""  and I resotred my dnn database (no smithcart installation) and did smithcart installation again. got below error messages:
           Those "cannot find"stored procedures exist in my dnn database with schema "dnn60"  such as:  dnn60.Messaging_UpdateMessage
 
          SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot find the object 'Messaging_UpdateMessage', because it does not exist or you do not have permission. Cannot find the object 'CreateStagedTabModule', because it does not exist or you do not have permission. Cannot find the object 'UpdateTabModule', because it does not exist or you do not have permission. Cannot find the object 'Commerce_Orders_PostLog_List', because it does not exist or you do not have permission. Cannot find the object 'GetSearchResultModules', because it does not exist or you do not have permission. Cannot find the object 'GetHtmlTextUser', because it does not exist or you do not have permission. Cannot find the object 'activesocial_Groups_ForumsList', because it does not exist or you do not have permission. Cannot find the object 'AddVendorClassification', because it does not exist or you do not have permission. Cannot find the object 
          
 
New Post
7/5/2012 2:00 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0

Hi Bing,

Sounds like your DNN install may be out of sync. I recommend using the Article found at the following link to create a fresh DNN 6.2 sandbox and install the Cart to test if the you are still experiencing the issue https://www.smith-consulting.com/Foru...

Thanks,
 
New Post
7/5/2012 2:49 PM
 
Bing Han
No Ranking


Joined: 6/13/2012
Posts: 10
Kevin wrote:

Hi Bing,

Sounds like your DNN install may be out of sync. I recommend using the Article found at the following link to create a fresh DNN 6.2 sandbox and install the Cart to test if the you are still experiencing the issue https://www.smith-consulting.com/Foru...

Thanks,

Thanks Kevin,

Installing smithcart with the default schema name "dbo" works fine for me. I am having trouble to install it with non-default schema name like "dnn60".

Is it possible that smithcart installation process uses a default "dbo" instead of databaseOwner value "dnn60" (in my case) at some point?

 
 
New Post
7/5/2012 3:29 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
You should not change dbo because your SQL will be faster since the optimizer doesn't have to lookup the schema. As a best practice, I always add the "dbo." prefix and every db I've worked with has used dbo. Most of the time in SQL it's good to be explicit.

Thanks
 
New Post
7/5/2012 5:42 PM
 
Bing Han
No Ranking


Joined: 6/13/2012
Posts: 10
Kevin wrote:
You should not change dbo because your SQL will be faster since the optimizer doesn't have to lookup the schema. As a best practice, I always add the "dbo." prefix and every db I've worked with has used dbo. Most of the time in SQL it's good to be explicit.

Thanks

Hi Kevin,

Thanks for the advice.

but our current dev,qa and production all have non-default schema name like "non-dbo". I would like to try other options before altering schema name.

Is it possible for you to get information from QA folks to see if my setup is in their testing checklist?

I will do one more testing, will install smithcart 5.0 in a fresh dnn 6 installation (with "run as db owner" unchecked - non default schema ) . I had a problem to install dnn 6 with "run as db owner" unchecked before, but worth give another try. 

 

 

 
 
New Post
7/9/2012 2:40 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0

Hi Bing,

You should find the following link helpful for installing DNN with 'run as dbo owner' unchecked: http://www.dotnetnuke.com/Resources/F...

Thanks,
 
New Post
7/10/2012 8:19 PM
 
Bing Han
No Ranking


Joined: 6/13/2012
Posts: 10
Kevin wrote:

Hi Bing,

You should find the following link helpful for installing DNN with 'run as dbo owner' unchecked: http://www.dotnetnuke.com/Resources/F...

Thanks,

Thanks Kevin, I came across that link too and tried, no luck :-)

Eventually we renamed the schema name from "dnn60" to "dbo" today and we have installed smithcart modules sucessfully.

Thanks again for your quick response and efforts you did for me.

-Bing
 
New Post
7/12/2012 2:23 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Bing,

Thank you for posting back with an update and happy to hear your Cart is now up and running.

Please let us know if we can help you with anything else.

Thanks,
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartHelp needed for smith cart module installationHelp needed for smith cart module installation




Questions? Contact us for answers!

Contact Us!