So, the only changes I will need to make are "Syntax" changes to my ASP Sql statements(when going from Access to Sql Server). Are you sure all my "select, updates, deletes, inserts" will function properly?
Will Sql Server 6.5/7 work on any operating system, I have an Win NT 4.0 with IIS 4.0 (this is where my asp application resides), or will I have to move it to a new box like Windows 2003 Server. --- In [EMAIL PROTECTED], Michael Brinkley <[EMAIL PROTECTED]> wrote: > Well, if I remember correctly, about all you'll need to change besides your > connection string and any Access specific functions, is in your sql statements > change # to ' for the dates and % to * for your wildcards. > > --- worldsolutionmk <[EMAIL PROTECTED]> wrote: > > Hi everyone, > > > > Heres my problem: We have an ASP application that will probably go > > corporate wide. Our current data is sitting in an MS Access 2000 > > database. Were thinking of moving to SQL Server 6.5 or 7.0. Is it > > possible to just use the upsizing wizard that comes along with > > Access to migrate the database to SQL server db? Will my classic > > ASP connection string be the only thing that will have to change? > > Or will I have to make changes also to my SQL statements? If there > > are any other things I should be aware of please let me know,,,, I > > greatly appreciate anyones help! (we might even think of going > > to .NET ... but thats another topic). > > > > Thanks Again, > > > > Moe > > > > > > > > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Domains � Claim yours for only $14.70/year > http://smallbusiness.promotions.yahoo.com/offer ------------------------ Yahoo! Groups Sponsor ---------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/saFolB/TM ---------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
