Hey Phillip, Did you figure out your IP / instance problem in MX? I'd like to know the answer if you figured it out... Thanks. Robert Berndt
-----Original Message----- From: Robert Berndt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 3:27 PM To: SQL Subject: RE: instances of SQL ( 7.0 and 2000 ) running with MX Well, I don't know if this will help you or not, but in JSP, JDBC Urls usually begin with "jdbc:subprotocol:subname" the sample connection to an Oracle database would be: connection = DriverManager.getConnection("jdbc:oracle:thin:dbhost:1548:ORCL", "user", "password"); Hope this helps... Robert Berndt -----Original Message----- From: Phillip B. Holmes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 3:44 PM To: SQL Subject: instances of SQL ( 7.0 and 2000 ) running with MX We have multiple instances of SQL ( 7.0 and 2000 ) running with MX and can no longer connect to the secondary 2000 instance. In CF 5.0 I simply put the instance name on the end of the IP as follows: 216.203.150.522\sql2k Since MX is JDBC, this no longer works. Any suggestions? Respectfully, <cf_developer> Phillip B. Holmes Media Resolutions Inc. Macromedia Alliance Partner http://www.mediares.com [EMAIL PROTECTED] 1-888-395-4678 ext. 101 972-889-0201 ext. 101 </cf_developer> Please send support requests to [EMAIL PROTECTED] ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
