ODBC Database Command | Supporting Task

jitu2110 — Thu, 25 May 2017 14:01:23 GMT

Hi,

i am trying to execute a SQL Command throw QMC -> Supporting Task .-> Database Command

In Connection String i am giving below mention value

"ODBC CONNECT TO <DATABASE NAME>(XUserId is <USERID>, XPassword is <PASSWORD>)"

in Database Command there is simple sql command, i am getting below mention error.

(2017-05-25 09:51:04) Information: Starting task 'Copy of TestDatabase'. Id:e385c08d-1432-48c0-9585-0cacf3929f56. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

(2017-05-25 09:51:04) Information: Entering Task Execution.

(2017-05-25 09:51:04) Information: ClusterID=1

(2017-05-25 09:51:04) Information: QDSID=a8c6155e-7112-ac3c-858d-7d7675394be0

(2017-05-25 09:51:04) Information: TaskID=e385c08d-1432-48c0-9585-0cacf3929f56

(2017-05-25 09:51:04) Information: MaxRunTime=1.00:00:00

(2017-05-25 09:51:04) Information: MachineName=*****************

(2017-05-25 09:51:04) Information: Max attempts:1

(2017-05-25 09:51:04) Information: Current Attempt=0

(2017-05-25 09:51:04) Information: Task Dependencies are OK

(2017-05-25 09:51:05) Error: The task "Copy of TestDatabase" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task failed ---> System.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 QDSMain.SQLTask.ExecuteSqlClient(Int32 commandTimeout) || at QDSMain.SQLTask.ExecuteSqlThread(ILogBucket logBucket, TaskResult currentTaskResult) || --- End of inner exception stack trace --- || at QDSMain.SQLTask.Execute(TaskResult taskResult) || at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2017-05-25 09:51:05) Information: Task Execute Duration=00:00:01.0156315

(2017-05-25 09:51:05) Information: TaskResult.status=Finished

(2017-05-25 09:51:05) Information: Notifying all triggers of new state:FinishedWithErrors

(2017-05-25 09:51:05) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2017

Re: ODBC Database Command | Supporting Task

jitu2110 — Fri, 26 May 2017 10:29:21 GMT

Did anyone can help me ?

topic Re: ODBC Database Command | Supporting Task in QlikView

ODBC Database Command | Supporting Task

Re: ODBC Database Command | Supporting Task