Solved

Pass through query in Access 2000 to MVSDB2 mainframe prompts for ODBC.

Posted on 2012-03-19
4
345 Views
Last Modified: 2012-03-19
I am trying to find out why when doing a pass through query to an MVSDB2 mainframe table from access 2000, the odbc prompt pops up? How do you invoke a specific odbc within the query? TIA
0
Comment
  • 2
  • 2
4 Comments
 
ID: 37738692
picture of query and prompt
example.bmp
0
 
LVL 28

Accepted Solution

by:
omgang earned 500 total points
ID: 37738721
View the property sheet for the query.  You'll see a field/property named ODBC Connect Str.  This is where you can enter a DSNless connection string, e.g.

ODBC;Driver={Microsoft ODBC for Oracle};UID=OMGang;PWD=MyPassw0rd;SERVER=MyOracleServer;

OM Gang
0
 

Author Closing Comment

by:selectallfrompeoplewhereclueisnotnull
ID: 37739460
I would add that you have to open the query in design mode and right click on the title bar to get the correct properties to open. Took me a few minutes to find.
0
 
LVL 28

Expert Comment

by:omgang
ID: 37739588
Glad you found it.  Getting the property sheet differs between versions so I was waiting to see if you'd ask how and indicate which version.  In 2007 and later there's an option on the ribbon to show property sheet.
OM Gang
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now