> Is it possible that the SQL Server is using an instance other
> than default? I.E. if your servername is "SQLServer" and the
> instance is "mydb" than you may have to use "SQLServer\mydb"
> as the servername in your connection.
If you're using JDBC and TCP/IP to connect, you do not have to s
>Well ... looks like there might be an issue with TCP/IP although it is
>enabled, in fact, I unchecked it a rechecked it, restarted SQL Server.
>Couldn't connect trying to telnet in using the IP of the box it's on and the
>standard 1433 on the port ... I'm going to reboot the server in a bit after
Well ... looks like there might be an issue with TCP/IP although it is
enabled, in fact, I unchecked it a rechecked it, restarted SQL Server.
Couldn't connect trying to telnet in using the IP of the box it's on and the
standard 1433 on the port ... I'm going to reboot the server in a bit after
ever
> Dave this is what I've run into with every attempt so far:
> Connection verification failed for data source: Faculty_Profile2
> java.sql.SQLException: [Macromedia][SQLServer JDBC
> Driver]Error establishing socket. Connection refused: connect
> The root cause was that: java.sql.SQLException:
>
Sent: Thursday, May 10, 2007 3:29 PM
To: CF-Talk
Subject: RE: Blob/clob issue
It is enabled, although I'm definitely not a db admin by a long shot. I
know the basics of to get around and work within enterprise manager and
such. But I'm always willing to break things ;)
Bob
> ---
Sent: Thursday, May 10, 2007 3:23 PM
> To: CF-Talk
> Subject: RE: Blob/clob issue
>
> Check your SQL server configuration and make sure that TCP/IP access is
> enabled (its off by default)
>
> Chris Peterson
~
Check your SQL server configuration and make sure that TCP/IP access is
enabled (its off by default)
Chris Peterson
-Original Message-
From: Bob Imperial [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 10, 2007 3:07 PM
To: CF-Talk
Subject: RE: Blob/clob issue
Dave this is what I'v
Dave this is what I've run into with every attempt so far:
Connection verification failed for data source: Faculty_Profile2
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing
socket. Connection refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][S
> Unfortunately, I've not been able to successfully register a
> ds in cf w/ms sql drivers, yet another story ;). So, off to
> pull down jdbc drivers from ms and see what I can break.
If you're unable to use the DataDirect drivers that come with CF to connect,
you will likely not be able to use
Original Message-
From: Bob Imperial [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 10, 2007 9:28 AM
To: CF-Talk
Subject: RE: Blob/clob issue
Unfortunately, I've not been able to successfully register a ds in cf
w/ms sql drivers, yet another story ;). So, off to pull down jdbc
drive
ursday, May 10, 2007 8:57 AM
> To: CF-Talk
> Subject: RE: Blob/clob issue
>
> Bob,
>
> First I would try the built in MS SQL driver, and if that still fails
> give the Microsoft JDBC driver a shot.
>
> Chris
>
> -Original Message-
> From: Bob Imperial
Bob,
First I would try the built in MS SQL driver, and if that still fails
give the Microsoft JDBC driver a shot.
Chris
-Original Message-
From: Bob Imperial [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 10, 2007 8:56 AM
To: CF-Talk
Subject: Blob/clob issue
Well . it's almost Friday a
/9i/FullTextIndexingUsingOracleText9i.php
-Original Message-
From: Douglas Knudsen [mailto:[EMAIL PROTECTED]
Sent: Saturday, 25 September 2004 9:37
To: CF-Talk
Subject: Re: BLOB
hmm...my eyes are opening here :) I recently built an app that got
clustered. Built a doc and image library
ubject: Re: BLOB
To: CF-Talk <[EMAIL PROTECTED]>
All of these are reasons we use the DB for all dynamically managed
content, including binary files. Oracle is absolutely fantastic at
this these days. For example, Oracle Text is far superior to the
Verity implementation in CF, since the full te
All of these are reasons we use the DB for all dynamically managed content, including binary files. Oracle is absolutely fantastic at this these days. For example, Oracle Text is far superior to the Verity implementation in CF, since the full text query can be included in the SQL statement used to
04 18:20:48 -0400
Subject: Re: BLOB
To: CF-Talk <[EMAIL PROTECTED]>
You can do this via CFCONTENT. Store the file in a directory NOT
under your webroot and bamm! Its not really a best practise to store
this in a DB. Note also that Verity can perform any full text
searching of these.
Dou
You can do this via CFCONTENT. Store the file in a directory NOT
under your webroot and bamm! Its not really a best practise to store
this in a DB. Note also that Verity can perform any full text
searching of these.
Doug
On Tue, 21 Sep 2004 13:52:56 +0930, Parker, Kevin <[EMAIL PROTECTED]> wro
I have successfully implemented a CF application that uploads or downloads documents to an Oracle database. This approach was chosen for security and full-text searching reasons. To accomplish this, I used a custom tag called CFX_BlobManager available from www.coresecure.com. (It is a commercial pa
> While storing the student dossier as a file is quite easily coded I do
need to lock them down from prying eyes - any suggestions greatly
appreciated.
You can store them outside the webroot then use cfcontent to retrieve
them
deletefile="No">
[Todays Threads]
[This Message]
r
WorkCover Corporation
p: 08 8233 2548
m: 0418 806 166
e: [EMAIL PROTECTED]
w: www.workcover.com
++
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 21 September 2004 11:41 PM
To: CF-Talk
Subject: RE: BLOB
Exactly, opinions don't
I have been able to insert a file into an image field in a SQL 2000
database.
I found that I had to use the built-in (Merant?) SQL Server driver
rather than the Microsoft JDBC driver.
Does anyone know of a reason why I can't use the built-in SQL Server
driver? Are the performance/stability/featu
Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: 21 September 2004 17:01
To: CF-Talk
Subject: Re: BLOB
> Well yes and no, it's not just my opinion its also good SQL practice,
> Storing data in BLOB's and CLOB's is not good full stop. It leads to
says who?
> If you can give me a v
> Well yes and no, it's not just my opinion its also good SQL practice,
> Storing data in BLOB's and CLOB's is not good full stop. It leads to
says who?
> If you can give me a valid business case of storing data in this matter
> which overrides the fact its bad practice then I am all ears.
multi
, full-text searching.
-Adam
- Original Message -
From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]>
Date: Tue, 21 Sep 2004 16:15:48 +0100
Subject: RE: BLOB
To: CF-Talk <[EMAIL PROTECTED]>
Not at all, I am not anti-BLOB...just storing file objects etc is not
goodWhat i
cism of "You shouldn't do that", rather than offering assitance.
>
> -Adam
>
>
>
> - Original Message -
> From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]>
> Date: Tue, 21 Sep 2004 15:42:06 +0100
> Subject: RE: BLOB
> To: CF-Talk <
Not at all, I am not anti-BLOB...just storing file objects etc is not
goodWhat if your DB is taken down.?
_
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: 21 September 2004 16:10
To: CF-Talk
Subject: Re: BLOB
Clustering and data integrity to name a couple reasons. If I
gt;
Date: Tue, 21 Sep 2004 15:42:06 +0100
Subject: RE: BLOB
To: CF-Talk <[EMAIL PROTECTED]>
Well yes and no, it's not just my opinion its also good SQL practice,
Storing data in BLOB's and CLOB's is not good full stop. It leads to
overgrown database systems and unnecessary storage of
ness case of storing data in this matter
which overrides the fact its bad practice then I am all ears.
N
_
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: 21 September 2004 14:57
To: CF-Talk
Subject: Re: BLOB
>Storing data of this type in a database is not good practice, it sh
TED]
Sent: Tuesday, September 21, 2004 8:57 AM
To: CF-Talk
Subject: Re: BLOB
>Storing data of this type in a database is not good practice, it should
be
>avoided at all costs...
Your opinion doesn't necessarily = good practice.
-Adam
[Todays Threads]
[This Message]
[Subscription
>Storing data of this type in a database is not good practice, it should be
>avoided at all costs...
Your opinion doesn't necessarily = good practice.
-Adam
- Original Message -
From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]>
Date: Tue, 21 Sep 2004 14:29:23 +0100
Storing data of this type in a database is not good practice, it should be
avoided at all costs...
_
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: 21 September 2004 13:50
To: CF-Talk
Subject: RE: BLOB
Read this thread
http://www.macromedia.com/cfusion/webforums/forum
Read this thread
http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=
2&threadid=795052
I'm trying to do the same thing, with little success. I can't get the
binary data inserted into SQL, however, I can use ToBase64() and insert
it, but that's not really what I want to do.
> How do you add a file (e.g. PDF) to SQL Server as opposed
> to creating a row that you convert to a URL that links to
> it.
> I want to create an application that includes student
> dossiers so I don't want them to be locatable or
> downloadable by anyone or anything other than application
> use
use
http://www.funjunkie.co.uk/link.cfm?CMBA4CQ8
display.cfm
===
myImage.cfm
===
> -Original Message-
> From: Shahzad.Butt [mailto:[EMAIL PROTECTED]]
> Sent: 15 March 2002 10:24
> To: CF-Talk
> Subject: BLOB
>
>
> Hi
>
> My Image is stored in SQL Server 2
onday, November 27, 2000 3:36 PM
To: CF-Talk
Subject: RE: BLOB manipulation
real good
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.c
real good
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sideba
Yes, i now it´s a cf problem but i think oracle handle Blob fields other
then SQL Server.
Yes, you right. They handle BLOB in different ways, but solution for CF is
in the link I sent you. Outstanding - just write SQL requests to store
binary file into BLOB and to get it from the table :))
The s
> But for SQL Server exist the getimage take.
BTW I could find only the way I show earlier. The problem is - how to get
image into CF variable and store into HD. And it is CF problem - not RDBMS
Cheers
> This take i need for Oracle.
> thanks franz
> --
I guess the problem is not in Oracle.
See http://www.experts-exchange.com/bin/Q.10578041
Cheers
> Hello
>
> i have some problem with the Blob in Oracle.
> I search a custom Tag that can view me the Blob.
> the Blob is a Jpg/gif or Htm but i can not view it.
> thanks for evrey help.
>
> Franz
>
39 matches
Mail list logo
