Results 1 to 2 of 2

Thread: Please hepl Me!!

  1. Jan 11th, 2002, 04:09 AM #1
    cuong
    cuong is offline

    Thread Starter
    Junior Member
    Join Date
    Nov 2001
    Location
    VietNam
    Posts
    23

    Wink Please hepl Me!!

    Thank for looking My Question !!
    I have a question that is:
    Our company Have a Wan network ( We Have the lease line) So Can anybody have know about that answer Me that Can I use Visual Basic connect to sql on the Wan network ? If The answer is OK so what about the speed ?
    Thanks advance !
    Reply With Quote Reply With Quote
  2. Jan 11th, 2002, 04:51 AM #2
    alex_read
    alex_read is offline
    Evil Genius alex_read's Avatar
    Join Date
    May 2000
    Location
    Espoo, Finland
    Posts
    5,538
    Yes you can connect to an SQL Server on the network by passing the IP address in :
    Code:
    "Provider=sqloledb; Data Source=255.255.225.0,4040; Network Library=DBMSSOCN; Initial Catalog=Database1; UID=UserName; pwd=Password"
    The 4040 bit is the port number for the IP address. As for the speed, works like a charm - I've had no problems with my webservers connecting & you won't see a difference between a local or network SQL server.

    Regards,
    Alex

    Please rate this post if it was useful for you!
    Please try to search before creating a new post,
    Please format code using [ code ][ /code ], and
    Post sample code, error details & problem details
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width