re: Change port for SQL Server connection

From: Jim Buyens (news_at_interlacken.com)
Date: 08/05/04 

Date: Wed, 4 Aug 2004 20:52:37 -0700

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

Relevant Pages

  • Re: Selective Database Results hurdle
    ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ... In your first DRW page, on page 2 of the wizard, you need ... and townname is the database field for the town ... Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.client)
  • Re: template and database pages
    ... Thomas A. Rowe (Microsoft MVP - FrontPage) ... "Jim Buyens" wrote in message ... > reserveations about hitting this database once per page hit anyway. ... > Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.client)
  • re: import data
    ... >data received through a Com Port from an external source. ... or database would be relatively simple. ... Microsoft FrontPage MVP ... || Web Database Development Step by Step .NET Edition ...
    (microsoft.public.frontpage.client)
  • re: Database Results Error
    ... the database connection info. ... Microsoft FrontPage MVP ... Live site, just recently I have put an online directory ...
    (microsoft.public.frontpage.client)
  • Re: asp.net pages
    ... If you want to run ASP.NET pages, you need to find a hosting service ... Microsoft FrontPage MVP ... >> access my Access database. ...
    (microsoft.public.frontpage.client)