Article View: borland.public.cppbuilder.database.ado
Article #1579ADO, MS Access and MS SQL Server 2000
From: Simon Elliott
Date: Tue, 25 May 2004 20:39
Date: Tue, 25 May 2004 20:39
18 lines
1545 bytes
1545 bytes
I need to quickly put together a program which will work with MS SQL Server 2000. The only problem is, SQL Server is not currently running here and I don't currently possess a copy of it. If I use ADO (TADOConnection etc) and create the relevant tables in MS Access, and develop and test the application, would it only be a matter of changing the connection string to get the app to work with SQL Server? Are there any risks in proceeding on this basis? I'm not familiar with the cut down version of SQL Server which is supplied with MS Office 2000 Pro. Can I cerate and populate tables using this version? Thanks in advance for any advice or information! -- Simon Elliott http://www.ctsn.co.uk
Technical Details
Message-ID:
<40b3af1d$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!npeer.de.kpn-eurorings.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,8abf2d740f25af17,start X-Google-Attributes: gid10698b,public From: "Simon Elliott" <Simon at ctsn.co.uk> Subject: ADO, MS Access and MS SQL Server 2000 Newsgroups: borland.public.cppbuilder.database.ado Reply-To: "Simon Elliott" <News at ctsn.co.uk> User-Agent: XanaNews/1.16.3.1 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 NNTP-Posting-Host: 82.152.41.49 Message-ID: <40b3af1d$1@newsgroups.borland.com> Date: 25 May 2004 13:39:57 -0700 X-Trace: newsgroups.borland.com 1085517597 82.152.41.49 (25 May 2004 13:39:57 -0700) Lines: 18 Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!npeer.de.kpn-eurorings.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail