1
Vote

m_dbProviderFactory.CreateConnection() ConnectionString

description

Hi,

After building the source from codeplex, and trying to run the all-in-one against a db created using the SQL files, i have a few problems.

m_dbProviderFactory.CreateConnection() - This doesn't return the connection string in the new connection, so any db access fails.

If i add the connection string in after calling m_dbProviderFactory.CreateConnection() then it works fine.

comments

aaronc wrote Nov 16, 2013 at 7:44 AM

Do you have the two settings below correctly set in the sipsorcery-allinone.exe.config file:

skrusty wrote Nov 16, 2013 at 1:32 PM

Yes, only difference is I am using SQLLinqMSSQL.

The connection string gets set in m_dbConnectionStr by the constructor - but when m_dbProviderFactory.CreateConnection() is called, there's no connection string in the returned object.

aaronc wrote Nov 18, 2013 at 10:19 AM

The connection string for the SQLLinqMSSQL provider should be being set in the SIPAssetPersistorFactory class. It uses the same mechanism as the SQLLinMySQL class so it would be strange if it were not being set.