Access databases other than through ODBC?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jim.brown1@gmail.com - 22 Nov 2006 13:52 GMT

I'm looking for a way to access databases (i.e., Oracle or MySQL) from
Excel. The obvious and current solution is to do this through ODBC. I
would prefer a more portable solution as ODBC requires the applicable
driver to be registered. My thought would be point to a file within
VBA that would allow for this. The reason for this, is for portability
- I would like to distribute an Excel file (along with the proper db
file) with connectivity to databases that don't have an ODBC driver
installed by default (i.e, MySQL).

Thank you.

Reply to this Message

CLR - 22 Nov 2006 16:53 GMT

Good luck. I'll be watching in hopes you get a good answer. Our MIS folks
won't allow access to any Oracle or SQL Server database except to specific
sign-on's from specific computers......I can't even go to another computer
and use my regular passwords and get in.......I also would like to distribute
Excel files that would allow the user to do queries as I've specifically
outlined by VBA within the file, but no luck yet..........

Vaya con Dios,
Chuck, CABGx3

> I'm looking for a way to access databases (i.e., Oracle or MySQL) from
> Excel. The obvious and current solution is to do this through ODBC. I
[quoted text clipped - 6 lines]
>
> Thank you.

Reply to this Message

aaron.kempf@gmail.com - 22 Nov 2006 20:04 GMT

buddy.. they' cant physcially enforce which computer you sign on FROM
using SQL Server

they can specify what USER is signing on.

but in order to have simple physical security like that; you're going
to need a real database server; like mySql for example

-Aaron

> Good luck. I'll be watching in hopes you get a good answer. Our MIS folks
> won't allow access to any Oracle or SQL Server database except to specific
[quoted text clipped - 16 lines]
> >
> > Thank you.

Reply to this Message