Questions tagged as 'odbc'

Tagged questions
1
answer

Is it possible to connect to PostgreSQL via ODBC in Delphi 7?

I'm having a hard time connecting to the PostgreSQL database in Delphi 7 , I got it with Zeos Lib, however I need it to be via dbExpress the connection, then I saw that in the most current versions of Delphi it is possible to connect via O...
asked by 26.10.2016 / 13:40
1
answer

Oracle - Error connecting to ADOConnection Delphi 10.1 (Berlin)

I have an application that works on Delphi XE2 using the database connection component ADOConnection . When I migrated to Delphi 10.1 (Berlin) , it did not show any error. The connection exists, but does not connect, and displays the followi...
asked by 18.09.2017 / 14:56
1
answer

Updating a datagrid with connection to mysql

I can not update a table from a database linked to a datagrid. When I change the data in the cells of the datagrid, although they appear changed during the debug, at the end the table is not updated. Does anyone know what's missing in the code?...
asked by 16.12.2015 / 11:22
2
answers

Job created in SSIS does not work in 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 into a sql server local table. The Sql Server and the access database are on different...
asked by 14.01.2016 / 17:03
1
answer

How to make an x64 application connect to a 32bits ODBC driver?

I have an x64 application written in C # with .Net Framework 4 that needs to connect to the Microsoft ODBC for Oracle driver. When using this driver with the application in x86 mode, this connection works normally. However when using the ap...
asked by 08.10.2014 / 13:51
0
answers

Missing Task SrcSet0 (Loading) in source MICROSOFT_EXCEL ODBC

Hello, I'm trying to set up oracle data integrator to read an excel spreadsheet in xls and xlsx formats, but I'm having problems and I can not find a solution! it returns me the following error: IconfiguredODBCinthisway: Andtestingthesepara...
asked by 27.12.2017 / 12:48
1
answer

Incompatibility of architecture between drive and application

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 run this error:    pyodbc.Error: ('IM014', '[IM014] [Microsof...
asked by 07.12.2016 / 19:47
1
answer

Connect Visual Studio to the database [closed]

Hello, I am trying to connect my project in Visual Basic, in Visual Studio, with my MySQL database, it presents the error below, could someone tell me how to solve this problem? I have already installed mysql odbc. An unhandled exception of typ...
asked by 24.08.2016 / 01:48
1
answer

Insert without explicit 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 only) of the previous ones. How can I insert of each one without having to explain which columns I'm insertin...
asked by 08.12.2015 / 15:01
0
answers

Configuring a DSN via C #

Hello, I found this article talking about how to configure a DSN via Code in VB. Is it possible to do the same in C # for a connection to BD Mysql? Thank you... VB - Configuring a DSN via Code     
asked by 04.07.2015 / 20:34