connec to sql server 2000 through inter net

Posted on 2006-04-30
Last Modified: 2013-12-25
i have pos system in head office (server) and clients ( 7 diffrent location)
when we add new item in the head office i must go to all the location to import this new items to the system so they can use it

the problem now we open 3 new clients in diffrrent city in the same country so to add new items i need to travel to this 3 cites

can i connect all the clients to the head office directly if i add new item to the head office(server) then all the clients can use the new data online direct without gooing and importing the new data to other location and is it useful (speed)

any helps please

i use vb6 programming (ado)

Question by:abdulhameeds
    LVL 9

    Accepted Solution

    if have static ip over internet you can access your server by changing the connection string like

    Driver={SQL Server};Server=<your Server IP address comes here>;Database=<your db name>;Uid=user;Pwd=asdasd;

    try this and give feedback
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    you need to use the Server IP address that is visible on the internet, and of course ensure that the port 1433 is open in the firewall for the offices that try to connect to your sql server.
    LVL 4

    Author Comment

    thanks all this is my connection string

    On Error GoTo OCError
       Set adoPOSACC = New ADODB.Connection
        sAttributes = "DATABASE=" & DATABASENAME & vbCr & "Description=VISPOS" & vbCr & "OemToAnsi=No" & vbCr & "Server=" &
        RegisterDatabase "VISPOS", "SQL Server", True, sAttributes
        VisConn.CursorLocation = adUseClient
        VisConn.Open sConnectString

    i try to put the ip not work with me
    the network domain error

    i tryied the ip
    LVL 9

    Expert Comment

    first tell us whether it is working on web server or in your organizations personal server? If it of your organization's one then it should have the public IP address which one was visible for the entire internet. Then only u can use that MS SQL server. Or try to buy a web hosting account from Service providers They will have the server with Public IP address. So that you can access that database from anywhere otherwise it is not possible to access your SQL server over internet(network).

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Introduction While answering a recent question ( in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
    Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now