CF9 ODBC Error
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 the file specified. Any ideas how to fix this? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343969 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 ODBC Error
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 error: The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). Any ideas? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343971 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
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 Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Informix][Informix ODBC Driver]Invalid string or buffer length. The error occurred in C:\Inetpub\wwwroot\bbpacts\Search\qry_searchpactsid.cfm: line 4 Called from C:\Inetpub\wwwroot\bbpacts\search.cfm: line 16 Called from C:\Inetpub\wwwroot\bbpacts\Search\qry_searchpactsid.cfm: line 4 Called from C:\Inetpub\wwwroot\bbpacts\search.cfm: line 16 2 : SELECT client.client_id, client.Last_Name, client.First_Name, case_defendant_id, sex 3 : FROM client, case_defendant 4 : WHERE client.client_id = #Client_id# 5 : AND client.client_id = case_defendant.client_id 6 : /CFQUERY ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313965 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ODBC Error
Do a cfdump var=#Client_id# right before the query start to verify that the variable has a value. If the variable contains a blank, or a non-number, then the query will fail. To make sure that the query always passes a value, you can send the variable as paramed. SELECT client.client_id, client.Last_Name, client.First_Name, case_defendant_id, sex FROM client, case_defendant WHERE client.client_id = cfqueryparam value=#Client_id# AND client.client_id = case_defendant.client_id -- William Seiter IT Web Developer / Consultant Is your income limited by the red tape and paperwork? Let SoftEx BackOffice help you. They know how to take care of the 'busy work' of your contracts and let you focus on the 'WOW' factor. http://www.softexconsulting.com/softex_office.cfm ::-Original Message- ::From: Tracie Nance [mailto:[EMAIL PROTECTED] ::Sent: 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 Query. ::[Macromedia][SequeLink JDBC Driver][ODBC Socket][Informix][Informix ODBC ::Driver]Invalid string or buffer length. :: ::The error occurred in ::C:\Inetpub\wwwroot\bbpacts\Search\qry_searchpactsid.cfm: line 4 ::Called from C:\Inetpub\wwwroot\bbpacts\search.cfm: line 16 ::Called from C:\Inetpub\wwwroot\bbpacts\Search\qry_searchpactsid.cfm: line ::4 ::Called from C:\Inetpub\wwwroot\bbpacts\search.cfm: line 16 :: ::2 : SELECT client.client_id, client.Last_Name, client.First_Name, ::case_defendant_id, sex ::3 : FROM client, case_defendant ::4 : WHERE client.client_id = #Client_id# ::5 : AND client.client_id = case_defendant.client_id ::6 : /CFQUERY :: :: :: :: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313976 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ODBC Error CFQuery
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] Too few parameters. Expected 1. The error occurred in C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginCheck.cfm: line 19 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm. cfm: line 206 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\PrivateAccess\Application.cfm: line 17 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginCheck.cfm: line 19 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm. cfm: line 206 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\PrivateAccess\Application.cfm: line 17 17 : SELECT * 18 : FROM Users 19 : WHERE UserLogin = '#Form.UserLogin#' AND Password = '#Form. Password#' 20 : /cfquery 21 : SQL SELECT * FROM Users WHERE UserLogin = 'paulw' AND Password = 'PPMILL' DATASOURCE RickRossiter VENDORERRORCODE -3010 SQLSTATE 07002 Resources: * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.11) Gecko/20071127 Firefox/2.0.0.11 CODE SOURCE: PROCESS BEGINS IN (application.cfm) WHEN USER ENTERS SECTION OF SITE REQUIRING A LOGIN: (application.cfm) !---If user is not logged in force them to log in--- cfif NOT isDefined(SESSION.Auth.IsLoggedIn) !---If the user is now submitting login action via login form--- !---Include Login Check code to validate the user attempting to log in.--- cfinclude template=../Templates/loginForm.cfm cfabort /cfif NEXT THE USER IS PROMPTED TO THE LOGIN PAGE: cfif isDefined(form.UserLogin) cfinclude template=loginCheck.cfm /cfif span class=HeaderEnter Access Code/span br cfform action=../PrivateAccess/showAR.cfm Name=LoginForm method=post input type=hidden name=UserLogin_required input type=hidden name=Password_required !---userLogin Field is required--- User Name: cfinput type=text name=UserLogin size=20 value= maxlength=24 required=yes message=Please enter your user name. Thank you. style=height:14px; width:125px; font-size:12px; font-weight:bold; color: maroon; letter-spacing:0.2em; text-align:left; p /pp /p Password: cfinput type=password name=Password size=24 value= maxlength=24 required=yes message=Please enter your assigned password to access this part of the site. Thank you. style=height:14px; width:125px; font-size:12px; font-weight:bold; color: maroon; letter-spacing:0.2em; text-align:left cfinput type=submit name=Enter /cfform WHICH IS CHECKED BY THE FOLLOWING CODE: !---The following code queries the database to find the record of the user's password.--- cfparam name=Form.UserLogin type=string cfparam name=Form.Password type=string cfquery name=getUser datasource=#dsn# SELECT * FROM Users WHERE UserLogin = '#Form.UserLogin#' AND Password = '#Form.Password#' /cfquery !--- If the user's password is correct the following code verifies it and obtains the information then creates a distinct session for each user that logs in. --- cfif getUser.RecordCount EQ 1 cflocation url=../PrivateAccess/showAR.cfm !--- The following code remembers the user's logged-in status their user type and their first name in the session structure. --- cfset SESSION.Auth = StructNew() cfset SESSION.Auth.IsLoggedIn = yes cfset SESSION.Auth.userID = getUser.userID cfset SESSION.Auth.FirstName = getUser.FirstName !--- Now that user is logged in, the following code sends them to PrivateAccess/showAR.cfm page and menu links. --- cflocation url=#CGI.SCRIPT_NAME# /cfif AS YOU CAN SEE THE QUERY IS PULLING THE DATA FROM THE DATABASE, BUT THROWING THIS ERROR MESSAGE. I TURNED ON DEBUGGING BUT THIS DID NOT REVEAL ANYTHING MORE THAN THE ORIGINAL ERROR MESSAGE. USING DREAMWEAVER 8 AND CFMX SERVERS. IF ANYONE CAN EXPLAIN THIS I SURE WOULD APPRECIATE IT. NICK [EMAIL PROTECTED] Hello Nick, It's possible that you are having a problem with the column name being Users. I recall a similar problem in our Support queue. The column name was identical to a DBMS reserved word. The user rectified the problem by placing the column name in square brackets, i.e., []. This remedy was specific to a Progress DBMS. If the same problem obtains in your environment, you may need to employ different escape characters other than the square brackets, but I would start there. Best regards, Netrista Khatam Technical Services Manager OpenLink Product Support
Re: ODBC Error CFQuery
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 Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. double check your column names again because in your other thread one of the column names was different and your error said Expected 2... so now you've got one bad column name still. Rick 20 : /cfquery 21 : SQL SELECT * FROM Users WHERE UserLogin = 'paulw' AND Password = 'PPMILL' Watch what you paste into email messages. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297206 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ODBC Error CFQuery
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] Too few parameters. Expected 1. The error occurred in C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginCheck.cfm: line 19 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.cfm: line 206 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\PrivateAccess\Application.cfm: line 17 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginCheck.cfm: line 19 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.cfm: line 206 Called from C:\Inetpub\wwwroot\RickRossiter\NLR\PrivateAccess\Application.cfm: line 17 17 : SELECT * 18 : FROM Users 19 : WHERE UserLogin = '#Form.UserLogin#' AND Password = '#Form.Password#' 20 : /cfquery 21 : SQL SELECT * FROM Users WHERE UserLogin = 'paulw' AND Password = 'PPMILL' DATASOURCE RickRossiter VENDORERRORCODE -3010 SQLSTATE 07002 Resources: * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.11) Gecko/20071127 Firefox/2.0.0.11 CODE SOURCE: PROCESS BEGINS IN (application.cfm) WHEN USER ENTERS SECTION OF SITE REQUIRING A LOGIN: (application.cfm) !---If user is not logged in force them to log in--- cfif NOT isDefined(SESSION.Auth.IsLoggedIn) !---If the user is now submitting login action via login form--- !---Include Login Check code to validate the user attempting to log in.--- cfinclude template=../Templates/loginForm.cfm cfabort /cfif NEXT THE USER IS PROMPTED TO THE LOGIN PAGE: cfif isDefined(form.UserLogin) cfinclude template=loginCheck.cfm /cfif span class=HeaderEnter Access Code/span br cfform action=../PrivateAccess/showAR.cfm Name=LoginForm method=post input type=hidden name=UserLogin_required input type=hidden name=Password_required !---userLogin Field is required--- User Name: cfinput type=text name=UserLogin size=20 value= maxlength=24 required=yes message=Please enter your user name. Thank you. style=height:14px; width:125px; font-size:12px; font-weight:bold; color: maroon; letter-spacing:0.2em; text-align:left; p /pp /p Password: cfinput type=password name=Password size=24 value= maxlength=24 required=yes message=Please enter your assigned password to access this part of the site. Thank you. style=height:14px; width:125px; font-size:12px; font-weight:bold; color: maroon; letter-spacing:0.2em; text-align:left cfinput type=submit name=Enter /cfform WHICH IS CHECKED BY THE FOLLOWING CODE: !---The following code queries the database to find the record of the user's password.--- cfparam name=Form.UserLogin type=string cfparam name=Form.Password type=string cfquery name=getUser datasource=#dsn# SELECT * FROM Users WHERE UserLogin = '#Form.UserLogin#' AND Password = '#Form.Password#' /cfquery !--- If the user's password is correct the following code verifies it and obtains the information then creates a distinct session for each user that logs in. --- cfif getUser.RecordCount EQ 1 cflocation url=../PrivateAccess/showAR.cfm !--- The following code remembers the user's logged-in status their user type and their first name in the session structure. --- cfset SESSION.Auth = StructNew() cfset SESSION.Auth.IsLoggedIn = yes cfset SESSION.Auth.userID = getUser.userID cfset SESSION.Auth.FirstName = getUser.FirstName !--- Now that user is logged in, the following code sends them to PrivateAccess/showAR.cfm page and menu links. --- cflocation url=#CGI.SCRIPT_NAME# /cfif AS YOU CAN SEE THE QUERY IS PULLING THE DATA FROM THE DATABASE, BUT THROWING THIS ERROR MESSAGE. I TURNED ON DEBUGGING BUT THIS DID NOT REVEAL ANYTHING MORE THAN THE ORIGINAL ERROR MESSAGE. USING DREAMWEAVER 8 AND CFMX SERVERS. IF ANYONE CAN EXPLAIN THIS I SURE WOULD APPRECIATE IT. NICK [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297180 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ODBC Error CFQuery
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? -- Scientists tell us that the fastest animal on earth, with a top speed of 120 feet per second, is a cow that has been dropped out of a helicopter. - Dave Barry ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297213 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ODBC error with CFMX6.1 even with SequeLink 5.4 installed
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 messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: ColdFusion MX ODBC [EMAIL PROTECTED],ErrorCode=3004,ErrorMessage=sched.swschd.1756.Internal error, an unexpected exception was detected.. According to technote e917887 the remedy for this was to install SequeLink 5.4, but that is already installed? Should I just push management to upgrade to CFMX 8 or does anyone else have any suggestions? Thanks. Damien McKenna Web Developer The LIMU Company ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286625 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ODBC Error For Advantage DB
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 to verify the conenction, I get the following: Connection verification failed for data source: HHMeds []java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Extended Systems][Advantage SQL][ASA] Error 6420: The 'discovery' process for the Advantage Database Server failed. Unable to connect to the Advantage Database Server. axServerConnect The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Extended Systems][Advantage SQL][ASA] Error 6420: The 'discovery' process for the Advantage Database Server failed. Unable to connect to the Advantage Database Server. axServerConnect Anyone have any insight into how to connect to an Advantage databse? I have NO experience with Advantage, I just have a need to read the data tables with CF to extract some information. TIA, Tim ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211283 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
ODBC Error Code = S1C00 (Driver not capable)
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 and will execute inline sql without a problem. i have a feeling i'm missing something that's probably obvious, so forgive the duh-factor on this ;) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210979 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
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 not sure why I am getting it. -- James Smith [EMAIL PROTECTED] ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184366 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
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 why I am getting it. There is a limit to the number of columns you can have in a query. Chances are the driver thinks that the query is returning the maximum number of columns an excel spreadsheet can have, which I think is some thing like the magic 65535 number. I think you are looking at a maximum of 256 columns in a query. Make sure that you have ranges and columns defined in your spreadsheet to make sure that there are specific tables and columns to query. Stephen ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184368 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ODBC error I can't explain
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. -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 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 not sure why I am getting it. -- James Smith [EMAIL PROTECTED] ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184369 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ODBC error I can't explain
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 spreadsheet not writing to it. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184371 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ODBC error I can't explain
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? -- Jay -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 16 November 2004 12:56 To: CF-Talk Subject: 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 why I am getting it. There is a limit to the number of columns you can have in a query. Chances are the driver thinks that the query is returning the maximum number of columns an excel spreadsheet can have, which I think is some thing like the magic 65535 number. I think you are looking at a maximum of 256 columns in a query. Make sure that you have ranges and columns defined in your spreadsheet to make sure that there are specific tables and columns to query. Stephen ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184372 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ODBC error I can't explain
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, excel has a nasty habit of saying all these x columns are actually in the spreadsheet, but empty. I can't remember exactly how the excel jdbc connector works, but couldn't you do a select COLUMN from spreadsheet, rather than select * from spreadsheet? Do you really need it to be an excel spreadsheet? If this is part of a manual process, can you save it out as a CSV and use that instead? Stephen ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184375 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ODBC error I can't explain
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 nasty habit of saying all these x columns are actually in the spreadsheet, but empty. Sorry, I wasn't clear enough, my bad. The sheet only has 1 column, all the other columns have been deleted, they are not empty, they are gone. I can't remember exactly how the excel jdbc connector works, but couldn't you do a select COLUMN from spreadsheet, rather than select * from spreadsheet? Unfortunately not, the format of the spreadsheet changes with great regularity so the first query does a select *, then presents the column names to the user for identification, this is really the only option because barcode could be expressed as bc, barcode, bar code, bcode, EAN, UPC, or any one of many other names, same goes for catalogue number (cat. No., cat number, etc...), title, etc... Do you really need it to be an excel spreadsheet? If this is part of a manual process, can you save it out as a CSV and use that instead? Unfortunately they come in to our computer illiterate staff as excel files, it is all I can do to teach them how to use a browse button, trying to get them to change to file format is not really an option. -- Jay ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184376 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
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 anyone provide some insight and a possible fix? --David ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ODBC Error Code = S1001 (Memory allocation error)
Looks to me like you might have run out of disk space. Either on the drive where the access database is at or in the drive where your temp files are created. Just a guess though. -Original Message- From: David K [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 1:16 PM To: CF-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 anyone provide some insight and a possible fix? --David ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 allocation error) [Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary disk. === Can anyone provide some insight and a possible fix? --David ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ODBC Error Code = S1001 (Memory allocation error)
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-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 on temporary disk. === Can anyone provide some insight and a possible fix? --David ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ODBC Error Code = S1001 (Memory allocation error)
Evidently, this error is somewhat routine with the MS Access driver and is the result of a memory leak. The only solution is to hiccup the server (!). Maybe now the client will pony up for upsizing... Thanks to all who replied. - Original Message - From: David K [EMAIL PROTECTED] To: CF-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 space on temporary disk. === Can anyone provide some insight and a possible fix? --David ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ODBC Error Code = S1001 (Memory allocation error)
I'd call cfdynamics support... there's not likely anything you could do to fix it without direct access to the server. 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-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 on temporary disk. === Can anyone provide some insight and a possible fix? --David ~~~ ~~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid =4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 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 but it still doesn't go away. It started happeneing Saturday then that night the sql team installed sp3 (no relation to errors). After that it got much worse. I have looked a lot of places but I can't seem to figure out what the error means. Anyone have an idea? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: odbc error 01000 (General Warning)
I typically see this when Box A is having trouble or intermittent TCP/IP trouble communicating with Box B. Check for: A) Bad Cables B) Router/Switch misconfiguration C) Mismatched Duplexes on the Network Cards (to the Switch) D) Make sure one of the boxes isn't rebooting randomly often Some 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 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 but it still doesn't go away. It started happeneing Saturday then that night the sql team installed sp3 (no relation to errors). After that it got much worse. I have looked a lot of places but I can't seem to figure out what the error means. Anyone have an idea? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ODBC Error
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 C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 446 Called from C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 760 Anyone knows is my MX Server gone mad or Shaz ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
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 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 C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 446 Called from C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 760 Anyone knows is my MX Server gone mad or Shaz ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
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 error. This thing started happening since I change my CFMX services to start with domain account but not Local System Account. -Original Message- From: 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 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 C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 446 Called from C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 760 Anyone knows is my MX Server gone mad or Shaz ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
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 Add button I said error. This thing started happening since I change my CFMX services to start with domain account but not Local System Account. -Original Message- From: 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 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 C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 446 Called from C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 760 Anyone knows is my MX Server gone mad or Shaz ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: ODBC Error
Sa.coldfusiondev/password/intranet-dev If I change coldfusion services back to Local System Account its OK. But if I make it domain account it gives same error. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 10:01 To: CF-Talk 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 Add button I said error. This thing started happening since I change my CFMX services to start with domain account but not Local System Account. -Original Message- From: 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 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 C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 446 Called from C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 760 Anyone knows is my MX Server gone mad or Shaz ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
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 coldfusion services back to Local System Account its OK. But if I make it domain account it gives same error. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 10:01 To: CF-Talk 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 Add button I said error. This thing started happening since I change my CFMX services to start with domain account but not Local System Account. -Original Message- From: 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 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 C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 446 Called from C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 760 Anyone knows is my MX Server gone mad or Shaz ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
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 it should've been sa.coldfusion.dev Thanks once again -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 10:13 To: CF-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 coldfusion services back to Local System Account its OK. But if I make it domain account it gives same error. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 10:01 To: CF-Talk 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 Add button I said error. This thing started happening since I change my CFMX services to start with domain account but not Local System Account. -Original Message- From: 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 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 C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 446 Called from C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 760 Anyone knows is my MX Server gone mad or Shaz ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: ODBC Error
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 it should've been sa.coldfusion.dev Thanks once again -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 10:13 To: CF-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 coldfusion services back to Local System Account its OK. But if I make it domain account it gives same error. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 10:01 To: CF-Talk 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 Add button I said error. This thing started happening since I change my CFMX services to start with domain account but not Local System Account. -Original Message- From: 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 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 C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 446 Called from C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 760 Anyone knows is my MX Server gone mad or Shaz ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
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 Subject: RE: ODBC Error 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 it should've been sa.coldfusion.dev Thanks once again -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 10:13 To: CF-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 coldfusion services back to Local System Account its OK. But if I make it domain account it gives same error. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 10:01 To: CF-Talk 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 Add button I said error. This thing started happening since I change my CFMX services to start with domain account but not Local System Account. -Original Message- From: 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 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 C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 446 Called from C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 760 Anyone knows is my MX Server gone mad or Shaz ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: ODBC Error
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 Subject: RE: ODBC Error 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 it should've been sa.coldfusion.dev Thanks once again -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 10:13 To: CF-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 coldfusion services back to Local System Account its OK. But if I make it domain account it gives same error. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 10:01 To: CF-Talk 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 Add button I said error. This thing started happening since I change my CFMX services to start with domain account but not Local System Account. -Original Message- From: 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 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 C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 446 Called from C:\WWWROOT\CFIDE\administrator\datasources\odbcsocket.cfm: line 760 Anyone knows is my MX Server gone mad or Shaz ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
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 executed. I have also started and started all MX services, hoping that it might fix it, it does not. Again, the strange this is that this was working just fine, and is now failing on any insert (or at least, any insert with transactions and a set nocount off/on statement). Using CFMX on 2kserver/IIS and MSSQL7 on another machine (2k server). Here is one of the offending statements, the only difference between this and the others that fail is Contact versus Account. Removing the address insert from the top also does nothing. Hopefully someone has a clue! Thanks! --- cftransaction action=begin cfquery name=InsertAddress datasource=CRMdb debug=Yes set nocount on insert into address(street1, street2, city, state, postal, country, attn) values(cfqueryparam value=#form.street1# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.street2# cfsqltype=cf_Sql_varchar, cfqueryparam value=#form.city# cfsqltype=cf_sql_char, cfqueryparam value=#form.state# cfsqltype=cf_Sql_varchar, cfqueryparam value=#form.postal# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.country# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.attn# cfsqltype=cf_Sql_varchar) select identity as currentaddressid set nocount off /cfquery cfquery name=InsertAccount datasource=CRMdb debug=Yes set nocount on insert into accounts(accounttypeid, companyname, esacctid, espurchid, mainphone, altphone, fax, emailtype, webaddress, createuserid, industryid, employees, productinterestids, addressid) values(cfqueryparam value=#form.accounttypeid# cfsqltype=cf_Sql_integer, cfqueryparam value=#form.companyname# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.esacctid# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.espurchid# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.mainphone# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.altphone# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.fax# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.emailtype# cfsqltype=cf_sql_char, cfqueryparam value=#form.webaddress# cfsqltype=cf_sql_varchar, cfqueryparam value=#client.userid# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.industryid# cfsqltype=cf_sql_integer, cfqueryparam value=#form.employees# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.productinterestids# cfsqltype=cf_sql_varchar, cfqueryparam value=#insertaddress.currentaddressid# cfsqltype=cf_sql_integer) select identity as currentaccountid set nocount off /cfquery cftransaction action=commit /cftransaction --- Other Error Info: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Could not find prepared statement with handle -1. The Error Occurred in C:\Inetpub\wwwroot\production_tree\Accounts\accounts_add.cfm: line 157 Called from C:\Inetpub\wwwroot\production_tree\Accounts\accounts.cfm: line 45 Called from C:\Inetpub\wwwroot\production_tree\Accounts\accounts_add.cfm: line 157 Called from C:\Inetpub\wwwroot\production_tree\Accounts\accounts.cfm: line 45 155 : 156 : set nocount off 157 : /cfquery 158 : cfquery name=InsertAccount datasource=CRMdb debug=Yes 159 : set nocount on __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange JDBC/ODBC error on Insert statements...
Well, I didn't get a response from the list, but I did figure it out *sorta*. It was the CFQUERYPARAM's that were killing it. I did a trace on the SQL Server, and it looks like the params just weren't getting passed, maybe this is a function of the transaction, I'm not sure. But I took out the cfqueryparam's and just did it without them, and things are working just fine. So. I'm responding just in case 3 months from now someone has the same problem and searches the archive. No idea why this happened. J -Original Message- From: Josh Remus' Mailing List Account [mailto:[EMAIL 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 executed. I have also started and started all MX services, hoping that it might fix it, it does not. Again, the strange this is that this was working just fine, and is now failing on any insert (or at least, any insert with transactions and a set nocount off/on statement). Using CFMX on 2kserver/IIS and MSSQL7 on another machine (2k server). Here is one of the offending statements, the only difference between this and the others that fail is Contact versus Account. Removing the address insert from the top also does nothing. Hopefully someone has a clue! Thanks! --- cftransaction action=begin cfquery name=InsertAddress datasource=CRMdb debug=Yes set nocount on insert into address(street1, street2, city, state, postal, country, attn) values(cfqueryparam value=#form.street1# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.street2# cfsqltype=cf_Sql_varchar, cfqueryparam value=#form.city# cfsqltype=cf_sql_char, cfqueryparam value=#form.state# cfsqltype=cf_Sql_varchar, cfqueryparam value=#form.postal# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.country# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.attn# cfsqltype=cf_Sql_varchar) select @@identity as currentaddressid set nocount off /cfquery cfquery name=InsertAccount datasource=CRMdb debug=Yes set nocount on insert into accounts(accounttypeid, companyname, esacctid, espurchid, mainphone, altphone, fax, emailtype, webaddress, createuserid, industryid, employees, productinterestids, addressid) values(cfqueryparam value=#form.accounttypeid# cfsqltype=cf_Sql_integer, cfqueryparam value=#form.companyname# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.esacctid# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.espurchid# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.mainphone# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.altphone# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.fax# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.emailtype# cfsqltype=cf_sql_char, cfqueryparam value=#form.webaddress# cfsqltype=cf_sql_varchar, cfqueryparam value=#client.userid# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.industryid# cfsqltype=cf_sql_integer, cfqueryparam value=#form.employees# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.productinterestids# cfsqltype=cf_sql_varchar, cfqueryparam value=#insertaddress.currentaddressid# cfsqltype=cf_sql_integer) select @@identity as currentaccountid set nocount off /cfquery cftransaction action=commit /cftransaction --- Other Error Info: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Could not find prepared statement with handle -1. The Error Occurred in C:\Inetpub\wwwroot\production_tree\Accounts\accounts_add.cfm: line 157 Called from C:\Inetpub\wwwroot\production_tree\Accounts\accounts.cfm: line 45 Called from C:\Inetpub\wwwroot\production_tree\Accounts\accounts_add.cfm: line 157 Called from C:\Inetpub\wwwroot\production_tree\Accounts\accounts.cfm: line 45 155 : 156 : set nocount off 157 : /cfquery 158 : cfquery name=InsertAccount datasource=CRMdb debug=Yes 159 : set nocount on __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error Code = 08001
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: 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. 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 could also be caused by an over worked sql server and because that query processor cannot grab the query string then the cf server thinks that either the sql server is not running or access was denied. Josh -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 Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 4:08 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 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:2) to (74:51). Thanks, Thanh Nguyen __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error Code = 08001
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 is able to get to the sql server but the query processor is either not available or kicking connection. Possibly a bad packet. The first thing I would do would be to run a trace on that db all day then run the index tunning wizard. Then I would start 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 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 could also be caused by an over worked sql server and because that query processor cannot grab the query string then the cf server thinks that either the sql server is not running or access was denied. Josh -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 Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 4:08 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 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:2) to (74:51). Thanks, Thanh Nguyen __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:2) to (74:51). Thanks, Thanh Nguyen __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 4:08 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 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:2) to (74:51). Thanks, Thanh Nguyen __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error Code = 08001
If it only happens every now and again sounds like you have some problems with your SQL Server. You probably need to either, run a trace on the database for the entire day, then run index wizard using the trace file that you created to create some good indexes on your database. Joshua Tipton -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 Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 4:08 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 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:2) to (74:51). Thanks, Thanh Nguyen __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error Code = 08001
That error could also be caused by an over worked sql server and because that query processor cannot grab the query string then the cf server thinks that either the sql server is not running or access was denied. Josh -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 Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 4:08 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 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:2) to (74:51). Thanks, Thanh Nguyen __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error Code = 08001
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 could also be caused by an over worked sql server and because that query processor cannot grab the query string then the cf server thinks that either the sql server is not running or access was denied. Josh -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 Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 4:08 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 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:2) to (74:51). Thanks, Thanh Nguyen __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error Code = 08001
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. 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 could also be caused by an over worked sql server and because that query processor cannot grab the query string then the cf server thinks that either the sql server is not running or access was denied. Josh -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 Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 4:08 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 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:2) to (74:51). Thanks, Thanh Nguyen __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error Code = 08001
Could be a network problem. The web server is able to get to the sql server but the query processor is either not available or kicking connection. Possibly a bad packet. The first thing I would do would be to run a trace on that db all day then run the index tunning wizard. Then I would start 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 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 could also be caused by an over worked sql server and because that query processor cannot grab the query string then the cf server thinks that either the sql server is not running or access was denied. Josh -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 Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 4:08 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 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:2) to (74:51). Thanks, Thanh Nguyen __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC Error - Changed database context to...
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 site with something about running the INSTCAT.SQL script. Any help? =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Simon Park Computer Systems Management, Inc. Director, E-Business205 South Whiting Street #201 Ph: 703-823-4300 x119 Alexandria, VA 22304 fax: 703-823-4301 http://www.csmi.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL 2000 ODBC Error?
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 DSN's work from the ODBC control panel, but not from the Cold Fusion control Panel. Anybody ever seen this before? Thanks, Mike __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 2000 ODBC Error?
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 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 DSN's work from the ODBC control panel, but not from the Cold Fusion control Panel. Anybody ever seen this before? Thanks, Mike _ _ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC error
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?
-
---
Queries
GetTableInfo (Records=10, Time=16ms)
SQL =
sp_columns tbl_user_profiles
/PLAINTEXTPRE/PRE/Q/S/SAMP/SCRIPT/SELECT/SMALL/STRIKE
/STRONG/SUB/SUP/TABLE/TD/TEXTAREA/TH/TITLE/TR/TT/U
UL/UL/VAR/WBRXMP/XMP
HR
H3Error Occurred While Processing Request/H3
P
TABLE border=1
TBODY
TR
TD
H4Error Diagnostic Information/H4
PODBC Error Code = 22005 (Error in assignment)
P
P[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
P
PSQL = INSERT INTO tbl_user_profiles
(username,password,FirstName,LastName,Email,Phone,CreateDate) Values
(''dbrown'',''karen1'',''David'',''Brown'',''[EMAIL PROTECTED]
rg'',''803-434-4703'',{ts
''2001-11-14 10:55:47''})
PData Source = Intranet_PHA2
PSQL = INSERT INTO tbl_user_profiles
(username,password,FirstName,LastName,Email,Phone,CreateDate) Values
(''dbrown'',''karen1'',''David'',''Brown'',''[EMAIL PROTECTED]
rg'',''803-434-4703'',{ts
''2001-11-14 10:55:47''})
P
PThe error occurred while processing an element with a general
identifier of
(CFQUERY), occupying document position (62:1) to (62:47).
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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
Subject: ODBC error
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?
-
---
Queries
GetTableInfo (Records=10, Time=16ms)
SQL =
sp_columns tbl_user_profiles
/PLAINTEXTPRE/PRE/Q/S/SAMP/SCRIPT/SELECT/SMALL/STRIKE
/STRONG/SUB/SUP/TABLE/TD/TEXTAREA/TH/TITLE/TR/TT/U
UL/UL/VAR/WBRXMP/XMP
HR
H3Error Occurred While Processing Request/H3
P
TABLE border=1
TBODY
TR
TD
H4Error Diagnostic Information/H4
PODBC Error Code = 22005 (Error in assignment)
P
P[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
P
PSQL = INSERT INTO tbl_user_profiles
(username,password,FirstName,LastName,Email,Phone,CreateDate) Values
(''dbrown'',''karen1'',''David'',''Brown'',''david.brown@palmettohealth.
o
rg'',''803-434-4703'',{ts
''2001-11-14 10:55:47''})
PData Source = Intranet_PHA2
PSQL = INSERT INTO tbl_user_profiles
(username,password,FirstName,LastName,Email,Phone,CreateDate) Values
(''dbrown'',''karen1'',''David'',''Brown'',''david.brown@palmettohealth.
o
rg'',''803-434-4703'',{ts
''2001-11-14 10:55:47''})
P
PThe error occurred while processing an element with a general
identifier of
(CFQUERY), occupying document position (62:1) to (62:47).
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ODBC error
Yes, the SQL is in variables.
That is why I had it output the SQL statement at the top. To make sure I
was sending the write string.
Here is the CFquery line.
This code has worked in the past.
!--- Int Fields with default ---
cfparam name=FieldNameValue default=
cfparam name=ColumnNames default=
cfparam name=FieldNameValues default=
!--- Get Column Names, Data Types from Form Field TableName and DSN(should
be an hidden form fields ---
cfquery name=GetTableInfodatasource=#Form.DSN#
sp_columns #Form.TableName#
/cfquery
!--- Loop through each column in table ---
cfloop query=GetTableInfo
cfif ListFindNoCase(Form.FIELDNAMES,Column_Name) NEQ 0 AND
Trim(Evaluate(ListGetAt(Form.FieldNames,ListFindNoCase(Form.FIELDNAMES,Colum
n_Name NEQ
cfset ElePos = ListFindNoCase(Form.FIELDNAMES,Column_Name)
!--- Check to see what data type each column is and build insert based on
value ---
CFSWITCH EXPRESSION=#GetTableInfo.Type_Name#
cfcase value=varchar
cfset FieldNameValues = FieldNameValues ,'
Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos))) '
cfset ColumnNames = ColumnNames , Column_Name
/cfcase
cfcase value=datetime
cfset FieldNameValues = FieldNameValues ,
CreateODBCDateTime(Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos
cfset ColumnNames = ColumnNames , Column_Name
/cfcase
cfcase value=text
cfset FieldNameValues = FieldNameValues ,'
Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos))) '
cfset ColumnNames = ColumnNames , Column_Name
/cfcase
cfcase value=timestamp
cfset FieldNameValues = FieldNameValues ,
CreateODBCDateTime(Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos
cfset ColumnNames = ColumnNames , Column_Name
/cfcase
cfcase value=smalldatetime
cfset FieldNameValues = FieldNameValues ,
CreateODBCDateTime(Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos
cfset ColumnNames = ColumnNames , Column_Name
/cfcase
CFDEFAULTCASE
cfset FieldNameValues = FieldNameValues ,
Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos)))
cfset ColumnNames = ColumnNames , Column_Name
/CFDEFAULTCASE
/CFSWITCH
/cfif
/cfloop
!--- Check to see if there is a ,(comma) at the END the string ---
CFIF Left(FieldNameValues,1) EQ ,cfset FieldNameValues =
Right(FieldNameValues,Len(FieldNameValues)-1)/CFIF
CFIF Left(ColumnNames,1) EQ ,cfset ColumnNames =
Right(ColumnNames,Len(ColumnNames)-1)/CFIF
!--- Insert statement ---
cfquery name=Insert datasource=#Form.DSN#
INSERT INTO #Form.Tablename#
(#ColumnNames#)
Values
(#FieldNameValues#)
/cfquery
- Original Message -
From: Pascal Peters [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: 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
Subject: ODBC error
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?
-
---
Queries
GetTableInfo (Records=10, Time=16ms)
SQL =
sp_columns tbl_user_profiles
/PLAINTEXTPRE/PRE/Q/S/SAMP/SCRIPT/SELECT/SMALL/STRIKE
/STRONG/SUB/SUP/TABLE/TD/TEXTAREA/TH/TITLE/TR/TT/U
UL/UL/VAR/WBRXMP/XMP
HR
H3Error Occurred While Processing Request/H3
P
TABLE border=1
TBODY
TR
TD
H4Error Diagnostic Information/H4
PODBC Error Code = 22005 (Error in assignment)
P
P[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
P
PSQL = INSERT INTO tbl_user_profiles
(username,password,FirstName,LastName,Email,Phone,CreateDate) Values
(''dbrown'',''karen1'',''David'',''Brown'',''david.brown@palmettohealth.
o
rg'',''803-434-4703'',{ts
''2001-11-14 10:55:47''})
PData Source = Intranet_PHA2
PSQL = INSERT INTO tbl_user_profiles
(username,password,FirstName,LastName,Email,Phone,CreateDate) Values
(''dbrown'',''karen1'',''David'',''Brown'',''david.brown@palmettohealth.
o
rg'',''803-434-4703'',{ts
''2001-11-14 10:55:47''})
P
PThe error occurred while processing an element with a general
identifier of
(CFQUERY), occupying document position (62:1) to (62:47).
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ODBC error
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 it output the SQL statement at the top. To make sure I
was sending the write string.
Here is the CFquery line.
This code has worked in the past.
!--- Int Fields with default ---
cfparam name=FieldNameValue default=
cfparam name=ColumnNames default=
cfparam name=FieldNameValues default=
!--- Get Column Names, Data Types from Form Field TableName and
DSN(should
be an hidden form fields ---
cfquery name=GetTableInfodatasource=#Form.DSN#
sp_columns #Form.TableName#
/cfquery
!--- Loop through each column in table ---
cfloop query=GetTableInfo
cfif ListFindNoCase(Form.FIELDNAMES,Column_Name) NEQ 0 AND
Trim(Evaluate(ListGetAt(Form.FieldNames,ListFindNoCase(Form.FIELDNAMES,Colum
n_Name NEQ
cfset ElePos = ListFindNoCase(Form.FIELDNAMES,Column_Name)
!--- Check to see what data type each column is and build insert based
on
value ---
CFSWITCH EXPRESSION=#GetTableInfo.Type_Name#
cfcase value=varchar
cfset FieldNameValues = FieldNameValues ,'
Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos))) '
cfset ColumnNames = ColumnNames , Column_Name
/cfcase
cfcase value=datetime
cfset FieldNameValues = FieldNameValues ,
CreateODBCDateTime(Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos
cfset ColumnNames = ColumnNames , Column_Name
/cfcase
cfcase value=text
cfset FieldNameValues = FieldNameValues ,'
Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos))) '
cfset ColumnNames = ColumnNames , Column_Name
/cfcase
cfcase value=timestamp
cfset FieldNameValues = FieldNameValues ,
CreateODBCDateTime(Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos
cfset ColumnNames = ColumnNames , Column_Name
/cfcase
cfcase value=smalldatetime
cfset FieldNameValues = FieldNameValues ,
CreateODBCDateTime(Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos
cfset ColumnNames = ColumnNames , Column_Name
/cfcase
CFDEFAULTCASE
cfset FieldNameValues = FieldNameValues ,
Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos)))
cfset ColumnNames = ColumnNames , Column_Name
/CFDEFAULTCASE
/CFSWITCH
/cfif
/cfloop
!--- Check to see if there is a ,(comma) at the END the string ---
CFIF Left(FieldNameValues,1) EQ ,cfset FieldNameValues =
Right(FieldNameValues,Len(FieldNameValues)-1)/CFIF
CFIF Left(ColumnNames,1) EQ ,cfset ColumnNames =
Right(ColumnNames,Len(ColumnNames)-1)/CFIF
!--- Insert statement ---
cfquery name=Insert datasource=#Form.DSN#
INSERT INTO #Form.Tablename#
(#ColumnNames#)
Values
(#FieldNameValues#)
/cfquery
- Original Message -
From: Pascal Peters [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: 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
Subject: ODBC error
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?
-
---
Queries
GetTableInfo (Records=10, Time=16ms)
SQL =
sp_columns tbl_user_profiles
/PLAINTEXTPRE/PRE/Q/S/SAMP/SCRIPT/SELECT/SMALL/STRIKE
/STRONG/SUB/SUP/TABLE/TD/TEXTAREA/TH/TITLE/TR/TT/U
UL/UL/VAR/WBRXMP/XMP
HR
H3Error Occurred While Processing Request/H3
P
TABLE border=1
TBODY
TR
TD
H4Error Diagnostic Information/H4
PODBC Error Code = 22005 (Error in assignment)
P
P[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
P
PSQL = INSERT INTO tbl_user_profiles
(username,password,FirstName,LastName,Email,Phone,CreateDate) Values
(''dbrown'',''karen1'',''David'',''Brown'',''david.brown@palmettohealth.
o
rg'',''803-434-4703'',{ts
''2001-11-14 10:55:47''})
PData Source = Intranet_PHA2
PSQL = INSERT INTO tbl_user_profiles
(username,password,FirstName,LastName,Email,Phone,CreateDate) Values
(''dbrown'',''karen1'',''David'',''Brown'',''david.brown@palmettohealth.
o
rg'',''803-434-4703'',{ts
''2001-11-14 10:55:47''})
P
PThe error occurred while processing an element with a general
identifier of
(CFQUERY), occupying document position (62:1) to (62:47).
~~
Structure
Weird ODBC error
Anyone ever see anything like the error, below? I've never seen this before...I've even made a copy of the database and it's still NG... Thanks, Howie = Error Occurred While Processing Request Error Diagnostic Information 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 identifier of (CFQUERY), occupying document position (39:1) to (39:43). Date/Time: 10/30/01 16:57:31 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 64.69.103.194 HTTP Referer: http://rabbitt.hoot.com/lowv/index.cfm Template: C:\Inetpub\wwwroot\lowv\index.cfm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Weird ODBC error
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 never seen this before...I've even made a copy of the database and it's still NG... Thanks, Howie = Error Occurred While Processing Request Error Diagnostic Information 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 identifier of (CFQUERY), occupying document position (39:1) to (39:43). Date/Time: 10/30/01 16:57:31 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 64.69.103.194 HTTP Referer: http://rabbitt.hoot.com/lowv/index.cfm Template: C:\Inetpub\wwwroot\lowv\index.cfm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC Error Code = 22008 (Datetime field overflow)
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 = N'sp_UpdateTimeOut') /CFQUERY CFIF NOT CheckProcedure.RecordCountCFQUERY NAME=CreateProcedure DATASOURCE=#MyDSN# DBTYPE=ODBC CREATE PROCEDURE sp_UpdateTimeOut @UserID [int] ,@TimeOutVarChar [varchar] AS SET @RowsEffected = 0 UPDATE Time_Actual SET Time_Out = CAST(@TimeOutVarChar AS datetime) WHERE Users_ID = @UserID AND Time_Out IS NULL /CFQUERY/CFIF !--- Ensure the user is clocked out if they are trying to clock in --- CFSTOREDPROC PROCEDURE=sp_UpdateTimeOut DATASOURCE=#MyDSN# CFPROCPARAM TYPE=In CFSQLTYPE=CF_SQL_INTEGER DBVARNAME=@UserID VALUE=18 CFPROCPARAM TYPE=In CFSQLTYPE=CF_SQL_VARCHAR DBVARNAME=@TimeOutVarChar VALUE=2001-10-22 21:41:02 /CFSTOREDPROC Thanx Dave ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: doublepost: odbc error
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... there is not enough space on the disk. Check the free space on your hard drive, it's getting real low by the sound of it. -- James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
doublepost: odbc error
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 Will ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC error code
No, the query runs fine on my machine (CF5 W98 and Access) and
on our development server (CF4.5.0 NT4SP5 SQL Server7)
but not on our production server with CF4.5.1
Here's the query anyway:
cfquery datasource=#application.ds#
INSERT INTO DBGENERE (Country,
TradeName,
InternationalName,
Category,
Indications,
RegistrationNo,
MRPReferenceNo,
RegistrationDate,
RenewalDueDate,
RenewalCycle,
RegistrationExpiry,
SafetyReportDueDate,
Comments,
ProductSizeNo,
MarketingParticulars,
FormulationNo,
UnitDose,
KindRegistration,
MRPNo,
RMSCMS,
Rapp,
CoRapp)
VALUES ('#Attributes.DBGENERE.Country#',
'#Attributes.DBGENERE.TradeName#',
'#Attributes.DBGENERE.InternationalName#',
'#Attributes.Category#',
'#Attributes.Indications#',
'#Attributes.RegistrationNo#',
'#Attributes.MRPReferenceNo#',
'#Attributes.RegistrationDate#',
'#Attributes.RenewalDueDate#',
'#Attributes.RenewalCycle#',
'#Attributes.RegistrationExpiry#',
'#Attributes.SafetyReportDueDate#',
'#Attributes.Comments#',
'#Attributes.ProductSizeNo#',
'#Attributes.MarketingParticulars#',
'#Attributes.DBGENERE.FormulationNo#',
'#Attributes.UnitDose#',
'#Attributes.KindRegistration#',
'#Attributes.MRPNo#',
'#Attributes.RMSCMS#',
'#Attributes.Rapp#',
'#Attributes.CoRapp#')
/cfquery
-Original Message-
From: Pete Freitag [mailto:[EMAIL PROTECTED]]
Sent: 26 September 2001 17:27
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 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 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 at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 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 at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: ODBC error please help
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 log1 with (NOLOCK) where Convert(datetime, datetimestamp) = {ts
'2001-07-28 00:00:00'} and Convert(datetime, datetimestamp) = {ts
'2001-08-29 00:00:00'} group by case Referrer when '' then 'No Referrer'
else Referrer end order by count(distinct tracker_id) desc
thanks
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC Error Code = 08S01 (Communication link failure)
We currently get about 400,00 hits per day on a cluster of CF 4 servers we have and about 900,000 transactions per day to our 3 read MS SQL7 databases. I have developed about 40 stored procedures that limited about 90% of the CFQUERIES to Stored procs. My questions is about 20 times a day we get errors that refer to the stored proc and refer to a Communication link failure or a Serialization error. Anyone know what this is? I do not a a pattern between Procs, CF Server, Read Databases, Browsers, Date/Time, or datasource... Just happens on it's own.. Begin the actually message. Date 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 Error Code = 08S01 (Communication link failure)P [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.PPSQL = emp_featured_listPData Source = webdbPpThe error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (44:3) to (44:83) in the template file d:\Webfiles\Tags\Common\featured.cfm./p Client IP Address is: 205.188.209.104 Server ID: www2 Generated Content: ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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, and is resolved by refreshing the current CF page in the client's browser. It doesn't appear to be isolated to one CF application, but to any hosted on our server. CF: 4.52 Enterprise IIS: 5.0 Op.Sys: Windows 2000 SQL Server: 7.0 Anyone got any ideas to a likely cause(s)? Regards Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange ODBC Error
Could possibly be linked to your licence and available concurrent database connections. Check your transaction and locking code and also take heed of Micro$ofts recent security bulletin for securing IIS. You might be being fired upon by denial of service attacks. -Original Message- From: [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 SQL Server Driver][Named Pipes]ConnectionTransact(GetOverlappedResults()) It occurs seemly at random, and is resolved by refreshing the current CF page in the client's browser. It doesn't appear to be isolated to one CF application, but to any hosted on our server. CF: 4.52 Enterprise IIS: 5.0 Op.Sys: Windows 2000 SQL Server: 7.0 Anyone got any ideas to a likely cause(s)? Regards Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Strange ODBC Error
Can't help with the problem , but why not use OLEDB when you use SQL server, its faster the ODBC and not prone to memory leaks either ? Russell Brown Internet Application Developer Freeserve.com Plc, PO Box 452, Leeds LS2 7EY Date: Thu, 16 Aug 2001 11:06:49 +0100 From: Mike Connolly [EMAIL 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(GetOverlappedResults()) It occurs seemly at random, and is resolved by refreshing the current CF page in the client's browser. It doesn't appear to be isolated to one CF application, but to any hosted on our server. CF: 4.52 Enterprise IIS: 5.0 Op.Sys: Windows 2000 SQL Server: 7.0 Anyone got any ideas to a likely cause(s)? Regards Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm -- End of CF-Talk-list V1 #99 ** FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Strange ODBC Error
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 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 page in the client's browser. It doesn't appear to be isolated to one CF application, but to any hosted on our server. CF: 4.52 Enterprise IIS: 5.0 Op.Sys: Windows 2000 SQL Server: 7.0 Anyone got any ideas to a likely cause(s)? Regards Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange ODBC Error
Hi Mike; We would get that error whenever the connection to our SQL database failed, like is someone decided to reboot the database server while the site was still running. Melanie -Original Message- From: Mike Connolly [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 6:07 AM 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, and is resolved by refreshing the current CF page in the client's browser. It doesn't appear to be isolated to one CF application, but to any hosted on our server. CF: 4.52 Enterprise IIS: 5.0 Op.Sys: Windows 2000 SQL Server: 7.0 Anyone got any ideas to a likely cause(s)? Regards Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange ODBC Error
You might want to try using the tcp/ip network library instead of Named Pipes - in general people seem to have more success with it. You have to adjust the network library (the network protocol choice) on both the server and the clients (including the CF server); the server can support more than one library simultaneously (different clients connecting with different libraries) but a client can use only one library to connect to a given server. On the server you adjust this with the install/setup tool, on the client there's something called the Client Configuration utility that does 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 failed, like is someone decided to reboot the database server while the site was still running. Melanie -Original Message- From: Mike Connolly [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 6:07 AM 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, and is resolved by refreshing the current CF page in the client's browser. It doesn't appear to be isolated to one CF application, but to any hosted on our server. CF: 4.52 Enterprise IIS: 5.0 Op.Sys: Windows 2000 SQL Server: 7.0 Anyone got any ideas to a likely cause(s)? Regards Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange ODBC Error
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 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
odbc error connecting to datasource
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 connection failed with security reason 0 (NOT SPECIFIED). SQLSTATE=08001 When the username and password are left in the administrator, there is no problems and everything seems to work well. Any suggestions? Thanx Bill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
access odbc error
Hi I have this problem: I have an access 2000 database with 72,000 booktitles in it. It has indexing, the table that is searched in this search only has 6 fields [ID, ISBN, Title, Author, Price, Category_ID and InStock] I have a search using LIKE and % - and I need to have some form of like 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 Microsoft Access Driver] Not enough space on temporary disk. SQL = SELECT ISBN, Title, Author, Price, StockLevel FROM tblTitles WHERE 0=0 AND Title LIKE '%potter%' Data Source = PAPERCHAIN_DATA The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:107). Date/Time: 04/28/01 14:32:01 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0) Remote Address: 210.8.44.17 HTTP Referer: http://www.paperchain.com.au/search/search.cfm My ISP says he can see no memory spike, and they have 512 mg ram. has anyone had this sort of error or have any clues as to where I should go from here. (I should say that website owner does not have the money to go to SQL Server at the moment, and does NOT get very many hits at the present) Hope some one can help - I am getting very frustrated Seamus ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access odbc error
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 space on temporary disk. Are you sure you have enough free space on the disk drive when this runs? Your ISP should be able to audit that for you, if necessary. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC Error
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 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error
With MS access a system database (usually called system.mdw) holds user / workgroup and security information , and probably some other things aswell. Though I'm not exactly sure what it means in your case. -Original Message- From: CF Crazy [mailto:[EMAIL PROTECTED]] Sent: 09 April 2001 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 but it FAILED! Please Help? Stephanie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error Code = 37000 UGH!!!!!!!!!!!!!
okay, there's got to be some SQL going from CF to the database driver... either an insert into or an update. Check to make sure that the variable you're updating in the database is the propper type for what CF is trying to put there. HTH Hatton -Original Message- From: Robert Everland 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, 2001 10:56 PM To: CF-Talk Subject: RE: ODBC Error Code = 37000 UGH! 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! 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'. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 then marking up the structure. When it is someone who only has a few customers to mark up, no error. Once I get to someone 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 be, and if not why am I getting this error. My next question will be going to allaire as I will have to buy a support ticket to get this resolved. Robert Everland III Web Developer Dixon Ticonderoga ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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. Database client vars for MS SQL Server 7 = unlimited You would be shocked at how long a string becomes when you serialize it using WDDX! Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: 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 then marking up the structure. When it is someone who only has a few customers to mark up, no error. Once I get to someone 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 be, and if not why am I getting this error. My next question will be going to allaire as I will have to buy a support ticket to get this resolved. Robert Everland III Web Developer Dixon Ticonderoga ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error 37000 Revisted
That sucks then because I am use client variables on MS SQL Server 7. Have a call into Allaire so we'll see what happens. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 10, 2001 11:06 AM To: CF-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. Database client vars for MS SQL Server 7 = unlimited You would be shocked at how long a string becomes when you serialize it using WDDX! Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: 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 then marking up the structure. When it is someone who only has a few customers to mark up, no error. Once I get to someone 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 be, and if not why am I getting this error. My next question will be going to allaire as I will have to buy a support ticket to get this resolved. Robert Everland III Web Developer Dixon Ticonderoga ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 but it FAILED! Please Help? Stephanie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error
It probably means that the datasource you want to access needs to be a system DSN, meaning that the sytem has control over the datasource, as opposed to file or user DSNs. Is your current datasource a user DSN, file DSN, or system DSN? Check the ODBC Datasource Administration (under the control panel). If your datasource is listed under any tab other than System, then CF won't be able to use it (as CF runs under the system account). Christopher McGuckin DynCorp IET, Inc. (703) 264-9247 "Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read". -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 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? Stephanie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC Error Code = 37000 UGH!!!!!!!!!!!!!
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'. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error Code = 37000 UGH!!!!!!!!!!!!!
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! 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'. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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, 2001 10:56 PM To: CF-Talk Subject: RE: ODBC Error Code = 37000 UGH! 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! 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'. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC Error Code = 37000
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] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error Code = 37000
man, i had that same error about 3-4 weeks ago... i was playing with a small access database and then one day every insert to one table came back with this error... i couldn't figure it out, i built a new table and transferred the data and relationships over and whola! it worked... i still have no clue except somehow it was a problem with accessing that one specific table.. Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [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 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] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 another row with data into the database. Any help will be greatly appreciated.: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (3:52). --- Thanks. Richard ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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. ~Simon Simon Horwith Allaire Certified ColdFusion Instructor Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 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 another row with data into the database. Any help will be greatly appreciated.: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (3:52). --- Thanks. Richard ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ODBC error.
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 -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 into an identity column using SET IDENTITY_INSERT tableName ON/OFF ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC error.
That may be true, but I'd generally recommend against it. ~Simon Simon Horwith Allaire Certified ColdFusion Instructor Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- 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 into an identity column using SET IDENTITY_INSERT tableName ON/OFF ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error 37000
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
hey Al,
You might try going to the MS support site and running a query for
single user mode...
http://search.support.microsoft.com/kb/psssearch.asp?SPR=sqlT=BKT=AL
LT1=7dLQ=single+user+modeS=FA=TDU=CFR=0D=sqlserver%2Bor%2Bodbc
LPR=%22SQL+Server%22LNG=ENGVR=http%3A%2F%2Fsupport.microsoft.com%2Fs
upport%3Bhttp%3A%2F%2Fsupport.microsoft.com%2Fservicedesks%2Fwebcasts%
3Bhttp%3A%2F%2Fsupport.microsoft.com%2FhighlightsCAT=SupportVRL=ENG
SA=GN
which I did for you... are you doing maintenance on your DB's?
Ton's of things might cause this.
Aaron Johnson, MCSE, MCP+I
MINDSEYE, Inc.
phn617.350.0339
fax617.350.8884
icq66172567
[EMAIL PROTECTED]
___
"Never forget that only dead fish swim with
the stream." -- Malcolm Muggeridge
___
- -Original 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 about 5 out of the 20 or so databases were
in
single user mode. I never selected single user mode in my entire
life:)
I unchecked the "single user" option, and everything was fine for
a
while. And I forgot about it. Today, when I first checked my email,
I got
4500 messages from my server saying there is a problem (When I trap a
database error in CF, I do a cfmail to me to tell me about it)
I just went back in, and 2 of the databases were in single user
mode. One was the database for my busiest site, thethin.net.
The other was used infrequently, so I guess it didn't trigger any
errors.
Nobody other than me has access to that server. I know I did not
select
single user mode.
So the question is: How did it go into single user mode?
Is there a bug in SQL Server 7.0SP2?
Could it have been a hacker playing around with a cold fusion
exploit in
some way?
thanks for the reply.. I will watch it closely.
Al
Al,
Go into SQLServer Enterprise Manager. Click on the entry for the
database, select Database Properties, go to the Options Tab and
deselect the Single User option.
Chris
--
Chris Lomvardias
[EMAIL PROTECTED]
Syscom, Inc.
400 E. Pratt Street, Suite 300
Baltimore, MD 21202
(410)539-3737 x1722 voice
(410)539-7302 fax
[EMAIL PROTECTED] (pager via email)
http://www.syscom.com/
--
-Original Message-
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 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 SQL Server Driver][SQL Server]Database 'thethin' is
already open and can only have one user at a time.
The most commonly executed querry is for a banner ad rotation I
wrote, which calls a stored procedure. I am pretty new at stored
procedures... so I may have blew this badly:)
cfquery name="nextad" datasource="thethin" dbtype="ODBC"
{ call getad(#cat_id#) }
/cfquery
The procedure is:
create procedure getad
@cat_id integer
as
begin transaction
declare @lastad_id int
declare @nextad_id int
declare @shown int
set @lastad_id = (select lastad_id from category where
category_id =
@cat_id)
set @nextad_id = (select min(ad_link) from ad_category_link
where
((category_link = @cat_id) and (ad_link @lastad_id)))
set @shown = (select shown from ads where ad_id = @nextad_id)
+1
if @nextad_id is NULL
begin
set @nextad_id = (select min(ad_link) from
ad_category_link
where (category_link = @cat_id) )
end
update category set lastad_id = @nextad_id where category_id=
@cat_id
update ads set shown= @shown where ad_id = @nextad_id
select * from ads where ad_id = @nextad_id
commit transaction
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error 37000 (anyone using SQL 7 SP2 - read!!!)
I think you got it!
I was in such a rush to fix it, I skimmed right by the correct
article. It is a "known bug" in SQL server 7 SP2. That is why it just
showed up - I recently installed SP2.
The maintanace plan wizard created a maintanace plan that puts the
database into single user mode, runs the test, corrects any errors it
finds, then removes the single user mode. If someone hits the database in
that exact moment between those last 2 steps, the table is in still single
user mode - so the command to remove single user mode can't get through.
That is also why it happens in the middle of the night:) That is when the
plan ran. For some reason, it couldn't even email me that there was a problem.
All of the tables checked out ok with a manual DBCC checkdatabase!
(And I just ordered sql 2000 because of this problem:)
thanks a million - I owe you one!
Al
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
hey Al,
You might try going to the MS support site and running a query for
single user mode...
http://search.support.microsoft.com/kb/psssearch.asp?SPR=sqlT=BKT=AL
LT1=7dLQ=single+user+modeS=FA=TDU=CFR=0D=sqlserver%2Bor%2Bodbc
LPR=%22SQL+Server%22LNG=ENGVR=http%3A%2F%2Fsupport.microsoft.com%2Fs
upport%3Bhttp%3A%2F%2Fsupport.microsoft.com%2Fservicedesks%2Fwebcasts%
3Bhttp%3A%2F%2Fsupport.microsoft.com%2FhighlightsCAT=SupportVRL=ENG
SA=GN
which I did for you... are you doing maintenance on your DB's?
Ton's of things might cause this.
Aaron Johnson, MCSE, MCP+I
MINDSEYE, Inc.
phn617.350.0339
fax617.350.8884
icq66172567
[EMAIL PROTECTED]
___
"Never forget that only dead fish swim with
the stream." -- Malcolm Muggeridge
___
- -Original 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 about 5 out of the 20 or so databases were
in
single user mode. I never selected single user mode in my entire
life:)
I unchecked the "single user" option, and everything was fine for
a
while. And I forgot about it. Today, when I first checked my email,
I got
4500 messages from my server saying there is a problem (When I trap a
database error in CF, I do a cfmail to me to tell me about it)
I just went back in, and 2 of the databases were in single user
mode. One was the database for my busiest site, thethin.net.
The other was used infrequently, so I guess it didn't trigger any
errors.
Nobody other than me has access to that server. I know I did not
select
single user mode.
So the question is: How did it go into single user mode?
Is there a bug in SQL Server 7.0SP2?
Could it have been a hacker playing around with a cold fusion
exploit in
some way?
thanks for the reply.. I will watch it closely.
Al
Al,
Go into SQLServer Enterprise Manager. Click on the entry for the
database, select Database Properties, go to the Options Tab and
deselect the Single User option.
Chris
--
Chris Lomvardias
[EMAIL PROTECTED]
Syscom, Inc.
400 E. Pratt Street, Suite 300
Baltimore, MD 21202
(410)539-3737 x1722 voice
(410)539-7302 fax
[EMAIL PROTECTED] (pager via email)
http://www.syscom.com/
--
-Original Message-
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 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 SQL Server Driver][SQL Server]Database 'thethin' is
already open and can only have one user at a time.
The most commonly executed querry is for a banner ad rotation I
wrote, which calls a stored procedure. I am pretty new at stored
procedures... so I may have blew this badly:)
cfquery name="nextad" datasource="thethin" dbtype="ODBC"
{ call getad(#cat_id#) }
/cfquery
The procedure is:
create procedure getad
@cat_id integer
as
begin transaction
declare @lastad_id int
declare @nextad_id int
declare @shown int
set @lastad_id = (select lastad_id from category where
category_id =
@cat_id)
set @nextad_id = (select min(ad_link) from ad_category_link
where
((category_link = @cat_id) and (ad_link @lastad_id)))
set @shown = (select shown from ads where ad_id = @nextad_id)
+1
if @nextad_id is NULL
be
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 Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC
SQL Server Driver][SQL Server]Database 'thethin' is already open and can
only have one user at a time.
The most commonly executed querry is for a banner ad rotation I wrote,
which calls a stored procedure. I am pretty new at stored procedures... so
I may have blew this badly:)
cfquery name="nextad" datasource="thethin" dbtype="ODBC"
{ call getad(#cat_id#) }
/cfquery
The procedure is:
create procedure getad
@cat_id integer
as
begin transaction
declare @lastad_id int
declare @nextad_id int
declare @shown int
set @lastad_id = (select lastad_id from category where category_id =
@cat_id)
set @nextad_id = (select min(ad_link) from ad_category_link where
((category_link = @cat_id) and (ad_link @lastad_id)))
set @shown = (select shown from ads where ad_id = @nextad_id) +1
if @nextad_id is NULL
begin
set @nextad_id = (select min(ad_link) from ad_category_link
where (category_link = @cat_id) )
end
update category set lastad_id = @nextad_id where category_id= @cat_id
update ads set shown= @shown where ad_id = @nextad_id
select * from ads where ad_id = @nextad_id
commit transaction
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error 37000
Al,
Go into SQLServer Enterprise Manager. Click on the entry for the database,
select Database Properties, go to the Options Tab and deselect the Single
User option.
Chris
--
Chris Lomvardias
[EMAIL PROTECTED]
Syscom, Inc.
400 E. Pratt Street, Suite 300
Baltimore, MD 21202
(410)539-3737 x1722 voice
(410)539-7302 fax
[EMAIL PROTECTED] (pager via email)
http://www.syscom.com/
--
-Original Message-
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 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
SQL Server Driver][SQL Server]Database 'thethin' is already open and can
only have one user at a time.
The most commonly executed querry is for a banner ad rotation I wrote,
which calls a stored procedure. I am pretty new at stored procedures... so
I may have blew this badly:)
cfquery name="nextad" datasource="thethin" dbtype="ODBC"
{ call getad(#cat_id#) }
/cfquery
The procedure is:
create procedure getad
@cat_id integer
as
begin transaction
declare @lastad_id int
declare @nextad_id int
declare @shown int
set @lastad_id = (select lastad_id from category where category_id =
@cat_id)
set @nextad_id = (select min(ad_link) from ad_category_link where
((category_link = @cat_id) and (ad_link @lastad_id)))
set @shown = (select shown from ads where ad_id = @nextad_id) +1
if @nextad_id is NULL
begin
set @nextad_id = (select min(ad_link) from ad_category_link
where (category_link = @cat_id) )
end
update category set lastad_id = @nextad_id where category_id= @cat_id
update ads set shown= @shown where ad_id = @nextad_id
select * from ads where ad_id = @nextad_id
commit transaction
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access ODBC error
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 = 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 of (CFQUERY), occupying document position (1:1) to (1:58). -- This leads me to think it has not been specified correctly in the datasource, i'm using an Access DB Thanx in advance ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access ODBC error
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 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 = 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 of (CFQUERY), occupying document position (1:1) to (1:58). -- This leads me to think it has not been specified correctly in the datasource, i'm using an Access DB Thanx in advance ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access ODBC error
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 of (CFQUERY), occupying document position (1:1) to (1:58). -- This leads me to think it has not been specified correctly in the datasource, i'm using an Access DB Thanx in advance Sounds like a problem on the server. I've never seen that one if a datasource is named wrong or something. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access ODBC error
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? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
