SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 09:05 PM
| ||||
| ||||
 Creating ODBC link within SELECT statement Is this possible. To explain myself, here is my situation. I created an Excel Spreadsheet that uses an ODBC link to a SQL database. In order for anyone to use this file on their PC, that same ODBC link must be setup. Is their some code I can use within a Select Statement that will allow me to bypass having to create an ODBC on everyone's PC? Thanks.      |
|
02-27-2008, 09:06 PM
| ||||
| ||||
| Re: Creating ODBC link within SELECT statement Hi Preacher Man, You've cross-posted this to a bunch of newsgroups, some of which, for example microsoft.public.fox.vfp.queries-sql, don't even apply to your question. What you haven't done is post to a relevant Excel newsgroup. Try posting this question (and your other one) there. Someone will probably tell you that you can use a connection string or a DSN-less connection as described here: http://support.microsoft.com/kb/q165866/ . (GoogleGroups helped me find that.) -- Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP cindy_winegarden@msn.com www.cindywinegarden.com "Preacher Man" <nospam> wrote in message news:uFEmV7eJGHA.3936@TK2MSFTNGP10.phx.gbl... > Is this possible. To explain myself, here is my situation. I created an > Excel Spreadsheet that uses an ODBC link to a SQL database. In order for > anyone to use this file on their PC, that same ODBC link must be setup. > Is their some code I can use within a Select Statement that will allow me > to bypass having to create an ODBC on everyone's PC? > > Thanks. > |
Linear Mode
