Solved

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

Posted on 2012-03-19
4
343 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

758 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

25 Experts available now in Live!

Get 1:1 Help Now