Jim Moss
jim.moss at jlmoss.net
Wed Jan 25 12:36:34 CST 2006
Ed, It probably has more to do with security than any other factor. My major client won't allow me to have any connection to Oracle of any type due to their security guidelines. My data tables are populated by the users running reports daily, saving them and kicking off Monarch processes that's part of an ETL load to my access backends. Jim > Assuming you have password authorization why not. > > http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForOracleFromMicrosoft > > I would use OLEDB > Open the Control Panel and start the ODBC Data Sources applet. > To see what ODBC and OleDB drivers you have installed. > > Open an Oracle database using ADO and ODBC > http://www.vb-helper.com/howto_ado_oracle.html > > > Tesiny, Ed wrote: > >>To access our agency's data we have to use this %$#@& Oracle tool called >>Discoverer. Could one access Oracle tables using Access as a front end >>through an ODBC connection. If so, would it be a big deal to set this >>up. The last time I asked, the IT answer was we can't do that. Never >>got a why we can't do that??? Anyway, that person is now gone and I'm >>wondering if I should give it another try. >>Any thoughts/advice appreciated. >>Ed >> >>Edward P. Tesiny >>Assistant Director for Evaluation >>Bureau of Evaluation and Practice Improvement >>New York State OASAS >>1450 Western Ave. >>Albany, New York 12203-3526 >>Phone: (518) 485-7189 >>Fax: (518) 485-5769 >>Email: EdTesiny at oasas.state.ny.us >> >>_______________________________________________ >>dba-Tech mailing list >>dba-Tech at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/dba-tech >>Website: http://www.databaseadvisors.com >> >> >> >> > > -- > Marty Connelly > Victoria, B.C. > Canada > > > > _______________________________________________ > dba-Tech mailing list > dba-Tech at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-tech > Website: http://www.databaseadvisors.com >