|
|
Browse by Tags
All Tags » Execute SQL
Showing page 1 of 3 (25 total posts)
-
I must be missing something.
I'm using the Execute SQL task to insert a record into a database table. Everything works fine as long as my values are strings but I have one int and one datetime field that fail no matter what I try.
If I put single quotes around my value I get the following error:
Conversion failed when converting the ...
-
I'm using the Execute SQL action and the Specify Column Names option and I get nothing returned. I've confirmed that the query itself works by having the result go to a collection, but when I specify the columns, I get nothing returned.
My column names are [ProjectName], [Current Phase], and [PHDate]. I've specified them with and ...
-
Hi,
Is it possible to return a custom string from an sql execute
I need to retrun "NO" if a certain value is not on the table columnj.
Thank you
-
Hello,
I try to put data to SQL table by following query:
SET IDENTITY_INSERT CCI ON
EXEC sp_dbcmptlevel CCI, 90
INSERT INTO CCI (id_in_table, Quest1, Quest2, Quest3, Quest4, Quest5, Quest6, Quest7, Ans1, Ans2, Ans3, Ans4, Ans5, Ans6, Ans7,ModifiedBy,ModDate,PSR)
VALUES ({ItemProperty:ID},Tex1,Text2.....Text7,3.5,4,5,4.4, 5, 4.1, ...
-
Vadim and others,
Based on reading the posts in this forum I have tried using the following connection string for our SQL 2008 database (note, I am using Nintex 2010 for Project Server 2010):
Data Source={DBSERVER\DBSERVERINSTANCE};Initial Catalog={DATABASENAME};Integrated Security=SSPI
I do not check the box for "Use ...
-
Regardless of the connection string I put in I get the following error:
Error performing database operation. Login failed for user ''.
Data Source=PSVR2010;Initial Catalog=ProjectServer_Reporting;User Id=myUsername;Password=myPassword;
(with correct username and password for a windows account with SystemAdmin rights. Also tried a ...
-
I had trouble with this and Vadim pointed me to add the following connection string makes the intergrated work:
"Integrated Security=SSPI;"
He also pointed out that if you leave the authetication boxes blank that it will use the app pool account to connect.
-
Now then it goes again to the basics. I tried changing my sql authentication mode to sql (earlier it was windows) made necessary changes in execute sql action, next to that a login history. where it gives error in the Nintex workflow history list.
A network-related or instance-specific error occurred while establishing a connection to ...
-
Hi,
I need to query a MS SQL server for some user information. I've been using Execute SQL and the workflow does not error but it always returns blank or 1.1.1900 if I store the result in date and time variable.
The connection string that is configured for the action is the following format and has full rights for the database:
Data ...
-
Thanks for the reply's.
@ Rob - Made the changes as you adviced single line of text but now it returns blank, even though i have created a text variable and made the result of query to store in it. :(
@ Vadim - Same query returns result as expected in Mgmt studio.
1
|
|
|