Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver

2008-08-13 Thread Tom Chiverton
On Monday 11 Aug 2008, Scott Stewart wrote: > the main weirdness that I've found is that cfqueryparam is returning > "true" or "false" which is a valid response for a boolean > but not what a SQL server bit field is expecting. (IE: 1 or 0) And what value are you passing into the cfqp there ? Sound

RE: cfqueryparam and bit field (was:Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver)

2008-08-12 Thread Craig Dudley
al Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: 11 August 2008 19:14 To: CF-Talk Subject: cfqueryparam and bit field (was:Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver) The cfqueryparam tags work fine with the character fields, but they're r

cfqueryparam and bit field (was:Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver)

2008-08-11 Thread Scott Stewart
; JDBC stuff but there are docs in the MS download package I think, it's not >> complex either way but sorry I couldn't find my examples as it might have >> saved some time. >> >> Craig. >> >> -Original Message----- >> From: Scott Stewart [mailto:

Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver

2008-08-11 Thread Scott Stewart
; Sent: 11 August 2008 17:14 > To: CF-Talk > Subject: Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 > Driver > > Thanks Craig > > The higher ups have deemed this a "last resort"... so if it comes to > this I'll put up some results. >

RE: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver

2008-08-11 Thread Craig Dudley
find my examples as it might have saved some time. Craig. -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: 11 August 2008 17:14 To: CF-Talk Subject: Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver Thanks Craig The higher ups have deemed

Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver

2008-08-11 Thread Scott Stewart
ECTED] > Sent: 11 August 2008 15:10 > To: CF-Talk > Subject: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver > > Hey all, > > I've run into an issue that I need opinions on. We've run into some SQL > server issues, where MS is saying "patc

Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver

2008-08-11 Thread Scott Stewart
Nothing, I've found a couple of CF blogs that point to as being the culprit... But it's in very specific cases: http://www.petefreitag.com/item/677.cfm However, mine is a basic insert statement. the error code(s) returned are: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 28: Incorrect s

RE: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver

2008-08-11 Thread Craig Dudley
ailto:[EMAIL PROTECTED] Sent: 11 August 2008 15:10 To: CF-Talk Subject: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver Hey all, I've run into an issue that I need opinions on. We've run into some SQL server issues, where MS is saying "patch the driver". Has an

Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver

2008-08-11 Thread Tom Chiverton
On Monday 11 Aug 2008, Scott Stewart wrote: > I've run into an issue that I need opinions on. We've run into some SQL > server issues, where MS is saying "patch the driver". And what has Adobe said ? -- Tom Chiverton This email is sent for a

CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver

2008-08-11 Thread Scott Stewart
Hey all, I've run into an issue that I need opinions on. We've run into some SQL server issues, where MS is saying "patch the driver". Has anyone used the MS SQL Server 2000 SP3 JDBC driver in place of the one shipped with CF8? Has it cleared up 8180 errors? Any performan

I need to "steal" a DDL for generic contact info for MS SQL Server 2000

2008-03-27 Thread Don L
got it handy? it would save me ~15/20 minutes. tks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://ww

Re: Importing XML data in SQL Server 2000 need ColdFusion?

2007-05-09 Thread coldfusion . developer
>Just found this. Maybe would do the trick? > >http://www.perfectxml.com/articles/xml/importxmlsql.asp > >Will I don't have Microsoft Visual Basic or Visual Studio .NET. Don't know Visual Basic or VBScript. Can I do it with ColdFusion or some wizard in SQL Server? ~~

Re: Importing XML data in SQL Server 2000 need ColdFusion?

2007-05-09 Thread Will Tomlinson
Just found this. Maybe would do the trick? http://www.perfectxml.com/articles/xml/importxmlsql.asp Will ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIA’s for your business. Upgrade now http://www.adobe.com/

Importing XML data in SQL Server 2000 need ColdFusion?

2007-05-09 Thread coldfusion . developer
I'm reading that there are many different ways to import data into a SQL Server database. I want to set up something that will allow a partner outside our company to be able to upload contest entries along with image files and have it all imported into a SQL Server table. Any one have adive or

Re: A few questions about SQL Server 2000

2007-02-22 Thread Jim Wright
Ben Nadel wrote: > Create a new file > Project using existing database > An Access project is probably a good way to go since you are comfortable with Access, but it does not use the Access "Relationships" function that was described. It has something similar in the "Database Diagrams" butto

RE: A few questions about SQL Server 2000

2007-02-22 Thread Andy Matthews
Yay... I found that SQL Server does have database diagrams. That's what I'm looking for. -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Thursday, February 22, 2007 10:57 AM To: CF-Talk Subject: RE: A few questions about SQL Server 2000 Andy, while I am no

RE: A few questions about SQL Server 2000

2007-02-22 Thread Dave Watts
> I've got some elaborate joins I'm performing against tables > with which I'm not all that familiar. Access has a built in > function called Relationships which allows you to visualize > tables and their columns. Does SQL Server have something like > this? Yes, look for Diagrams. You will have

RE: A few questions about SQL Server 2000

2007-02-22 Thread Ben Nadel
ent: Thursday, February 22, 2007 11:36 AM To: CF-Talk Subject: A few questions about SQL Server 2000 I've got some elaborate joins I'm performing against tables with which I'm not all that familiar. Access has a built in function called Relationships which allows you to visualize tables

A few questions about SQL Server 2000

2007-02-22 Thread Andy Matthews
I've got some elaborate joins I'm performing against tables with which I'm not all that familiar. Access has a built in function called Relationships which allows you to visualize tables and their columns. Does SQL Server have something like this? Alternately, is there a quick way of dumping a fe

Re: OSX development database compatible with SQL Server 2000?

2006-06-30 Thread Damien McKenna
On Jun 30, 2006, at 2:51 PM, Barney Boisvert wrote: > SQL Server on a V-PC instance. Won't be crazy fast or particularly > friendly on your RAM, but it'll get you SQL Server. DUH!I can just use JDBC drivers and hit the SQL Server down the hall. Duh! -- Damien McKenna - Web Developer - [E

Re: OSX development database compatible with SQL Server 2000?

2006-06-30 Thread Barney Boisvert
SQL Server on a V-PC instance. Won't be crazy fast or particularly friendly on your RAM, but it'll get you SQL Server. cheers, barneyb On 6/30/06, Damien McKenna <[EMAIL PROTECTED]> wrote: > Right now our production environment is on a Windows server with SQL > Server 200

OSX development database compatible with SQL Server 2000?

2006-06-30 Thread Damien McKenna
Right now our production environment is on a Windows server with SQL Server 2000 for most of the data storage. I've started using a Mac for local development again and am getting CFMX installed on it to make life easier on me, but I've got a problem with the database element

Re: Running CF7 SQL Server 2000 and SQL Server 2005 on same machi ne.

2006-04-27 Thread Scott Stroz
l Message- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 27, 2006 2:58 PM > To: CF-Talk > Subject: RE: Running CF7 SQL Server 2000 and SQL Server 2005 on same machi > ne. > > > On one of my development boxes, I am running CF 7 (on windows > >

RE: Running CF7 SQL Server 2000 and SQL Server 2005 on same machi ne.

2006-04-27 Thread Dave Watts
they did, you wouldn't be able to use them simultaneously. On Windows XP, you can use netstat to find the program listening at a specific port. From a command prompt, type "netstat -ab" (and wait - it takes a while to run). To find out what port SQL Server 2000 is using, look in the

RE: Running CF7 SQL Server 2000 and SQL Server 2005 on same machi ne.

2006-04-27 Thread Scott Stewart
rsday, April 27, 2006 2:58 PM To: CF-Talk Subject: RE: Running CF7 SQL Server 2000 and SQL Server 2005 on same machi ne. > On one of my development boxes, I am running CF 7 (on windows > XP) I installed SQL Server 2005 with no issues. I then > realized that for one client, I will ne

Re: Running CF7 SQL Server 2000 and SQL Server 2005 on same machi ne.

2006-04-27 Thread Scott Stroz
ne of my development boxes, I am running CF 7 (on windows > > XP) I installed SQL Server 2005 with no issues. I then > > realized that for one client, I will need to have SQL Server > > 2000. I installed 2000 as a separate instance. > > > > I am unable to connect to

RE: Running CF7 SQL Server 2000 and SQL Server 2005 on same machi ne.

2006-04-27 Thread Dave Watts
> On one of my development boxes, I am running CF 7 (on windows > XP) I installed SQL Server 2005 with no issues. I then > realized that for one client, I will need to have SQL Server > 2000. I installed 2000 as a separate instance. > > I am unable to connect to the new i

Running CF7 SQL Server 2000 and SQL Server 2005 on same machine.

2006-04-27 Thread Scott Stroz
On one of my development boxes, I am running CF 7 (on windows XP) I installed SQL Server 2005 with no issues. I then realized that for one client, I will need to have SQL Server 2000. I installed 2000 as a separate instance. I am unable to connect to the new instance with CF (I was able to

RE: MS SQL Server 2000 Standard to SQL Server 2005 Express?

2006-04-11 Thread Munson, Jacob
> So has anyone migrated from '2000 to '2005, and if so how well did it go? We > don't use any fancy stuff in SQL Server like stored procedures, etc, > just basically as a collection of dumb tables, and like I > said we've got > a few hundred meg of data and that's it. It's my understanding that

RE: MS SQL Server 2000 Standard to SQL Server 2005 Express?

2006-04-11 Thread Damien McKenna
OK, nevermind, SQL Server 2005 Express won't work on dual-processor servers. Ah well. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include ~| Message:

MS SQL Server 2000 Standard to SQL Server 2005 Express?

2006-04-11 Thread Damien McKenna
Evening folks. We use MS SQL Server 2000 for a small amount of data on our site, mostly smaller bits of content separate to our core business (which is in Cobol), so a few hundred meg of real data I figure. I'm working on building a new web server to replace the loaner we've had for a

RE: Why does this happen with SQL Server 2000 and CFML?

2006-01-23 Thread Kevin Penny
ot now I'm multitasking" -Original Message- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Thursday, January 19, 2006 4:07 PM To: CF-Talk Subject: Why does this happen with SQL Server 2000 and CFML? Select convert(float,getdate()) as datetimefromdb dis

Re: Why does this happen with SQL Server 2000 and CFML?

2006-01-19 Thread Richard Dillman
MAIL PROTECTED] > > Sent: Thursday, January 19, 2006 5:07 PM > > To: CF-Talk > > Subject: Why does this happen with SQL Server 2000 and CFML? > > > > > > Select convert(float,getdate()) as datetimefromdb > > > > > > > > displa

RE: Why does this happen with SQL Server 2000 and CFML?

2006-01-19 Thread Russ
07 PM > To: CF-Talk > Subject: Why does this happen with SQL Server 2000 and CFML? > > > Select convert(float,getdate()) as datetimefromdb > > > > display that with: #val(datetimefromdb - 0)# > Returns 38734.6939544 (or whatever date/time it is) &g

Why does this happen with SQL Server 2000 and CFML?

2006-01-19 Thread Richard Dillman
Select convert(float,getdate()) as datetimefromdb display that with: #val(datetimefromdb - 0)# Returns 38734.6939544 (or whatever date/time it is) display that with: #dateformat(val(datetimefromdb-0), "dd-mmm-yy")# Returns 17-Jan-06 (what? thats 2 days ago) Now use select getda

Re: SQL Server 2000 to 7

2005-12-20 Thread Bryan Stevenson
> You should be able to do this through DTS, if the SQL Server 2000 machine > can connect to the SQL Server 7 machine. If that's not possible, you can > install both on a single machine by installing a default SQL Server 7 > instance, then installing a named SQL Server 2000 i

RE: SQL Server 2000 to 7

2005-12-20 Thread Dave Watts
> I have a SQL Server 2000 DB that I need to convert to SQL > Server 7. Can it be done? if so, how? You should be able to do this through DTS, if the SQL Server 2000 machine can connect to the SQL Server 7 machine. If that's not possible, you can install both on a single machine by i

Re: SQL Server 2000 to 7

2005-12-20 Thread Robert Everland III
I don't think a backup will work for this, but you can try. If that doesn't work I would create SQL scripts for the structure of the database then use data transformation services to get the data into the tables. Bob ~| Logwa

SQL Server 2000 to 7

2005-12-20 Thread Bryan Stevenson
Hey All, I have a SQL Server 2000 DB that I need to convert to SQL Server 7. Can it be done? if so, how? BTW this is tables, PKs, FKs, and data types.no triggers or stored procs. TIA Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group

RE: SQL Server 2000 Full-text search issues

2005-10-05 Thread Martin Parry
arch\bin\tquery.dll" /s pause This was adapted from a posting ON DBFORUMS.COM Restart "Microsoft Search" service after running it and voila - It now indexes like a charm. I think this is definitely a problem with MS Clusters only. Martin http://www.beetrootstreet.com -Original

RE: SQL Server 2000 Full-text search issues

2005-10-03 Thread Snake
7;#form.searchCriteria#' -- Russ -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 03 October 2005 14:02 To: CF-Talk Subject: Re: SQL Server 2000 Full-text search issues Russ, I am probably a bad SQL coder, but almost all the code that I had to do with se

Re: SQL Server 2000 Full-text search issues

2005-10-03 Thread George Abraham
red their search query in the form > as > uusal. > > russ > > -Original Message- > From: George Abraham [mailto:[EMAIL PROTECTED] > Sent: 01 October 2005 14:25 > To: CF-Talk > Subject: Re: SQL Server 2000 Full-text search issues > > Hi, > Full-text searc

RE: SQL Server 2000 Full-text search issues

2005-10-03 Thread Martin Parry
e Martin -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: 03 October 2005 02:18 To: CF-Talk Subject: RE: SQL Server 2000 Full-text search issues Martin, That's the weird thing with ours. I assumed the same thing that it was the install. So, we scheduled dow

RE: SQL Server 2000 Full-text search issues

2005-10-02 Thread Burns, John D
John From: Martin Parry [mailto:[EMAIL PROTECTED] Sent: Sun 10/2/2005 11:08 AM To: CF-Talk Subject: RE: SQL Server 2000 Full-text search issues I don't have problems on my dev box but when uploading the DB to live server it never populates the catalogue. I think it's som

RE: SQL Server 2000 Full-text search issues

2005-10-02 Thread Burns, John D
arry [mailto:[EMAIL PROTECTED] Sent: Fri 9/30/2005 11:41 AM To: CF-Talk Subject: RE: SQL Server 2000 Full-text search issues I too get this on my 2003 cluster. I restored the database as a backup from my dev box (which it works on) and do a full rebuild - It takes but a second to say its compl

RE: SQL Server 2000 Full-text search issues

2005-10-02 Thread Martin Parry
CTED] Sent: 02 October 2005 15:26 To: CF-Talk Subject: RE: SQL Server 2000 Full-text search issues What sor tof problems. I have used FULL-TEXT SEARCH many times without problem, even on a massive 13gb database with millions of records, it certainly never required the user to do anything spe

RE: SQL Server 2000 Full-text search issues

2005-10-02 Thread Snake
: George Abraham [mailto:[EMAIL PROTECTED] Sent: 01 October 2005 14:25 To: CF-Talk Subject: Re: SQL Server 2000 Full-text search issues Hi, Full-text search on SQL Server 2K gave me huge problems. Not only was the code to conduct a full-text search cumbersome, but the user had to learn how to

RE: SQL Server 2000 Full-text search issues

2005-10-01 Thread Taco Fleur
; From: George Abraham [mailto:[EMAIL PROTECTED] > Sent: Saturday, 1 October 2005 11:25 PM > To: CF-Talk > Subject: Re: SQL Server 2000 Full-text search issues > > > Hi, > Full-text search on SQL Server 2K gave me huge problems. Not > only was the code to conduct a full-

Re: SQL Server 2000 Full-text search issues

2005-10-01 Thread George Abraham
> -Original Message- > From: Burns, John D [mailto:[EMAIL PROTECTED] > Sent: 30 September 2005 16:22 > To: CF-Talk > Subject: SOT: SQL Server 2000 Full-text search issues > > I have a development CF server (Windows 2003 Server, SQL Server 2000 > SP4, CFMX 6.1) on wh

RE: SQL Server 2000 Full-text search issues

2005-09-30 Thread Martin Parry
http://www.beetrootstreet.com -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: 30 September 2005 16:22 To: CF-Talk Subject: SOT: SQL Server 2000 Full-text search issues I have a development CF server (Windows 2003 Server, SQL Server 2000 SP4, CFMX 6.1) on which I have a database tha

RE: SQL Server 2000 Full-text search issues

2005-09-30 Thread Matt Osbun
g/Microsoft/SQL-Server-L.asp Matt Osbun Applications Manager Health Systems, International -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Friday, September 30, 2005 10:22 AM To: CF-Talk Subject: SOT: SQL Server 2000 Full-text search issues I'm at my wit's

SOT: SQL Server 2000 Full-text search issues

2005-09-30 Thread Burns, John D
I have a development CF server (Windows 2003 Server, SQL Server 2000 SP4, CFMX 6.1) on which I have a database that has full-text enabled on a table. When I run a query against the full-text index, it returns 31 rows. I have 2 production servers. 1 production CF Server (Windows 2003 Server

Re: SQL Server 2000 Driver for JDBC

2005-09-23 Thread Stephen Dupre
> The DataDirect 3.4 drivers for SQL Server 2000 are causing CFMX 6.1 > to > hang when certain insert triggers are executed. I reverted to the 3.3 > drivers, but those have other problems with them. I just installed > the > Microsoft JDBC sp3 driver in hopes that it i

SQL Server 2000 Driver for JDBC

2005-09-23 Thread Mike Chabot
The DataDirect 3.4 drivers for SQL Server 2000 are causing CFMX 6.1 to hang when certain insert triggers are executed. I reverted to the 3.3 drivers, but those have other problems with them. I just installed the Microsoft JDBC sp3 driver in hopes that it is better, and I am wondering if anybody

Re: Storing and retrieving images from SQL Server 2000

2005-07-13 Thread Larry Lyons
>> Never too late to reverse a bad decision. > >Except when that decision was to step off the curb in front of a fast >moving buss. > >s. isaac dealey 954.522.6080 Then again depending on the person, stepping in front of a fast moving buss would not be a bad decision. Stepping in front of a fas

RE: Storing and retrieving images from SQL Server 2000

2005-07-12 Thread Dave Watts
> Any hint on the latter part of your statement? Is that where I'd need > to convert to base64 or to string and then store in the db and when > pulled out do tobinary()? What exactly is it coming out of the db as > when I insert it? Notice in my first post, I'm having trouble inserting > as well.

Re: Storing and retrieving images from SQL Server 2000

2005-07-12 Thread Aaron Rouse
His job is to monitor email lists. :) On 7/12/05, Ben Forta <[EMAIL PROTECTED]> wrote: > > Like Dave (who regularly beats us all to the punch, I don't believe he > ever > gets any real work done, that or he has figured out cloning) said. > > ;-) > > ~

RE: Storing and retrieving images from SQL Server 2000

2005-07-12 Thread Ben Forta
g and retrieving images from SQL Server 2000 > Thanks for the response, but I'm curious as to why the documentation > doesn't show the variable attribute for > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a1 > 7.htm#wp2850760 > > Is this going to be depre

RE: Storing and retrieving images from SQL Server 2000

2005-07-12 Thread Burns, John D
t: Tuesday, July 12, 2005 3:40 PM To: CF-Talk Subject: RE: Storing and retrieving images from SQL Server 2000 > Thanks for the response, but I'm curious as to why the documentation > doesn't show the variable attribute for > http://livedocs.macromedia.com/coldfusion/6.1/htmld

RE: Storing and retrieving images from SQL Server 2000

2005-07-12 Thread Dave Watts
> Thanks for the response, but I'm curious as to why the documentation > doesn't show the variable attribute for > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a1 > 7.htm#wp2850760 > > Is this going to be deprecated or is this new or what? I'm using CFMX > 6.1. The VARIABLE attrib

RE: Storing and retrieving images from SQL Server 2000

2005-07-12 Thread Burns, John D
Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 12, 2005 2:53 PM To: CF-Talk Subject: RE: Storing and retrieving images from SQL Server 2000 John, check out th

RE: Storing and retrieving images from SQL Server 2000

2005-07-12 Thread Ben Forta
John, check out this thread: http://www.forta.com/blog/index.cfm?mode=e&entry=1645 --- Ben -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 12, 2005 2:10 PM To: CF-Talk Subject: Storing and retrieving images from SQL Server 2000 I've look

RE: Storing and retrieving images from SQL Server 2000

2005-07-12 Thread Dawson, Michael
-Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 12, 2005 1:39 PM To: CF-Talk Subject: Re: Storing and retrieving images from SQL Server 2000 >>I have no say about storing the images in the DB and that decision is already made Never too late to rev

RE: Storing and retrieving images from SQL Server 2000

2005-07-12 Thread Burns, John D
ssage- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 12, 2005 2:39 PM To: CF-Talk Subject: Re: Storing and retrieving images from SQL Server 2000 >>I have no say about storing the images in the DB and that decision is already made Never too late to r

RE: Storing and retrieving images from SQL Server 2000

2005-07-12 Thread Burns, John D
EMAIL PROTECTED] Sent: Tuesday, July 12, 2005 2:39 PM To: CF-Talk Subject: Re: Storing and retrieving images from SQL Server 2000 >>I have no say about storing the images in the DB and that decision is already made Never too late to reverse a bad decision. -- __

Re: Storing and retrieving images from SQL Server 2000

2005-07-12 Thread S . Isaac Dealey
> >>I have no say about storing the images in the DB and > >>that decision is > already made > Never too late to reverse a bad decision. Except when that decision was to step off the curb in front of a fast moving buss. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? ad

Re: Storing and retrieving images from SQL Server 2000

2005-07-12 Thread Claude Schneegans
>>I have no say about storing the images in the DB and that decision is already made Never too late to reverse a bad decision. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this addr

Storing and retrieving images from SQL Server 2000

2005-07-12 Thread Burns, John D
I've looked in the archives and can't find a good answer to this. I know I've done it in the past, I just can't remember how and my brain hurts so i figured i'd ask the list. I have no say about storing the images in the DB and that decision is already made, so I just need help putting them in the

Re: Insert Unicode Smart Quotes into MS SQL Server 2000

2005-03-05 Thread Paul Hastings
Mike Chabot wrote: > insert Unicode into these columns without any problems. you really can't insert "unicode" into non "N" columns in sql server & get unicode back. i'd guess you're actually inserting data that the driver or db is interpreting as non-unicode. > Smart quotes: "" '' > Where am I

Insert Unicode Smart Quotes into MS SQL Server 2000

2005-03-03 Thread Mike Chabot
I thought char and varchar columns would only allow the 255 ASCII values and would not allow Unicode. SQL Server 2000 seems to let me insert Unicode into these columns without any problems. For example, when I insert the two sets of MS Word smart quotes, separated by a space, into a varchar(5

RE: SQL Server 2000

2005-01-06 Thread Robertson-Ravo, Neil (RX)
Also note that you can install SQL 7 and SQL 2K side by side no problem! -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: 05 January 2005 21:16 To: CF-Talk Subject: SQL Server 2000 Hi there, I'm trying to connect to a remote MSSQL database with Microsof

Re: SQL Server 2000

2005-01-05 Thread Claude Schneegans
>>If you install only the "Client Tools" then they do not time out Ah ah! Just the info I was looking for. Thanks. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PR

Re: SQL Server 2000

2005-01-05 Thread Mike Kear
Davis <[EMAIL PROTECTED]> wrote: > If you install only the "Client Tools" then they do not time out - only the > server itself times out after the evaluation. > > I'm 99% positive that the SQL Server 2000 Client Tools (Enterprise Manager, > Query Analyzer, etc) allow

RE: SQL Server 2000

2005-01-05 Thread Jim Davis
If you install only the "Client Tools" then they do not time out - only the server itself times out after the evaluation. I'm 99% positive that the SQL Server 2000 Client Tools (Enterprise Manager, Query Analyzer, etc) allow you to attach to both version 7 and 2000 databases (but,

SQL Server 2000

2005-01-05 Thread Claude Schneegans
Hi there, I'm trying to connect to a remote MSSQL database with Microsoft SQL Enterprise Manager but the connection fails because the server requires I uograde to version 2000. I'm presently using the version 7, I'm pretty happy with it and have no intention to upgrade. If I upgrade, I can get t

OT - SQL Server 2000

2004-08-23 Thread Steve Logan
Since this is going to be considered off topic for this list, it'd be best to reply to me off list unless this sparks an interesting discussion. I've kind of evolved in being the "person who sets up the SQL servers for new users" as part of my job.  I've managed to muddle my way around and get SQL

Re: SQL Server 2000 developer edition?

2004-07-14 Thread Matt Robertson
No mention of any sort of concurrent user limit, and no mention of thread limits.  Does anyone know if these restrictions are lifted and the published performance limits are all there are? A 4gb database limit is no big deal to me, and the single-processor limit isn't an issue as I can't afford a

RE: SQL Server 2000 developer edition?

2004-07-13 Thread Samuel R. Neff
Express is a version of SQL Server 2005.  MSDE is a version of SQL Server 2000 or 7.  Hence the different requirements. Sam > -Original Message- > From: Paul Hastings [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 13, 2004 10:27 PM > To: CF-Talk > Subject: Re: SQL Server

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Paul Hastings
> MSDE is being replaced by SQL Server EXPRESS cool. thanks for the info. it requires .NET & a bit more resources than old msde though. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Doug White
http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com http://www.forta.com/cf/isp/isp.cfm?isp_id=1069 ==   - Original Message -   From: Paul Hastings   To: CF-Talk   Sent: Tuesday, July 13, 2004 8:50 PM   Subject: Re: SQL Server

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Paul Hastings
> MSDE is available to anyone who has acopy of MS Office Pro, or any > other MS product that includes MSDE... for deployment, even.  Its a > chopped down version of the SQL Server engine and contains no > Enterprise mgr, among other things. you used to have to get it that way, but ms has been givi

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Claude Schneegans
>>Not hard to find at all... Thanks a lot. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Claude Schneegans
>>It's called MSDE (Microsoft Developers Edition). Thanks a lot. >>as always it's buried where you'd never think to lookboy I love the MS site Yeah, quite frustrating to look for information. The most important things, like reference docs are always buried deep into useless general descr

Re: SQL Server 2000 developer edition?

2004-07-13 Thread C. Hatton Humphrey
ise Manager and SQL Query Analyzer do not expire. - You can download MSDE... it's just the server engine and does not include any other tools.  It's free for developers. - You can purchase a copy of SQL Server 2000 Developer Edition (this is what I did).  Standard retail is about $49

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Bryan Stevenson
2004 2:26 PM   Subject: Re: SQL Server 2000 developer edition?   N :-)   MSDE is available to anyone who has acopy of MS Office Pro, or any   other MS product that includes MSDE... for deployment, even.  Its a   chopped down version of the SQL Server engine and contains no   Enterprise mgr, among

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Matt Robertson
N :-) MSDE is available to anyone who has acopy of MS Office Pro, or any other MS product that includes MSDE... for deployment, even.  Its a chopped down version of the SQL Server engine and contains no Enterprise mgr, among other things. The MS SQL Server 2000 Developer Edition is now a

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Todd
under & Director > www.cfug-vancouverisland.com >   - Original Message - >   From: Claude Schneegans >   To: CF-Talk >   Sent: Tuesday, July 13, 2004 1:48 PM >   Subject: SQL Server 2000 developer edition? > > >   >>Does anyone know if there is an Oracle

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Jeff Garza
July 13, 2004 2:14 PM   Subject: Re: SQL Server 2000 developer edition?   Yes there isbut getting it is the fun parthave to be part of some MS developer group OR I think you can get it with various MS product licences.   It's called MSDE (Microsoft Developers Edition).Best thing

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Matt Robertson
Claude Schneegans  wrote: > Same question for SQL Server 2000... ;-) Yes, but it will cost you about US$50.  Its license allows you to copy it anywhere in your office as many times as you like so long as its use is development/testing only.  No production use.  I got mine at cdw.com. -- --M

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Bryan Stevenson
2004 1:48 PM   Subject: SQL Server 2000 developer edition?   >>Does anyone know if there is an Oracle Developer Edition that we could use   to develop an app in-house, then have it hosted at any Oracle host once done?   Same question for SQL Server 2000... ;-)   --   ___

SQL Server 2000 developer edition?

2004-07-13 Thread Claude Schneegans
>>Does anyone know if there is an Oracle Developer Edition that we could use to develop an app in-house, then have it hosted at any Oracle host once done? Same question for SQL Server 2000... ;-) -- ___ REUSE CODE! Use custom tags; Se

Re: communicating with SQL Server 2000

2004-06-12 Thread Andrew Grosset
Thanks for the help, I was hoping that there was an alternative to downloading 170MB of waffle just to communicate with the databasepreviously I used SQL Server 7.0 and that had a very quick and simple interface using Access 2000 that allowed me to transfer/edit/delete tables etc. >> I've been

RE: communicating with SQL Server 2000

2004-06-12 Thread C. Hatton Humphrey
> I've been advised that I need "the 2000 version of the Enterprise Manager" > to communicate with "SQL 2000". >    Should I download "Microsoft SQL Server 2000 Desktop Engine (MSDE > 2000)" (44MB) or do I need to download an entire evaluation ve

communicating with SQL Server 2000

2004-06-11 Thread Andrew Grosset
I've been advised that I need "the 2000 version of the Enterprise Manager" to communicate with "SQL 2000".    Should I download "Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)" (44MB) or do I need to download an entire evaluation version of SQL server 2

Re: OT: migrating to SQL Server 2000

2004-03-01 Thread brobborb
i ddi that a long time ago.  We are cleaning out the whole hard drive this time  :D   - Original Message -   From: Rob   To: CF-Talk   Sent: Monday, March 01, 2004 5:42 PM   Subject: Re: OT: migrating to SQL Server 2000   On Mon, 2004-03-01 at 14:57, brobborb wrote:   > ok i j

Re: OT: migrating to SQL Server 2000

2004-03-01 Thread Rob
t: Monday, March 01, 2004 4:55 PM >   Subject: Re: OT: migrating to SQL Server 2000 > > >   On Mon, 2004-03-01 at 14:52, Rob wrote: >   > What kind of commit are you using by >   That should be transaction level sorry - > >   > >   > "Try rebooting"

Re: OT: migrating to SQL Server 2000

2004-03-01 Thread brobborb
no network involved at all i am running the queries striaght from the local comp.  the disk is good, the ram is good, 1 GB! hehe   - Original Message -   From: Rob   To: CF-Talk   Sent: Monday, March 01, 2004 5:07 PM   Subject: Re: OT: migrating to SQL Server 2000   Are you running

Re: OT: migrating to SQL Server 2000

2004-03-01 Thread brobborb
e: OT: migrating to SQL Server 2000   On Mon, 2004-03-01 at 14:52, Rob wrote:   > What kind of commit are you using by   That should be transaction level sorry -   >   > "Try rebooting"   > -- MCSE   >   > On Mon, 2004-03-01 at 14:27, brobborb wrote:   > &g

Re: OT: migrating to SQL Server 2000

2004-03-01 Thread Kwang Suh
Perhaps DMA needs to be turned on? - Original Message - From: brobborb <[EMAIL PROTECTED]> Date: Monday, March 1, 2004 3:50 pm Subject: Re: OT:  migrating to SQL Server 2000 > IO cost is like .0101 > > > UPDATE.we installed a copy on a different server, and it

Re: OT: migrating to SQL Server 2000

2004-03-01 Thread Rob
day, March 01, 2004 4:52 PM >   Subject: Re: OT: migrating to SQL Server 2000 > > >   When you hover over the icon does it give you any more info that is >   helpful (IO time or something)? What kind of commit are you using by >   default - bad / lame disk maybe? > >   

  1   2   3   4   >