Styjun

Nails holding drywall

What to do with someone that cheated their way through university and a PhD program?

std::unique_ptr of base class holding reference of derived class does not show warning in gcc compiler while naked pointer shows it. Why?

Find the identical rows in a matrix

Mistake in years of experience in resume?

Philosophical question on logistic regression: why isn't the optimal threshold value trained?

How do I deal with a coworker that keeps asking to make small superficial changes to a report, and it is seriously triggering my anxiety?

Can a level 2 Warlock take one level in rogue, then continue advancing as a warlock?

Combinatorics problem, right solution?

Why did Rep. Omar conclude her criticism of US troops with the phrase "NotTodaySatan"?

How to keep bees out of canned beverages?

Where was the County of Thurn und Taxis located?

"My boss was furious with me and I have been fired" vs. "My boss was furious with me and I was fired"

Check if a string is entirely made of the same substring

Why doesn't the standard consider a template constructor as a copy constructor?

Why is the underscore command _ useful?

Why do distances seem to matter in the Foundation world?

Will I lose my paid in full property

Multiple fireplaces in an apartment building?

Is there any pythonic way to find average of specific tuple elements in array?

Is it acceptable to use working hours to read general interest books?

Suing a Police Officer Instead of the Police Department

Double-nominative constructions and “von”

Crossed out red box fitting tightly around image

R - use pool package with RODBC dsn connection

RODBC error - ODBC connection failed - can't connect to MySQL with my mac (mavericks)How to Connect R to MySQL Database Using ODBC on Mac OS 10.10.3 (Yosemite)Connect to Ms SQL with RODBC without dsnRODBC ERROR: state IM002, code 0, message unixODBC Driver Manager]Data source name not found, and no default driver specifiedCan not Connect to a database on Redshift in R by RODBC packageCannot connect to data warehouse using ODBC connectionR RODBC SQL Server ConnectionError connecting to SQL Server using RODBC in linuxR ODBC nanodbc error when not using DSNHow to use DSN file for connection to SQL Server using R

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I already have a dsn connection setup to a an SQL server. I connect using:

library(RODBC)
conn <- odbcConnect(dsn = "my_db",
 uid = "uid",
 pwd = "pwd")

I'd like to use the pool package to look after connections within a shiny app. I tried this:

library(pool)
pool <- dbPool(
 odbc::odbc(),
 dsn = "my_db",
 uia = "uid",
 pwd = "pwd"
)

But I get an error:

Error: nanodbc/nanodbc.cpp:950: 08001: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source 

I think perhaps I need to replace the odbc::odbc() with something but I can't figure it out. I found this reference but it didn't help.

r

share|improve this question

asked Mar 22 at 16:33

Pete900Pete900

84511025

add a comment | 

0

I already have a dsn connection setup to a an SQL server. I connect using:

library(RODBC)
conn <- odbcConnect(dsn = "my_db",
 uid = "uid",
 pwd = "pwd")

I'd like to use the pool package to look after connections within a shiny app. I tried this:

library(pool)
pool <- dbPool(
 odbc::odbc(),
 dsn = "my_db",
 uia = "uid",
 pwd = "pwd"
)

But I get an error:

Error: nanodbc/nanodbc.cpp:950: 08001: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source 

I think perhaps I need to replace the odbc::odbc() with something but I can't figure it out. I found this reference but it didn't help.

r

share|improve this question

asked Mar 22 at 16:33

Pete900Pete900

84511025

add a comment | 

I already have a dsn connection setup to a an SQL server. I connect using:

library(RODBC)
conn <- odbcConnect(dsn = "my_db",
 uid = "uid",
 pwd = "pwd")

I'd like to use the pool package to look after connections within a shiny app. I tried this:

library(pool)
pool <- dbPool(
 odbc::odbc(),
 dsn = "my_db",
 uia = "uid",
 pwd = "pwd"
)

But I get an error:

Error: nanodbc/nanodbc.cpp:950: 08001: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source 

I think perhaps I need to replace the odbc::odbc() with something but I can't figure it out. I found this reference but it didn't help.

r

share|improve this question

asked Mar 22 at 16:33

Pete900Pete900

84511025

library(RODBC)
conn <- odbcConnect(dsn = "my_db",
 uid = "uid",
 pwd = "pwd")

library(pool)
pool <- dbPool(
 odbc::odbc(),
 dsn = "my_db",
 uia = "uid",
 pwd = "pwd"
)

Error: nanodbc/nanodbc.cpp:950: 08001: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source 

share|improve this question

asked Mar 22 at 16:33

Pete900Pete900

84511025

share|improve this question

asked Mar 22 at 16:33

Pete900Pete900

84511025

asked Mar 22 at 16:33

Pete900Pete900

84511025

asked Mar 22 at 16:33

Pete900Pete900

84511025