Article View: borland.public.cppbuilder.database.ado
Article #1581Re: ADO, MS Access and MS SQL Server 2000
From: Simon Elliott
Date: Wed, 26 May 2004 06:54
Date: Wed, 26 May 2004 06:54
16 lines
1609 bytes
1609 bytes
On 26/05/2004, Viatcheslav V. Vassiliev wrote: > There are some differences in MS SQL Server and MS Jet (Access). So > just changing connection string may be not enough. > > You can use MSDE (MS SQL Server Desktop Edition - that ships with MS > Office, MS Visual Studio etc.) - it MS SQL Server will slow down if > there are more than 5 concurent connections (really this means that > usually you can have even 100 users) and limit databases to 2 GB. Thanks for this. Looks like installing MSDE would be a good idea. I've been given an export from SQL Server with all the data. Do you know if it would be possible to load this into MSDE? -- Simon Elliott http://www.ctsn.co.uk
Technical Details
Message-ID:
<40b43f36$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!controlnews3.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!news.tele.dk!news.tele.dk!small.news.tele.dk!npeer.de.kpn-eurorings.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<40b3af1d$1@newsgroups.borland.com> <40b43aaf@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,8abf2d740f25af17 X-Google-Attributes: gid10698b,public From: "Simon Elliott" <Simon at ctsn.co.uk> Subject: Re: ADO, MS Access and MS SQL Server 2000 Newsgroups: borland.public.cppbuilder.database.ado Reply-To: "Simon Elliott" <News at ctsn.co.uk> References: <40b3af1d$1@newsgroups.borland.com> <40b43aaf@newsgroups.borland.com> User-Agent: XanaNews/1.16.3.1 NNTP-Posting-Host: 82.152.41.49 Message-ID: <40b43f36$1@newsgroups.borland.com> Date: 25 May 2004 23:54:46 -0700 X-Trace: newsgroups.borland.com 1085554486 82.152.41.49 (25 May 2004 23:54:46 -0700) Lines: 16 Path: arc1-ca.pugleaf.net!controlnews3.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!news.tele.dk!news.tele.dk!small.news.tele.dk!npeer.de.kpn-eurorings.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail