Re: [MLUG] MySQL and DB access with ODBC and MS products

[Jason McIntosh <EMAIL:PROTECTED>]

Usually, you can use the installed ODBC drivers.  I usually setup a 
file DSN, make it network sharable, setup a registry script so that 
everyone loads the script which sets the File DSN location to that 
network path.  Then, you use the MyODBC driver (which should have a 
common registry name), your file DSN, and you've got a common 
configuration for all your applications.
Hope that makes some sense.  The thing is, any ODBC driver when 
installed should be able to be loaded.  You just have to setup the DSN 
config stuff to make use of that driver.
Cheers!
Jason

Jason McIntosh
Programmer/Analyst
University of Missouri
573-884-3865
GnuPG Key: http://poetshome.com/pubkey.asc
On Tuesday, August 5, 2003, at 1:20 PM, Davis, Ryan W. (UMC-STUDENT) 
wrote:

> Guys,
>
> So, we have a bunch of Vision Drawings and Excel Spreadsheets that we
> are looking to tie into a DBMS so that when we update one (say an excel
> spreadsheet) the visio drawing is altered to reflect those changes. 
> Now,
> I know that you can connect to an ODBC compliant server through Excel
> and Visio. The thing is that I have not been able to find much
> information on how. Do I need separate MyODBC driver for Office 
> products
> or do I use a specific one currently installed? It doesn't seem like
> they have a specific generic ODBC driver but the only one I found that
> is not MS is a Oracle ODBC driver. Have any of you ever done this
> before? Any help is appreciated.
>
> Ryan Davis
> Network Programmer Analyst
> IAT Services - DNPS
> University of Missouri-Columbia
> (573)882-2759
> EMAIL:PROTECTED
>
>
> _______________________________________________
> members mailing list
> EMAIL:PROTECTED
> http://mlug.missouri.edu/mailman/listinfo/members

_______________________________________________
members mailing list
EMAIL:PROTECTED
http://mlug.missouri.edu/mailman/listinfo/members