In computing, ODBC (Open Database Connectivity) is a standard C programming language interface for accessing database management systems (DBMS).

learn more… | top users | synonyms

0
votes
0answers
36 views

Connecting to SQL Server 2014 with sqlcmd

I am using the version of sqlcmd that comes with the Microsoft ODBC Driver 11 for Sql Server to connect to a remote 2014 instance. I can create a DSN connection using the SQL Server Native Client ...
2
votes
1answer
36 views

#Deleted as values when using MS Access to query a db2 database through ODBC

When trying to query certain db2 tables I get #Deleted for all values in the table. But for other tables it works fine. The row count of this query is equal to the row count when using the data ...
-2
votes
1answer
23 views

Application load considerations, use what you get vs. not all at once

General question: Should I as an application use all resources I can get and thrust the OS schedeuler or should I already do some load considerations for the OS. If so, what metric should I use? ...
1
vote
0answers
18 views

Need ODBC connection to postgresql to include materialized views

I have an Access front end user interface that links to tables in a postgreSQL database using the most recent ODBC driver. I can link to the postgreSQL tables and views but can't get to the ...
0
votes
1answer
69 views

DB2 ODBC inconsistent connectivity

My ASP.net application uses ODBC(64 bit) to connect to DB2 Database(9.5.3). I am using 64 bit IBM DB2 Client 10.5. on Windows Server 2008 R2. Connection pool is turned on. It works fine(immediate ...
1
vote
1answer
60 views

ADO connection suddenly starts failing Intermittently

I have an Access 2010 front end connecting to a SQL Server 2014 back end. I've got SSMS 2014 installed on my machine, and everything was working fine. (Running Win7 64-bit with 64-bit Office.) Long ...
1
vote
0answers
121 views

iSeries Linked-Server SQL 2012 performance issue

I have a seen a serious performance dive when moving from SQL2008R2 to SQL2012 on my linked server queries. I have set the linked server on the SQL2012 server as a Microsoft OLE DB Provider for ODBC ...
0
votes
1answer
46 views

SQL database ODBC connection Multi-part identifier could not be bound

We're using PADS Professional xDX Designer (from MentorGraphics) with a SQL parts database connected through ODBC using views. All seems to be working just fine, except for our Inductor parts where ...
1
vote
1answer
113 views

Linked servers on SQL Server 2008 R2 through linked tables in MS-Access?

We have a really old data source (file-based) in Visual FoxPro, that we currently use via linked table through an ODBC data source. Recently, we started having an issue because the latest update to ...
0
votes
0answers
934 views

ORA-28040: No matching authentication protocol

I'm trying to connect to my RAC database using odbc drivers. While trying I get ORA-28040: No matching authentication protocol I have added this in both client and the server: ...
1
vote
0answers
88 views

SQL Server using Linked Server to Oracle - table definition not updating with refresh

Is there some trick for SQL Server Linked Server to update the ODBC connection to a changed table? SQL Server provides Oracle with a view. Oracle runs a materialized query to basically make a table ...
0
votes
0answers
58 views

How to read from Mongodb secondary Only in a replica set?

Mongodb version 2.6.10 Ubuntu 14.04 Currently having a replica set of 4 nodes , my read preference is Primary Only , I configured one node with priority 0 Also i have a file on the priority 0 node ...
0
votes
1answer
55 views

Windows ODBC Driver versions for Netezza

I am looking for information regarding the Netezza windows ODBC driver versions. What are the supported/preferred windows ODBC driver versions for Netezza 7.2, Netezza 6.1 and Netezza 6.0. Any ...
1
vote
2answers
197 views

Using SQLite ODBC without installing a driver

I am currently trying to access a SQLite database via an ODBC connection but the system that I am working on is extremely locked down and it is therefore not possible to install the drivers. Is there ...
0
votes
0answers
51 views

How does SQL Server Import and Export Wizard fetch metadata?

I'm using SSMS 2014 to fetch data from Progress OpenEdge 10.2B via ODBC, and dealing with OpenEdge's overstuffing of its datatypes is a constant challenge. The only way I've found to see what size my ...
2
votes
0answers
431 views

Connection string for MariaDB using ODBC

What is the connection string for using MariaDB with ODBC? I'm guessing it's something like DRIVER={MariaDB ODBC 5.1 Driver}; SERVER=LOCALHOST; PORT=3306; DATABASE=DatabaseName; UID=root; ...
0
votes
1answer
610 views

What DSN file is MS Access using for ODBC Linked Tables?

I set up a linked tables in Microsoft Access to connects to an remote database using ODBC with a File DSN. But which DSN file is Access using now? I want to examine it and compare it with the other ...
3
votes
1answer
509 views

Query SQL Server from Excel with parameters linked to cells

I have a bunch of Excel spreadsheet that have data connections to a SQL Server DB (Hosted by AWS RDS) and I follow exactly this procedure to get those connections up and running with the parameters ...
0
votes
1answer
105 views

Set in mySQL a predefined order for SELECT queries without using the ORDER BY clause

I have a MySQL database and users access it through an old legacy software (OLS) the company bought years ago. OLS connects to MySQL through MySQL ODBC driver. There is no way to change OLS in recent ...
3
votes
0answers
81 views

Create an SSL connection with ODBC driver to MySQL(5.6) using openSSL

I want to create an asymmetric SSL connection from MySQL to an ODBC driver but don't fully know how to generate the keys and certificates (I'm using openSSL as recommended here: ...
2
votes
1answer
349 views

Oracle instant client

What is the difference between instant client and the original Oracle client? The Oracle client is almost 800MB and the instant client is not so much. I need to install oracle client, ODBC drivers and ...
0
votes
1answer
57 views

Can SQL Server 2014 schema be defined using ODBC?

I am trying to use the ODBC driver for SQL Server 2014 to export data from an Autodesk Revit 2015 model to a database. However, I would like to export to a default database (e.g. db1), creating a new ...
0
votes
1answer
33 views

Oracle ODBC Driver, Tables and Columns Remarks

I'm using the Oracle ODBC Driver 11.2 to access an 11.2 Oracle Database. It seems that the driver does not return tables nor columns remarks (comments) when calling the SQLTables() or SQLColumns ODBC ...
0
votes
2answers
160 views

ODBC Driver tracing not capturing any logparser events

I have enabled Driver Tracing using these directions. I am running SQL Server 2014, which uses the 2012 native driver. I run the start batch file then the following LogParser command: ...
0
votes
0answers
26 views

Cannot create 64bit ODBC DSN entry to local SQL2008R2

Environment: SQL Server 2008 R2 server (Express Edition) running under Windows 7 64bit Professional. I want to access the server locally via 32bit VB-application and 64bit Web application. SQL ...
0
votes
1answer
167 views

Access 2010 ODBC Connection to SQL Server 2005

I'm trying to code an ODBC connection to SQL Server in Access 2010 and hoping someone can help me, as I've lost the plot. This is my code, it simply accesses one SQL Server database/table and insert ...
0
votes
0answers
18 views

Accessing Unidata DB over Access 2003 through ODBC driver

My apologies if it sounds like gibberish, I work extensively with MS SQL and not much else. I have an Access SQL query that selects data in a linked table in Access 2003. That table is linked using ...
10
votes
1answer
847 views

Avoiding “Row by row” fetch method when dealing with source LOB columns

I have a legacy PostgreSQL database source (ODBC) that I'm attempting to migrate to new SQL Server schema using SSIS. I'm getting a warning saying: 'Row by Row' fetch method is enforced because ...
0
votes
0answers
133 views

Timeout too long on SQL Server 2012 Linked Server to MySQL

We have a statement in a SQL Server 2012 stored procedure that is an INSERT into a temp table from SELECT using OpenQuery to pull data through a Linked Server from a remotely hosted MySQL database. ...
0
votes
1answer
331 views

Issuing Inserts/Updates to Progress OpenEdge via ODBC

I'm attempting to build some ETL to integrate our SQL Server environment with a remotely hosted 3rd party app running Progress OpenEdge. I have a linked server to it set up in SQL Server 2014. ...
0
votes
0answers
43 views

How to avoid frequently needing to re-grant permission in Hue?

My organization has a cluster/environment with the following: Component Version Hue 2.5.1-695 HDP 2.1.2 Hadoop 2.4.0 Pig 0.12.1 Hive-Hcatalog 0.13.0 ...
1
vote
0answers
51 views

MySQL ODBC Mirror/Failover

I am wondering if it is possible with the Windows MySQL ODBC driver to mirror the data writing on a local (Access) database or, at least, to write on the local database if the writing on the remote ...
0
votes
1answer
150 views

Why does Informatica hang and say “Not Responding” when connecting to ODBC Data Source

Informatica just hangs when trying to open this dialog. The ODBC connection exists in Control Panel > Administrative Tools > ODBC Data Sources. Source Analyzer > Sources (menu) > Import from ...
0
votes
0answers
78 views

Query returns rows for the first time only (Oracle to SQL-Server using ODBC 64bit)

SELECT MJ_GR, GRP_NO, GRP_NAME, EGRP_NAME, sys_guid() rowguid FROM STK_GRP WHERE GRP_NO NOT IN (SELECT "BrandNo" FROM HH_Brand@salesbuzz) AND MJ_GR IN (SELECT ...
0
votes
1answer
519 views

How to query a server linked via ODBC

I've looked at multiple other questions about querying linked servers, but nothing has worked for my setup. Notes: I'm not using localdb at all. I just wanted to use SQLSMS for a remote cache ...
1
vote
1answer
175 views

User can see Oracle tables via ODBC that her account does not have access to [closed]

We have a user whose Oracle account, according to ALL_TAB_PRIVS, has access to tables A, B, and C. However, when the user creates an ODBC and connects to Oracle via Microsoft Access (using her Oracle ...
0
votes
0answers
149 views

Databasewizard ask for ODBC driver login id and password

I am new to SPSS, but I have recently gotten it installed on my university computer, the program seems to work fine, but the problem starts when I try to import a existing Access database.The ...
1
vote
1answer
474 views

Comparing two different ODBC system-DNS entries. Which is faster? PS script

i want to find out which ODBC Connection is faster on my VM with Windows Server 2008 R2. I have two different ODBC providers. The first is "Oracle Instant Client ODBC" in v11. The other "Microsoft ...
0
votes
0answers
33 views

Getting exception in Servlet due to ODBC

I am getting exception which is as follow - Exception[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedjava.sql.SQLException: [Microsoft][ODBC Driver ...
0
votes
0answers
85 views

How to add External data source into MySQL?

I have two database. One is FileMaker database and another one is mysql. I want to use this database in mysql.I created odbc data base connection so that I can sync both database e.g when I maker ...
1
vote
0answers
74 views

Named a table “order” in Microsoft Office Access database and the webapp now can't see the table (even after renaming it)

I am creating a web application in Dreamweaver using ASP VBScript. The web application is a store and I have to implement a database into it (which I did). I created a table in my database called ...
1
vote
0answers
56 views

Can I revert to local logging in IIS 7.5 if ODBC fails? [closed]

Environment I have 3 Servers running instances of IIS 7.5 hosting different websites. 1 Server is on Domain A, 2 Servers are on Domain B. I have a one way trust setup from Domain A to Domain B. SQL ...
0
votes
1answer
379 views

odbc connection from windows machine to mysql server running on ubuntu?

I was able to install mysql server on an ubuntu machine and set up a test data base, created a user and granted that user access to the database. I also changed the binding address to the IP of the ...
1
vote
1answer
234 views

SSIS - ODBC Parameter Size

I have created a SSIS package which runs every hour from my Machine. First part of my Package runs a Execute SQL Task and result set (single row, single column) is a comma separated list of Unique ...
0
votes
1answer
506 views

Importing a Foxpro Database

I have a Fox Pro database (one DBC and a bunch of DBF files) that I want to import into SQL via the Import and Export wizard. I downloaded the FoxPro ODBC driver. I managed to get to the screen that ...
2
votes
1answer
548 views

Linking Oracle 10g XE with SQL server using ODBC

I am connecting Oracle 10 XE with an SQL server 2008 using ODBC in windows 7. I have successfully done following steps: Configured ODBC and test it, runs ok! Configured listener in tnsnames.ora and ...
1
vote
1answer
2k views

Oracle Database Client 11g R2 Installation Types, which components?

I need to know which component is under each installation type! Instant Client Administrator Runtime Custom (No need as it shows all the components) ALSO? does it includes ODP.NET? is it the ...
0
votes
2answers
54 views

Meaning of 'show variables LIKE '%_database'

Despite being a newbie in db administration, I have been assigned to move our crm from mysql to mssql. I have reached a point where I have met a query I dont understand and it cannot execute in sql ...
0
votes
1answer
1k views

ODBC SQL Server driver on Linux/nginx

Writing here because really can't figure out what to do. I have a site located at ftp server. And now it moves to a new server based on Linux/nginx. And everything is fine except SQL Server ODBC ...
0
votes
1answer
239 views

ODBC Data Source Administrator: Driver name is an empty string

Below you will see a screen shot of a warning in Windows 7. Why would I get this error when opening up "Data Sources (ODBC)"? How can I resolve it? If you can give me some tips on where to start ...