runsqlscript Error with ODBC Connection

Hi all,

I'm having trouble using the runsqlscript with the native ODBC connection to an MS SQL server. I get the following error message:

Undefined function 'runsqlscript' for input arguments of type 'database.ODBCConnection'.

I can run sql queries fine, just not a .sql script.

Any ideas on what I'm missing?

Answer 1

[Abhiram Bhanuprakash]

Hi Ahmed,

As of now, the 'runsqlscript' method does not exist for the database.ODBCConnection class in Database Toolbox.

There are no workarounds.

However, it looks like it is available if you use JDBC connection.

For usage of 'runsqlscript', please go through the doc

You can go through the doc here for the workflow to connect to Microsoft SQL Server JDBC for Windows

Please also go through the doc here for information on 'Choosing Between ODBC and JDBC Drivers'

Hope this helps,

Cheers!

Abhiram.