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:
>
> jdbc:sqls
c Ports section, in my install 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 PROTE
>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 problem
>
>>
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.
>
>
>
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, delive
> -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 in
: 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
> 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,
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 Updat
> 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
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 see
n, in my install 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
Subj
> > 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 ge
>> 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
> 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 not
A. Kruger, CFG, MCSE
www.coldfusionmuse.com
www.necfug.com
-Original Message-
From: kurt schroeder [mailto:[EMAIL PROTECTED]
Sent: Monday, October 09, 2006 2:42 PM
To: CF-Talk
Subject: CF, jdbc, SQL2k5 problem
I have the works, on one box for testing. and it all functions except for
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 that i
17 matches
Mail list logo
