runsqlscript Error with ODBC Connection

조회 수: 2(최근 30일)
Ahmed Akgiray
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?

답변(1개)

Abhiram Bhanuprakash
Abhiram Bhanuprakash 2015년 4월 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.

태그

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by