Good afternoon,
I've a question regarding converting Oracle SQL Statement to Microsoft Access. I need to monitor DB's and I would getting data into MS Access direct. I've installed ODBC driver and got connection to Oracle DB's. Now when I trying to get data from Oracle DB (like tablespace size, free space etc) I'm getting error, because I took just the same SQL Statement that I used on Oracle DB. But MS Access is not able to recognize all oracle commands. I'm not an expert in DB's and just would to know what should I do to get data in MS Access? It should be anyway free and on Windows. Is there any way to get data from Oracle without rewrite and adjust sql statements to MS Access.
Thank you.
I've a question regarding converting Oracle SQL Statement to Microsoft Access. I need to monitor DB's and I would getting data into MS Access direct. I've installed ODBC driver and got connection to Oracle DB's. Now when I trying to get data from Oracle DB (like tablespace size, free space etc) I'm getting error, because I took just the same SQL Statement that I used on Oracle DB. But MS Access is not able to recognize all oracle commands. I'm not an expert in DB's and just would to know what should I do to get data in MS Access? It should be anyway free and on Windows. Is there any way to get data from Oracle without rewrite and adjust sql statements to MS Access.
Thank you.
Comment