Questions tagged as 'odbc'

3
answers

What are providers? What is the difference between OLE DB and ODBC?

I need to read dbf files. I found a tutorial to read the same where the author uses these two providers. In the code I only saw differences in the connection string. What are these providers? What's the difference between them?     
asked by 25.06.2014 / 17:56
2
answers

View "View" from Postgres in Mysql. It's possible? How to make?

Is there any way to view a View created in Postgres and view it in MySQL? If yes, how to configure?     
asked by 01.09.2014 / 20:26
2
answers

Updating Mysql table using sqlSave in R

I'm new to R and I'm trying to add new tables in the database, the problem is that it always shows this message: Error in sqlSave(connection, dado, tablename = "teste", rownames = FALSE, : unable to append to table ‘teste’ Where: dado =...
asked by 17.04.2015 / 14:54
2
answers

UnixODBC: Decimal formatting problem

I've set up a server with CentOS 7, SQL Server 2017, and UnixODBC In tsql, the numbers are correct. But when I look at isql, the decimals are separated by a comma (,) instead of a period (.). How can I fix this? Q: What I really want...
asked by 26.06.2017 / 21:58
1
answer

Windows Service - ERROR [IM002] [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified

I have 2 projects (WebForms and Windows Services) in .NetFramework 4 that connects to the Oracle database through ObdcConnection. In the web project I can successfully open the connection ... However in Windows Services the following error...
asked by 29.08.2014 / 00:11
1
answer

Error trying to connect via ODBC to MySQL [duplicate]

I'm trying to make a connection via ODBC with MySQL Database to access data in Excel, however after performing all the necessary settings the following error window is shown to me: SoIconfiguredtheconnector: If you have any idea wha...
asked by 05.04.2017 / 21:19
1
answer

What is the Parameter OPTION = 3 used for Database connections?

A connection to the database is usually something like this Driver=MySQL ODBC 5.1 Driver;Server=XXX;Database=XXX;UID=XXX;PWD=XXX;OPTION=3; Most google searches suggest this OPTION = 3. In the Mysql manual there is little and has a number...
asked by 16.08.2018 / 13:23
1
answer

Reload content while giving Submit

I need to load all the content defined in the database query every while and fill in the fields and give the submit, it will write to the bank and reload only that loop bringing me the filled bank data again. So when you are posting information...
asked by 25.08.2016 / 13:30
1
answer

Function to read file via ODBC

Hello, it must be a very simple problem, but I have already looked a lot and I could not find a solution to my question. My configuration is: R version 3.3.1 (2016-06-21) Platform: x86_64-w64-mingw32/x64 (64-bit) Running under: Windows...
asked by 11.01.2017 / 13:23
1
answer

ODBC SQL Server Error 17 and SQL Server Error 2

There is a BI application on a workstation that has an ODBC connection configured to fetch the database from another server. If I open the BI on the server where the SQL database is and perform connection testing, import, query processes with po...
asked by 01.02.2015 / 15:33