Ben Forta wrote:
> Less forgiving perhaps, or it could be that it just does a lot less and
> thus has less reserved words. Don't get me wrong, I like MySQL and use
> it myself for some projects, but it is nowhere near as feature rich
> (yet) as SQL Server (or Oracle or ...).
The problem is lack o
o: CF-Talk
> Subject: RE: Moving from MySQL to MS SQL Server 2000
>
>
> Execute sp_tables and see what tables get returned, make sure
> "tbllogin"
> is listed.
>
>
>
> -Original Message-
> From: Bushy [mailto:[EMAIL PROTECTED]
> Sent: Wednesda
g my head
> > against the wall, scream, holler, etc. Then someone finally told me it was a
> > reserved word and I kicked my ex boss in the head. :)
> >
> > -Original Message-----
> > From: Bushy [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 9:37 AM
To: CF-Talk
Subject: RE: Moving from MySQL to MS SQL Server 2000
OK...It seems MySQL is more forgiving.
Thanks
On Wed, 13 Aug 2003 14:28:13 +0100, Craig Dudley wrote:
> A fair amount of people simply start tab
Yes, this is exactly what I do Bushy. If you do that you will never have a
problem like you have. Thanks Craig.
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 9:28 AM
To: CF-Talk
Subject: RE: Moving from MySQL to MS SQL Server 2000
A
A fair amount of people simply start table names with 'tbl', which would
solve your problems.
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: 13 August 2003 14:28
To: CF-Talk
Subject: RE: Moving from MySQL to MS SQL Server 2000
Login is a reserved wo
ingly, never use sa for your cf apps. Sorry for
the digression there, just thought it was a point worth making.
Mark
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 9:45 AM
To: CF-Talk
Subject: RE: Moving from MySQL to MS SQL Server 2000
Hmmm
Problem was with SQL username/password at time of installation. Once I fixed that it
was fine.
Will I run into problems if I name my databases with this syntax? Will the "_" cause
me problems in SQL or CF ?
interface_prefs
~~
ssage-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 8:45 AM
To: CF-Talk
Subject: RE: Moving from MySQL to MS SQL Server 2000
HmmmI just changed all the table names to have "tbl" at the beginning. I
ran a test using the SQL Query Analyzer. Just did a sim
ble quotes to single quotes. As for the
> error, could you post the query so we can see what's going on?
>
> Mark
>
> -Original Message-
> From: Bushy [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 13, 2003 7:21 AM
> To: CF-Talk
> Subject: re: Movin
Hi,
I've just migrated my databases over to SQL server. DO I need to change any of my CF
code especially my tags?
I get this error when running my app.
ODBC Error Code = S0002 (Base table not found)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'login'.
~~
IL PROTECTED]
> Sent: 13 August 2003 14:28
> To: CF-Talk
> Subject: RE: Moving from MySQL to MS SQL Server 2000
>
>
> Login is a reserved word. Change the login table name to something else
> and it will work. Try not to use names for anything that are simple
> na
---
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 12:24 PM
To: CF-Talk
Subject: RE: Moving from MySQL to MS SQL Server 2000
Problem was with SQL username/password at time of installation. Once I fixed
that it was fine.
Will I run into problems if I name my databases with this s
AM
To: CF-Talk
Subject: RE: Moving from MySQL to MS SQL Server 2000
It's a simple query.
select * from login
I've added the database via Data Sources (ODBC) under the System DSN tab
using the SQL Server driver. I did a test and it passed.
On Wed, 13 Aug 2003 09:03:55 -0400, Ma
: RE: Moving from MySQL to MS SQL Server 2000
HmmmI just changed all the table names to have "tbl" at the beginning. I
ran a test using the SQL Query Analyzer. Just did a simple
select * from tbllogin
Worked fine until I tried to run the simple query within my .CFM template
riginal Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 9:37 AM
To: CF-Talk
Subject: RE: Moving from MySQL to MS SQL Server 2000
OK...It seems MySQL is more forgiving.
Thanks
On Wed, 13 Aug 2003 14:28:13 +0100, Craig Dudley wrote:
> A fair amount of p
from MySQL to MS SQL Server 2000
Hi,
I've just migrated my databases over to SQL server. DO I need to change any of my CF
code especially my tags?
I get this error when running my app.
ODBC Error Code = S0002 (Base table not found)
[Microsoft][ODBC SQL Server Driver][SQL Server]Inva
where did you declare your DSN? in coldfusion administrator or in the System DSN
window from your windows => Services?
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: woensdag 13 augustus 2003 15:45
To: CF-Talk
Subject: RE: Moving from MySQL to MS SQL Server 2000
H
> From: Bushy [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 13, 2003 9:37 AM
> To: CF-Talk
> Subject: RE: Moving from MySQL to MS SQL Server 2000
>
>
> OK...It seems MySQL is more forgiving.
>
>
> Thanks
>
>
> On Wed, 13 Aug 2003 14:28:13 +0100, Cr
m/vicodemo/login.cfm
- Original Message -
From: "Bushy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 13, 2003 9:45 AM
Subject: RE: Moving from MySQL to MS SQL Server 2000
> HmmmI just changed all the table names to have "
Forgive me if I'm wrong ,
but
double and triple check the datasource is actually pointing at the
correct database ;-)
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: 13 August 2003 14:45
To: CF-Talk
Subject: RE: Moving from MySQL to MS SQL Server 2000
Hmmm
Execute sp_tables and see what tables get returned, make sure "tbllogin"
is listed.
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 9:45 AM
To: CF-Talk
Subject: RE: Moving from MySQL to MS SQL Server 2000
HmmmI just changed all
Bushy, double check that your datasource is pointing to the correct
database.
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 9:45 AM
To: CF-Talk
Subject: RE: Moving from MySQL to MS SQL Server 2000
HmmmI just changed all the table names to
23 matches
Mail list logo