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

learn more… | top users | synonyms

1
vote
1answer
234 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 ...
1
vote
1answer
647 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
106 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
83 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 ...
0
votes
1answer
452 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
328 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 ...
1
vote
1answer
650 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
639 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
59 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
2k 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
333 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
894 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
1k 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
323 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
315 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
81 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
517 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. ...
2
votes
5answers
1k 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
283 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
214 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
199 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 ...
3
votes
0answers
2k 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
313 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
2k 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
75 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.
3
votes
1answer
470 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. ...
2
votes
1answer
1k 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
178 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
685 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
411 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
4k 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
1k 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 ...
0
votes
2answers
562 views

Queries hang when accessing Oracle via ODBC and Python

I have Python scripts running on a Windows 2003 server that access an Oracle 11g database in the US via VPN. I am in the UK. We have recently moved offices and upgraded our broadband speed. Some of ...
1
vote
1answer
259 views

Access Linked Tables and Their Network Connections

I need to know some simplistic details about how Microsoft Access' linked tables work. I think I know the answer, and this question is more about asking for a confirmation than anything else. A ...
0
votes
1answer
3k views

Converting .TPS (TopSpeed) to SQL

I have an older application that uses TopSpeed as the database engine. I want to use some of the data contained in these tables in another application that uses SQL. To accomplish this, I purchased ...
1
vote
3answers
852 views

Connecting to Oracle Database with ODBC/Python

We've recently installed a new piece of software that uses an Oracle Database to store the data. My goal is to connect to that database and pull the data from the back end to do analysis on. I'm ...
2
votes
1answer
825 views

Installing Netezza 6.0.8 ODBC driver on Windows Server 2008

Below are four Netezza drivers that are available for Netezza 6.0.8. I installed the second one on Windows Server 2008, and it placed it into the system32 folder (64 bit folder). However, when I set ...
1
vote
1answer
4k views

How to run DB2 export command in shell

I am trying to run the following DB2 command through the Python pyodbc module: DB2 export to C:\file.ixf of ixf select * from emp_hc I am successfully connected to the DSN using the pyodbc module in ...
0
votes
0answers
1k views

Push Data from MySQL to SQL Server

I am not sure if my title is correct, but I will try my best to explain the current problem. Current Scenario: I have a php web application with MySQL database (let's call it DB1) which is stored ...
1
vote
2answers
257 views

Postgres ODBC driver versions

On the Postgres ODBC driver page the name for each file is of the form: psqlodbc_09_01_0100-x64.zip psqlodbc_09_01_0100.zip psqlodbc_09_01_0100-1.zip psqlodbc_09_01_0200-x64.zip ...
2
votes
0answers
138 views

ODBC - how to set up ODBC driver for 2 languages (for different code page)

How to set up an ODBC driver to operate the Polish code page (1250) and Lithuania (1257) at the same time? Although the code page Lithuanian is wider than the Polish code page, the driver incorrectly ...
0
votes
0answers
626 views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)! in Fedora16

I installed MariaDB server in linux using tar file(mariadb-5.5.28a-linux-i686.tar.gz) followed by the instructions from this link : https://kb.askmonty.org/en/installing-mariadb-binary-tarballs/. ...
4
votes
2answers
4k views

Access 2010 linked table - solve the “decimal field's precision” error

I have an Access 2003 database (running on Win 7 64-bit, Office is also 64-bit) that has many linked tables pointing to an Oracle 11g instance through 64-bit Oracle ODBC driver. Most of the tables ...
1
vote
1answer
870 views

Connect to SQL Server using OLEDB or ODBC?

We have a desktop application written in Visual Basic .NET. One our clients needs to use ODBC instead of OLEDB to connect to the SQL Server 2008 R2 Database. The company has several databases ...
10
votes
1answer
80k views

ODBC Data Source SQL Server Connection - Login Failed For User

I have moved my database from an SQL 2005 to a server with SQL 2008. I am now trying to create an ODBC Data Source. I am using "With SQL Server authentication using a login ID and password ...
1
vote
2answers
6k views

Import Excel Table to SQL Server - with date column

I'm trying to import a excel table that has a column with dates. My query works without the column date. I'm using ODBC to import. strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & ...
0
votes
1answer
3k views

How do I connect to a database which is a linked server via ODBC?

(All the searches for this sort of thing tell me about where the linked server is connecting to the original database via ODBC, but I'm connecting to the intermediate server via ODBC.) I have a ...
1
vote
0answers
937 views

Connection to MS Access from Oracle over a DB Link

I need to establish a connection between a MS Access database, which is placed on a network share on a windows box, and an Oracle database on a Unix Box. I need to query the Access tables from the ...