Most voted "odbc" questions
ODBC (acronym for Open Database Connectivity) is a standard for access to database management systems (DBMS)
Learn more…45 questions
Sort by count of
-
16
votes3
answers6549
viewsWhat are providers? What is the difference between OLE DB and ODBC?
I need to read files dbf. I found a tutorial to read the same where the author uses these two providers. I only saw differences in the connection string. What are these providers? What is the…
-
6
votes1
answer5859
viewsWindows 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 Oracle base via Obdcconnection. In the Web project I can successfully open the connection... But in Windows…
-
5
votes2
answers427
viewsView "View" from Postgres in Mysql. Is it possible? How to Do?
Is there any way to view a View created in Postgres and view in Mysql? If so, how to configure?
-
4
votes2
answers108
viewsUpdating Mysql table using sqlSave in R
I’m new to R and I’m trying to add new tables to the database,: Error in sqlSave(connection, dado, tablename = "teste", rownames = FALSE, : unable to append to table ‘teste’ Where: dado =…
-
3
votes1
answer301
viewsError when connecting PHP to SQL Server via ODBC Linux
I am making a connection in no windowns via php to SQL SERVER and it is going normal, in a machine where the php server is linux this giving the following error: Fatal error: Uncaught exception…
-
3
votes2
answers419
viewsUnixodbc: Decimal Formatting Problem
I built a server with Centos 7, SQL Server 2017, and Unixodbc On tsql, the numbers are correct. But when I see in isql, the decimals are separated by a comma (,) rather than a dot (.). How can I fix…
-
2
votes1
answer2624
viewsODBC -SQL Server Error 17 and SQL Server Error 2
There is a BI application on a station that has an ODBC connection configured to fetch the database on another server. If I open the BI on the server where the SQL database is and perform connection…
-
2
votes1
answer858
viewsError trying to connect via ODBC to Mysql
I’m trying to make a connection via ODBC with the Mysql Database to access data in Excel, but after performing all necessary settings the following error window is shown to me: So I set up the…
-
2
votes1
answer107
viewsReload while while giving Submit
I have the need to when load all the content defined in the database query to each while and fill in the fields and give Submit, it record in the database and reload only that loop bringing me the…
-
2
votes1
answer78
viewsFunction to read file via ODBC
Hello, it must be a very simple problem, but I’ve searched a lot and I couldn’t find a solution to my question. My setting is: R version 3.3.1 (2016-06-21) Platform: x86_64-w64-mingw32/x64 (64-bit)…
-
2
votes1
answer44
viewsWhat is the OPTION=3 parameter for in the Database connections?
A database connection 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…
-
2
votes1
answer173
viewsMysql - Problems changing the "max_execution_time" variable
I have a Mysql Server 5.7 installed on a Windows server, when I change the variable "max_execution_time" to 6000, when I run the query below with ODBC to confirm that the change was made: show…
-
1
votes1
answer1009
viewsHow to make an x64 application connect to a 32bit ODBC driver?
I have an x64 application written in C# with .Net Framework 4 you need to connect to the Microsoft ODBC for Oracle driver. When using this driver with the application in x86 mode, this connection…
-
1
votes0
answers71
viewsConfiguring a DSN via C#Code
Hello found this article talking about how to do Configuring a DSN via VB Code. Is there any way to do the same in C# for a connection to BD Mysql? Thank you... VB - Configuring a DSN via Code…
-
1
votes1
answer1509
viewsInsert without specifying columns
I have several tables T1, T2... TN, each one can have columns in common or not. My final table F, contains all the columns (one time) of the previous ones. There is how I insert from each without…
-
1
votes1
answer56
viewsUpdating a datagrid with mysql connection
I can’t update a table from a database linked to a datagrid. When I change the data in the datagrid cells, although these appear changed during the debug, at the end the table is not updated. Does…
-
1
votes2
answers1051
viewsJob created on SSIS does not work on SQL SERVER AGENT
I have a job created in SSIS (working perfectly) that does not work in SQL SERVER AGENT. The job extracts some data from an access table, via ODBC, and loads it into a sql server location table. Sql…
-
1
votes1
answer1256
viewsIs it possible to make a connection to Postgresql via ODBC in Delphi 7?
I’m having difficulties to make the connection to the database Postgresql in the Delphi 7, I got it from Zeos Lib, but I need it to be via dbExpress the connection, then I saw that in the most…
-
1
votes1
answer1857
viewsArchitecture incompatibility between drive and app
I’m trying to access data from a database using pyodbc with this code: import pyodbc cnxn = pyodbc.connect("DSN=banco;uid=usuario;pwd=senha") cursor = cnxn.cursor() But when I make that mistake:…
-
1
votes1
answer329
viewsOracle - Error connecting with Adoconnection Delphi 10.1 (Berlin)
I have an app that works on Delphi XE2 using the database connection component Adoconnection. When I migrated to the Delphi 10.1 (Berlin), no error. Connection exists, but does not connect, and…
-
1
votes1
answer14
viewsODBC and PHP bringing string results with formatting problem
This is the result: The result of the name has no accent The code works on my machine, but on the server this problem. <?php $con1=odbc_connect('***','***','***'); $sql = " SELECT * FROM tabela…
-
1
votes0
answers28
viewsSrcset0 task failure (Loading) on MICROSOFT_EXCEL ODBC source
Good morning, I’m trying to configure oracle data Tegrator to read an excel spreadsheet in xls and xlsx formats, but I’m having problems and I can’t find a solution! it returns me the following…
-
1
votes1
answer55
viewsProblem with the type of Ncode I get from a Sybase comic
Good, I’m getting values from a Sybase database through odbc in php. It turns out that when printing special characters ,such as ô or ç, are printed '?? ' instead of these. I have tried using…
-
0
votes2
answers1515
viewsRemember user and password of an Oracle ODBC connection
I am connecting an Oracle database with an Access database through Oracle ODBC Driver 11.2. The problem is that every time I access the base in Access, the driver from Oracle requests…
-
0
votes0
answers73
viewshow to access a 64-bit SQL
I have a software in vb6 32 bits, in a station of 32 bits accessing a database SQL 64 bits on a 64 server bits. How to create ODBC?…
-
0
votes1
answer253
viewsSybase 15 and Laravel 5.1 via ODBC and Error 3811
I have a database in Sybase (Adaptive Server Enterprise) and we started using the Laravel framework to transfer existing systems to it (a migration in BD cannot be contemplated). Laravel by default…
-
0
votes1
answer82
viewsCreate ODBC Informix data source
Problem: I need to register a INFORMIX data source and I’m not getting it. I enter the parameters, but always error occurs. What should I do?…
-
0
votes0
answers36
viewsSQL DATE EXECUTION - ODBC
I am doubtful in the date format that ODBC performs. I tried every way and nothing. This Query performs normal if I insert only the code, but when I want to enter dates it does not execute. I…
-
0
votes1
answer356
viewsMigrate Firebird Delphi 7 Application to Postgresql
I am trying to migrate an application that was developed in Delphi 7 and that uses the database Firebird to save your information, to the database postgresql, from this, I have already been able to…
-
0
votes1
answer297
viewspsqlodbca.so: Cannot open shared object file: File or directory not found
I cannot migrate Postegresql database to mysql due to this error: psqlodbca.so: Cannot open shared object file: File or directory not found I am using Ubuntu 64 Postgresql 9x and Workbench 6.x, how…
-
0
votes0
answers259
viewsI cannot connect to Mysql database
I have a classic ASP application and I am not able to connect to the database. I have configured all the right settings stringConexate = "DRIVER={Mysql ODBC 5.3.9 ANSI Driver}; SERVER=localhost;…
-
0
votes1
answer3105
viewsHow to assign the value of an Excel column in an SQL command
I was able to connect to my Mysql Database via ODBC, and display the information I need via SQL command, but I would like the contents of a particular cell of my spreadsheet to be in this SQL query,…
-
0
votes1
answer89
viewsDownload database file via php
I have a system that I didn’t create, the bank runs on sybase driver-like odbc, the php accesses everything with odbc, I need to download Pdfs that are recorded in this database in the type file…
-
0
votes1
answer170
viewsVery slow SQL query in Openedge database, what can it be?
I’m having trouble executing queries in the Openedge 11.6 database. Several queries take a long time to be executed, sometimes almost 2 minutes. Here’s an example of a query I’m trying to run:…
-
0
votes2
answers43
viewsDjango - DATABASES configuration
DATABASES = { 'default': { 'ENGINE': 'sql_server.pyodbc', 'NAME': 'name', The string of ODBC only use the attribute DATABASE, but Django only executes with the attribute NAME. How can I resolve this…
-
0
votes0
answers50
viewsDoubt PHP + Sql server
Good Afternoon everyone I’m new to the forum so I don’t know if I’ve opened this topic in the right place. I need a help in a table that I am generating with php through some queries being one in…
-
0
votes1
answer40
viewsPHP connection via ODBC to the intersystems CACHE database
Good morning, everyone. Does anyone have experience of making a connection via odbc with the intersystems caché database in PHP? I have already installed the ODBC driver on my host and connected it…
-
0
votes1
answer155
viewsCreate xlsx File with html table
Good, I am trying to pass the values of an HTML table that receives data from a SYBASE database through odbc. When creating an 'xlsx' file formatting excel prevents the created page from opening and…
-
0
votes0
answers25
viewsI can not fetch information from a MS SQL database through ODBC and with Codeigniter query Builder
Good, I am trying to create a login page with Codeigniter. It turns out, to validate the entered data, I need to fetch information from a MS SQL database through ODBC. When using the Codeigniter…
-
-1
votes1
answer338
viewsConnect Visual Studio to database
Hello, I am trying to connect my project in Visual Basic, in Visual Studio, with my Mysql database, it presents the error below, would anyone tell me how to solve this problem? I already installed…
-
-1
votes2
answers260
viewsPython string prefix
I made a script to download an attachment from an email, this attachment is an XML file, and I want to save it in a database. But when I get the XML body, it comes with the prefix 'b' and therefore…
-
-1
votes1
answer14
viewsHow to receive date values from a Sybase database?
Good, I need to search a database Sybase fields type Date to fill in my application. When searching for the necessary information and debugging it, the fields in the Date format appeared to me empty…
-
-1
votes1
answer88
viewsHow to get a Procedure return using ODBC in PHP?
I am trying to communicate PHP with the Caché database of Intersystems, but I will need to use ODBC to communicate. My doubt is how I can get PHP to return Procedure, in the case of a String, I’m…
-
-2
votes1
answer214
viewsName of the MYSQL Server
I am following a video lesson in which the instructor puts the name of your server in ODBC as it appears in mysql, but as my version (Mysql Workbench 8.0.15) is different and does not include the…
-
-3
votes1
answer130
viewspsqlodbc. h:54:23: fatal error: iodbcinst. h: No such file or directory
Error installing postgresql ODBC in Ubuntu 64 How should I proceed ?…