Moving .asp with ODBC Data Source to Production Server

[Kristen Wagner]

Thanks in advance for any suggestions:

I created a set of .asp pages using FP2000 which interact with a SQL Server
database, all of which resides on a development server. I used the DBRW and
ODBC for the connection. Now I need to move the entire project to the
production server. Is there any way I can alter the data source pointer in
the .asp files without losing everything I've done?

Kristen Wagner

 

[Jim Buyens]

-----Original Message-----

Thanks in advance for any suggestions:

I created a set of .asp pages using FP2000 which interact
with a SQL Server database, all of which resides on a
development server. I used the DBRW and ODBC for the
connection. Now I need to move the entire project to the
production server. Is there any way I can alter the data
source pointer in the .asp files without losing everything
I've done?

Kristen Wagner

Yes, just open the production site directly in FrontPage
and then build/modify the connection to suit.

Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*

 

[Kristen Wagner]

Right--but when I change the data source the DBRW wants to re-create
everything, and I've done quite a bit of custom sql that I don't want to
lose.

Kristen Wagner

 

[Jim Buyens]

-----Original Message-----
Or, I should say, I've done a lot of customizing of the data results. I
don't want to have to re-create everything.

Right.

Open the production site directly in FrontPage, choose Web
Settings from the Tools menu, click the Database tab, and
create a connection with the same name that you used in
test, but pointing to the productiopn database.

Assuming your test and production databases have the same
schema, this should require no change to the Web pages
themselves.

Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*

 

[Kristen Wagner]

Yep, that will do it! The databases are identical.

Thanks, Jim.