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:
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,
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.
~|
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
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
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
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
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
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
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
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
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
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
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,
: 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
-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
16 matches
Mail list logo