Hey,
I have a client with an in house sql 7 db. I'm a bit afraid of trying
to upgrade them to 2k on this box and I'm in a bit of a hurry. We're
moving them to a sql 2k hosted server. The sql manager on this
computer is sql 7 and doesnt want to communicate with the sql 2k
server. So, what are my
-Talk
Sent: Sat Aug 05 18:47:32 2006
Subject: HELP, sql 7 to 2k upgrade, least risk
Hey,
I have a client with an in house sql 7 db. I'm a bit afraid of trying
to upgrade them to 2k on this box and I'm in a bit of a hurry. We're
moving them to a sql 2k hosted server. The sql manager
Hi everybody, we have a MS-SQL-7 server piking (+ plateaus) to 100% CPU.
It is caused by mssqlserver.exe. How can we find out, what database access is
causing this,
since I have about 20 DBs running on them ? All DBs are powering
ColdFusion shop-systems.
We have Win2000 server, SP4.
Thanks
Try experimenting with trace logs, there you should also be able to see
how much cpu different actions/access takes. It can be hard to wade
through all though.
Some info here, for instance, or try google or the MSSQl help.
http://www.databasejournal.com/features/mssql/article.php/10894_2239461_
1
[EMAIL PROTECTED] wrote:
Hi everybody, we have a MS-SQL-7 server piking (+ plateaus) to 100% CPU.
It is caused by mssqlserver.exe. How can we find out, what database access is
causing this,
since I have about 20 DBs running on them ? All DBs are powering
ColdFusion shop-systems.
Use
change query times
drastically from SP to SP (especially when we were using SQL 7)so
it's a good idea to run traces like this regularly, and make sure that
your indexes are optimized.
Make sure you run the tools on another machine...as there is quite a
bit of overhead associated with them.
On 3/21
Hi Hugo, and everybody
who answered on my question.
I will try most of the hints.
Thanks a lot !
Uwe
HA Try experimenting with trace logs, there you should also be able to see
HA how much cpu different actions/access takes. It can be hard to wade
HA through all though.
HA Some info here, for
This has worked for years in Access
UPDATE tbl_keeplist2
LEFT JOIN tbl_keeplist2_daily ON
tbl_keeplist2.ID = tbl_keeplist2_daily.ID
SET tbl_keeplist2.status = 'D'
WHERE tbl_keeplist2_daily.status = 'P'
OR tbl_keeplist2_daily.ID Is Null
But no luck in SQL 7 I get
-Original Message-
From: Ryan Roskilly [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 12:14 PM
To: CF-Talk
Subject: Left join works in Access NOT in SQL 7
This has worked for years in Access
UPDATE tbl_keeplist2
LEFT JOIN tbl_keeplist2_daily ON
tbl_keeplist2.ID
Entering () around that just gave me another syntax error.
Another forum gave me the following but it stats
Invalid object name 'tbl_keeplist2_daily'.
UPDATE tbl_keeplist2
SET status = 'D'
FROM tbl_keeplist2
LEFT JOIN tbl_keeplist2_daily ON
tbl_keeplist2.ID =
This ended up working
UPDATEtbl_keeplist2
SET tbl_keeplist2.status = 'D'
FROM tbl_keeplist2
LEFT JOIN tbl_keeplist2_daily ON
This ended up working
UPDATEtbl_keeplist2
SET tbl_keeplist2.status = 'D'
FROM tbl_keeplist2
LEFT JOIN
tbl_keeplist2_daily ON
fine ( or appear to ), however on an MS SQL 7 db, I get the message
error converting data type text to ntext ...
If I change the value of the input parameter in the stored procedure to text
and then explicitely convert the value during an insert or update in the
procedure, it works okay... What I
I have the following SQL Create statement ... MS SQL 7 doesn't like the collate, what
should I remove just the collate statement or the whole SQL_Latin1 ect...
CREATE TABLE [#form.dbOwner#].[#form.dbPrefix#admin_security] (
[id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
The whole thing. The syntax here is created for SQL 2000 - not SQL 7.0.
SQL 7.0 doesn't use collations.
-mk
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 08, 2002 8:43 PM
To: CF-Talk
Subject: OT: COLLATE SQL 7
I have the following SQL
Anyone ever seen a situation where the db goes into recovery when it gets done it just
sits there and does nothing??
SQL 7 cluster just gets to 100% for the recovery then it just says there and does
nothing.
Bill Wheatley
Senior Database Developer
Macromedia Certified Advanced Coldfusion
I want to use CF to run a SHOWCONTIG and send the results via an email and i'm
thinking of a way to get it to show em the results.
Can i set the results into an OUT VARIABLE and then have CF take that out var and
display that?
DECLARE id int, indid int
SET id = OBJECT_ID('tblBenefit')
do you have usernames and passwords defined in the CFAdmin?
-Original Message-
From: Double Down [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 07, 2002 8:09 PM
To: CF-Talk
Subject: Setting Up SQL 7 Database in MX
I just installed CFMX and when I went to my data sources page I see
I just installed CFMX and when I went to my data sources page I see that
there is an error on all SQL 7 databases. I checked my ODBC
Administrator and the database is connected through there. How do I set
if up in the CF Administrator?
TIA
DDINC
If you have no luck, try the standard ODBC socket, at least on a development
box behind a firewall. At least it actually works.
I've had no luck yet on getting the Java SQL driver to work yet (after six
years CF development).
the SQL 7 DB, with TXT files to import once the
tables have been created.
I'm not very SQL Server-savvy, so I'm just looking for suggestions.
I noticed in SQL 2000 there's an option to limit functionality to
SQL 7-level stuff - could I set this option, upsize to SQL 2000,
and just give them the DB
Hi there, has anyone researched which ODBC driver is most stable with CF 5
and MSSQL 7? We are currently running the 3.70.09.61 SQLserver driver and
this query will crash CF to 100% CPU every time I run it:
CFQUERY datasource=#request.mainDSN# Name=ViewAssignment
SELECT
Subject: sql 7 MDAC
Hi there, has anyone researched which ODBC driver is most stable with CF
5 and MSSQL 7? We are currently running the 3.70.09.61 SQLserver driver
and this query will crash CF to 100% CPU every time I run it:
CFQUERY datasource=#request.mainDSN# Name=ViewAssignment
SELECT
resorts
here and was hoping that SOMEBODY can offer a fix.
-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 11:40 AM
To: CF-Talk
Subject: RE: sql 7 MDAC
Have you tried using OLE DB or a Dynamic query with a connection string
:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 11:40 AM
To: CF-Talk
Subject: RE: sql 7 MDAC
Have you tried using OLE DB or a Dynamic query with a connection string?
__
steve oliver
cresco technologies, inc.
http://www.crescotech.com
-Original Message-
From
Adam,
How big is the query. I noticed it's from a view - are other queries from
views giving you any problems?
mark
-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 11:03 AM
To: CF-Talk
Subject: RE: sql 7 MDAC
due to forces beyond my
.
EC
-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 2:03 PM
To: CF-Talk
Subject: RE: sql 7 MDAC
due to forces beyond my control, we are stuck with ODBC.
I've updated the MDAC to 2.6 SP1 and it updated the SQLserver ODBC
driver
it
shouldn't be a bandwidth/memory issue. The server is pretty hefty on the
resources too.
Adam.
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 3:13 PM
To: CF-Talk
Subject: RE: sql 7 MDAC
Adam,
How big is the query. I noticed it's
- Original Message -
From: Cantrell, Adam [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, January 22, 2002 11:03 AM
Subject: RE: sql 7 MDAC
due to forces beyond my control, we are stuck with ODBC.
I've updated the MDAC to 2.6 SP1 and it updated the SQLserver ODBC driver
You might try adjusting the long text buffers in CF Admin or blockfactors
on that query to more closely control the flow of data. Just a guess...
-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 11:37 AM
To: CF-Talk
Subject: RE: sql 7
: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 3:47 PM
To: CF-Talk
Subject: RE: sql 7 MDAC
You might try adjusting the long text buffers in CF Admin or blockfactors
on that query to more closely control the flow of data. Just a guess...
-Original Message
List,
Does anyone know of a way in SQL (as opposed to enterprise manager) to get the file
size of a MS SQL database?
Thanks in advance,
Ben Morris
~~
Structure your ColdFusion code with Fusebox. Get the official book at
Does anyone know of a way in SQL (as opposed to enterprise manager) to get
the file size of a MS SQL database?
sp_helpdb()
Nick
**
Information in this email is confidential and may be privileged.
It is intended for the
and look
at the location of your database and it will tell you the name and the place
it is stored. Hope this helps.
Chris Sinkwitz
-Original Message-
From: BEN MORRIS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 7:35 AM
To: CF-Talk
Subject: MS SQL 7/2k File Size
List
To: CF-Talk
Subject: RE: MS SQL 7/2k File Size
There will be a file most likely in your D:\MSSQL7\DATA folder that will be
a .mdf file. That is your database, look at the properties of that. If you
don't know what the file would be named or can't figure it out you can look
in Enterprise Manager right
Its a very unique situation. We have a training lab here
that is completely cut off from the outside world. One of
our clients is coming in to train on our applications. Al
of their data is on our live DB, but I need to be able
to save something to disk to carry over to the training
Hey,
How do I go about importing a saved DTS once I have it?
Tim Heald
ACP/CCFD :)
Application Development
http://www.schoollink.net/
~~
Structure your ColdFusion code with Fusebox. Get the official book at
]]
Sent: Monday, August 27, 2001 10:03 AM
To: CF-Talk
Subject: OT: Importing saved DTS in SQL 7
Hey,
How do I go about importing a saved DTS once I have it?
Tim Heald
ACP/CCFD :)
Application Development
http://www.schoollink.net/
~~
Structure
Subject: RE: Importing saved DTS in SQL 7
Tim,
Need a little more detail here. Where do you want to import from/to? Is
it safe to say that you've created a DTS package on, let's say, a dev db
server and you now want to export it to your production db server?
Mark
-Original Message-
From
know if I find anything. Good Luck.
Mark
-Original Message-
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 10:27 AM
To: CF-Talk
Subject: RE: Importing saved DTS in SQL 7
Its a very unique situation. We have a training lab here that is
completely
cut off from
to reuse it just save again once it is open to the SQL
Server Repository.
If you have anymore questions let me know.
Chris Sinkwitz
-Original Message-
From: Mark Stewart [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 7:41 AM
To: CF-Talk
Subject: RE: Importing saved DTS in SQL 7
Message-
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 9:27 AM
To: CF-Talk
Subject: RE: Importing saved DTS in SQL 7
Its a very unique situation. We have a training lab here that is
completely cut off from the outside world. One of our clients is coming
I would not recommend this way at all. This gives you a good change of
corrupting your database.
-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 8:38 AM
To: CF-Talk
Subject: RE: Importing saved DTS in SQL 7
In situations like that, I
Sinkwitz [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 11:27 AM
To: CF-Talk
Subject: RE: Importing saved DTS in SQL 7
Step 1.
Go into Enterprise Manager
Step 2.
Connect to your database server
Step 3.
Right click on the Data Transformation Services folder
Step 4.
Select All Tasks
: Monday, August 27, 2001 10:47 AM
To: CF-Talk
Subject: RE: Importing saved DTS in SQL 7
I would not recommend this way at all. This gives you a good change of
corrupting your database.
-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 8:38 AM
on
another machine.
-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 9:11 AM
To: CF-Talk
Subject: RE: Importing saved DTS in SQL 7
I'd agree, but like I said, I've had some success with it, so file it
away as a last resort. Just for my own
To: CF-Talk
Subject: RE: Importing saved DTS in SQL 7
You could have DTS packages on one server that are not on your dev
server and by replacing the .mdf and .ldf it would erase any hooks to
that package that it didn't know about. What you are doing is basically
taking and entire SQL repository
This seems to be a new problem that I haven't had before with NT 4. At least in the
time I have worked with SQL 7 I don't remember having to set the maximum memory
setting in SQL 7.
But anyway the default memory setup left only 5 meg of free memory out of 800+ meg.
Only running 1% cpu usage
Other than converting to Lauren* Closet and searching for Lauren*
Closet, how do I automagically search and find: Lauren's Closet using
SQL7 full text search?
best, paul
~~
Structure your ColdFusion code with Fusebox. Get the official book at
Other than converting to Lauren* Closet and searching for Lauren*
Closet, how do I automagically search and find: Lauren's
Closet using
SQL7 full text search?
Escape single quotes by replacing them with two single quotes prior to
submitting the search query. You would then be searching for
Thanks! That's what I tried first. Didn't work. Now it does. Go figure.
best, paul
At 03:39 PM 6/5/01 -0500, you wrote:
Other than converting to Lauren* Closet and searching for Lauren*
Closet, how do I automagically search and find: Lauren's
Closet using
SQL7 full text search?
I set SET NOCOUNT ON/OFF outside the BEGIN/COMMIT TRANSACTION and it seems
to work fine.
Thanks!
best, paul
At 10:54 AM 5/10/01 +0700, you wrote:
* Team Allaire *
Thanks! Now that you mention it I did had BEGIN TRANSACTION/COMMIT
I've been putting one SQL statement after another like the following inside
a CFQUERY for a while. Seems to work fine.
UPDATE MAX_ID_Clients SET MAX_ID_Client = MAX_ID_Client + 1
DECLARE @MAX INT
SELECT @MAX = MAX_ID_Client FROM MAX_ID_Clients
INSERT INTO ClientData(CFID,CFTOKEN)
-
From: Paul Smith [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, May 09, 2001 9:36 PM
Subject: SQL 7 Question
I've been putting one SQL statement after another like the following
inside
a CFQUERY for a while. Seems to work fine.
UPDATE MAX_ID_Clients SET MAX_ID_Client
if they
both hit it at the same time and the two updates run before either of the
selects? @max is probabaly going to be off...
jon
- Original Message -
From: Paul Smith [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, May 09, 2001 9:36 PM
Subject: SQL 7 Question
I've been
On 4/20/01, Bob Silverberg penned:
When you install the SQL 2000 client tools on your machine it will overwrite
the SS7 tools (e.g., Enterprise Manager). You can only have one version of
EM on a machine.
You can install 2000 as a separate Instance and it won't touch 7.
I've got both desktop
to
add to that?
Bob
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 21, 2001 6:33 AM
To: CF-Talk
Subject: RE: SQL 7 and 2000 on same machine?
On 4/20/01, Bob Silverberg penned:
When you install the SQL 2000 client tools on your machine it will
overwrite
the SS7
version). Do you have something to
add to that?
Nope. I mistakenly thought that the old version of EM remained with
SQL 7. Thanks for setting me straight. :)
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL
Hopefully someone can help.
I am now at the point where I have to start supporting both SQL 7 and 2000
databases. I know I can manage sql 7 databases through sql 2000 enterprise
manager, but can I create sql 7 databaases with 2000? Or do I have to have
both enterprise managers on the same
you can create DBs on a remote SQL 7 machine with SQL 2000 ent. mgr.
-Original Message-
From: Sandra Clark [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 20, 2001 4:32 PM
To: CF-Talk
Subject: OT: SQL 7 and 2000 on same machine?
Hopefully someone can help.
I am now at the point
installing the SS2K client tools on your machine will allow you to manage
all of your database servers.
Bob
-Original Message-
From: Sandra Clark [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 20, 2001 7:32 PM
To: CF-Talk
Subject: OT: SQL 7 and 2000 on same machine?
Hopefully someone
In a message dated 4/20/2001 7:33:42 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
I am now at the point where I have to start supporting both SQL 7 and 2000
databases. I know I can manage sql 7 databases through sql 2000 enterprise
manager, but can I create sql 7 databaases with 2000
Ask Bud Shenanigans on this list (sorry, can't remember his real surname).
He's recently been through the mill with SQL Server licences... might have
picked up some info on upgrading too.
And this is some info the network admin here sent me the other day... might
be useful:
On 3/16/01, Aidan Whitehall penned:
Ask Bud Shenanigans on this list (sorry, can't remember his real surname).
He's recently been through the mill with SQL Server licences... might have
picked up some info on upgrading too.
LOL
That's closer than most of the telemarketer's get. :)
What does it
What does it cost to upgrade? Do you need to upgrade the Internet connector licensee?
Where should I purchase?
--
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
You can manage SQL 7 (and 6.5) databases using the SQL 2k Enterprise
Manager. You cannot manage SQL 2k databases using the SQL 7 Enterprise
Manager.
Cary
At 06:54 PM 2/16/2001 -0500, you wrote:
On 2/16/01, Cary Gordon penned:
One possible negative is that, if you have a mixed environment
Anyone have experience with the upgrade of SQL7 to SQL2K? Negatives.. etc?
Just thought I'd ask before trying it. All the docs say it's pretty much a
no-brainer.. but we all know what THAT means...
Lee Fuller
Chief Technical Officer
PrimeDNA Corporation
Its the easiest upgrade you'll ever do ...
-Original Message-
From: Lee Fuller [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 1:14 PM
To: CF-Talk
Subject: SQL 7 vs SQL2k...
--
From: Lee Fuller[SMTP:[EMAIL PROTECTED]]
Sent: Friday, February 16
One possible negative is that, if you have a mixed environment, you cannot
manage SQL-2k databases from the SQL 7 Enterprise Manager. The converse
works fine.
Cary
At 10:14 AM 2/16/2001 -0800, you wrote:
Anyone have experience with the upgrade of SQL7 to SQL2K? Negatives.. etc?
Just
On 2/16/01, Cary Gordon penned:
One possible negative is that, if you have a mixed environment, you cannot
manage SQL-2k databases from the SQL 7 Enterprise Manager. The converse
works fine.
Can you elaborate on that?
--
Bud Schneehagen - Tropical Web Creations
I have have a 20 gig hard drive that I formated the whole drive C into one partition.
20 gigs. Now I'm trying to put SQL 7 SP3 on it. When I try in unpack the service pack
it pops up and says there is not
enough space on the hard drive free up 76 meg and try again... Weird because there is
16
It worked for me. Is your C drive formatted NTFS?
Regards,
Howie
- Original Message -
From: [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, January 04, 2001 5:52 PM
Subject: WOT: SQL 7 SP3 on Windows 2000 server. Weird?
I have have a 20 gig hard dr
Does anyone know of any handy tools that enable one to more efficiently
manipulate creating tables, fields with SQL 7 from a web browser forms based
interface?
Or is there perhaps something else out there that's faster than the SQL 7
client program? Thanks
You could struggle with that one as you would require loads of permissions
etc... it is also not a good idea in practice/theory. I have an app which
can do it for an Access DB (which also requires you to change your DB
security rights)
N
! ---
Neil Clark
Senior
I run this query on a VIEW and I get a list of the column_name's with a data_type of
bit.
SELECT DATA_TYPE, TABLE_NAME, ORDINAL_POSITION,
COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE (TABLE_NAME = N'defaultview') AND (DATA_TYPE = N'bit')
ORDER BY ORDINAL_POSITION
I change the query
We are evaluating how our websites run on NT versus Solaris. What do I need on the
CF/Solaris side to connect with my NT/SQL7 Database? I tried using the Merant default
MSSQL Driver and it can verify the datasource but it does not get any data and throws
errors when the page is executed.
ge-
From: Al Musella, DPM [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 1:41 PM
To: CF-Talk
Subject: ODBC Error 37000
I have been getting this error message a lot lately.. I have no
idea where the problem is.
When it happens, I have been rebooting the cold fus
Check out sp_change_users_login to recover "phantom" logins.
Works like a charm.
best, paul
At 02:47 PM 12/1/00 -0500, you wrote:
There's one problem that I ran into with moving databases with sp_attach_db
on SQL Server 7. If you've specified any logins for that database within the
original
Please explain this in more detail.
In addition, does it work for dbo?
best, paul
At 09:34 PM 12/6/00 -0500, you wrote:
Actually... as I recall there is a solution to that which I
hacked together.
As I recall, there's a stored procedure to delete a user in
the master database. Just
Actually... as I recall there is a solution to that which I hacked together.
As I recall, there's a stored procedure to delete a user in the master database.
Just copy that sp across to the restored database, and run it on those users.
Worked for me. Neat, huh?
David Cummins
Dave Watts wrote:
Actually... as I recall there is a solution to that which I
hacked together.
As I recall, there's a stored procedure to delete a user in
the master database. Just copy that sp across to the restored
database, and run it on those users.
Worked for me. Neat, huh?
That is neat! I hope
Hi list, I have a CF 4.02 Enterprise Server.
I want to get access to a MS SQL 7 DB via a TCP/IP-connection. It works fine
when I do it locally but not via the net.
I have a TCP/IP connectivity between the DB-machine and the CF-machine
instead of named pipes.
Default port 1433 is open.
I double
Look up the syntax for sp_dettach and sp_attach.
With that you can move the db by hand with no leftovers.
There's one problem that I ran into with moving databases with sp_attach_db
on SQL Server 7. If you've specified any logins for that database within the
original database server, the
Don't you have an option whether or not to transfer individual objects such
as logins?
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 01, 2000 11:48 AM
To: CF-Talk
Subject: RE: SQL 7 database transfer from one server to another
Look up the syntax
Please ignore my prior reply. I did not catch you were talking about
sp_attach_db. Sorry.
-Original Message-
From: Rich Pransky [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 01, 2000 9:10 PM
To: CF-Talk
Subject: RE: SQL 7 database transfer from one server to another
Don't you
when I transfer a SQL database from one server to another using MSDTS, it
ignores the datatypes. am I missing something when I use MSDTS, or is this
a bug?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
This is a multi-part message in MIME format.
--=_NextPart_000_0038_01C05AC0.8A100420
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
when I transfer a SQL database from one server to another using MSDTS, =
it ignores the datatypes. am I
however left with a few questions that I
hope some kind soul(s) could answer for me.
The Burning Questions (as in if I don't get these answered, my boss
is gonna burn me at the stake...):
1) Can anyone confirm or deny that CF 4.5.x is unable to handle
Unicode text from an MS SQL 7 database? If anyone
That said, I'm hoping to make another attempt at upgrading to CF
4.5.1 / Win2k. My beloved baby (a *very* stable, *very* profitable
server) must unfortunately be moved off-site for better bandwidth,
and I'd REALLY like to have Win2k on that box so I can TermServe in
if necessary, etc. I'm
USE oledb as dbtype
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 15, 2000 6:19 PM
To: [EMAIL PROTECTED]
Subject: MS SQL 7 Varchar
I've got a MS SQL 7 table with some fields defined as Varchar(510).
When I retrieve them in CF Pro 4.01 via ODBC
I believe this happens when you upsize from Access and the original Access
field is Text (255).
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 15, 2000 10:19 AM
To: [EMAIL PROTECTED]
Subject: MS SQL 7 Varchar
I've got a MS SQL 7 table with some
Thanks for the help. That may be the case when upsizing, but this
database wasn't. Actually, I found the answer elsewhere - it's because
I was using older ODBC drivers that aren't MS SQL 7 aware. In SQL 6.5
varchar fields have a limit of 255 characters, while in SQL 7 the limit
is 8000.
Jim
You need to update the MDAC.
My SQL driver is showing version 3.70+
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 15, 2000 10:19 AM
To: [EMAIL PROTECTED]
Subject: MS SQL 7 Varchar
I've got a MS SQL 7 table with some fields defined as Varchar(510
I've got a MS SQL 7 table with some fields defined as Varchar(510).
When I retrieve them in CF Pro 4.01 via ODBC, they get truncated to 255
characters. Is there a reason for this? How about a workaround?
Jim
I know you can assign more than one column in setting up a fulltext index
on a table -- but it seems like you can't include more than one column in
the where CONTAINS statement...if this is indeed true how do you create a
query to search thru all of the columns you have included in the fulltext
BY KEY_TBL.RANK DESC
--
Original Message
From: "PC"[EMAIL PROTECTED]
Subject: OT SQL 7 FULL-TEXT more than one column?
Date: Tue, 05 Sep 2000 12:44:52 -0700
I know you can assign more than one column in setting up a fulltext index
on a table -- bu
I am colocating an NT 4 server running coldfusion and SQL 7 for a
web site.
I need to know which version of sql 7 I should purchase for unlimited
internet connections/not developer connections I seem to recall that
it's different than the true UNLIMITED client version which retails
) for
the backend to their web site.
-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: 01 August 2000 10:33
To: [EMAIL PROTECTED]
Subject: RE: appropriate SQL 7 licensing for CF website
I am colocating an NT 4 server running coldfusion and SQL 7 for a
web site
I think this is a 'hazy' area. It's the same as CF. If you are running a
multi-processor server you are supposed to have a special CF license for
each processor but I heard that Allaire have sold very few of
these. Every
company that I have worked for have bought a normal SQL license
I think this is a 'hazy' area. It's the same as CF. If you are running a
multi-processor server you are supposed to have a special CF license for
each processor but I heard that Allaire have sold very few of
these. Every
company that I have worked for have bought a normal SQL license
1 - 100 of 134 matches
Mail list logo