I tried connection to create a CF ODBC datasource connection today on a Windows
2008 Server machine and got the following error:
HError accessing available odbc datasources. - Cannot open
HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INIODBC Data Sources: Windows error 2
occurred.The system cannot find
Figured out that I needed to make a 64bit DSN to initialize something on the
server. I used firebug to manually enter my 32bit DSN, submit and get:
Connection verification failed for data source: merlinFoxPro
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal
OK guys .. I am new to CF. I have a desktop ODBC that connects. The data
source within CF connects. Why do I get this error? I get so far into the
program and then I get this message ..
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Informix][Informix
: Wednesday, October 15, 2008 4:22 PM
::To: cf-talk
::Subject: ODBC Error
::
::OK guys .. I am new to CF. I have a desktop ODBC that connects. The
::data source within CF connects. Why do I get this error? I get so far
::into the program and then I get this message ..
::
::Error Executing Database
ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS
A SYNTAX PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS
IS A SIMPLE LOGIN APPLICATION.
Error Executing Database Query. [Macromedia][SequeLink JDBC
Driver][ODBC Socket][Microsoft][ODBC Microsoft Access
On 1/23/08, Nick Ross [EMAIL PROTECTED] wrote:
ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS A
SYNTAX PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS IS A
SIMPLE LOGIN APPLICATION.
Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS A SYNTAX
PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS IS A SIMPLE LOGIN
APPLICATION.
Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver]
On Jan 23, 2008 10:42 AM, Nick Ross [EMAIL PROTECTED] wrote:
ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS A
SYNTAX PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS IS A
SIMPLE LOGIN APPLICATION.
really? 3 times now? and still with the caps lock?
--
We've got CFMX 6.1 installed with all of the current updates. Just
today I noticed the following error:
The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Server
) cannot be found. The local computer may not have the necessary
registry information or message DLL files to display
I am attempting to connect to an Advantage database.
I have been to the Advantage website and downloaded the ODBC driver, and
installed it. I used the ODBC manager on the server machine to set up a
connection (HHMeds). I then added the new data source in CF
Administrator (HHMeds). When I attempt
what do you make of this...
ODBC Error Code = S1C00 (Driver not capable)
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented
error when i try exectuting a stored procedure with an odbc sql server driver
for the dsn.
sql server 2000, cf5, btw
the dsn is verifiable
I am reading an excel file with an ODBC query and I am getting the following
error.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel
Driver] Too many fields defined.
Can anyone explain this error, I am not sure why I am getting it.
--
James Smith
[EMAIL PROTECTED]
James Smith wrote:
I am reading an excel file with an ODBC query and I am getting the following
error.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel
Driver] Too many fields defined.
Can anyone explain this error, I am not sure why I am getting it.
There is a limit
: 16 November 2004 12:54
To: CF-Talk
Subject: ODBC error I can't explain
I am reading an excel file with an ODBC query and I am getting the following
error.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel
Driver] Too many fields defined.
Can anyone explain this error, I am
Robertson-Ravo, Neil (RX) wrote:
Should be fairly self explanatory...you are passing too much information to
the Datasource - it is expecting say 10 fields of data and you are passing
it 11.
Perform a data mapping to see what you should be passing.
Wrong way around Neil. He's querying the
: Re: ODBC error I can't explain
James Smith wrote:
I am reading an excel file with an ODBC query and I am getting the
following error.
[Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Excel
Driver] Too many fields defined.
Can anyone explain this error, I am not sure
James Smith wrote:
That would be my interpretation of the error as well, however the sheet only
has 1 column and that column has only 2956 records.
Any other ideas?
Still sounds like that is the problem. Although when you look at the
spreadsheet it only has one column with data in it,
That would be my interpretation of the error as well,
however the sheet
only has 1 column and that column has only 2956 records.
Any other ideas?
Still sounds like that is the problem. Although when you
look at the spreadsheet it only has one column with data in
it, excel has a
Never seen this error before...
===
ODBC Error Code = S1001 (Memory allocation error)
[Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary
disk.
===
Can anyone provide some insight and a possible fix?
--David
-Talk
Subject: ODBC Error Code = S1001 (Memory allocation error)
Never seen this error before...
===
ODBC Error Code = S1001 (Memory allocation error)
[Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary
disk.
===
Can
Database coppied from a CD is set with read-only permissions? ... just the first thing
that occurs to me.
Never seen this error before...
===
ODBC Error Code = S1001 (Memory allocation error)
[Microsoft][ODBC Microsoft Access Driver] Not enough space
The db is located on a webserver at CFDynamics.
- Original Message -
From: S. Isaac Dealey [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 10:21 AM
Subject: Re: ODBC Error Code = S1001 (Memory allocation error)
Database coppied from a CD is set with read
-Talk [EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 10:15 AM
Subject: ODBC Error Code = S1001 (Memory allocation error)
Never seen this error before...
===
ODBC Error Code = S1001 (Memory allocation error)
[Microsoft][ODBC Microsoft Access Driver] Not enough
05, 2003 10:21 AM
Subject: Re: ODBC Error Code = S1001 (Memory allocation
error)
Database coppied from a CD is set with read-only
permissions? ... just the
first thing that occurs to me.
Never seen this error before...
===
ODBC Error Code = S1001 (Memory
We have a box win2000 with cf 5 that points to a sql2000 box. We started noticing a
lot of these errors that occured randomly
ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server Driver][TCP/IP
Sockets]ConnectionWrite
We tried rebooting, we tried re starting the cf service
ideas...
-Original Message-
From: Michael Ross [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 11:23 AM
To: CF-Talk
Subject: odbc error 01000 (General Warning)
We have a box win2000 with cf 5 that points to a sql2000 box. We
started noticing a lot of these errors that occured
When I try to create datasource from CFMX Administrator page using ODBC
Socket I get following error right after click Add Button.
Variable THISDATASOURCE is undefined.
The Error Occurred in
C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 522
Called from
have you added a datasource name?
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 09:50
To: CF-Talk
Subject: ODBC Error
When I try to create datasource from CFMX Administrator page using ODBC
Socket I get following error right after click Add
: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 09:52
To: CF-Talk
Subject: RE: ODBC Error
have you added a datasource name?
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 09:50
To: CF-Talk
Subject: ODBC Error
When I try
username/password/server?
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 09:57
To: CF-Talk
Subject: RE: ODBC Error
Yeah, I filled datasource name field with OPERADATA and from select box
I select ODBC Socket. As soon as I click Add button I said
Subject: RE: ODBC Error
username/password/server?
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 09:57
To: CF-Talk
Subject: RE: ODBC Error
Yeah, I filled datasource name field with OPERADATA and from select box
I select ODBC Socket. As soon as I click
are you prefixing the domina password with the domain?
i.e. MYDOMAIN/USERNAME
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 10:11
To: CF-Talk
Subject: RE: ODBC Error
Sa.coldfusiondev/password/intranet-dev
If I change coldfusion services back
-Talk
Subject: RE: ODBC Error
are you prefixing the domina password with the domain?
i.e. MYDOMAIN/USERNAME
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 10:11
To: CF-Talk
Subject: RE: ODBC Error
Sa.coldfusiondev/password/intranet-dev
If I change
so, you just had to add the domain?
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 11:28
To: CF-Talk
Subject: RE: ODBC Error
Its fixed. Thanks a lot.
I was using sa.coldfusiondev (as its Logon name) in CFMX Admin. But when
I browsed through
That's correct
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 11:32
To: CF-Talk
Subject: RE: ODBC Error
so, you just had to add the domain?
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]]
Sent: 03 December
bella...
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 11:38
To: CF-Talk
Subject: RE: ODBC Error
That's correct
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 11:32
To: CF-Talk
I have a transaction here that was working fine, but is now returning
[Macromedia][SQLServer JDBC Driver][SQLServer]Could not find prepared
statement with handle -1. when executed. I have also started and started
all MX services, hoping that it might fix it, it does not. Again, the
strange
PROTECTED]]
Sent: Friday, August 16, 2002 10:09 AM
To: CF-Talk
Subject: Strange JDBC/ODBC error on Insert statements...
I have a transaction here that was working fine, but is now returning
[Macromedia][SQLServer JDBC Driver][SQLServer]Could not find prepared
statement with handle -1. when
Yeah. We have a firewall. the webserver is set up as an IP forwarding.
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 5:53 PM
To: CF-Talk
Subject: RE: ODBC Error Code = 08001
Do you have a firewall?
-Original Message-
From
Josh,
that's what I thought to, I'm running a trace right now.
Thanks
Thanh
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 7:17 PM
To: CF-Talk
Subject: RE: ODBC Error Code = 08001
Could be a network problem. The web server
Hi all,
I've been getting this error on our website. But can't figure out what
caused it. have anybody seen this error or knows what could have caused it.
This error only occurs once in a while.
Error Diagnostic Information
ODBC Error Code = 08001 (Unable to connect to data source
PM
Subject: ODBC Error Code = 08001
Hi all,
I've been getting this error on our website. But can't figure out what
caused it. have anybody seen this error or knows what could have caused it.
This error only occurs once in a while.
Error Diagnostic Information
ODBC Error Code = 08001
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 7:15 PM
To: CF-Talk
Subject: Re: ODBC Error Code = 08001
mabye check the username and password associated with the failing DSN
connection
Bryan Stevenson B.Comm.
VP Director of E-Commerce
]]
Sent: Tuesday, July 02, 2002 7:15 PM
To: CF-Talk
Subject: Re: ODBC Error Code = 08001
mabye check the username and password associated with the failing DSN
connection
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL
Could it be a network problem?
I have another website connecting to the same server with no problems.
Thanks
Thanh
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 4:23 PM
To: CF-Talk
Subject: RE: ODBC Error Code = 08001
That error
Do you have a firewall?
-Original Message-
From: Thanh Nguyen [mailto:[EMAIL PROTECTED]]
Sent: mercredi 3 juillet 2002 12:44
To: CF-Talk
Subject: RE: ODBC Error Code = 08001
Could it be a network problem?
I have another website connecting to the same server with no problems
checking my sql dump logs and the regular sql logs
just to see if sql is screaming something.
-Original Message-
From: Thanh Nguyen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 8:44 PM
To: CF-Talk
Subject: RE: ODBC Error Code = 08001
Could it be a network problem?
I have
Has anyone seen this error:
ODBC Error Code = S1000 (General error)
[MERANT][ODBC SQL Server Driver][SQL Server]Changed database context
to 'dcwasa_dev'.
You can see the full error at
http://206.239.48.240/customercare/billing_questions.cfm
A Google search led me to the MSDN
All of a sudden our CF4.5 on Windows2000 started throwing this error when
attempting to connect to SQL2000 datasources.
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context
Oracle, Access, and SAS datasources all work fine AND the SQL2000
Hey - do you have more information? What network libraries are you using
for example.
Mark
-Original Message-
From: WebMaster [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 11:11 AM
To: CF-Talk
Subject: SQL 2000 ODBC Error?
All of a sudden our CF4.5 on Windows2000
The below is an output of what is in the query.
INSERT INTO tbl_user_profiles
(username,password,FirstName,LastName,Email,Phone,CreateDate) Values
('dbrown','karen1','David','Brown','[EMAIL PROTECTED]','803-
434-4703',{ts '2001-11-14 10:55:47'})
Below is the error I get. Any idea?
Im I correct in thinking this SQL Is in a variable?
cfquery ...
#PreserveSingleQuotes(myvar)#
/cfquery
Pascal
-Original Message-
From: David Brown [mailto:[EMAIL PROTECTED]]
Sent: woensdag 14 november 2001 17:17
To: CF-Talk
Subject: ODBC error
The below is an output of what
: Wednesday, November 14, 2001 11:30 AM
Subject: RE: ODBC error
Im I correct in thinking this SQL Is in a variable?
cfquery ...
#PreserveSingleQuotes(myvar)#
/cfquery
Pascal
-Original Message-
From: David Brown [mailto:[EMAIL PROTECTED]]
Sent: woensdag 14 november 2001 17:17
To: CF-Talk
cfquery ...
#PreserveSingleQuotes(myvar)#
/cfquery
that fixed it thanks.
- Original Message -
From: David Brown [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, November 14, 2001 11:46 AM
Subject: Re: ODBC error
Yes, the SQL is in variables.
That is why I had
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine
stopped the process because you and another user
are attempting to change the same data at the same time.
The error occurred while processing an element with a general
Nevermind...
Can you say corrupted database?
I knew you could
Howie
- Original Message -
From: Howie Hamlin [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 30, 2001 4:58 PM
Subject: Weird ODBC error
Anyone ever see anything like the error, below? I've
Hi Guys!
Can anybody figure out why I get a date time field overflow on this:
CFQUERY NAME=CheckProcedure DATASOURCE=#MyDSN# DBTYPE=ODBC
SELECT *
FROM sysobjects
WHERE
(OBJECTPROPERTY(id, N'IsProcedure') = 1)
AND (name =
At 12:16 AM 10/19/2001, you wrote:
What does this mean?
Message:ODBC Error Code = S1000 (General error)
Error Code: -1808
SQL State: S1000
Detail: [Microsoft][ODBC Microsoft Access Driver] Not enough space
on disk.
My guess
What does this mean?
Message:ODBC Error Code = S1000 (General error)
Error Code: -1808
SQL State: S1000
Detail: [Microsoft][ODBC Microsoft Access Driver] Not enough space on disk.
Cheers
To: CF-Talk
Subject: RE: ODBC error code
Are you using any reserved words? send your query.
+++
Pete Freitag ([EMAIL PROTECTED])
CFDEV.COM
ColdFusion Developer Resources
http://www.cfdev.com/
-Original Message-
From: Tristram Charnley
Does anyone knows what this signifies?
ODBC Error Code = 22005 (Error in assignment)
(MS Access)
Tristram Charnley
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http
, 2001 12:12 PM
To: CF-Talk
Subject: ODBC error code
Does anyone knows what this signifies?
ODBC Error Code = 22005 (Error in assignment)
(MS Access)
Tristram Charnley
~~
Structure your ColdFusion code with Fusebox. Get the official book
Please help me, how to fix this:
ODBC Error Code = S1000 (General error)
[MERANT][ODBC SQL Server Driver]Unicode conversion failed
SQL = select count(distinct tracker_id) as sessions, min(datetimestamp),
case Referrer when '' then 'No Referrer' else Referrer end as ref_site from
SiteTracker
and Time : 08/17/01 21:36:56
Error Message : ODBC Error Code = 08S01 (Communication link failure)P
Template Affected: D:\WEBFILES\EGCWEB\WELCOME.HTML
Query String :
Browser Used: Mozilla/4.0 (compatible; MSIE 5.0; AOL 6.0; Windows 98;
DigExt)
Error Type : DATABASE
HTTP Referer :
Diagnostics : ODBC
Fellow CFers,
Has anyone ever seen an intermittent ODBC error, like the following:
ODBC Error Code = 01000 (General Warning)
[Microsoft][ODBC SQL Server Driver][Named
Pipes]ConnectionTransact(GetOverlappedResults())
It occurs seemly at random, and is resolved by refreshing the current CF
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mike
Connolly
Sent: Thursday, 16 August 2001 8:07 PM
To: CF-Talk
Subject: Strange ODBC Error
Fellow CFers,
Has anyone ever seen an intermittent ODBC error, like the following:
ODBC Error Code = 01000 (General Warning)
[Microsoft][ODBC
PROTECTED]
Subject: Strange ODBC Error
Message-ID: ADA83ADF685BD511BBC924C8E36A40F5CA@EXCHANGE
Fellow CFers,
Has anyone ever seen an intermittent ODBC error, like the following:
ODBC Error Code = 01000 (General Warning)
[Microsoft][ODBC SQL Server Driver][Named
Pipes]ConnectionTransact
Mike,
Check your SQL Connection setting. It looks like it is using [Named Pipes].
Try changing to TCP/IP.
Jeff Craig
- Original Message -
From: Mike Connolly [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, August 16, 2001 5:06 AM
Subject: Strange ODBC Error
Fellow
To: CF-Talk
Subject: Strange ODBC Error
Fellow CFers,
Has anyone ever seen an intermittent ODBC error, like the following:
ODBC Error Code = 01000 (General Warning)
[Microsoft][ODBC SQL Server Driver][Named
Pipes]ConnectionTransact(GetOverlappedResults())
It occurs seemly at random
this. All assuming your SQL server is set up to talk tcp/ip..
-Original Message-
From: Melanie Maddix [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 8:33 AM
To: CF-Talk
Subject: RE: Strange ODBC Error
Hi Mike;
We would get that error whenever the connection to our SQL database
change your default Network protocol to TCP/IP in the SQL Server Client Config
The named-pipes protocol does more than just shift data from A to B, it has
some security mechanisms too. Any breaks in the network traffic between
your web server and database can cause errors like this.
Mark
Greetings
We are attempting to move the username/password from the cfadministrator and
place it in application variables. When this is done, we are getting the
following message
ODBC Error Code = 08001 (Unable to connect to data source)
[IBM][CLI Driver] SQL30082N Attempt to establish
search.
i have cached the query
Everything was working fine until a couple of weeks ago when we started
getting (intermittently) the below error (I cannot create the error on my
personal server)
Error Diagnostic Information
ODBC Error Code = S1001 (Memory allocation error)
[Microsoft][ODBC
I have an access 2000 database ...
...
Everything was working fine until a couple of weeks ago
when we started getting (intermittently) the below error ...
Error Diagnostic Information
ODBC Error Code = S1001 (Memory allocation error)
[Microsoft][ODBC Microsoft Access Driver] Not enough
I'm getting this error when executing a stored procedure occasionally under
load.
Error Diagnostic Information
ODBC Error Code = 01000 (General warning)
[Microsoft][ODBC SQL Server Driver][SQL Server]rotation
Anyone know what a general warning means?
jon
19:49
To: CF-Talk
Subject: ODBC Error
I was using a new tag(not a tag just a single page) from the Allaire Dev
Gallery.
It says that I need to set a system database in my Administrator. I have
never done that. What is a System Database? I tried picking the same
database as my Data source
III [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 10:51 PM
To: CF-Talk
Subject: RE: ODBC Error Code = 37000 UGH!
No query at all, it's a client variable going to a database.
-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09
with around 100 it
gives me the odbc error. Now I checked my odbc driver, it lets me use long
text retrieval. The SQL field is set as long text. So in theory it should
work no matter how much data I send to the SQL server. My question now is,
is there really a limit to how big a client variable can
: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 7:58 AM
To: CF-Talk
Subject: ODBC Error 37000 Revisted
Ok I found out what is causing the error. I am marking up a lot of
data to insert as a client variable. Basically I am joining three queries in
a structure
-Talk
Subject: RE: ODBC Error 37000 Revisted
Yes there are limits to client variables:
1. Cookie client vars = 4000 chars.
2. Registry client vars = ??
2. Database client vars for ORACLE 8i using native drivers = 4000 chars
3. Database client vars for ORACLE 8i using ODBC drivers = 2000 chars
4
I was using a new tag(not a tag just a single page) from the Allaire Dev
Gallery.
It says that I need to set a system database in my Administrator. I have
never done that. What is a System Database? I tried picking the same
database as my Data source but it FAILED!
Please Help?
.
-Groucho Marx
-Original Message-
From: CF Crazy [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 2:49 PM
To: CF-Talk
Subject: ODBC Error
I was using a new tag(not a tag just a single page) from the Allaire Dev
Gallery.
It says that I need to set a system database in my Adminis
I have CF 4.5.1 SP2, MDAC 2.6, SQL SP3. Does this whenever I set a client
variable. Anyone seen this before?
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near
'55
what is the code for the query? I'd guess that it's either a Where problem
or a variable reference problem.
Hatton
-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 10:35 PM
To: CF-Talk
Subject: ODBC Error Code = 37000 UGH
No query at all, it's a client variable going to a database.
-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 10:56 PM
To: CF-Talk
Subject: RE: ODBC Error Code = 37000 UGH!
what is the code for the query? I'd guess
Anyone seen this before? I have one site user who gets this error any time
he visits on particular page. He is the only guy in a year of being live
who has had this problem.
Thanks in advances for your expertise.
Nick Call
[EMAIL PROTECTED]
~~
]
icq: 5202487 aim: lv2bounce
http://www.cs.odu.edu/~bader
-Original Message-
From: Nick Call [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 1:23 PM
To: CF-Talk
Subject: ODBC Error Code = 37000
Anyone seen this before? I have one site user who gets
Hi. I'm a CF newbie. I ran into the following error while making my page
All i wanted to do was insert another row with data into the database.
Any help will be greatly appreciated.:
The changes you requested to the table were
202.797.6570 (direct line)
www.figleaf.com
-Original Message-
From: Richard Banks [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 12:42 PM
To: CF-Talk
Subject: ODBC error.
Hi. I'm a CF newbie. I ran into the following error while making my page
All i wanted to do was insert
This error means that you are trying to update a field that is either a primary key or
an indentity column(in Access, this is an autonumber field).
Look for that and you will find your problem.
--
Clint Tredway
www.factorxsoftware.com
--
~~
do not insert a value into an identity or auto numbering primary ey field.
You can let the database increment this value for you.
well in sql server you can insert values into an identity column using
SET IDENTITY_INSERT tableName ON/OFF
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 1:37 PM
To: CF-Talk
Subject: Re: ODBC error.
do not insert a value into an identity or auto numbering primary ey field.
You can let the database increment this value for you.
well in sql server you can insert values
al Message-
From: Al Musella, DPM [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 7:20 PM
To: CF-Talk
Subject: RE: ODBC Error 37000
Chris,
Wow...
This is going to sound strange
When I first got that message, I went into the enterprise
manager, and strangely a
essage-
From: Al Musella, DPM [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 7:20 PM
To: CF-Talk
Subject: RE: ODBC Error 37000
Chris,
Wow...
This is going to sound strange
When I first got that message, I went into the enterprise
manager, and strangely a
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 fusion server and sql 7
server. Then it works for a while and then stops.
ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC
: 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 fusion server and sql 7
server. Then it works for a while and then stops.
ODBC
i am using the free CF hosting at CFresources, so i'm accessing the thing
through an FTP account.
Presumabley the ODBC datasource has been set for me.
Yet when i run a simple insert or select * i get this error
-
Error Diagnostic Information
ODBC Error Code
Whats the url fo CFresources free hosting?
-Original Message-
From: war ape [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2000 16:22
To: CF-Talk
Subject: Re: Access ODBC error
i am using the free CF hosting at CFresources, so i'm accessing the thing
through an FTP account.
Presumabley
On 12/12/00, war ape penned:
Error Diagnostic Information
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'SOFTWARE\ODBC\ODBC.INI\MYDB'.
The error occurred while processing an element with a general identifier
http://www.cfm-resources.com/
-Original Message-
From: Nick Betts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 12, 2000 10:39 AM
To: CF-Talk
Subject: RE: Access ODBC error
Whats the url fo CFresources free hosting
1 - 100 of 143 matches
Mail list logo