Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    India
    Posts
    2

    Arrow Unanswered: VB without SQL Client Please Help VV Urgent

    Hi,
    Please help me, when i install my VB application to the client i have to install the "SQL client Network Utility" to connect to database without that i cant conect please help me how can i solve this.
    I cannot distribute "SQL client Network Utility" to all clients and i need database connectivity.

    i am using simple ADO and sample code is

    glbstrConnection = "driver={SQL Server};server=" & ServerName & ";uid=" & UserID & _ ";pwd=" & Password & ";database=" & DatabaseName

    Cnn.Open glbstrConnection
    Cnn.CursorLocation = adUseClient


    Please Help its very Urgent

  2. #2
    Join Date
    Aug 2002
    Location
    india
    Posts
    41

    tcp ip 1433 to 2048

    Hi,

    There is a possiblity of default tcp ip properties or settings You can change the default settings from 1433 to 2048.

    procedure is as follows -

    start ->program -> mssqlserver ->clientnetwork utility -> tcpip -> properties -> change from 1433 to 2048.

    give me the feedback ....

    thnx regds

    ranjan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •