openReport over ODBC to Oracle

[kistemaker]

Hi, I could need your help.

I am working with ACC97 as frontend and Oracle9 as database. All Queries are made as pass-through-queries. Everything looks fine, but I can't handle the OpenReport to the remote Database.

When I start the DoCmd.OpenReport, the ODBC-View pops up and I have to fill out the popup manually. But I like to set the database-name and the pwd only one time during the opened access.

Is it possible, to give the Connection string to the openReport Command ?

Or is there an other feature?


Thank you for helping me

[zzqxxq]

MS Knowledge Base Article KB101084 does not EXACTLY deal with your issue but does shed some light as to where you might look to troubleshoot.

It states: "For Microsoft SQL Server, Sybase SQL Server, and ORACLE Server databases, your SQL database administrator can choose to disable this feature, requiring all users to enter their login IDs and passwords each time they connect to a SQL database."

The "feature" they are referring to is: "In Microsoft Access, when you link (or attach in Microsoft Access 2.0 or earlier) a SQL database table, you can choose whether you want Microsoft Access to store your login ID and password locally. If you do not, Microsoft Access prompts you for your login ID and password each time that you connect to the SQL database containing the table."

The bold part (above) seems to indicate that there might be a system setting that would if turned off, makes you login each time you access the Oracle back end

Hope that helps - best regards,