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

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
selectallfrompeoplewhereclueisnotnullAsked:
Who is Participating?
 
omgangConnect With a Mentor IT ManagerCommented:
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
 
selectallfrompeoplewhereclueisnotnullAuthor Commented:
picture of query and prompt
example.bmp
0
 
selectallfrompeoplewhereclueisnotnullAuthor Commented:
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
 
omgangIT ManagerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.