Trinity

Hello, I am using the collabion wizard to create chart from csv file. I choose csv in the wizard, enter the path to the csv file and press connect. I have an error message "Error in parsing data.Please, check CSV data that you have provided". I tried several csv file but same erro message. Can you help me, please ?

Hello, i am using the collabion wizard to create chart from a SQL database. I enter servername, Database name and press the button connect. But I have error message "could not connect to server. login failed for user xxx\xxx. please check the network conneciotn or make sure database settings are correct.". The user used to connect is dbowner on the SQL database. Can you help me, please ?

thank you I am looking for the next update in that case.

Hi, I try a connection from Excel and can't connect to SQL. It seems to be SQL authentication problem. Thank you for your help, I will have a look with my SQL DB administrator.

Hi, When using URL how should i enter the path to my file ? I access the site from my computer and the csv file is on my D drive, so in the URL i enter D:\france.csv is it the right way of using a path to a file ?

Hi, I check on SQL server and the account from Active Directory is allow to remote connect to the SQL server.

Hello, With header still the same error message. But if I copy/paste the data from the csv file to the wizard and use static Data, it is working.

I tried same connection but using sa account instead of the Active Directory who is dbowner on the database. With SA it is working, should it possible to have it work with the windows active directory account ?

I tried with this files. Rename the file en france.csv (i was not allowed to upload csv file in the forum). France.txt

The server is configured with Mixed mode "SQL server and Windows authentication mode".

Error in parsing data. Please, check CSV data that you have provided. at Collabion.Charts.Business.Providers.CsvDataProvider.RetrieveData() at Collabion.Charts.Business.Providers.CsvDataProvider.Connect() at Collabion.Charts.Business.WebService.Connect(String webPartId, String name) at Collabion.Charts.WebServicePage.OnInit(EventArgs e)

2 errors messages in the logs Provider is not found for WebPart: g_c5af8a87_ada7_4df7_ace7_ebbfba024eb4 and Provider Name: g_c5af8a87_ada7_4df7_ace7_ebbfba024eb4. at Collabion.Charts.Business.ProviderManager.GetProvider(String webPartId, String name) at Collabion.Charts.Business.WebService.GetProviderConfiguration(String webPartId, String name) at Collabion.Charts.WebServicePage.OnInit(EventArgs e) AND Login failed for user 'global\admnga'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Collabion.Charts.Business.Providers.Base.SqlDataProvider.Connect() at Collabion.Charts.Business.WebService.Connect(String webPartId, String name) at Collabion.Charts.WebServicePage.OnInit(EventArgs e)