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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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
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: ODBC error
What about username and password permissions on the database tables themselves, or in the datasource as possible places to look. regards Andrew Scott Senior Cold Fusion Application Developer ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: thanh nguyen [mailto:[EMAIL PROTECTED]] Sent: 21 November 2000 07:04 To: CF-Talk Subject: ODBC error if anyone knows why this happened so strange, I checked everything seems to work fine, i can log in (using database table) the page, some how when i run query it gives errors, I verify the datasource in the cold fusion administration it looked OK Please help ODBC Error Code = 08001 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (31:1) to (31:71). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.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 ~~ 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 message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C05350.8DF0 Content-Type: text/plain; charset="iso-8859-1" If this is on windows, open up the ODBC admin, goto the connection properties and Test the connection that way. E -Original Message- From: thanh nguyen [mailto:[EMAIL PROTECTED]] if anyone knows why this happened so strange, I checked everything seems to work fine, i can log in (using database table) the page, some how when i run query it gives errors, I verify the datasource in the cold fusion administration it looked OK Please help ODBC Error Code = 08001 (Unable to connect to data source) --_=_NextPart_001_01C05350.8DF0 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12" TITLERE: ODBC error/TITLE /HEAD BODY PFONT SIZE=2If this is on windows, open up the ODBC admin, goto the connection properties and Test the connection that way./FONT /P PFONT SIZE=2E/FONT /P PFONT SIZE=2-Original Message-/FONT BRFONT SIZE=2From: thanh nguyen [A HREF="mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT /P PFONT SIZE=2if anyone knows why this happened so strange, I checked everything seems to /FONT BRFONT SIZE=2work fine, i can log in (using database table) the page, some how when i run /FONT BRFONT SIZE=2query it gives errors,nbsp; I verify the datasource in the cold fusion /FONT BRFONT SIZE=2administration it looked OK/FONT BRFONT SIZE=2Please help/FONT /P BR PFONT SIZE=2ODBC Error Code = 08001 (Unable to connect to data source)/FONT /P /BODY /HTML --_=_NextPart_001_01C05350.8DF0-- ~~ 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 = S0002 (Base table not found)
take off all references of dbo. - Original Message - From: Martin S [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 5:14 PM Subject: ODBC Error Code = S0002 (Base table not found) Hello all, I have been using coldFusion now for almost a year, including interacting with DB (before just MS.Access). Now I am a sole developer on a project requiring interfacing with Ms.SQl Server. This new adventure is seeing my we problems I have never seen before. Before I go in to the problem, to my knowledge I have the DB source set up corretly (in both CFAMINISTRATOR and WIN NT). I have created a query in ColdFusion successfully using the Query Builder. Within the query buildr I can exeute the query with no problems. However, when I drag and drop the Query in to my page, and run the page the following error occurs (however, as I said this error didn't occur in the ColdFusion Query Builder) : Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:1) to (10:26). Date/Time: 10/30/00 10:55:36 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 203.43.104.222 Template: C:\Inetpub\wwwroot\TGV-Admin\MerchantFindAction.cfm -- -- On the side I am using ColdFusion 4.0 currently. Work hasn't upgraded :-( Thanks for your help..please CC your reply to [EMAIL PROTECTED] - I check this email much more regulary - several times daily. Thanks in advance. Adios. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
It will likely be advised that you consider changing your "Select *" to the actual field/columns you need. Select myDB.dbo.Billers.Merchant_Name, myDB.dbo.Billers.Merchant_Address1, myDB.dbo.Billers.Merchant_ZipCode, myDB.dbo.Billers.Merchant_Shoe_Size, etc. many around here consider Select* to be bad form. tho thats not likely causing your error. you may need the database.owner.tablename syntax : Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name or even: Merchant_Name FROM sql_server_name.database_name.dbo.Billers WHERE .. --- Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
Or that :-) depends take off all references of dbo. - Original Message - From: Martin S [EMAIL PROTECTED] Hello all, I have been using coldFusion now for almost a year, including interacting with DB (before just MS.Access). Now I am a sole developer on a project requiring interfacing with Ms.SQl Server. This new adventure is seeing my we problems I have never seen before. Before I go in to the problem, to my knowledge I have the DB source set up corretly (in both CFAMINISTRATOR and WIN NT). I have created a query in ColdFusion successfully using the Query Builder. Within the query buildr I can exeute the query with no problems. However, when I drag and drop the Query in to my page, and run the page the following error occurs (however, as I said this error didn't occur in the ColdFusion Query Builder) : Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:1) to (10:26). Date/Time: 10/30/00 10:55:36 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 203.43.104.222 Template: C:\Inetpub\wwwroot\TGV-Admin\MerchantFindAction.cfm -- -- On the side I am using ColdFusion 4.0 currently. Work hasn't upgraded :-( Thanks for your help..please CC your reply to [EMAIL PROTECTED] - I check this email much more regulary - several times daily. Thanks in advance. Adios. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
I have tried removing the .dbo before and no that didn't seem to work. I have also tried to add the name of the datasource (db) to the beginning (ie.db.dbo.blahblah). This was just in a rage of brain storming and that didn't work. Is that what you were talking about by saying myDB.db.blahblah or something else, if so can you elaberate a little further. I know about th * being bad form..just a temp test DB page :-) Thanks anyway. Thanks again all. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 16:34:35 -0800 It will likely be advised that you consider changing your "Select *" to the actual field/columns you need. Select myDB.dbo.Billers.Merchant_Name, myDB.dbo.Billers.Merchant_Address1, myDB.dbo.Billers.Merchant_ZipCode, myDB.dbo.Billers.Merchant_Shoe_Size, etc. many around here consider Select* to be bad form. tho thats not likely causing your error. you may need the database.owner.tablename syntax : Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name or even: Merchant_Name FROM sql_server_name.database_name.dbo.Billers WHERE .. --- Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
When you created the ODBC datasource, you have to point to the database you want to connect. By default its the master dB. Go in Control Panel\ODBC and edit the datasource. This should fix the problem Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:22 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) I have tried removing the .dbo before and no that didn't seem to work. I have also tried to add the name of the datasource (db) to the beginning (ie.db.dbo.blahblah). This was just in a rage of brain storming and that didn't work. Is that what you were talking about by saying myDB.db.blahblah or something else, if so can you elaberate a little further. I know about th * being bad form..just a temp test DB page :-) Thanks anyway. Thanks again all. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 16:34:35 -0800 It will likely be advised that you consider changing your "Select *" to the actual field/columns you need. Select myDB.dbo.Billers.Merchant_Name, myDB.dbo.Billers.Merchant_Address1, myDB.dbo.Billers.Merchant_ZipCode, myDB.dbo.Billers.Merchant_Shoe_Size, etc. many around here consider Select* to be bad form. tho thats not likely causing your error. you may need the database.owner.tablename syntax : Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name or even: Merchant_Name FROM sql_server_name.database_name.dbo.Billers WHERE .. --- Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" --- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
Hey... to make it simple go through Cold Fusion ODBC. do this by pointing
your browser to something like
http://yourserver.com/cfide/Administrator/index.cfm
Create the ODBC that way...
- Original Message -
From: Marius Milosav [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, October 29, 2000 7:15 PM
Subject: Re: ODBC Error Code = S0002 (Base table not found)
If the database name is correct, check that you authenticate using SQL
server authentication and you provide the same login information in
ColdFusion Administrator.
Also, I hope that you created the ODBC datasource as System DSN
Marius Milosav
www.scorpiosoft.com
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm
- Original Message -
From: "Martin S" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, October 29, 2000 8:57 PM
Subject: Re: ODBC Error Code = S0002 (Base table not found)
Marius and all,
Sorry about this. I am new to accessing DBs other than Access in
COldFusion..so excuse my ignorance when it comes to this.
I belive I have done what you say, but please verify this with me, as I
am
after all new to this frontier.
I just went to confirm this from the ontrol Panel, ODBC DS, System DSN,
and
it was all there..I checked it etc..
and at the end it came up with this test successfull result :
Microsoft SQL Server ODBC Driver Version 03.70.0623
Data Source Name: BP
Data Source Description: Internet Billpay Staging box
Server: ###.
Database: TGV
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: No
Use Regional Settings: Yes
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Whwere does this leave me?
From: "Marius Milosav" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: ODBC Error Code = S0002 (Base table not found)
Date: Sun, 29 Oct 2000 20:55:00 -0500
When you created the ODBC datasource, you have to point to the database
you
want to connect. By default its the master dB.
Go in Control Panel\ODBC and edit the datasource. This should fix the
problem
Marius Milosav
www.scorpiosoft.com
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm
- Original Message -
From: "Martin S" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, October 29, 2000 8:22 PM
Subject: Re: ODBC Error Code = S0002 (Base table not found)
I have tried removing the .dbo before and no that didn't seem to
work.
I have also tried to add the name of the datasource (db) to the
beginning
(ie.db.dbo.blahblah). This was just in a rage of brain storming and
that
didn't work. Is that what you were talking about by saying
myDB.db.blahblah
or something else, if so can you elaberate a little further.
I know about th * being bad form..just a temp test DB page :-)
Thanks
anyway.
Thanks again all.
From: "Stephen M. Aylor" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: ODBC Error Code = S0002 (Base table not found)
Date: Sun, 29 Oct 2000 16:34:35 -0800
It will likely be advised that you consider changing your "Select
*"
to
the
actual field/columns you need.
Select myDB.dbo.Billers.Merchant_Name,
myDB.dbo.Billers.Merchant_Address1,
myDB.dbo.Billers.Merchant_ZipCode,
myDB.dbo.Billers.Merchant_Shoe_Size, etc.
many around here consider Select* to be bad form. tho thats not
likely
causing your error.
you may need the database.owner.tablename syntax :
Merchant_Name FROM database_name.dbo.Billers WHERE
(Merchant_Name
or even:
Merchant_Name FROM sql_server_name.database_name.dbo.Billers
WHERE
..
---
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = S0002 (Base table not found)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object
name
'dbo.Billers'.
SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE
(Merchant_Name
LIKE
'43')"
---
-
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
or
send
a
message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
__
Re: ODBC Error Code = S0002 (Base table not found)
Marius et al. Yes, that is all correct as far as I can tell thus can't be causing the error. the dot notion in the query..hould I do datasourcename.db.fieldname or something else? Cos someone was touching on that before..but I couldn't understand their post. Thanks, Martin. From: "Marius Milosav" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 21:15:15 -0500 If the database name is correct, check that you authenticate using SQL server authentication and you provide the same login information in ColdFusion Administrator. Also, I hope that you created the ODBC datasource as System DSN Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:57 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) Marius and all, Sorry about this. I am new to accessing DBs other than Access in COldFusion..so excuse my ignorance when it comes to this. I belive I have done what you say, but please verify this with me, as I am after all new to this frontier. I just went to confirm this from the ontrol Panel, ODBC DS, System DSN, and it was all there..I checked it etc.. and at the end it came up with this test successfull result : Microsoft SQL Server ODBC Driver Version 03.70.0623 Data Source Name: BP Data Source Description: Internet Billpay Staging box Server: ###. Database: TGV Language: (Default) Translate Character Data: Yes Log Long Running Queries: No Log Driver Statistics: No Use Integrated Security: No Use Regional Settings: Yes Prepared Statements Option: Drop temporary procedures on disconnect Use Failover Server: No Use ANSI Quoted Identifiers: Yes Use ANSI Null, Paddings and Warnings: Yes Whwere does this leave me? From: "Marius Milosav" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 20:55:00 -0500 When you created the ODBC datasource, you have to point to the database you want to connect. By default its the master dB. Go in Control Panel\ODBC and edit the datasource. This should fix the problem Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:22 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) I have tried removing the .dbo before and no that didn't seem to work. I have also tried to add the name of the datasource (db) to the beginning (ie.db.dbo.blahblah). This was just in a rage of brain storming and that didn't work. Is that what you were talking about by saying myDB.db.blahblah or something else, if so can you elaberate a little further. I know about th * being bad form..just a temp test DB page :-) Thanks anyway. Thanks again all. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 16:34:35 -0800 It will likely be advised that you consider changing your "Select *" to the actual field/columns you need. Select myDB.dbo.Billers.Merchant_Name, myDB.dbo.Billers.Merchant_Address1, myDB.dbo.Billers.Merchant_ZipCode, myDB.dbo.Billers.Merchant_Shoe_Size, etc. many around here consider Select* to be bad form. tho thats not likely causing your error. you may need the database.owner.tablename syntax : Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name or even: Merchant_Name FROM sql_server_name.database_name.dbo.Billers WHERE .. --- Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" --- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb
Re: ODBC Error Code = S0002 (Base table not found)
I have..
The thing is I am doing the Cold Fusion remotely on a different computer on
the network.
I have set up the remote computer (where the Code and DB is stored)
datasource settings in Both NT and ColdFusion Admin..as well a the local
computer (my pc) datasource settings in both NT and ColdFusion Admin. I am
not sure if this is over-kill or required but as I said I am new to using a
DB other than Acss (which I haven't had many problems with before) and
working remotely, so to speak.
Thanks,
Martin.
From: [EMAIL PROTECTED] (Brian bouldernet)
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: ODBC Error Code = S0002 (Base table not found)
Date: Sun, 29 Oct 2000 20:25:14 -0700
Hey... to make it simple go through Cold Fusion ODBC. do this by pointing
your browser to something like
http://yourserver.com/cfide/Administrator/index.cfm
Create the ODBC that way...
- Original Message -
From: Marius Milosav [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, October 29, 2000 7:15 PM
Subject: Re: ODBC Error Code = S0002 (Base table not found)
If the database name is correct, check that you authenticate using SQL
server authentication and you provide the same login information in
ColdFusion Administrator.
Also, I hope that you created the ODBC datasource as System DSN
Marius Milosav
www.scorpiosoft.com
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm
- Original Message -
From: "Martin S" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, October 29, 2000 8:57 PM
Subject: Re: ODBC Error Code = S0002 (Base table not found)
Marius and all,
Sorry about this. I am new to accessing DBs other than Access in
COldFusion..so excuse my ignorance when it comes to this.
I belive I have done what you say, but please verify this with me, as
I
am
after all new to this frontier.
I just went to confirm this from the ontrol Panel, ODBC DS, System
DSN,
and
it was all there..I checked it etc..
and at the end it came up with this test successfull result :
Microsoft SQL Server ODBC Driver Version 03.70.0623
Data Source Name: BP
Data Source Description: Internet Billpay Staging box
Server: ###.
Database: TGV
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: No
Use Regional Settings: Yes
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Whwere does this leave me?
From: "Marius Milosav" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: ODBC Error Code = S0002 (Base table not found)
Date: Sun, 29 Oct 2000 20:55:00 -0500
When you created the ODBC datasource, you have to point to the
database
you
want to connect. By default its the master dB.
Go in Control Panel\ODBC and edit the datasource. This should fix the
problem
Marius Milosav
www.scorpiosoft.com
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm
- Original Message -
From: "Martin S" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, October 29, 2000 8:22 PM
Subject: Re: ODBC Error Code = S0002 (Base table not found)
I have tried removing the .dbo before and no that didn't seem to
work.
I have also tried to add the name of the datasource (db) to the
beginning
(ie.db.dbo.blahblah). This was just in a rage of brain storming
and
that
didn't work. Is that what you were talking about by saying
myDB.db.blahblah
or something else, if so can you elaberate a little further.
I know about th * being bad form..just a temp test DB page :-)
Thanks
anyway.
Thanks again all.
From: "Stephen M. Aylor" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: ODBC Error Code = S0002 (Base table not found)
Date: Sun, 29 Oct 2000 16:34:35 -0800
It will likely be advised that you consider changing your "Select
*"
to
the
actual field/columns you need.
Select myDB.dbo.Billers.Merchant_Name,
myDB.dbo.Billers.Merchant_Address1,
myDB.dbo.Billers.Merchant_ZipCode,
myDB.dbo.Billers.Merchant_Shoe_Size, etc.
many around here consider Select* to be bad form. tho thats not
likely
causing your error.
you may need the database.owner.tablename syntax :
Merchant_Name FROM database_name.dbo.Billers WHERE
(Merchant_Name
or even:
...
Re: ODBC Error Code = S0002 (Base table not found)
cfquery datasource="BP" username="yourusername" password="Your_pwd" Select * from TGV.dbo.tablename.column_name WHERE some_column_name = '43' /cfquery Are you absolutely positive that the table "name" your using in your query statement actually exists in the database ? Steve - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 6:50 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) Marius et al. Yes, that is all correct as far as I can tell thus can't be causing the error. the dot notion in the query..hould I do datasourcename.db.fieldname or something else? Cos someone was touching on that before..but I couldn't understand their post. and at the end it came up with this test successfull result : Microsoft SQL Server ODBC Driver Version 03.70.0623 Data Source Name: BP Data Source Description: Internet Billpay Staging box Server: ###. Database: TGV Language: (Default) Translate Character Data: Yes Log Long Running Queries: No Log Driver Statistics: No Use Integrated Security: No Use Regional Settings: Yes Prepared Statements Option: Drop temporary procedures on disconnect Use Failover Server: No Use ANSI Quoted Identifiers: Yes Use ANSI Null, Paddings and Warnings: Yes Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
Post your query.. - Original Message - Marius et al. Yes, that is all correct as far as I can tell thus can't be causing the error. the dot notion in the query..hould I do datasourcename.db.fieldname or something else? Cos someone was touching on that before..but I couldn't understand their post. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error NO MORE
ALAS, Your a legend, it works now!! Thanks..I can progress to another problem no doubt :-) Cheers mate. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 19:19:36 -0800 cfquery datasource="BP" username="yourusername" password="Your_pwd" Select * from TGV.dbo.tablename.column_name WHERE some_column_name = '43' /cfquery Are you absolutely positive that the table "name" your using in your query statement actually exists in the database ? Steve - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 6:50 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) Marius et al. Yes, that is all correct as far as I can tell thus can't be causing the error. the dot notion in the query..hould I do datasourcename.db.fieldname or something else? Cos someone was touching on that before..but I couldn't understand their post. and at the end it came up with this test successfull result : Microsoft SQL Server ODBC Driver Version 03.70.0623 Data Source Name: BP Data Source Description: Internet Billpay Staging box Server: ###. Database: TGV Language: (Default) Translate Character Data: Yes Log Long Running Queries: No Log Driver Statistics: No Use Integrated Security: No Use Regional Settings: Yes Prepared Statements Option: Drop temporary procedures on disconnect Use Failover Server: No Use ANSI Quoted Identifiers: Yes Use ANSI Null, Paddings and Warnings: Yes Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error: ?!? What in the world ?!?
Oddly, I checked in my Sybase server and "sp_server_info" is a standard system stored procedure. But "Sp_SeRvEr_InFo" is not. I am so baffled?! I never called this stored procedure. This bit of SQL has run thousands of times successfully. What does this mean? Is it some nearly random call coded inside the Merant ODBC driver written by an NT programmer that doesn't realize Sybase is case sensitive? At 03:37 PM 10/13/00 -0400, Peter Theobald wrote: I have a small bit of SQL that runs in a loop. It runs successfully several hundred times and then I get this bizarre error: ODBC Error Code = 37000 (Syntax error or access violation) [MERANT][ODBC Sybase driver][SQL Server]Stored procedure 'Sp_SeRvEr_InFo' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output). SQL = "delete from QLangLabels where labelname='ADNationalPressYN' and language='de' and EventArea='MEWE'" You can see from the SQL that it is a simple statement deleting one record. I never call any Stored Procedure. I do not have any Triggers. I never even *heard* of the stored procedure "Sp_SeRvEr_InFo". --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ODBC Error: ?!? What in the world ?!?
ODBC drivers will sometimes call system procedures in order to check on the databases' capabilities, etc.It does look like a driver bug - I'd contact Allaire, assuming you're using the driver provided with CF. -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Friday, October 13, 2000 3:51 PM To: CF-Talk Subject: Re: ODBC Error: ?!? What in the world ?!? Oddly, I checked in my Sybase server and "sp_server_info" is a standard system stored procedure. But "Sp_SeRvEr_InFo" is not. I am so baffled?! I never called this stored procedure. This bit of SQL has run thousands of times successfully. What does this mean? Is it some nearly random call coded inside the Merant ODBC driver written by an NT programmer that doesn't realize Sybase is case sensitive? At 03:37 PM 10/13/00 -0400, Peter Theobald wrote: I have a small bit of SQL that runs in a loop. It runs successfully several hundred times and then I get this bizarre error: ODBC Error Code = 37000 (Syntax error or access violation) [MERANT][ODBC Sybase driver][SQL Server]Stored procedure 'Sp_SeRvEr_InFo' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output). SQL = "delete from QLangLabels where labelname='ADNationalPressYN' and language='de' and EventArea='MEWE'" You can see from the SQL that it is a simple statement deleting one record. I never call any Stored Procedure. I do not have any Triggers. I never even *heard* of the stored procedure "Sp_SeRvEr_InFo". --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ODBC Error Code=S0002(Base Table Not found)
This is a multi-part message in MIME format.
--=_NextPart_000_0158_01C01416.6FC80770
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
ODBC Error Code=S0002(Base Table Not found)If the "sort order" of the
database has been set to binary, or something other than "case-insensitive
dictionary sort", you will have to refer to the tables in the exact case as
specified in the SQL Server database. This looks like a case-sensitivity
problem.
DC
-Original Message-
From: John Crawford [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 01:06
To: [EMAIL PROTECTED]
Subject: ODBC Error Code=S0002(Base Table Not found)
Newbie Question.
NT 4.0 sp6 Running SQL 6.5 sp5
I have a datasource=cresthollow with one table=contacts
I get the following error
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = S0002 (Base table not found)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'Contacts'.
The error occurred while processing an element with a general identifier
of
(CFQUERY), occupying document position (7:1) to (7:49).
Here is the code, I have not implemented much error trapping yet. but this
does work on my local machine using access 2k. Thanks in advance for you
help.
HTML
HEAD
TITLEThanks/TITLE
/HEAD
BODY BGCOLOR="#ff" BACKGROUND="Graphics/background.jpg"
cfquery NAME="Contacts" DATASOURCE="cresthollow"
INSERT INTO contacts (firstname, lastname, address, city, state,
postalcode,
email,phone,
fax, notes, functions, othertext)
VALUES ('#Form.firstname#', '#Form.lastname#', '#Form.address#',
'#Form.city#',
'#Form.state#', '#Form.postalcode#', '#Form.email#', '#Form.phone#',
'#Form.fax#', '#Form.notes#', '#Form.functions#', '#Form.othertext#' )
/CFQUERY
cfmail FROM="#Form.email#"
TO="[EMAIL PROTECTED]"
SUBJECT="Automated Contact Form Submission"
Hi,
My name is #Form.firstname# #Form.Lastname# and I used your online contact
form to send you the following comments:
I would like information on the following:
#Form.functions#
cfif Form.notes is not ""
I have encluded the following comments:
#Form.notes#
/cfif
I can be reached at:
Address:BR
#Form.address#BR
#Form.City#, #Form.State# #Form.postalcode#
Phone: #Form.phone#
Fax: #Form.Fax#
Email: #Form.email#
/cfmail
Thanks
cfoutput
#Form.Firstname#
/cfoutput
HR
Your form has been successfully submitted. Someone will be in contact with
you shortly.
/BODY
/HTML
John R. Crawford
Dolphin NewMedia, Inc
[EMAIL PROTECTED]
Phone 717-728-5554
Fax 717-728-5566
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--=_NextPart_000_0158_01C01416.6FC80770
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEADTITLEODBC Error Code=3DS0002(Base Table Not found)/TITLE
META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR/HEAD
BODY
DIVFONT color=3D#ff face=3DArial size=3D2SPAN =
class=3D745361213-01092000If the=20
"sort order" of the database has been set to binary, or something other =
than=20
"case-insensitive dictionary sort", you will have to refer to the tables =
in the=20
exact case as specified in the SQL Server database.nbsp; This looks =
like a=20
case-sensitivity problem./SPAN/FONT/DIV
DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20
class=3D745361213-01092000/SPAN/FONTnbsp;/DIV
DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20
class=3D745361213-01092000DC/SPAN/FONT/DIV
BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px"
DIV align=3Dleft class=3DOutlookMessageHeader dir=3DltrFONT =
face=3DTahoma=20
size=3D2-Original Message-BRBFrom:/B John Crawford=20
[mailto:[EMAIL PROTECTED]]BRBSent:/B Friday, =
September 01,=20
2000 01:06BRBTo:/B [EMAIL PROTECTED]BRBSubject:/B =
ODBC=20
Error Code=3DS0002(Base Table Not found)BRBR/DIV/FONT
PFONT size=3D2Newbie Question./FONT BRFONT size=3D2NT 4.0 =
sp6 Running=20
SQL 6.5 sp5/FONT /P
PFONT size=3D2I have a datasource=3Dcresthollow with one =
table=3Dcontacts/FONT=20
BRFONT size=3D2I get the following error/FONT /P
PFONT size=3D2Error Occurred While Processing Request/FONT =
BRFONT=20
size=3D2Error Diagnostic Information/FONT BRFONT size=3D2ODBC =
Error Code =3D=20
S0002 (Base table not found)/FONT BRFONT =
size=3D2[Microsoft][ODBC SQL=20
Server Driver][SQL Server]Invalid object name/FONT BRFONT=20
size=3D2'Contacts'./FONT BRFONT size=3D2The error occurred =
while processing=20
an element with a
RE: ODBC Error Code=S0002(Base Table Not found)
I have a datasource=cresthollow with one table=contacts I get the following error Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Contacts'. Make sure you specified the name of the database (not just the name of the database server) in your ODBC settings in CF Administrator. If you leave the database field blank, it'll use the default database (usually the master database) which won't have your tables in it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ODBC Error Code=S0002(Base Table Not found)
Thanks Dave, That did it. JC From: "Dave Watts" [EMAIL PROTECTED] Subject: RE: ODBC Error Code=S0002(Base Table Not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Contacts'. Make sure you specified the name of the database (not just the name of the database server) in your ODBC settings in CF Administrator. If you leave the database field blank, it'll use the default database (usually the master database) which won't have your tables in it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: odbc error code = s1000 (general error)
We had a similar problem. We solved the problem by reinstalling MDAC 2.5. Scott Scott Brader USAV Group 5485 South Westridge Drive PO Box 510620 New Berlin, WI 53151-0620 Phone: 262.814.2000 Fax: 262.814.2006 Amateurs Practice Until They Get It Right, Experts Practice Until They Can't Get It Wrong Any opinions expressed herein are mine and are not representative of USAV Communications Group. -Original Message- From: Kelvin Hicks [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 16, 2000 11:56 To: [EMAIL PROTECTED] Subject: odbc error code = s1000 (general error) Situation - I have made sure that IIS is installed first, then installed Cold Fusion and completed the test installation to ensure system was working properly. At that time I was not yet writing any new database code or submitting queries. I'm now ready to write queries and populate a db and I have now received the dreaded odbc error code = s1000 (general errror). Verified the dbs in the server administrator and each failed. This is how the actual code reads from the 'test installation' page on the server. ***Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Disk or network error. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:2) to (3:52). Date/Time: 08/16/00 10:06:01 Browser: Mozilla/4.73 [en] (Windows NT 5.0; U) Remote Address: 127.0.0.1 HTTP Referer: http://127.0.0.1/CFDOCS/testinstallation/test.cfm I have uninstalled and reinstalled the Cold Fusion Server software. Today, I uninstalled the IIS server and reinstalled and the problem persists. The ODBC sources - system DSN has the cfsnippets db and other example dbs. I am at a lost to what has caused this problem or how to correct the situation. Obviously there is a conflict - unknown to me. Any and all possible solutions will be considered. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ODBC Error-MS Access / locking problem
Usually that means someone has access running with that database open in design or databiew mode... -Original Message- From: Joe Tartaglia [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 14, 2000 9:59 AM To: [EMAIL PROTECTED] Subject: ODBC Error-MS Access / locking problem I am implementing some banner rotation/ad tracking stuff and am getting a fair number of the following errors in my CF application log (lightly edited for clarity): Error,TID=178,06/14/00,04:10:45, ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't update; currently locked by user 'admin' on machine 'NEPTUNE'. SQL = "INSERT INTO Views( SessionID, PositionID, AdID ) VALUES( 'ADTRAX_1807_68186843', 4, 6 )" At times, this site can get busy so there is a lot of these "INSERT" statements going on. I remember something about MS Access doing page locks and not releasing locks right away... Any thoughts/suggestions? TIA Joe Tartaglia High Caliber Systems, Inc. 212-684-5553 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: odbc error
Include the 'id' field as part of the aggregate function (sum, group by, avg, whatever) Can anyone give suggestions why I am getting the following error when selecting specific fields from an Access db, yet when I use a "select *" everything is fine? [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'id' as part of an aggregate function. thanks. Sincerely, Shane Witbeck Webmaster [EMAIL PROTECTED] www.digitalsanctum.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: odbc error
Can we see the query that is causing this problem? --Katrina Katrina Chapman Consultant Ameriquest Mortgage "Shane Witbeck" webmaster@digitalsaTo: [EMAIL PROTECTED] nctum.com cc: Subject: odbc error 05/08/00 03:39 PM Please respond to cf-talk Can anyone give suggestions why I am getting the following error when selecting specific fields from an Access db, yet when I use a "select *" everything is fine? [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'id' as part of an aggregate function. thanks. Sincerely, Shane Witbeck Webmaster [EMAIL PROTECTED] www.digitalsanctum.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: odbc error
can you possibly post the query? -Original Message- From: Shane Witbeck [mailto:[EMAIL PROTECTED]] Sent: Monday, May 08, 2000 4:40 PM To: [EMAIL PROTECTED] Subject: odbc error Can anyone give suggestions why I am getting the following error when selecting specific fields from an Access db, yet when I use a "select *" everything is fine? [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'id' as part of an aggregate function. thanks. Sincerely, Shane Witbeck Webmaster [EMAIL PROTECTED] www.digitalsanctum.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
