runsqlscript Error with ODBC Connection
조회 수: 2(최근 30일)
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?
Abhiram Bhanuprakash 2015년 4월 1일
편집: Abhiram Bhanuprakash 2015년 4월 1일
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,