runsqlscript Error with ODBC Connection

Question

Ahmed Akgiray 2015-3-30

编辑： Abhiram Bhanuprakash 2015-4-1

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 2015-4-1

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.