Error connecting to database

database
studio

#1

Hi

I have experienced the following error when trying to use the activity ‘Execute Query’:
Message: Cannot create and populate list type System.Data.Odbc.OdbcErrorCollection. Path ‘$values’, line 1, position 175.

Source: NewtonSoft.Json

Exception Type: JsonSerializationException

Have any of you seen this error before and knows how to fix it?

Best regards,
Jan


How to connect to ORACLE Database
Workbook write cell error
#2

Hi Again

I have uploaded my workflow file here:
DB_Test.xaml (6.4 KB)

Thanks!


#3

Hi,

Can you use the Microsoft Driver syntax for ODBC in the connection string and try? Below is an example. I am guessing the issue might be because you have used the DSN syntax.

“Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=UserName;Pwd=Secret;”

Regards,
Amrita


What is the ConnectionString for Oracle Database in UI Path?
How to connect to ORACLE Database
#4

This seems to be working, thank you very much :slight_smile:


#6

hi,

i am facing same error in connecting excel

I have used ODBC as the provider

could u please let me know the perfect and exact connection string for connecting excel (odbc provider) so that i can eliminate this issue…

regards…


#7

Regards…!!
Aksh


#8

Hi Akshay,

The above attachment is for OLEDB

I need the string for ODBC and not for OLEDB


#9

#10

Hi I use this syntax but the same error appears… I can connect to MySQL, but when inserting data and executing queries, there is error. Do you know how to solve this problem?


#11

I have attached workflow check it. DatabaseConnection.zip (2.8 KB)


#12

Hello,

I am facing same error now. Did you had any solution for that.

Please let me know.

Thanks.


#13

I am also facing the same issue.

: ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed


#14

Hi @thepathbreaker

  1. One item that can cause this error is not having the ORACLE_HOME bin directory in your Windows OS path. Please check and put it on the first place.
  2. Check whether you have Oracle client installed. If not then please install Oracle client and verify.

Regards,
@therishirawat