Rafael,
Your connectionstring should be:
cConnString = 'Driver={SQL Native Client};Server=
\\123.456.345.1\SQLEXPRESS;Database=datos;Trusted_Connection=yes')
You simply precede the \SQLEXPRESS with the IP address or the URL of the
target machine.
Dave Crozier
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf
Of Rafael Copquin
Sent: 2009-02-05 10:37
To: [email protected]
Subject: Re: remote access with sqlserver express 2005
Thank you Rick. I thought of that, too, and it seems like a good idea.
However, I still want to know how to connect directly, ie, a branch computer
accessing the server via the internet, with no VNC.
In my local machine I use the following connection string:
cConnString = 'Driver={SQL Native
Client};Server=RAFAELPC\SQLEXPRESS;Database=datos;Trusted_Connection=yes')
What should I add to it in order to connect to the server, which has a fixed
IP ?
Is it something like:
cConnString = 'Driver={SQL Native Client};Server=
\\123.456.345.1\RAFAELPC\SQLEXPRESS;Database=datos;Trusted_Connection=yes')
Please?
Rafael
----- Original Message -----
From: "Rick Schummer" <[email protected]>
To: <[email protected]>
Sent: Wednesday, February 04, 2009 10:13 PM
Subject: RE: remote access with sqlserver express 2005
>>>But in my ignorance, I have no clue on how to establish an IP connection
>>>from the branches to
> SQLServer.<<
>
> You should use a VPN connection. If you set the VPN up you reference the
> SQL Server via the
> servername\instance just like you would inside your network. The VPN
> establishes a secure connection
> and you don't have to expose the ports to the general Internet.
>
> Rick
> White Light Computing, Inc.
>
> www.whitelightcomputing.com
> www.swfox.net
> www.rickschummer.com
>
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/31d3288c6e2049b3b9a5f4e6bff66...@develop
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
