Change port for SQL Server connection

[Jonathan Blitz]

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."

 

[Thomas A. Rowe]

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

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Jonathan Blitz]

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."

 

[Thomas A. Rowe]

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)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Jon Spivey]

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.

 

[Jim Buyens]

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)
|/---------------------------------------------------
*----------------------------------------------------