R program connecting remote SQL Server

R program connecting remote SQL Server

R program connecting remote SQL Server

Connect to SQL Server on remote machine from R programming:

1. Create a SQL Server ODBC Data Source.

a. Open the ODBC Data Source Administrator as described :

Navigate to Control Panel ->Administrative tools -> Data Source(ODBC)

b. On the User DSN tab or the System DSN tab, click Add to add a user data source or a system data source.

c. Click SQL Native Client or SQL Server Native Client 10.0 to select the driver, and then click Finish.

d. Follow the instructions in the Wizard mentioning remote Server Name say “rconnect”. In next window select SQL Server authentication using a login ID and password entered by the user

i. LoginID

ii. Password

R program connecting remote SQL Server

e. Change default database name in next window:

R program connecting remote SQL Server

2. On R Terminal , use command

a. install.packages(“RODBC”)

b. library(RODBC)

c. odbcConnect(“rConn”)
where “rConn” is name of the user/System DSN

Enter password if required.

Related posts:

weka time series forecasting java eclipse

machine learning using Weka library with java

Resolving technical problems:

Solve your technical problems instantly

We provide Remote Technical Support from Monday to Sunday, 7:00PM to 1:00 AM

Mail your problem details at writeulearn@gmail.com along with your mobile numberand we will give you a call for further details. We usually attend your problems within 60 minutes and solve it in maximum 2 days.