Changing Sql7 TCP Port

From: Mike (mikenospam_at_com.nospam)
Date: 12/08/04

  • Next message: Russell Fields: "Re: 'No login mapping' error message" 
    Date: Wed, 8 Dec 2004 14:34:37 -0500

    If the website is running on the same machine as the sql server, and the DSN
    connection string in each website has the IP address hard coded and no port
    specified in the connection string, does the port have to be hard coded in
    each DSN if the default sql server port is changed in the conection manager
    on the same machine?

    Thanks....

  • Next message: Russell Fields: "Re: 'No login mapping' error message"

    Relevant Pages

    • Re: Connection string question
      ... If this is a web site, ... Your connection string would be more suitable for a Windows Forms ... Hitchhiker's Guide to Visual Studio and SQL Server ... the root of the website. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: dsn connection
      ... of processing and file IO to accomplish the same thing. ... All a DSN does is ... store information that you can put right into your Connection String. ... > points to the SQL Server and DB? ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Client applications
      ... and you'll find many ways to build a connection string without a DSN. ... I have been given the responsibility of upgrading a client application ... with database authentication with SQL Server. ...
      (comp.databases.ms-sqlserver)
    • Re: Copying an SQL database, to a memory stick, to transfer to a lapto
      ... asking for his connection string info ... Actually, if it is a SQL Server Express database, a copy would suffice on ... I'm new at SQL server databases, and I've been tring to copy a ASP.NET ... website from a desktop PC to a memory stick, and then to a lap top PC ...
      (microsoft.public.sqlserver.server)
    • Re: URGENT- Unable to connect to the SQL Server
      ... Check out this website ... Locke ... > I need some help urgently regarding the code to connect to the SQl Server ... > connection string or so. ...
      (microsoft.public.dotnet.languages.vb)