Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 7th, 2005, 02:10 AM
Authorized User
Join Date: Jul 2003
Posts: 71
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Server 2000 on Windows XP SP2 -- HELP ASAP

From Windows XP SP1 I have decided to shift to XP SP2(not by update), I have set the port 1433(example only) in the exception of windows firewall. To my surprise I can no longer connect to the server using TCP/IP Protocol(DBMSSOCN).

This is my code in Visual Basic 6

    If chkNT.Value Then
        pstr = ";integrated security=sspi"
        pstr = ";User ID=" & txtUser & _
        ";Password=" & txtPassword
    End If

   mconnstr = "Provider=sqloledb;" & _
              "Network Library=DBMSSOCN;" & _
              "Data Source=" & txtIpAddress & ",1433;" & _
              "Initial Catalog=Mydatabase" & pstr

Even if I turn off the firewall I cant connect, What are the other things that I must configure.:crying:

Proud To Be Pinoy
Proud To Be Pinoy

Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP - Access 2000 Runtime w Windows XP Compiled.. chasidim Access 2 April 3rd, 2006 11:06 AM
MS Analysis 2000 and WINDOWS XP Prof SP2 ZoroAstris SQL Server 2000 0 April 21st, 2005 04:44 AM
SQL server 2000 developer Edition on XP Pro sevdon SQL Server 2000 1 January 6th, 2005 11:52 PM
Migrate Access XP to SQL Server 2000 Walden Access 1 September 21st, 2003 01:54 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.