We have built a web site using Frontpage and SQL Server.

Now we need to change the port used by the database.
How can I change the port in Frontpage?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."

You don't, you change the port in your connection string.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Jonathan Blitz" <((jb))@anykey.co.il (remove brackets)> wrote in message
news:(E-Mail Removed)...
> We have built a web site using Frontpage and SQL Server.
>
> Now we need to change the port used by the database.
> How can I change the port in Frontpage?
>
> --
> Jonathan Blitz
> AnyKey Limited
> Israel
>
> "When things seem bad
> Don't worry and shout
> Just count up the times
> Things have worked themselves out."
>
>

Where exactly do I change it?
When I define a connection there doesn't seem to be anywhere to enter it.

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
"Jonathan Blitz" <((jb))@anykey.co.il (remove brackets)> wrote in message
news:(E-Mail Removed)...
> We have built a web site using Frontpage and SQL Server.
>
> Now we need to change the port used by the database.
> How can I change the port in Frontpage?
>
> --
> Jonathan Blitz
> AnyKey Limited
> Israel
>
> "When things seem bad
> Don't worry and shout
> Just count up the times
> Things have worked themselves out."
>
>

It could be in your global.asa file, if one is being used. There are many ways to create a
connection to a database. Without having login access to your site, only you can determine how you
are connecting to the database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Jonathan Blitz" <((jb))@anykey.co.il (remove brackets)> wrote in message
news:(E-Mail Removed)...
> Where exactly do I change it?
> When I define a connection there doesn't seem to be anywhere to enter it.
>
> --
> Jonathan Blitz
> AnyKey Limited
> Israel
>
> "When things seem bad
> Don't worry and shout
> Just count up the times
> Things have worked themselves out."
> "Jonathan Blitz" <((jb))@anykey.co.il (remove brackets)> wrote in message
> news:(E-Mail Removed)...
> > We have built a web site using Frontpage and SQL Server.
> >
> > Now we need to change the port used by the database.
> > How can I change the port in Frontpage?
> >
> > --
> > Jonathan Blitz
> > AnyKey Limited
> > Israel
> >
> > "When things seem bad
> > Don't worry and shout
> > Just count up the times
> > Things have worked themselves out."
> >
> >
>
>

Hi,
if you're hand coding your connection string you'd have something like
strConn=
"provider=sqloledb;uid=you;pwd=secret;server=10.10.10.10,1500;database=pubs"

This would connect on port 1500 - obviously replave 10.10.10.10 with the IP
of your sql server. If you're using FP to create the connection click
Tools - Site Settings - Database - Add check Network Connection to Server
hit Browse and then in the server name box type 10.10.10.10,1500 - again
this will connect to a sql server at ip 10.10.10.10 on port 1500, modify to
suit.

--
Cheers,
Jon
Microsoft MVP

"Jonathan Blitz" <((jb))@anykey.co.il (remove brackets)> wrote in message
news:(E-Mail Removed)...
> Where exactly do I change it?
> When I define a connection there doesn't seem to be anywhere to enter it.
>
> --
> Jonathan Blitz
> AnyKey Limited
> Israel
>
> "When things seem bad
> Don't worry and shout
> Just count up the times
> Things have worked themselves out."
> "Jonathan Blitz" <((jb))@anykey.co.il (remove brackets)> wrote in message
> news:(E-Mail Removed)...
> > We have built a web site using Frontpage and SQL Server.
> >
> > Now we need to change the port used by the database.
> > How can I change the port in Frontpage?
> >
> > --
> > Jonathan Blitz
> > AnyKey Limited
> > Israel
> >
> > "When things seem bad
> > Don't worry and shout
> > Just count up the times
> > Things have worked themselves out."
> >
> >
>
>

Choose Siote Setting from the Tools menu, then click
Database.

Select your database connection, then click Modify.

Set Type Of Conenction to Custom Definition, then enter a
string such as this in the assiciated text box:

"Provider=sqloledb;Data Source=190.190.200.100,1433;
Network Library=DBMSSOCN;Initial Catalog=pubs;
User ID=sa;Password=asdasd;"

Where 190.190.200.100 is the SQL Server IP address and
1433 is the port.

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


>-----Original Message-----
>We have built a web site using Frontpage and SQL Server.
>
>Now we need to change the port used by the database.
>How can I change the port in Frontpage?
>
>--
>Jonathan Blitz
>AnyKey Limited
>Israel
>
>"When things seem bad
> Don't worry and shout
> Just count up the times
> Things have worked themselves out."
>
>
>.
>