This is a multi-part message in MIME format.
------=_NextPart_000_0158_01C01416.6FC80770
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
ODBC Error Code=S0002(Base Table Not found)If the "sort order" of the
database has been set to binary, or something other than "case-insensitive
dictionary sort", you will have to refer to the tables in the exact case as
specified in the SQL Server database. This looks like a case-sensitivity
problem.
DC
-----Original Message-----
From: John Crawford [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 01:06
To: [EMAIL PROTECTED]
Subject: ODBC Error Code=S0002(Base Table Not found)
Newbie Question.
NT 4.0 sp6 Running SQL 6.5 sp5
I have a datasource=cresthollow with one table=contacts
I get the following error
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = S0002 (Base table not found)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'Contacts'.
The error occurred while processing an element with a general identifier
of
(CFQUERY), occupying document position (7:1) to (7:49).
Here is the code, I have not implemented much error trapping yet. but this
does work on my local machine using access 2k. Thanks in advance for you
help.
<HTML>
<HEAD>
<TITLE>Thanks</TITLE>
</HEAD>
<BODY BGCOLOR="#ffffff" BACKGROUND="Graphics/background.jpg">
<cfquery NAME="Contacts" DATASOURCE="cresthollow">
INSERT INTO contacts (firstname, lastname, address, city, state,
postalcode,
email,phone,
fax, notes, functions, othertext)
VALUES ('#Form.firstname#', '#Form.lastname#', '#Form.address#',
'#Form.city#',
'#Form.state#', '#Form.postalcode#', '#Form.email#', '#Form.phone#',
'#Form.fax#', '#Form.notes#', '#Form.functions#', '#Form.othertext#' )
</CFQUERY>
<cfmail FROM="#Form.email#"
TO="[EMAIL PROTECTED]"
SUBJECT="Automated Contact Form Submission">
Hi,
My name is #Form.firstname# #Form.Lastname# and I used your online contact
form to send you the following comments:
I would like information on the following:
#Form.functions#
<cfif Form.notes is not "">
I have encluded the following comments:
#Form.notes#
</cfif>
I can be reached at:
Address:<BR>
#Form.address#<BR>
#Form.City#, #Form.State# #Form.postalcode#
Phone: #Form.phone#
Fax: #Form.Fax#
Email: #Form.email#
</cfmail>
Thanks
<cfoutput>
#Form.Firstname#
</cfoutput>
<HR>
Your form has been successfully submitted. Someone will be in contact with
you shortly.
</BODY>
</HTML>
John R. Crawford
Dolphin NewMedia, Inc
[EMAIL PROTECTED]
Phone 717-728-5554
Fax 717-728-5566
--------------------------------------------------------------------------
----
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------=_NextPart_000_0158_01C01416.6FC80770
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>ODBC Error Code=3DS0002(Base Table Not found)</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D745361213-01092000>If the=20
"sort order" of the database has been set to binary, or something other =
than=20
"case-insensitive dictionary sort", you will have to refer to the tables =
in the=20
exact case as specified in the SQL Server database. This looks =
like a=20
case-sensitivity problem.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D745361213-01092000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D745361213-01092000>DC</SPAN></FONT></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> John Crawford=20
[mailto:[EMAIL PROTECTED]]<BR><B>Sent:</B> Friday, =
September 01,=20
2000 01:06<BR><B>To:</B> [EMAIL PROTECTED]<BR><B>Subject:</B> =
ODBC=20
Error Code=3DS0002(Base Table Not found)<BR><BR></DIV></FONT>
<P><FONT size=3D2>Newbie Question.</FONT> <BR><FONT size=3D2>NT 4.0 =
sp6 Running=20
SQL 6.5 sp5</FONT> </P>
<P><FONT size=3D2>I have a datasource=3Dcresthollow with one =
table=3Dcontacts</FONT>=20
<BR><FONT size=3D2>I get the following error</FONT> </P>
<P><FONT size=3D2>Error Occurred While Processing Request</FONT> =
<BR><FONT=20
size=3D2>Error Diagnostic Information</FONT> <BR><FONT size=3D2>ODBC =
Error Code =3D=20
S0002 (Base table not found)</FONT> <BR><FONT =
size=3D2>[Microsoft][ODBC SQL=20
Server Driver][SQL Server]Invalid object name</FONT> <BR><FONT=20
size=3D2>'Contacts'.</FONT> <BR><FONT size=3D2>The error occurred =
while processing=20
an element with a general identifier of</FONT> <BR><FONT =
size=3D2>(CFQUERY),=20
occupying document position (7:1) to (7:49).</FONT> </P>
<P><FONT size=3D2>Here is the code, I have not implemented much error =
trapping=20
yet. but this</FONT> <BR><FONT size=3D2>does work on my local machine =
using=20
access 2k. Thanks in advance for you</FONT> <BR><FONT =
size=3D2>help.</FONT> </P>
<P><FONT size=3D2><HTML></FONT> <BR><FONT =
size=3D2><HEAD></FONT> </P>
<P><FONT size=3D2> <TITLE>Thanks</TITLE></FONT> =
<BR><FONT=20
size=3D2></HEAD></FONT> <BR><FONT size=3D2><BODY =
BGCOLOR=3D"#ffffff"=20
BACKGROUND=3D"Graphics/background.jpg"></FONT> <BR><FONT =
size=3D2><cfquery=20
NAME=3D"Contacts" DATASOURCE=3D"cresthollow"></FONT> <BR><FONT =
size=3D2>INSERT=20
INTO contacts (firstname, lastname, address, city, state, =
postalcode,</FONT>=20
<BR><FONT size=3D2>email,phone,</FONT> <BR><FONT size=3D2>fax, notes, =
functions,=20
othertext)</FONT> <BR><FONT size=3D2>VALUES ('#Form.firstname#',=20
'#Form.lastname#', '#Form.address#',</FONT> <BR><FONT=20
size=3D2>'#Form.city#',</FONT> <BR><FONT =
size=3D2> '#Form.state#',=20
'#Form.postalcode#', '#Form.email#', '#Form.phone#',</FONT> <BR><FONT=20
size=3D2> '#Form.fax#', '#Form.notes#', '#Form.functions#',=20
'#Form.othertext#' )</FONT> <BR><FONT size=3D2></CFQUERY></FONT> =
<BR><FONT=20
size=3D2><cfmail FROM=3D"#Form.email#"</FONT> <BR><FONT=20
size=3D2>TO=3D"[EMAIL PROTECTED]"</FONT> <BR><FONT=20
size=3D2>SUBJECT=3D"Automated Contact Form Submission"></FONT> =
<BR><FONT=20
size=3D2>Hi,</FONT> <BR><FONT size=3D2>My name is #Form.firstname# =
#Form.Lastname#=20
and I used your online contact</FONT> <BR><FONT size=3D2>form to send =
you the=20
following comments:</FONT> </P>
<P><FONT size=3D2>I would like information on the following:</FONT> =
<BR><FONT=20
size=3D2>#Form.functions#</FONT> </P>
<P><FONT size=3D2><cfif Form.notes is not ""></FONT> <BR><FONT =
size=3D2>I=20
have encluded the following comments:</FONT> <BR><FONT=20
size=3D2>#Form.notes#</FONT> <BR><FONT size=3D2></cfif></FONT> =
<BR><FONT=20
size=3D2>I can be reached at:</FONT> <BR><FONT =
size=3D2>Address:<BR></FONT>=20
<BR><FONT size=3D2>#Form.address#<BR></FONT> <BR><FONT =
size=3D2>#Form.City#,=20
#Form.State# #Form.postalcode#</FONT> </P>
<P><FONT size=3D2>Phone: #Form.phone#</FONT> <BR><FONT size=3D2>Fax:=20
#Form.Fax#</FONT> <BR><FONT size=3D2>Email: #Form.email#</FONT> </P>
<P><FONT size=3D2></cfmail></FONT> <BR><FONT =
size=3D2>Thanks</FONT>=20
<BR><FONT size=3D2><cfoutput></FONT> <BR><FONT=20
size=3D2>#Form.Firstname#</FONT> <BR><FONT =
size=3D2></cfoutput></FONT>=20
<BR><FONT size=3D2><HR></FONT> <BR><FONT size=3D2>Your form has =
been=20
successfully submitted. Someone will be in contact with</FONT> =
<BR><FONT=20
size=3D2>you shortly.</FONT> <BR><FONT size=3D2></BODY></FONT> =
<BR><FONT=20
size=3D2></HTML></FONT> </P><BR>
<P><FONT size=3D2>John R. Crawford</FONT> <BR><FONT size=3D2>Dolphin =
NewMedia,=20
Inc</FONT> <BR><FONT size=3D2>[EMAIL PROTECTED]</FONT> =
<BR><FONT=20
size=3D2>Phone 717-728-5554</FONT> <BR><FONT =
size=3D2>Fax =20
717-728-5566</FONT> </P>
<P><FONT=20
=
size=3D2>----------------------------------------------------------------=
--------------</FONT>=20
<BR><FONT size=3D2>Archives: <A=20
href=3D"http://www.mail-archive.com/[email protected]/"=20
=
target=3D_blank>http://www.mail-archive.com/[email protected]/</A=
></FONT>=20
<BR><FONT size=3D2>To Unsubscribe visit <A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_talk</A>=20
or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in=20
the body.</FONT></P></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0158_01C01416.6FC80770--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
