You will need to be able to connect tot he distant machine via ODBC DSN.
Once you have this you can go to the CF administrator and verify the
connection. Cold Fusion just requires an ODBC connection to pass the SQL
command to the database. If you need help creating an ODBC connection
that's a different discussion, but I would be happy to help.
I hope this helps, if you need more assistance just let me know.
Thanks,
Robert Filipovich
----- Original Message -----
From: "CFTALK" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 09, 2000 4:36 AM
Subject: Querying a distant Sybase server
> Hello,
>
>
> I am trying to send a SQL query from my coldfusion (NT 4) server to a
> distant server (NT 4)hosting Sybase 11.
> Is it possible, or does the ColdFusion server have to be on the same
machine
> than the SybaseSQL server ?
>
> If it is, how will the code look like ? Is there any declaration to make
in
> the ODBC connections on the cold fusion server machine ?
>
>
> Thanks a lot !
>
>
>
> Olivier.
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
