Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in Azure by (5.8k points)

I have already set up an Azure SQL Database and loaded results into it from my local machine via R (RODBC) successfully. I can do queries in R Studio with no problem.

However, when I use the same code in the Execute R Script module in the ML studio, I get an error that the connection is not open.

The reason Reader or Import Data module is not working for my case is that I am creating an API that provides me with the information to query the database before doing analytics. The database is very big and I do not want to load the whole table and then use project columns, etc.

What do I need to change? I have tried different strings for the driver with no avail.

Any help is really appreciated

1 Answer

0 votes
by (9.6k points)

1. Use an Import Data module

2. Mark the query string as a web service parameter

3. You can dynamically inject the query.

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94k users

Browse Categories

...