connect to a remote server

[Guest]

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!

[CutterBl]

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.

[Dani Szwarc]

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