[thelist] Connecting to remote daabase?
Brian Cummiskey
Brian at hondaswap.com
Tue Aug 9 13:08:51 CDT 2005
looks like a MS SQL box. if its not, this probably won't apply.
Provider=SQLOLEDB.1;UID=abc456;Password=******;Persist Security
Info=False;Initial Catalog=abc123;Data Source=fubar.url.com:1433
of course, fill that in with the right stuff :p
the firewall on their end that the sql box is behind will need to port
forward 1433 to the sql box. verify that with them before you even
attempt to conenct (it should be up if they gave you the port.. but you
never know-- 1433 is the default sql port, and if they have more than 1
DB server, you might have connection probelms, as it needs to be
specified on the firewall which one to go to on the domain)
you would use the DSN to conenct to the box for queries w/ odbc. and
that depends on the language you are using for the site it self.
Casey wrote:
> I'm doing some sub-contracting for a new client, and he gave me the following information on the database to which I need to connect:
>
> Database Name:
> abc123
>
> SQL Login:
> abc456
>
> SQL Password:
> xxxxxx
>
> TCP/IP Server Name:
> fubar.url.com
>
> SQL Server Port:
> 1433
>
> DSN on Web Server:
> abc789
>
>
>
> I have no idea how to build a connection string to a remote database.... is this even possible? any point in the right direction would be great.
>
> Thanks!
More information about the thelist
mailing list