On Mon, May 5, 2008 at 10:13 AM, Vince Teachout <[EMAIL PROTECTED]> wrote:
> Paul Hill wrote: > > On Mon, May 5, 2008 at 3:20 PM, Vince Teachout <[EMAIL PROTECTED]> > wrote: > > > >> <used wrong address - sorry if duplicate> > >> > >> I have a vendor questionnaire that I need to fill out and return > today, > >> and it deals with SQL Server named instances, which I know nothing > about. > >> > >> I'm in the process of googling madly, but given that we're running > >> vfp9, using ODBC to a SQL2005 back end, does anyone know what the > answer > >> to these two questions is LIKELY to be for VFP apps in general? > Thanks. > >> > > > > My experience is limited in this area but as far as I can tell the > > only difference with a named instance is in the server name. Instead > > of 'MyServer' you use 'MyServer/Instance' in the connection string. > > > > You can easily test this yourself by installing SQL to a named > > instance on your PC (or use SQL Express which by default installs a > > named instance). > > > > > Thank you - after a lot of fretting and googling, I realized that my > SqlExpress WAS a named instance. But it's nice to have it confirmed. > Thank you! > ---------------------------------------- To give you the full story. An instance is an independent server engine on your box. So the same beefy server can host your ourCompany\Production as well as ourCompany\Staged and ourCompany\Test. Good idea for ourCompany\HotBackup If something goes STUPID in staged say a migration of schema you can down that instance and not harm your Production. Your connection string needs the name of the instance to connect. you will have to go to the configuration manager for SQL Server 2005 to open these new instances for use. HTH -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
