regarding sql server

Oct 22, 2012 at 9:35 AM

I am using sql server 2005, after making the configurations as mentioned in the documentation , I cann't store logs in that tables. pls help me.

where I can put my password into this?

 <connectionStrings>
<add name="HistoryEntities" connectionString="metadata=HistoryEntities.Sql.ssdl|res://*/History.DAL.HistoryEntities.csdl|res://*/History.DAL.HistoryEntities.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=192.168.1.101;Initial Catalog=SquiggleHistory;Integrated Security=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>

Coordinator
Oct 22, 2012 at 9:40 AM

Replace

IntegratedSecurity=True;
with 
User Id=myUsername;Password=myPassword;

Oct 22, 2012 at 10:06 AM
 
thanks for prompt reply.
 
I changed to like this
  <connectionStrings>
<add name="HistoryEntities" connectionString="metadata=HistoryEntities.Sql.ssdl|res://*/History.DAL.HistoryEntities.csdl|res://*/History.DAL.HistoryEntities.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=192.168.1.101;Initial Catalog=SquiggleHistory;IntegratedSecurity=True;User Id=sa;Password=innovations;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>
 
is it update in ths table?
Events
Participants
Sessions
StatusUpdates
under SquiggleHistory database.
 
but NOT updating. Any other change?
Coordinator
Oct 22, 2012 at 10:33 AM

I can see instead of replacing IntegrateSecurity, you simply added username and password. As far as updating is concerned. It will only log history if it is enabled in the cilent. Enable history logging and it will start logging it. Of course you also need to chat with someone to have the history logged.

Oct 22, 2012 at 10:48 AM

  <connectionStrings>
<add name="HistoryEntities" connectionString="metadata=HistoryEntities.Sql.ssdl|res://*/History.DAL.HistoryEntities.csdl|res://*/History.DAL.HistoryEntities.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=192.168.1.101;Initial Catalog=SquiggleHistory;User Id=sa;Password=innovations;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>

Sorry, I changed like this, already ticked Enable history. Where I can see history files, in that tables or some where?

 

Oct 24, 2012 at 5:21 AM

Still now, I can't see data of history in that sql server 2005 tables, pls pls help me.

 

Regards

Jiju

Oct 25, 2012 at 4:45 AM

Dear All,

please please help me regarding sql server log issue.

 

Regards

Jiju Mathew

94478 72867

Coordinator
Oct 25, 2012 at 4:52 AM

Squiggle.exe.config file has a trace section which is commented out. Uncomment it and run squiggle, chat with people and then check out the Squiggle.log file to see if any errors related to logging history are logged.

Oct 25, 2012 at 9:35 AM

Initial lines of log file. pls help me

Erorr occured while logging history.: System.Data.MetadataException: The specified metadata path is not valid. A valid path must be either an existing directory, an existing file with extension '.csdl', '.ssdl', or '.msl', or a URI that identifies an embedded resource.

at System.Data.Metadata.Edm.MetadataArtifactLoader.Create(String path, ExtensionCheck extensionCheck, String validExtension, ICollection`1 uriRegistry, MetadataArtifactAssemblyResolver resolver)

at System.Data.Metadata.Edm.MetadataCache.SplitPaths(String paths)

at System.Data.Common.Utils.Memoizer`2.<>c__DisplayClass2.<Evaluate>b__0()

at System.Data.Common.Utils.Memoizer`2.Result.GetValue()

at System.Data.Common.Utils.Memoizer`2.Evaluate(TArg arg)

at System.Data.EntityClient.EntityConnection.GetMetadataWorkspace(Boolean initializeAllCollections)

at System.Data.Objects.ObjectContext.RetrieveMetadataWorkspaceFromConnection()

at System.Data.Objects.ObjectContext..ctor(EntityConnection connection, Boolean isConnectionConstructor)

at Squiggle.History.HistoryManager.AddStatusUpdate(DateTime stamp, Guid contactId, String contactName, Int32 status) in C:\Users\Hasan\Desktop\squiggle\Squiggle.History\HistoryManager.cs:line 26

Coordinator
Oct 25, 2012 at 9:37 AM

Do you have HistoryEntities.Sql.ssd in Squiggle directory?

Oct 25, 2012 at 9:46 AM

no, History.sdf file only. Squiggle-3.1 Client.zip , I downloaded and unzipped,  please help me.

Coordinator
Oct 25, 2012 at 9:47 AM

Please read the instructions in the documentation very carefully again and follow each step

http://squiggle.codeplex.com/wikipage?title=How%20to%20save%20chat%20history%20in%20SQL%20Server&referringTitle=Documentation

Oct 25, 2012 at 9:59 AM

sorry, I copied that file, then exiting and login again.

Please contents of .log file

Erorr occured while logging history.: System.Data.MetadataException: Unable to load the specified metadata resource.

at System.Data.Metadata.Edm.MetadataArtifactLoaderCompositeResource.LoadResources(String assemblyName, String resourceName, ICollection`1 uriRegistry, MetadataArtifactAssemblyResolver resolver)

at System.Data.Metadata.Edm.MetadataArtifactLoaderCompositeResource.CreateResourceLoader(String path, ExtensionCheck extensionCheck, String validExtension, ICollection`1 uriRegistry, MetadataArtifactAssemblyResolver resolver)

at System.Data.Metadata.Edm.MetadataArtifactLoader.Create(String path, ExtensionCheck extensionCheck, String validExtension, ICollection`1 uriRegistry, MetadataArtifactAssemblyResolver resolver)

at System.Data.Metadata.Edm.MetadataCache.SplitPaths(String paths)

at System.Data.Common.Utils.Memoizer`2.<>c__DisplayClass2.<Evaluate>b__0()

at System.Data.Common.Utils.Memoizer`2.Result.GetValue()

at System.Data.Common.Utils.Memoizer`2.Evaluate(TArg arg)

at System.Data.EntityClient.EntityConnection.GetMetadataWorkspace(Boolean initializeAllCollections)

at

Oct 25, 2012 at 10:41 AM

at Squiggle.History.HistoryManager.AddStatusUpdate(DateTime stamp, Guid contactId, String contactName, Int32 status) in C:\Users\Hasan\Desktop\squiggle\Squiggle.History\HistoryManager.cs:line 26

How this folder comes in log file?

 

 pls help me.

Oct 26, 2012 at 11:10 AM

pls pls help me.

log file:

Erorr occured while logging history.: System.Data.MetadataException: Unable to load the specified metadata resource.

at System.Data.Metadata.Edm.MetadataArtifactLoaderCompositeResource.LoadResources(String assemblyName, String resourceName, ICollection`1 uriRegistry, MetadataArtifactAssemblyResolver resolver)

Squiggle.exe.config :

 

 <connectionStrings>
<add name="HistoryEntities" connectionString="metadata=HistoryEntities.Sql.ssdl|res://*/History.DAL.HistoryEntities.csdl|res://*/History.DAL.HistoryEntities.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=innovations;Initial Catalog=SquiggleHistory;User Id=sa;Password=innovations;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>

Oct 29, 2012 at 4:31 AM

Dear Hasankhan,

 

 Please help me.

Regards

Jiju

Oct 29, 2012 at 10:07 AM

Same issue I am also facing, I am using sql server 2005.
<add name="HistoryEntities" connectionString="metadata=HistoryEntities.Sql.ssdl|res://*/History.DAL.HistoryEntities.csdl|res://*/History.DAL.HistoryEntities.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=innovations;Initial Catalog=SquiggleHistory;User Id=sa;Password=innovations;MultipleActiveResultSets=True&quot;"
providerName="System.Data.EntityClient" />
  </connectionStrings>

log file shows this error - Erorr occured while logging history.: System.Data.MetadataException: Unable to load the specified metadata resource.

History.sql.SSdl - ProviderManifestToken="2008"  pls help me

Coordinator
Oct 29, 2012 at 10:19 AM
Edited Oct 29, 2012 at 10:39 AM

Replace

res://*/

with  

res://Squiggle.History, Version=3.1.6.0, Culture=neutral, PublicKeyToken=null/

See if it helps

Oct 29, 2012 at 10:34 AM

same error with Sql server 2005

Erorr occured while logging history.: System.Data.MetadataException: Unable to load the specified metadata resource.

 

<add name="HistoryEntities" connectionString="metadata=HistoryEntities.Sql.ssdl|res://Squiggle.History/History.DAL.HistoryEntities.csdl|res://Squiggle.History/History.DAL.HistoryEntities.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=innovations;Initial Catalog=SquiggleHistory;User Id=sa;Password=innovations;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>

Oct 30, 2012 at 12:12 PM

I tried with SQl server 2008.

 

<connectionStrings>
<add name="HistoryEntities" connectionString="metadata=HistoryEntities.Sql.ssdl|res://*/History.DAL.HistoryEntities.csdl|res://*/History.DAL.HistoryEntities.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=INNOVATIONS\INNOICT2008;Initial Catalog=SquiggleHistory;User Id=sa;Password=innovations;MultipleActiveResultSets=True&quot;"
providerName="System.Data.EntityClient" />
  </connectionStrings>

 

same error :-   

 

 

Erorr occured while logging history.: System.Data.MetadataException: Unable to load the specified metadata resource.

at System.Data.Metadata.Edm.MetadataArtifactLoaderCompositeResource.LoadResources(String assemblyName, String resourceName, ICollection`1 uriRegistry, MetadataArtifactAssemblyResolver resolver)

at