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
1answer
21 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
6 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 ...
7
votes
0answers
141 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
39 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
108 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
25 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 ...
0
votes
0answers
19 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
24 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
56 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
85 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
98 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
52 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
178 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
23 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
13 views

Connecting/Synching MYSQL with SQL Anyqhere 10

We have a database on our network that uses SQL Anywhere 10 with and ODBC connector as a database for customer and product information. Our intention is to sync this database with a newly created ...
0
votes
0answers
45 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
35 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
36 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
208 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 ...
0
votes
1answer
118 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
0answers
26 views

SQLAnywhere: ODBC and Database mirroring

I'm tying to setup the correct way to connect to a mirrored database via ODBC. Usually a connection string like (taken from tutorial) ...
0
votes
1answer
244 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 ...
0
votes
1answer
281 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 ...
0
votes
1answer
862 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
35 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
450 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
123 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 ...
0
votes
0answers
356 views

Linked Server in SSMS 2014 - Shared Memory Provider, error: 0 - The pipe has been ended

I'm trying to connect to Mongo database from Microsoft SQL Server Management Studio through Linked Servers using Mongo ODBC Driver. Right now I'm testing Easysoft ODBC Driver. I can connect to the ...
1
vote
1answer
496 views

Install Access Database Engine on Linux Centos [closed]

I want to read mdb file from linux centos. To read that file, we must already install access data engine. Is there any access data engine for linux? Now I'm using mdbtools to configure ODBC connect ...
0
votes
0answers
118 views

DSN connection and RODBC on windows 8

I wish to run queries on a PostgreSQL database in R using the RODBC package. Before I had windows 7 and it was working but now trying to make it work on windows 8 I have not yet succeeded to find ...
0
votes
0answers
168 views

create an automatic synchronized copy of data base

I have a system dsn(sqlserver odbc) configured on my computer. The DSN has multiple views of very large size. I want to create a local db that copies the selected view and keep it synced with the ...
1
vote
0answers
195 views

MYOB ODBC crashes SQL Server

A sister company of ours uses MYOB AccountRight Enterprise and has the read-only ODBC license available. The thing that is annoying them the most is what apparently annoys many a MYOB user: its ...
0
votes
2answers
58 views

In what way are Access tables linked with SQL server?

I have a mdb file with lots of OBDC linked tables that are linked to the tables in SQL server elsewhere. I can not see any information on how they are "linked". It is a little scary not knowing ...
1
vote
1answer
196 views

Linked Server using ODBC too slow

The scenario is that developers used a linked server object on ServerM to reach ServerST. This linked server was setup as a "SQL Server" type using a domain login that exists as a login on ServerST. ...
1
vote
5answers
697 views

Export data from a CCURE 800/8000 System using a pair of ODBC data sources?

I'm working on a security system called CCURE 800/8000 and trying to export some entrance / exit data from the Activity Monitor that logs when people use their badges to enter and exit the building. ...
2
votes
0answers
149 views

Slow query execution using ODBC 32

When executing a simple select query on a SQL Server 2012 system, the execution time is very different if I use OLE or ODBC 32bit. Unfortunately I am forced to use ODBC 32bit. The Query: SELECT ...
1
vote
0answers
143 views

Transfer an Advantage Database's Schema/Data to a PostgreSQL Platform Using C# Program

I am currently in the process of writing a .NET program with C# to transfer a database on a Sybase/Advantage 9.1 platform to a PostgreSQL 9.3.4 platform. I am doing this transfer in two stages - ...
0
votes
1answer
128 views

MonetDB ODBC driver memory allocation error on Windows

The driver is the latest from a month ago: 2014-SP2: 11.17.17, 64-bit. Windows is Server 2012. I have limited options to test whether earlier versions of the driver would work or this version works ...
2
votes
0answers
1k views

DB2 Query Error SQL0204N Even With The Schema Defined

I'm using Python to access tables in DB2 10.1.0 I have a login account named foobar and a schema with the same name. I have a table named users under the schema. When I'm logged in as foobar, I can ...
0
votes
1answer
184 views

ODBC configuration

I have an internal system which includes a Database and I'm also using QuickBooks Accounting package. Is there anyway I can sync my Quickbooks database with my internal system database? What I want to ...
1
vote
1answer
1k views

Using ODBC Connection to Access Firebird Database

I have an ODBC connection to a Firebird database that tests successfully. Is there a way to use this ODBC connection within SQL Server 2008 R2 to access the tables? I haven't used Linked Servers ...
0
votes
1answer
54 views

Linking Two database to execute join query

I have a remote odbc connexion and an MySQL database in my localhost i ask if there is a way to execute a join query ( linking the two database ) ? thanks.
2
votes
1answer
288 views

How can I connect to a network MySQL server using ODBC?

Somewhere on my company's network there's a (Oracle) MySQL server named FOO. I see FOO reference in SAS code written by my team's analysts, who use SAS's PROC SQL command to connect to it using ODBC. ...
1
vote
1answer
842 views

How to configure connection accessing Sybase Anywhere from Sybase IQ via ODBC on Linux

I'm trying to access an ASA16 server from IQ16 via ODBC driver. Both servers are installed on the same Linux box. I've installed unixodbc-bin and added a file .odbc.init into home of user running ...
0
votes
1answer
113 views

How to link a MySQL Table with a binary key into Access?

In MS Access I've created a linked table via ODBC to a MySQL table with a binary(16) primary key column (UUID). MS Access only shows the first row, all other rows have #deleted entries. I guess the ...
0
votes
3answers
301 views

How to create an Access query to find # symbol into a field?

It seems easy but I'm missing something. I have a MySQL database that is connected from access through ODBC connector. I'm looking for the fields where there are # symbol but I'm getting zero ...
1
vote
0answers
223 views

ODBC Connection Not Refreshing

I am trying to connect FedEx Shipping Manager Integration Assistant to a SQL 2008 R2 database. I have a view created that has all the necessary fields to populate in the Integration Assistant. The ...
1
vote
3answers
2k views

ODBC Microsoft Access Driver: Not enough space on temporary disk

I am running spatial modelling software that uses an Access database to store data needed for the computation. Each model run, data is loaded into the model from a Microsoft Access 2010 database using ...
0
votes
2answers
628 views

SQL ODBC silently truncating numeric data

We have a middleware that replicates data from an Oracle (11g) database to a SQL Server (2012) using ODBC connection to the destination. One of the tables has a NUMBER data type on Oracle and given ...
1
vote
0answers
31 views

How to restrict SQL Server database access to application or server running the application [duplicate]

I have a third-party application that connects to a SQL Server database via a SQL Server Native Client 10 ODBC data source. The application requires that each user of the application must have ...