In computing, ODBC (Open Database Connectivity) is a standard C programming language interface for accessing database management systems (DBMS).
2
votes
0answers
17 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 ...
1
vote
0answers
24 views
Is there a generic SQL-92 ODBC 64-bit Mac driver for Python?
I have a 4D SQL database which implements SQL-92.
4D's ODBC driver does not work on my system because it is compiled for 32 bit (and I am on 64 bit) and it is closed source.
I wonder if there is ...
1
vote
0answers
26 views
MySQL Federated acces to PostgreSQL table
For example 2 DBases:
DBMS Postgresql
DBMS MySQL
In each DB include one DB and one table in it. Can I work with table in PostgreSQL through MySQL?
Is it possible to link as federated postgresql ...
0
votes
0answers
112 views
Unable to configure Informatica sources with ODBC 64 bit drivers
I have an Oracle database installed on my local system (64 bit) and am trying to use Informatica as an ETL tool.
My problem is that my database is working fine (I am able to connect to it via ...
0
votes
0answers
30 views
SQL Server connection failed for normal domain user [duplicate]
I have SQL Server 2008 R2 SP1. I am using connection string to connect to SQL Server.
In connection string I am passing the driver path, server name, TCP port number, user name with which I want to ...
0
votes
0answers
207 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/.
...
0
votes
0answers
108 views
What are the improvements of OpenOffice Base and LibreOffice Base in the last 2 years? [closed]
I wonder how the database parts of the 2 products have changed or improved in the last 2 years.
I need a tool for working with ODBC Databases, MS Access and SQL Server and I have been using the old ...
2
votes
0answers
435 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
352 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 ...
3
votes
1answer
2k 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
470 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
296 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
164 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 ...
4
votes
2answers
1k views
MS Access / MySQL: unlock locked Records
I have a Microsoft Access database that is connected to a MySQL server via ODBC and is accessed by multiple users.
Over time many records are locked and editing is not possible anymore.
Is there a ...
1
vote
0answers
257 views
SELECT value from database over ODBC wont reach the software
SQL Server 2008 R2 latest updates.
SQL server ODBC driver version 6.01.7601.17514
PS!!! native drivers are incompatible with the software so i cannot use them.
I cannot edit or change the server ...
3
votes
1answer
563 views
SQL Server ODBC Mirror/Failover Partner
Background/Context
We are in the process of moving our SQL Server 2000 databases to a mirrored SQL Server 2008 R2 server with a witness and automatic failover. We have both .Net and Access ...
2
votes
1answer
90 views
Good tool for simulating many threads doing INSERTS UPDATES SELECTS and DELETES on an ODBC database?
I've done load testing on a web application already using tools like JMeter, and tested my database for transactional integrity.
But are there any tools for testing an ODBC connected database (like ...
0
votes
0answers
28 views
Duplicate Customer Records for SQL Query from ODBC with Joins and Group Bys [duplicate]
Possible Duplicate:
SQL Query with ODBC, Joins and Group Bys
I am getting duplicate customer records with the query below. The main purpose of the query is to pull a list of customers into ...
2
votes
5answers
324 views
SQL Query with ODBC, Joins and Group Bys
I am having issues with the statement below. The main purpose of the query is to pull a list of customers into an Access db from ODBC (our customers are stored in DB2 on IBM i). The query is ...
0
votes
0answers
233 views
busy with results for another hstmt - one table only issue
321 08/08/12 06:40:51 : Query : select MemberCount from tbl_guild where serial = 6
322 08/08/12 06:40:51 : SqlState:HY000, NativeError:0 Msg:[Microsoft][ODBC SQL Server Driver]Connection is busy ...
2
votes
2answers
840 views
How can I set up a read only odbc connection?
I have a user that needs to do queries on an SQL Server 2008 database that I administrate. They have rights to edit the data, but I'd rather they weren't able to do it directly against the table ...
0
votes
0answers
100 views
Connecting to a remote production MS-Access 2003 database that has Workgroups with SquirrelSQL?
I'm trying to connect to an MS-Access 2003 database using SQuirrelSQL and the JDBC-ODBC Driver.
I have the database shared on a network share mounted on drive D:
In SQuirrelSQL, I add an Alias like ...
0
votes
1answer
178 views
How to extract a whole database schema using only ODBC access?
I need to migrate an old proprietary database (custom database based on a Btrieve engine) to a newer system . All I have to access this database is an ODBC driver that works pretty well. When I ...
5
votes
1answer
171 views
SQL Server Linked server query problem (group by)
I have been using an old SQL Server 2000 installation for a long time that is linked to several Oracle servers, and it all works very well.
I am trying to migrate to SQL Server 2012 via SQL Server ...
1
vote
1answer
546 views
Why do I only see SYS and INFORMATION_SCHEMA tables? Access 2007 ODB to SQL Server 2008
I was finally able to create my ODBC connection but now when I go to External Data > ODBC > LINK TABLES using my ODBC connection in Access 2007 I get a huge list of tables such as
...
2
votes
2answers
224 views
SQL Server 2008 ODBC
My SQL Server 2008 is located on a remote computer so I am trying to create an ODBC connection using SQL Server Authentication.
My problem is that the way i normally connect to my SQL Server is by ...
2
votes
1answer
733 views
Informatica Source Qualifier not working from Windows ODBC data source (system DSN) from Excel xlsx file
Reference:
https://community.informatica.com/message/62128
Windows ODBC Workflow:
Windows > Control Panel > Administrative Tools > Data Sources (ODBC) > click "System DSN" menu > click "Add" > ...
2
votes
0answers
174 views
MYSQL & Access ODBC
I am trying to connect mysql with access, i am settings up the ODBC correctly from the data sources, however i get a driver error.
I am using access 2010 and the driver version of the ODBC conector ...
3
votes
2answers
215 views
Remove nulls from TSQL connection string
I have a bunch of queries, against a couple different databases, that I use to generate delimited reports. I'm trying to create some new reports against a MSSQL database and I'm having trouble ...
0
votes
1answer
791 views
Access ODBC reserved error 7711
I have user who is trying to access some tables from our Microsoft SQL Server 2008 R2 system (which very recently got moved to a brand new hardware/software stack) using Access 2007 via an ODBC ...
3
votes
1answer
867 views
Converting Microsoft SQL Server collation to UTF 8
I've a Rails-Application, which reads data from a Microsoft SQL Server 2008 R2 Database.
All umlauts are represented by a '?', so I checked the encoding of the database. The encoding is 'Latin 1'. ...
1
vote
0answers
362 views
What can cause [DataDirect][ODBC Oracle Wire Protocol driver]Connection refused.?
The Title speaks for itself.
We have this error message on the client side of the application.
The devs suspect a problem on the database.
The alert log on the database shows no errors at all.
The ...
2
votes
3answers
230 views
Can I limit access to postgresql 8.4 databases via ODBC on the server side?
I have a bit of a tricky problem at the moment that I could really use some help to solve. I'll do my best to explain it but please feel free to ask questions :-)
We have a postgresql 8.4 database ...
1
vote
1answer
242 views
schema shows through standard client connection but not through ODBC connection?
Hoping you can help!
The Gist
When I log into an Oracle 11g DB using SQL Developer or DBVisualizer, I can see schemas and execute queries against them.
However, when I use the same credentials to ...
3
votes
1answer
602 views
Foreign Key constraint on fixed value field
Note: I am a developer...
I have an Asset table that has many codes that are foreign keys into a second table OutlineFiles. The OutlineFiles table has Type and Code as the primary key. The foreign ...
3
votes
1answer
770 views
MS Access displays alle columns in SQL Server tables as “deleted”
I have created an ODBC connection to a SQL Server 2005.
When I link to the tables from MS Access, some tables have only "deleted" data.
This means the rows and columns are displayed, but all data ...
3
votes
1answer
482 views
Ms-access ODBC calls for linked table behaviour
I'm curious if anyone knows how ms-access goes about generating ODBC calls for linked tables.
The reason I ask is that I'm trying to make the front-end of a system super efficient and too minimise ...
4
votes
1answer
594 views
How to make iSQL/FreeTDS behave like a normal client?
I have a third-party Sybase database, which my users would like to connect to and query from a Linux box, using iSQL. I have installed UnixODBC and FreeTDS. As it is third-party database however, I am ...
