What happens to db connection when changing to SQL

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

What happens to db connection when changing to SQL

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> What happens to db connection when changing to SQL

Page: [1]


arnie Posts: 209 From: Gobbler Knob, Indiana Status: offline	What happens to db connection when changing to SQL - 1/14/2002 18:58:54 Would experiment myself, but time is short to make a decision to "switch now or later." If I change to SQL Server from Access 2000, will I have to click through all DRWs to make work (once the db connection has been redirected to the SQL db?) Hope not - there are tons of them... Thanks! Arnie Howes


Spooky Posts: 26603 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: What happens to db connection when changing to SQL - 1/14/2002 22:55:49 At the simplest level, you would open your site live, and edit the existing database connection in the tools > web settings to point to the new SQL connection ��k� Database / DRW Q & A VP-ASP Shopping cart Spooky Login (in reply to arnie)


Rayne Posts: 68 From: AL USA Status: offline	RE: What happens to db connection when changing to SQL - 1/14/2002 23:53:44 I would think that as long as you are using the DRW, you would just have to change the db connection then verify it. Rayne www.raynecountry.net (in reply to arnie)


arnie Posts: 209 From: Gobbler Knob, Indiana Status: offline	RE: What happens to db connection when changing to SQL - 1/15/2002 7:57:38 Thanks- I'm hoping it's that simple. I knew that I would have to redirect the connection but was paranoid that the multitudes of DRWs might need work. After 2 1/2 years, I still don't take this assistance for granted. Spooky, Thomas & everyone - thanks again for providing this forum... Arnie Howes (in reply to arnie)


Spooky Posts: 26603 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: What happens to db connection when changing to SQL - 1/15/2002 15:06:19 About the only thing to keep an eye on (if they arent simple DRW queries) is handling of dates ��k� Database / DRW Q & A VP-ASP Shopping cart Spooky Login (in reply to arnie)


arnie Posts: 209 From: Gobbler Knob, Indiana Status: offline	RE: What happens to db connection when changing to SQL - 1/15/2002 15:08:40 They're simple enough. I bet it will work - hope to try some tonight. You really should watch those sheep... Arnie Howes (in reply to arnie)