Displaying 4 results from an estimated 4 matches for "nanodbc".
Did you mean:
nanoc
2017 Aug 29
2
DBI::dbWriteTable syntax error apparently from quotes
...varchar(255),
"mpg" FLOAT,
"cyl" FLOAT,
"disp" FLOAT,
"hp" FLOAT,
"drat" FLOAT,
"wt" FLOAT,
"qsec" FLOAT,
"vs" FLOAT,
"am" FLOAT,
"gear" FLOAT,
"carb" FLOAT
)
'
nanodbc/nanodbc.cpp:1587: 42000: [FreeTDS][SQL Server]Incorrect syntax
near 'mtcars'.
I believe that the complaint is related to the double quotes around
"mtcars" (and presumably the other double quotes in the command).
I tried searching to see if others have had this problem but I could...
2023 Mar 17
1
connect MSSQL server problem
.... I can use dbConnect (from DBI package) to connect the serve.Another one do not ask me credential to access the serve. But when I remove UID and PWD, it doesn't work. Then I tried to use my PC log in credential for UID and PWD, it still doesn't allow me to access. The error message:?Error: nanodbc/nanodbc.cpp:1021: 28000: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user '******'.?How to modify the code (see below) to access second MSSQL server?
con <- dbConnect(odbc(),? ? ? ? ? ? ? ? ?Driver? ?= "ODBC Driver 17 for SQL Server",? ? ? ? ? ? ? ? ?...
2019 Jun 13
2
Problema de INSERT en Windows SQL
...quot;))
obtengo el siguiente error:
rs <- dbSendStatement(con,query)Error: <SQL> 'INSERT INTO DATOSPERFIL
VALUES ( 1 , 13/06/2019 , 170604 , 90 , , Periodista de Antena 3
Autor de El rastro de los rusos muertos Antena 3 Tv News Spain
managing editor presenter and author , NA )'
nanodbc/nanodbc.cpp:1587: 42000: [Microsoft][ODBC SQL Server
Driver][SQL Server]Sintaxis incorrecta cerca de ','.
¿Qué estoy haciendo mal?
Conseguí añadir datos en la base con la función dbWriteTable del mismo
paquete DBI:
dbWriteTable(con, "imdbpelis_copia", dtf, append=FALSE, overwrit...
2017 Aug 29
0
DBI::dbWriteTable syntax error apparently from quotes
...;cyl" FLOAT,
> "disp" FLOAT,
> "hp" FLOAT,
> "drat" FLOAT,
> "wt" FLOAT,
> "qsec" FLOAT,
> "vs" FLOAT,
> "am" FLOAT,
> "gear" FLOAT,
> "carb" FLOAT
>)
>'
> nanodbc/nanodbc.cpp:1587: 42000: [FreeTDS][SQL Server]Incorrect syntax
>near 'mtcars'.
>
>I believe that the complaint is related to the double quotes around
>"mtcars" (and presumably the other double quotes in the command).
>I tried searching to see if others have had this...