connect to a remote server

hi,



i'm not sure how or if this is possible...



i'm at the company network that's setup for coldfusion
application (CF 8).



i need to create an ODBC to a SQL server that is NOT in the
local network.. it's at a remote datacenter.



i tried this:



jdbc:microsoft:sqlserver://SERVERNAME;DatabaseName=DBNAME

com.microsoft.jdbc.sqlserver.SQLServerDriver



with the username/password



i get this error message:

connection verification failed for data source: DBNAME

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC]Error establishing socket.

The root cause was that: java.sql.SQLException:
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing
socket.





is this possible or how can i fix... thanks!











connect to a remote server
Remote access will be better served by ColdFusion's built in
JDBC drivers. Use the IP address of the db server, db name, and
standard username and password in the config for the MS SQL
driver.connect to a remote server
Hello guys, I'm trying to do something similar. I need to be
able to query a remote mySQL db from a CF server.

Basically what I'm trying to do is this:



1) User selects x amount of products on a website hosted on a
PHP Server, where the mySQL DB is.

2) The he submits the form to a CF page on a different
server.

3) This CF page then queries the remote DB with the info
received from the PHP website and shows the results in a PDF file
using CFDocument tag.



Is this possible?



Thanks a lot



Dani Szwarc

Thiez Multimedia

www.thiez.com