Questions tagged [odbc]
In computing, ODBC (Open Database Connectivity) is a standard software interface for accessing database management systems (DBMS).
0
votes
0answers
18 views
Issues with getting the ODBC driver to correctly work with Wine on Ubuntu 18.04
I am having issues with getting the ODBC driver to correctly work with Wine on Ubuntu 18.04. Under "Wine Control > Drivers" I can see the Windows ODBC Driver 17 however when I try to associate it with ...
0
votes
0answers
12 views
Excel, ODBC - desired database not listed
When I attempt to create an ODBC to a server (named DARKHELMET for all you spaceballs fans out there) it doesn't show in the list of available data sources.
..but it does show up under data source ...
0
votes
1answer
36 views
PowerQuery ODBC connection revokes password: due to auto-refresh?
I have a nice PowerQuery query that connects with ODBC to a database. Our passwords change every month. When I enter GetAndTransform to edit the query, that time of the month - even if I don't ...
1
vote
1answer
53 views
How to create an odbc string connection in an excel spreadsheet to make it portable instead of setting up an odbc connection on every computer?
I'm setting up an excel reporting using Excel 2013 for that.
The spreadsheet is retrieving data, through an odbc connection that I need to set on every computer in order to retrieve the data.
I ...
0
votes
2answers
80 views
Migrating multiple User DSN connections (ODBC)
I'm looking for a way to migrate multiple User DSN connections (ODBC) from an old server to a fresh new server.
In the registry i can only see the saved User DSN connections of my own user, is there ...
0
votes
1answer
278 views
32-bit ODBC32 system DSN on Windows 10 apparently not able to access network
I have an application which runs correctly on most of my machines here.
Two of them stopped working for no reason that I could fathom (same updates as all the others, same network settings, same ...
0
votes
0answers
570 views
[unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.1.so.0.1
I am trying to run windows command line program that uses ODBC to connect to a remote MSSQL server. It works fine in Windows 10. Now I want to run the same program in Linux using Wine. I have ...
0
votes
0answers
19 views
How to know/contact a community which hold an API (ODBC API)
I am currently working with the unix-odbc API to create my own ODBC driver.
I found on wikipedia that ODBC is a standard and is implemented by communities.
In computing, Open Database ...
0
votes
1answer
358 views
How can we disable ODBC credentials popup in excel
Can we disable the ODBC credential popup on refresh of external data
in Excel 2016:
and, if so, how?
2
votes
1answer
112 views
How does an OLEDB/ODBC connection know the path to a SQL Server database by name only?
If i have a connection string like this that I use in a Data Connection in Excel to get data from a SQL Server database:
OLEDB;
Provider=SQLOLEDB.1;
User ID=MY_USERNAME;
Password=MY_PASSWORD;
Persist ...
0
votes
2answers
1k views
Use a Cell Value for a Paramater Value using in Power Query
I am using a query like below in power query Excel 2016:
let
Source = Odbc.Query("dsn=AS400", "select * from libm61.emleqpm1 where STN1 = '03' ")
in
Source
I want to replace '03' with a ...
1
vote
0answers
200 views
Linked Server between Progress database and MS SQL Server management studio
I wish to set up a linked server within MS SQL Server Management 2014 to access my PROGRESS DB. The Linked Server will allow us to update the tables etc and then run our queries off of SQL Server.
I ...
4
votes
2answers
299 views
Link to Skyward Database to MS SQL Server
I am trying to connect Skyward Database( Progress Database ) to MS SQL Server. What am I doing to connect?
First Setup an ODBC connection to the Progress database in the ODBC Administrator in the ...
0
votes
0answers
160 views
Odbc connection with Sqlserver Progress openEdge
I am working on the MS SQL server so I want to connect MS SQL Server to progress OpenEdge Database and import all data from OpenEdge to SQL Server through ODBC. I add driver from Data sources in ...
0
votes
0answers
20 views
Why is the database tab not functional in Crystal Reports 9?
I have a particular report that I can run, it prompts for an Oracle username and password and then generates the report. The Database tab is not fully available. I cannot select Database Expert or set ...
0
votes
1answer
476 views
ODBC working only with sudo
I'm having troubles with unixODBC. I've installed the latest version and currently is working only with sudo. To test the ODBC I've used isql. Example:
# isql -v testTable
[IM002][unixODBC][Driver ...
1
vote
1answer
214 views
InstallAnywhere issue: This application has unexpectely quit
I have downloaded IBM Client SDK 4.10 FC5DE for Windows x64. When I proceed to install it, InstallAnyWhere popups saying "Preparing installation files...". When it reaches to 100% below error is shown ...
0
votes
0answers
810 views
Export the ODBC Driver of ODBC Data Source Administrator
I am trying to export the following IBM INFORMIX ODBC DRIVER of the ODBC Data Source Administrator as viewed below:
I understand that the ODBC driver is installed in the registry and Program Files (...
1
vote
0answers
53 views
Oracle ODBC Error 12170 - Accessing over Internet
I have Oracle 8i on Windows XP 32 connected to a router. I have installed Oracle client v10 (64 bit) on Windows 7 64 laptop connected to the same router. I am able to make & successfully test ...
0
votes
0answers
23 views
Frontier 6.2.1 ODBC Connection
We've got an application that's using a Frontier (UserLand) database. I'm not at all familiar with this type of system or object-oriented database structures in general. So, I'm trying to connect with ...
1
vote
1answer
58 views
ODBC trace that has been activated but how can I deactivate it?
My colleague has activated an odbc trace to troubleshoot the issue we currently have.
But alas he has created another issue e.g the tracing is activated each time we are running the msaccess program ...
0
votes
1answer
413 views
What is the difference between OLE DB and ODBC in relation to a Crystal Reports datasource connection?
I'm relatively new to Crystal Reports and I'm testing out various report viewers. When I made my report in Crystal reports, apparently I used an OLE DB connection to the data source, in this case SQL ...
0
votes
1answer
8k views
Windows 10 unable to add Visual FoxPro ODBC driver
I am attempting to add the Visual FoxPro ODBC driver to my list of active data sources, but am unable to do so.
I have installed the latest driver downloaded directly from microsoft, and I have found ...
0
votes
1answer
185 views
Cannot get external odbc connection to work in excel
I created a 32 bit DSN and tested it with winsql and can browse the catalog and do queries. Using excel 2013 32-bit if I do get external data from other data sources > from data connection wizard > ...
1
vote
0answers
185 views
How to use an ODBC file source (.DSN) to export to excel with defined location but no defined filename, bringing up “select workbook”
How can I set up a DSN to direct to a specific location, but then allow me to select the file rather than writing to a specific file.
[ODBC]
DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *....
0
votes
1answer
401 views
how to install a visualfox pro odbc on windows 7?
I'm currently on a windows 7 laptop, on which I want to install a visualfoxpro driver.
On Microsoft's page, it says Visualfoxpro's ODBC driver has been discontinued.
I've used instead Microsoft OLE ...
3
votes
1answer
3k views
Retrieve ODBC DSN Password
Recently I inherited a web server and nobody knows the password to the ODBC connection that talks to the Sql database.
The screen in particular that is asking for the pass looks like:
I tried ...
0
votes
0answers
178 views
How to avoid login multiple times when having multiple connections to the same Teradata database in one Excel Sheet?
I have an Excel 2010 document with several tables fetching data from different views in the same Teradata database using ODBC DSN connections.
When I refresh the tables I am prompted to enter my ...
0
votes
1answer
930 views
ODBC connection to Cisco UCCX
I followed this guide to successfully create an ODBC connection to UCCX, but using the 32bit driver. I need to use the 64bit driver and the GUI changed dramatically.
My 64 bit ODBC settings
Below is ...
0
votes
0answers
491 views
System ODBC not visible to user
We have made a couple of ODBC connections on the System DSN with the admin account. They are not visible to the users. This in Windows 7 with 64 bit OS. What do I need to do to get them visible. Let ...
0
votes
0answers
16 views
Reading an Access-compatible File w/ Access
I have a .dfm file extension, which I can read in Microsoft Access 2010 (by selecting All Files *.* in the open menu). When I open this file it says it's an "Access 2000" file. Microsoft Access 2010 ...
2
votes
1answer
255 views
ODBCAD.exe same datasource in system32 and syswow64
Currently i want to proof, which odbc data sources are configurated on a windows server 2008 R2 machine. When i open system32/odbcad32.exe and SysWow64/odbcad32.exe, they contains the same sources (64-...
2
votes
1answer
746 views
Connection failed, Access denied connecting to MySQL via ODBC on Windows
I know nothing about MySQL or Linux and am tasked with migrating a MySQL DB to MS SQL. I found a tool for that but it requires an ODBC connection so I downloaded the MySQL Connector/ODBC and installed ...
0
votes
0answers
817 views
Access ODBC connection made on another PC?
I have made an ODBC connection on a Windows XP machine.
I have another Windows 8 machine on the same network. I want to access that ODBC connection on XP from the Windows 8 machine without having to ...
0
votes
1answer
287 views
Installing 16bit ODBC driver on modern pc
I need to use AcuODBC drivers which are 16bit. They currently run on Windows XP but it is an old pc with little processing speed and 2gb ram. I wish to upgrade to a faster pc with 16gb ram.
These ...
1
vote
0answers
711 views
How to install SQL Server ODBC driver on OSX?
I'm using MySQL Workbench on a Macbook to migrate a SQL Server database to MySQL. When I try to connect to SQL Server I get the error:
The ODBC driver that was selected for the source connection ...
0
votes
1answer
2k views
SQL server missing in ODBC
I installed a SQL Express server on a 32-bit Windows 2008 server r2. I installed this while installing a Phoenix fueling station program. When I am trying to add a user DSN in ODBC I am unable to find ...
0
votes
0answers
74 views
Alternative option for select * from
In the Excel database query we will use the below syntax to define a reference value
SELECT * FROM [Sheet1$A1:Z500] where Dept = 'IT'
In the above case I am taking the Dept value IT as a reference ...
2
votes
2answers
4k views
VBA Automation error when querying database through ODBC
I am trying to run Excel macro to query some data from my ODBC database.
My database details are as below:
DSN: sgdv UID:l8qc1 Password:l8qc1 server:sgdv
I am trying to query the data from ...
0
votes
1answer
305 views
MS Access won't connect to linked Visual Fox Pro after Symantec Endpoint Update
We have an end user used MS-Access database which connects to a Visual Fox Pro directory of .dbf files via linked tables and an ODBC DSN. This worked fine until Symantec Endpoint Protection installed ...
3
votes
1answer
12k views
ODBC Data Source Driver 'Does Not Exist' After Updating to Windows 10
I received the following errors in the Microsoft ODBC Data Source manager (64-bit), for my data source an MS Access DB (.accdb), after updating to Windows 10 from 7 and uninstalling MS 2010 and ...
3
votes
2answers
16k views
Windows 10 Visual FoxPro ODBC Issue
I just upgraded from windows 7 64 to Windows 10 64. Now I am having problems with the Visual FoxPro driver. I am using the 32-bit ODBC manager (C:\Windows\SysWOW64\odbcad32.exe). When I try to add or ...
1
vote
1answer
946 views
SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
I am running a PHP script on a RedHat server using Teradatas ODBC drivers.
<?php
$conn = odbc_connect("Teradata", "username", "password");
$result = odbc_exec($conn, 'SELECT count(*) FROM table');...
0
votes
2answers
26k views
Microsoft ODBC driver can't find Oracle Instant Client
I have an old 32-bit software program that connects to an Oracle database but only works with the Microsoft ODBC driver for Oracle. It does not work with the more up-to-date native Oracle ODBC driver....
1
vote
1answer
55 views
Why does ODBC connection from win2k (to ASA 8) stop working after moving workstation from LAN to VPN connection?
Background of my question is, from a local network we take one workstation, and connect it again via VPN from a home office.
I thought, a connection via VPN would be the same as if the computer were ...
1
vote
1answer
841 views
Impact of adding a 32-Bit ODBC driver to a 64-Bit Win Server 2008 R2
Would there be no problem if i ADD another ODBC driver to a server (a 32bit version to cater my 32bit PHP application) with an existing ODBC 64bit version? Would it not create confilict to other ...
2
votes
2answers
1k views
odbc error connecting mysql: “sql server does not exist or access denied”
For a few weeks now I have been trying to create an odbc connection with microsoft access and a mysql database on webhost server with no luck whatsoever.
I have no problem connecting to the database ...
0
votes
2answers
866 views
Unable to make ODBC connection on Ubuntu 14.04
I usually access an ODBC connection through a CentOS server, and I'm trying to make the same connection locally on my Ubuntu Trusty laptop. So far as I can tell I've duplicated everything properly ...
0
votes
1answer
57 views
Mysql won't show my databases (MYSQL-WIN7)
I create a database using workbench and don't find this database at ODBC list, I'm able to see only information_schema database. I tried to restart my machine but don't solve the issue.
Could you ...
0
votes
1answer
385 views
Which ODBC connection properties have higher priority ?
I take data from PostgreSQL via ODBC and put the data in excel worksheet. For this I use VBA which makes a query table. In the VBA script I specify a connection string which contains some ODBC ...
