In computing, ODBC (Open Database Connectivity) is a standard C programming language interface for accessing database management systems (DBMS).
0
votes
0answers
16 views
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I am trying to open a program for the first time on Windows XP Pro that uses PostgreSQL 9. I'm getting an error message that says :
A problem was encountered while trying to log into or create the ...
2
votes
0answers
21 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
27 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
35 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
123 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
210 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
110 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
465 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
379 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
572 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
337 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
168 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
269 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
585 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
93 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
335 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
234 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
935 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
107 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
184 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
172 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
584 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
227 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
776 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
175 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
217 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
837 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
976 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
372 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
239 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
246 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
634 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
788 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
489 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
597 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 ...
