Connecting to a sql server from home.

Here is the problem, i'm sure there is quite a bit on google but i'mnot sure what to search for. I want to know how to connect to asql server from my home machine using the localhost for testing asp.netfiles out. At work the machines will connect fine usinglocalhost. The server we connect to is in another location. If someone could get me started on what to search for i wouldappreciate it.
Do you want to connect to the same SQL Server (which is at work), using 'Localhost'?
If so - you can't - localhost is used only for a Server which resides locally - on the computer where your web pages are residing.
(I'm not sure how you say it's using Localhost but, at the same time, you say it's in another location)
The SQL Server at work would become, by default, a 'remote' host - to do that, you'd need to use the IP address or the like, enter the username and password for it, and login that way - of course if it's using Windows Authentication, you'd need to work something else out...
Now - if you wanted to just work on pages, testing, etc...you could install SQL Server on your own computer and use localhost - but you'd need to have an identical database (you could do several things, like DTS, if the work computer is accessible outside the walls, along with other things)
|||Ok thanks for the reply.
This was what was throwing me off the computer i use at work doesn'thave sql server on it. The sql Server resides in Chicago and weare in TN. But when testing and using the local host it willconnect to the sql server fine. When i try the same thing at homei can not connect. I'll look more into remote hosting.
|||Is it possible your host has a firewall set up to only allow incoming connections from certain IP addresses (your work), and you need to ask someone to add your home IP address to those that are trusted by the firewall?

Connecting from Windows (VB6.0) app to SQL on Internet

Hello,
We have a client-server application written in VB 6.0 that connects to a
SQL Server instance on the local network. We're interested to know if we are
able to use our same VB 6.0 application but connect to a SQL Server that is
hosted on a web domain. That is, if we have our SQL database hosted by a
service provider on the internet, are we able to simply change our connection
string in our application so that we connect to this SQL Server instance and
not the SQL Server on the LAN? If possible we hope to avoid having to
rewrite our application as a .NET application...
Thanks.
Yes that's doable. It's not unusual to develop applications
locally and then change the connection string to access the
"live" database.
-Sue
On Fri, 21 Jan 2005 01:17:02 -0800, aglanz
<aglanz@.discussions.microsoft.com> wrote:

>Hello,
> We have a client-server application written in VB 6.0 that connects to a
>SQL Server instance on the local network. We're interested to know if we are
>able to use our same VB 6.0 application but connect to a SQL Server that is
>hosted on a web domain. That is, if we have our SQL database hosted by a
>service provider on the internet, are we able to simply change our connection
>string in our application so that we connect to this SQL Server instance and
>not the SQL Server on the LAN? If possible we hope to avoid having to
>rewrite our application as a .NET application...
>Thanks.
|||In your connection, you would specify the IP address of the hosting server.
http://www.able-consulting.com/ADO_Conn.htm
"aglanz" <aglanz@.discussions.microsoft.com> wrote in message
news:9E786AE0-5D0C-48DA-86BC-B39F9871CC03@.microsoft.com...
> Hello,
> We have a client-server application written in VB 6.0 that connects to
a
> SQL Server instance on the local network. We're interested to know if we
are
> able to use our same VB 6.0 application but connect to a SQL Server that
is
> hosted on a web domain. That is, if we have our SQL database hosted by a
> service provider on the internet, are we able to simply change our
connection
> string in our application so that we connect to this SQL Server instance
and
> not the SQL Server on the LAN? If possible we hope to avoid having to
> rewrite our application as a .NET application...
> Thanks.
|||Hi,
Can you please let me know how did you connect vb6.0 with MS-SQLServer in a network(LAN)?Iam facing a problem of connecting MS-SQLServer with vb6.0 on the network what i mean is clients cant access the sqlserver?
Regards
Jack

Quote:

Originally posted by aglanz
Hello,
We have a client-server application written in VB 6.0 that connects to a
SQL Server instance on the local network. We're interested to know if we are
able to use our same VB 6.0 application but connect to a SQL Server that is
hosted on a web domain. That is, if we have our SQL database hosted by a
service provider on the internet, are we able to simply change our connection
string in our application so that we connect to this SQL Server instance and
not the SQL Server on the LAN? If possible we hope to avoid having to
rewrite our application as a .NET application...
Thanks.

Connecting from Windows (VB6.0) app to SQL on Internet

Hello,
We have a client-server application written in VB 6.0 that connects to a
SQL Server instance on the local network. We're interested to know if we ar
e
able to use our same VB 6.0 application but connect to a SQL Server that is
hosted on a web domain. That is, if we have our SQL database hosted by a
service provider on the internet, are we able to simply change our connectio
n
string in our application so that we connect to this SQL Server instance and
not the SQL Server on the LAN? If possible we hope to avoid having to
rewrite our application as a .NET application...
Thanks.Yes that's doable. It's not unusual to develop applications
locally and then change the connection string to access the
"live" database.
-Sue
On Fri, 21 Jan 2005 01:17:02 -0800, aglanz
<aglanz@.discussions.microsoft.com> wrote:

>Hello,
> We have a client-server application written in VB 6.0 that connects to
a
>SQL Server instance on the local network. We're interested to know if we a
re
>able to use our same VB 6.0 application but connect to a SQL Server that is
>hosted on a web domain. That is, if we have our SQL database hosted by a
>service provider on the internet, are we able to simply change our connecti
on
>string in our application so that we connect to this SQL Server instance an
d
>not the SQL Server on the LAN? If possible we hope to avoid having to
>rewrite our application as a .NET application...
>Thanks.|||In your connection, you would specify the IP address of the hosting server.
http://www.able-consulting.com/ADO_Conn.htm
"aglanz" <aglanz@.discussions.microsoft.com> wrote in message
news:9E786AE0-5D0C-48DA-86BC-B39F9871CC03@.microsoft.com...
> Hello,
> We have a client-server application written in VB 6.0 that connects to
a
> SQL Server instance on the local network. We're interested to know if we
are
> able to use our same VB 6.0 application but connect to a SQL Server that
is
> hosted on a web domain. That is, if we have our SQL database hosted by a
> service provider on the internet, are we able to simply change our
connection
> string in our application so that we connect to this SQL Server instance
and
> not the SQL Server on the LAN? If possible we hope to avoid having to
> rewrite our application as a .NET application...
> Thanks.