Value cannot be null -Parameter atleast one of the connections must be used

Help Activities
,
1

Hi when I am inserting this

image
image971×161 94 KB

syntax of my query-"
Can anyone help me how to rectify the error.
TIA

2

@Cuberoot

Can you please show the properties is the connection details procided properly?

Cheers

4

@Cuberoot

In the activity is the connection details provided?

This si the connect activity

Cheers

5

yes.i have mentioned it

6

Did you put Connection into the property of the SQL query activity?

7

yes,I did it but seems facing the issue

8

Show the properties of that activity

9

Connection is a property of System.Net (System.Net.Connection). You should not use it as a variable name. Create a better variable name like dbConnection

10

i have created connection variable

11

You should not use Connection as a variable name. It’s a property of System.Net (System.Net.Connection). Create a variable with a better name like dbConnection

12

executeNonquery property

image
image831×395 79.4 KB

14

@Cuberoot

The output of your connect activity and the input variable you provided in existing are different

Cheers

15

Could you please please correct it because i did it

16

@Cuberoot

What you want me to correct?

Cheers

1 Like
17

What is my mistake?

18

@Cuberoot

Here you used connection variable

image

here you used dbconnector

image
image778×172 43.1 KB

Also connection is a reserved word change it to any other name so that it does not conflict

cheers

19

As oer the pauls info i have changed it but changed to db connection it shows me System. Oracle.Dataclient is not available.So what should I do?

20

@Cuberoot

Please try with

Microsoft.Data.SqlClient

Cheers

21

But we are entering the data in oracle sql client.so it will shows the error?

22

Did you use the wizard to configure the connection?