Re: CF, jdbc, SQL2k5 problem

2006-10-11 Thread Dan Plesse
Andrew, Should be jdbc:macromedia:sqlserver://#server_URL#:#port#/ Interesting CF does not allow a custom property file to be loaded with the JDBC URL. Add that to the CF 8 wishlist. prop file location with a browse button. On 10/10/06, Andrew Scott [EMAIL PROTECTED] wrote:

Re: CF, jdbc, SQL2k5 problem

2006-10-10 Thread Dan Plesse
I think what is needed here is a good old look see of your JDBC URL. Nothing else is needed. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers,

Re: CF, jdbc, SQL2k5 problem

2006-10-10 Thread Andrew Scott
jdbc:sqlserver:/stargate\dbinstanceone:1433;DatabaseName=StoneCutters On 10/10/06, Dan Plesse [EMAIL PROTECTED] wrote: I think what is needed here is a good old look see of your JDBC URL. Nothing else is needed. ~|

Re: CF, jdbc, SQL2k5 problem

2006-10-10 Thread kurt schroeder
2006 12:38 PM To: CF-Talk Subject: RE: CF, jdbc, SQL2k5 problem You can't connect using an instance name. You will need to use the IP socket corresponding to the instance. I'm not so sure about that. I believe i used an instance name at a client and it worked see: http://www.adobe.com

Re: CF, jdbc, SQL2k5 problem

2006-10-10 Thread kurt schroeder
Mobile: 0404 998 273 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, 10 October 2006 12:38 PM To: CF-Talk Subject: RE: CF, jdbc, SQL2k5 problem You can't connect using an instance name. You will need to use the IP socket corresponding to the instance

RE: CF, jdbc, SQL2k5 problem

2006-10-09 Thread Mark A Kruger
I'm interested in what you are using for server/instance ... .NET can access AD or NetBIOS (friendly server) names to access the server instance - but you will need an IP or (better) an FQDN to access it via JDBC. Perhaps you can post your settings from CF Admin. -mark Mark A. Kruger, CFG, MCSE

RE: CF, jdbc, SQL2k5 problem

2006-10-09 Thread Dave Watts
I have the works, on one box for testing. and it all functions except for the ColdFusion connection to the SQL2K5. I even created a few dot.net apps for testing and they connected fine! The other, possibly related symptom is that i can not create an ODBC data source eather. A side note is

Re: CF, jdbc, SQL2k5 problem

2006-10-09 Thread kurt schroeder
I have the works, on one box for testing. and it all You can't connect using an instance name. You will need to use the IP socket corresponding to the instance. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized

RE: CF, jdbc, SQL2k5 problem

2006-10-09 Thread Dave Watts
You can't connect using an instance name. You will need to use the IP socket corresponding to the instance. I'm not so sure about that. I believe i used an instance name at a client and it worked see: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18294 but can't get it to

RE: CF, jdbc, SQL2k5 problem

2006-10-09 Thread Andrew Scott
this was automatically set to port 1771. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, 10 October 2006 12:38 PM To: CF-Talk Subject: RE: CF, jdbc, SQL2k5

Re: CF, jdbc, SQL2k5 problem

2006-10-09 Thread Aaron Rouse
I thought this was needed so did it the first couple of times I setup MSSQL 2005 on boxes. The last few times though I just used the SQL Server driver that comes with CF and have not noticed any difference in how things are running. I have done this on a WinXP Pro and a Win2003 boxes. It all

RE: CF, jdbc, SQL2k5 problem

2006-10-09 Thread Dave Watts
For someone with your length of development you really have surprised me on this issue. Why? Second of all, yes for every named instance you do need to have a different port. Uh, that's what I said. You connect to SQL Server instances by IP socket, not by name. You need to download the

RE: CF, jdbc, SQL2k5 problem

2006-10-09 Thread Andrew Scott
Dave, You can connect to a sql2005 Instance Name I do it at home. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 ~| Introducing the Fusion Authority Quarterly

RE: CF, jdbc, SQL2k5 problem

2006-10-09 Thread Dave Watts
You can connect to a sql2005 Instance Name I do it at home. By name? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia,

RE: CF, jdbc, SQL2k5 problem

2006-10-09 Thread Andrew Scott
: Tuesday, 10 October 2006 1:43 PM To: CF-Talk Subject: RE: CF, jdbc, SQL2k5 problem You can connect to a sql2005 Instance Name I do it at home. By name? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction

RE: CF, jdbc, SQL2k5 problem

2006-10-09 Thread Andrew Tyrone
-Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 10, 2006 12:19 AM To: CF-Talk Subject: RE: CF, jdbc, SQL2k5 problem Yes by server\instancename in the jdbc driver from M$, provided you have opened that instance up for tcp/ip. That also