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

learn more… | top users | synonyms

0
votes
0answers
506 views

How can I use the ODBC connection of another computer on my network?

I'm not sure if I need to look at this problem a different way but here goes. Computer A (windows XP) has an SSH Tunnel to the web server. Port 3306 on the web server is tunneled to port 3306 on ...
5
votes
1answer
6k views

Anyway to use SSMS to connect to MySql?

I've grown to love SQL server management studio (ssms), I realise that it is not naturually compatible, however is there a way of connecting to MySQL? Perhaps using an ODBC connection? I realise ...
2
votes
0answers
364 views

Access 2010: The Oracle client and networking components were not found

I've installed these Oracle client and ODAC files required for "Microsoft ODBC for Oracle": ODAC112021Xcopy_32bit win32_11gR1_client But alas it will not work! I'm on Windows 7, using Access 2010. ...
1
vote
1answer
740 views

Querying big databases with Excel

Is it possible to use Excel's pivot table as a kind of query builder against a database, without copying the entire database into Excel? I know that with the External Data Sources feature, you can ...
0
votes
2answers
16k views

What ports does MS SQL Server use for ODBC connections?

I require our firewall to allow ODBC connection from clients to the MS SQL Server. Which ports should be opened for this?
3
votes
2answers
8k views

How do I configure ODBC DSNs in Windows Server 2003 and Windows 7?

I haven't done this in quite a while, but years ago I have set up DSNs for an ODBC connection using Windows 2000 and maybe Windows XP. I remember there being a Data Sources or ODBC icon to click in ...
0
votes
1answer
701 views

Export data from ODBC to CSVs or similar

I have a SQL Anywhere 5 database which I can currently access through ODBC. I managed to open it with Access but when I used Access to export text files it would truncate the data. Is there a way ...
0
votes
1answer
706 views

Linked Query in MS Access 2007 to SQL database - ODBC error - How do I see the linking details?

I am converting an old Access 2003 database to 2007. It has a query linking to a SQL database. How do I look at the link, e.g., whether it using a DSN, etc.? The query has the globe to the left of ...
3
votes
2answers
10k views

Windows 7 ODBC Text Driver

Some software requires me to setup an ODBC Text Driver. In the Windows 7 Control Panel > ODBC Data Source Administrator, the only driver available is "SQL Server". How do I find/download/install a ...
2
votes
1answer
4k views

How do I automate creation of an ODBC connection in the system DSN?

I need to create an ODBC connection in System DSN on a bunch of windows machines. What can I do to make this process simpler than manually typing the details into the Create New Datasource Wizard on ...
1
vote
1answer
116 views

Dealing with modal popups in Dynamics GP when running as a Remote Application in Terminal Services

Running GP10 as a Remote Application in Terminal Servers (W2K8). The multi-analysis tool requires ODBC credentials, when it executes against the database, to build the data cube. Unfortunately, ...
2
votes
2answers
2k views

Database access through odbc driver and excel

Is it possible to access a database via ODBC and access this in MS Excel or OpenOffice, then exporting the database into a flat file? The program I am accessing data only allows an ODBC connection ...
0
votes
1answer
175 views

What configuration for DSN access in Apache?

I am configuring a standalone Apache Http Server (2.2.16, on Windows. Can be XP or more recent) to communicate with J (standalone as in not XAMPP or other packages). I can get my list of user DSN's in ...
1
vote
0answers
58 views

Update Billing Email Addresses in Sage MAS90

I have been tasked with trying to find a method of updating about 500 customer email addresses in MAS90. I recently discovered that they had the ability to email invoices to their customers and ...
1
vote
2answers
3k views

Problem creating ODBC connection to SQL Server 2008 with Vista

Well, I'm trying to get a database schema thing working, first I tried just doing it in Linux where I'm more comfortable, but ODBC seems to be a hack there and I couldn't get it to work. So I figured ...
0
votes
1answer
580 views

is using Hosts for resolving a sql-server more performant?

we have a legacy application which uses a access.mdb with hundreds of ODBC-connected tables on a sql-server. the access.mdb contains nothing else than these odbc-connections. Now we consider to use a ...