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=subscribe&forumid=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
ODBC error
Hi guys, can anybody tell me quickly, what this means: ODBC Error Code = S1000 (General error) [INTERSOLV][ODBC Oracle 8 driver][Oracle 8]ORA-02019: connection description for remote database not found I am just doing a simple SELECT there. Thanks! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
SQL = "INSERT INTO tbl_user_profiles
(username,password,FirstName,LastName,Email,Phone,CreateDate) Values
(''dbrown'',''karen1'',''David'',''Brown'',''[EMAIL PROTECTED]
rg'',''803-434-4703'',{ts
''2001-11-14 10:55:47''})"
Data Source = "Intranet_PHA2"
SQL = "INSERT INTO tbl_user_profiles
(username,password,FirstName,LastName,Email,Phone,CreateDate) Values
(''dbrown'',''karen1'',''David'',''Brown'',''[EMAIL PROTECTED]
rg'',''803-434-4703'',{ts
''2001-11-14 10:55:47''})"
The 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
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
ODBC Error
I was using a new tag(not a tag just a single page) from the . It says that I need to set a system database in my Administrator. I have never done that. What is a System Database? I tried picking the same database as my Data source but it FAILED! Please Help? Stephanie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC Error
I'm getting this error when executing a stored procedure occasionally under load. Error Diagnostic Information ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server Driver][SQL Server]rotation Anyone know what a general warning means? jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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
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=subscribe&forumid=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=subscribe&forumid=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=subscribe&forumid=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=subscribe&forumid=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=subscribe&forumid=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=subscribe&forumid=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=subscribe&forumid=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=subscribe&forumid=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=subscribe&forumid=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.
ODBC Error = IM002
I'm having a problem with an access database (see below). I have a form that calls a CF script to perform a simple insert into the database. This code was working fine until Friday morning, until our server crashed. Today, users are getting the error below. I've gone into CF Admin page, and verified the database and still get this problem. I am able to access the database via MS Access and I can perform a query on it via CF Studio. I have also tried deleting and adding the database via CF Admin ODBC and I still get this error. Any input is greatly appreciated since I'm the only CF programmer left on this team. :-) Thanks, Karen Reiter -- Diag. Info - Error Diagnostic Information ODBC Error Code = IM002 (Data source not found and no default driver specified) [Microsoft][ODBC Driver Manager] Data source 'gissurvey' not found and no default driver specified Hint: In order to use ODBC data sources with Cold Fusion you must create the data source using the Data Sources page of the Cold Fusion Administrator. In addition, if you are running under Windows NT you must make sure that the Data Source is created as a System DSN in order for it to be available to Cold Fusion. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (66:1) to (66:52). Date/Time: 07/24/00 10:32:25 Browser: Mozilla/4.5 [en]C-CCK-MCD (WinNT; U) Remote Address: 146.82.80.219 HTTP Referer: http://fit1.east.frontiercorp.com/webpub1/gis/survey1.htm Template: D:\wwwdocs\fit1\webpub1\gis\submit_survey.cfm -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Oracle ODBC error
I'm having trouble hitting an Oracle 8i database via ODBC (I'm running CF4Pro). When I try to verify the connection in the CF Administrator or run a CF template that hits the DB, I get a popup box titled OCI.DLL that says "The specified module could not be found" and then finally I get this message in the browser ODBC Error Code = IM003 (Specified driver could not be loaded) Specified driver could not be loaded due to system error 1114 (Oracle ODBC Driver). I looked and found the OCI.DLL file, so I know that the file is there. The crazy thing is that I am able to hit and query the DB just fine using the "Oracle ODBC Test" application and I'm also able to use Access to link to the DB tables just fine. Anyone have any suggestions? Thanks, Chris -- Chris Lomvardias Syscom, Inc. 400 E. Pratt Street, Suite 300 Baltimore, MD 21202 (410)539-3737 x1722 voice (410)539-7302 fax [EMAIL PROTECTED] [EMAIL PROTECTED] (pager via email) -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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=lists&body=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" 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=lists&body=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=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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
doublepost: odbc error
What does this mean? Message:ODBC Error Code = S1000 (General error) Error Code: -1808 SQL State: S1000 Detail: [Microsoft][ODBC Microsoft Access Driver] Not enough space on disk. Cheers Will ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Weird ODBC error
Anyone ever see anything like the error, below? I've never seen this before...I've even made a copy of the database and it's still NG... Thanks, Howie = Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (39:1) to (39:43). Date/Time: 10/30/01 16:57:31 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 64.69.103.194 HTTP Referer: http://rabbitt.hoot.com/lowv/index.cfm Template: C:\Inetpub\wwwroot\lowv\index.cfm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC error
Im I correct in thinking this SQL Is in a variable?
#PreserveSingleQuotes(myvar)#
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
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
SQL = "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''})"
Data Source = "Intranet_PHA2"
SQL = "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''})"
The 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.
sp_columns #Form.TableName#
INSERT INTO #Form.Tablename#
(#ColumnNames#)
Values
(#FieldNameValues#)
- 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?
>
>
> #PreserveSingleQuotes(myvar)#
>
>
> 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
>
>
>
> >
>
>
>
>
> Error Occurred While Processing Request
>
>
>
>
>
> Error Diagnostic Information
> ODBC Error Code = 22005 (Error in assignment)
>
> [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
> specification
>
> SQL = "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''})"
> Data Source = "Intranet_PHA2"
> SQL = "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''})"
>
> The 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
> >
> > #PreserveSingleQuotes(myvar)#
> >
> >
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.
>
>
>
>
>
>
>
>
>
> sp_columns #Form.TableName#
>
>
>
>
>
Trim(Evaluate(ListGetAt(Form.FieldNames,ListFindNoCase(Form.FIELDNAMES,Colum
> n_Name NEQ "">
>
>
>
>
>
> Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos))) &"'">
>
>
>
> CreateODBCDateTime(Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos>
>
>
>
> Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos))) &"'">
>
>
>
> CreateODBCDateTime(Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos>
>
>
>
> CreateODBCDateTime(Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos>
>
>
>
> Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos)))>
>
>
>
>
>
>
>
> Right(FieldNameValues,Len(FieldNameValues)-1)>
> Right(ColumnNames,Len(ColumnNames)-1)>
>
>
>
>
> INSERT INTO #Form.Tablename#
> (#ColumnNames#)
> Values
> (#FieldNameValues#)
>
>
>
> - 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?
> >
> >
> > #PreserveSingleQuotes(myvar)#
> >
> >
> > 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
> >
> >
> >
> > > >
> >
> >
> >
> >
> > Error Occurred While Processing Request
> >
> >
> >
> >
> >
> > Error Diagnostic Information
> > ODBC Error Code = 22005 (Error in assignment)
> >
> > [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
> > specification
> >
> > SQL = "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''})"
> > Data Source = "Intranet_PHA2"
> > SQL = "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''})"
> >
> > The error occurred while processing an element with a general
> > identifier of
> > (CFQUERY), occupying document position (62:1) to (62:47).
> >
> >
> >
> >
>
~~
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
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" RE: ODBC error 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]">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-- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Access ODBC error
Hello everyone i am using the free CF hosting at CFresources, so i'm accessing the thing through an FTP account. Presumabley the ODBC datasource has been set for me. Yet when i run a simple insert or select * i get this error - Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'SOFTWARE\ODBC\ODBC.INI\MYDB'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:58). -- This leads me to think it has not been specified correctly in the datasource, which might be difficult because they are a bit hard to get a hold of by email, guess it gets kind of busy over there. Any one shed some light on this for me? Thanx in advance War-Ape ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC Error 37000
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:)
{ call getad(#cat_id#) }
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
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 I&ET, 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 . 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
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 . 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
access odbc error
Hi I have this problem: I have an access 2000 database with 72,000 booktitles in it. It has indexing, the table that is searched in this search only has 6 fields [ID, ISBN, Title, Author, Price, Category_ID and InStock] I have a search using LIKE and % - and I need to have some form of like search. i have cached the query Everything was working fine until a couple of weeks ago when we started getting (intermittently) the below error (I cannot create the error on my personal server) Error Diagnostic Information ODBC Error Code = S1001 (Memory allocation error) [Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary disk. SQL = "SELECT ISBN, Title, Author, Price, StockLevel FROM tblTitles WHERE 0=0 AND Title LIKE '%potter%'" Data Source = "PAPERCHAIN_DATA" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:107). Date/Time: 04/28/01 14:32:01 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0) Remote Address: 210.8.44.17 HTTP Referer: http://www.paperchain.com.au/search/search.cfm My ISP says he can see no memory spike, and they have 512 mg ram. has anyone had this sort of error or have any clues as to where I should go from here. (I should say that website owner does not have the money to go to SQL Server at the moment, and does NOT get very many hits at the present) Hope some one can help - I am getting very frustrated Seamus ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 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
Strange ODBC Error
Fellow CFers, Has anyone ever seen an intermittent ODBC error, like the following: "ODBC Error Code = 01000 (General Warning) [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionTransact(GetOverlappedResults())" It occurs seemly at random, and is resolved by refreshing the current CF page in the client's browser. It doesn't appear to be isolated to one CF application, but to any hosted on our server. CF: 4.52 Enterprise IIS: 5.0 Op.Sys: Windows 2000 SQL Server: 7.0 Anyone got any ideas to a likely cause(s)? Regards Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Strange ODBC Error
Can't help with the problem , but why not use OLEDB when you use SQL server, its faster the ODBC and not prone to memory leaks either ? Russell Brown Internet Application Developer Freeserve.com Plc, PO Box 452, Leeds LS2 7EY Date: Thu, 16 Aug 2001 11:06:49 +0100 From: Mike Connolly <[EMAIL PROTECTED]> Subject: Strange ODBC Error Message-ID: <ADA83ADF685BD511BBC924C8E36A40F5CA@EXCHANGE> Fellow CFers, Has anyone ever seen an intermittent ODBC error, like the following: "ODBC Error Code = 01000 (General Warning) [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionTransact(GetOverlappedResults())" It occurs seemly at random, and is resolved by refreshing the current CF page in the client's browser. It doesn't appear to be isolated to one CF application, but to any hosted on our server. CF: 4.52 Enterprise IIS: 5.0 Op.Sys: Windows 2000 SQL Server: 7.0 Anyone got any ideas to a likely cause(s)? Regards Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm -- End of CF-Talk-list V1 #99 ** FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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
ODBC Error: Timeout Expired
Hi, We are running SQL Server 7.0. I'm getting "timeout expired" errors on one script, which runs a lenthy query. The CFQuery has a timeout attrib of , and the script has a requesttimeout value of . The error is still occurring. I'm thinking this must be a server config issue. Any ideas on resolution? Geoff B 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: Oracle ODBC error
1) when you say that you can connect tothe DB using the Oracle ODBC Test app, are you running that app on the CF server machine? (I'm sure it's yes, but sometimes...) 2) Is the CF server service running under an account other than LocalSystem? If so, you might want to turn on auditing for the oracle DLLS to see if there is a permissions problem. -Original Message- From: Lomvardias, Christopher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 6:11 PM To: [EMAIL PROTECTED] Subject: Oracle ODBC error I'm having trouble hitting an Oracle 8i database via ODBC (I'm running CF4Pro). When I try to verify the connection in the CF Administrator or run a CF template that hits the DB, I get a popup box titled OCI.DLL that says "The specified module could not be found" and then finally I get this message in the browser ODBC Error Code = IM003 (Specified driver could not be loaded) Specified driver could not be loaded due to system error 1114 (Oracle ODBC Driver). -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Oracle ODBC error
Here is a link to a list of errors dealing with Oracle http://www.allaire.com/Handlers/index.cfm?ID=5803&Method=Full Don't know it it will help, but it does mention your error code. Todd Ashworth - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 30, 2000 8:11 AM Subject: RE: Oracle ODBC error > 1) when you say that you can connect tothe DB using the Oracle ODBC Test > app, are you running that app > on the CF server machine? (I'm sure it's yes, but sometimes...) > > 2) Is the CF server service running under an account other than LocalSystem? > If so, you might want to turn on auditing for the oracle DLLS to see if > there is a permissions problem. > > -Original Message- > From: Lomvardias, Christopher [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 29, 2000 6:11 PM > To: [EMAIL PROTECTED] > Subject: Oracle ODBC error > > > I'm having trouble hitting an Oracle 8i database via ODBC (I'm running > CF4Pro). When I try to verify the connection in the CF Administrator or run > a CF template that hits the DB, I get a popup box titled OCI.DLL that says > "The specified module could not be found" and then finally I get this > message in the browser > ODBC Error Code = IM003 (Specified driver could not be loaded) > Specified driver could not be loaded due to system error 1114 (Oracle ODBC > Driver). > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle ODBC error
Well, I feel like an idiot. I didn't reboot after installing the Oracle client. Once I did that, connect to the db via CF worked fine. Just goes to show that you should always try the easiest solutions first. Thanks everyone for your replies and suggestions. Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 30, 2000 8:12 AM To: [EMAIL PROTECTED] Subject: RE: Oracle ODBC error 1) when you say that you can connect tothe DB using the Oracle ODBC Test app, are you running that app on the CF server machine? (I'm sure it's yes, but sometimes...) 2) Is the CF server service running under an account other than LocalSystem? If so, you might want to turn on auditing for the oracle DLLS to see if there is a permissions problem. -Original Message- From: Lomvardias, Christopher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 6:11 PM To: [EMAIL PROTECTED] Subject: Oracle ODBC error I'm having trouble hitting an Oracle 8i database via ODBC (I'm running CF4Pro). When I try to verify the connection in the CF Administrator or run a CF template that hits the DB, I get a popup box titled OCI.DLL that says "The specified module could not be found" and then finally I get this message in the browser ODBC Error Code = IM003 (Specified driver could not be loaded) Specified driver could not be loaded due to system error 1114 (Oracle ODBC Driver). -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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
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:
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#')
> -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: doublepost: odbc error
At 12:16 AM 10/19/2001, you wrote: >What does this mean? > >Message: ODBC Error Code = S1000 (General error) >Error Code: -1808 >SQL State: S1000 >Detail: [Microsoft][ODBC Microsoft Access Driver] Not enough space >on disk. My guess... there is not enough space on the disk. Check the free space on your hard drive, it's getting real low by the sound of it. -- James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Weird ODBC error
Nevermind... Can you say "corrupted database?" I knew you could Howie - Original Message - From: "Howie Hamlin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 30, 2001 4:58 PM Subject: Weird ODBC error > Anyone ever see anything like the error, below? I've never seen this before...I've >even made a copy of the database and it's still > NG... > > Thanks, > > Howie > > = > > Error Occurred While Processing Request > Error Diagnostic Information > ODBC Error Code = S1000 (General error) > > > [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine >stopped the process because you and another user > are attempting to change the same data at the same time. > > > > The error occurred while processing an element with a general identifier of >(CFQUERY), occupying document position (39:1) to > (39:43). > > > Date/Time: 10/30/01 16:57:31 > Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) > Remote Address: 64.69.103.194 > HTTP Referer: http://rabbitt.hoot.com/lowv/index.cfm > Template: C:\Inetpub\wwwroot\lowv\index.cfm > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access ODBC error
i am using the free CF hosting at CFresources, so i'm accessing the thing through an FTP account. Presumabley the ODBC datasource has been set for me. Yet when i run a simple insert or select * i get this error - Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'SOFTWARE\ODBC\ODBC.INI\MYDB'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:58). -- This leads me to think it has not been specified correctly in the datasource, i'm using an Access DB Thanx in advance ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access ODBC error
Whats the url fo CFresources free hosting? -Original Message- From: war ape [mailto:[EMAIL PROTECTED]] Sent: 12 December 2000 16:22 To: CF-Talk Subject: Re: Access ODBC error i am using the free CF hosting at CFresources, so i'm accessing the thing through an FTP account. Presumabley the ODBC datasource has been set for me. Yet when i run a simple insert or select * i get this error - Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'SOFTWARE\ODBC\ODBC.INI\MYDB'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:58). -- This leads me to think it has not been specified correctly in the datasource, i'm using an Access DB Thanx in advance ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access ODBC error
On 12/12/00, war ape penned: >Error Diagnostic Information >ODBC Error Code = S1000 (General error) > >[Microsoft][ODBC Microsoft Access Driver]General error Unable to open >registry key 'SOFTWARE\ODBC\ODBC.INI\MYDB'. > >The error occurred while processing an element with a general identifier of >(CFQUERY), occupying document position (1:1) to (1:58). >-- >This leads me to think it has not been specified correctly in the >datasource, i'm using an Access DB >Thanx in advance Sounds like a problem on the server. I've never seen that one if a datasource is named wrong or something. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access ODBC error
http://www.cfm-resources.com/ > -Original Message- > From: Nick Betts [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 12, 2000 10:39 AM > To: CF-Talk > Subject: RE: Access ODBC error > > > Whats the url fo CFresources free hosting? > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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:)
{ call getad(#cat_id#) }
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
I am not DB expert but here are some things to check.
First is there a limit to the number of users for that table?
If not then:
The issue here seems to be with commiting the transaction.
If someone is viewing the banner and using the stored procedure then they
would have it locked until the transaction is commited. Therefore if
someone else accessed the script before it was commited you might have a
locking issue.
Mark Johnson
---
Senior Cold Fusion Developer
Cardinal Communications
-Original Message-
From: Al Musella, DPM [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 6: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:)
{ call getad(#cat_id#) }
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
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:)
>
>
>
> { call getad(#cat_id#) }
>
>
>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
-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=sql&T=B&KT=AL
L&T1=7d&LQ=single+user+mode&S=F&A=T&DU=C&FR=0&D=sqlserver%2Bor%2Bodbc&
LPR=%22SQL+Server%22&LNG=ENG&VR=http%3A%2F%2Fsupport.microsoft.com%2Fs
upport%3Bhttp%3A%2F%2Fsupport.microsoft.com%2Fservicedesks%2Fwebcasts%
3Bhttp%3A%2F%2Fsupport.microsoft.com%2Fhighlights&CAT=Support&VRL=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.
617.350.0339
617.350.8884
66172567
[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:)
>
>
>
> { call getad(#cat_id#) }
>
>
>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
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: access odbc error
> I have an access 2000 database ... > ... > Everything was working fine until a couple of weeks ago > when we started getting (intermittently) the below error ... > > Error Diagnostic Information > ODBC Error Code = S1001 (Memory allocation error) > [Microsoft][ODBC Microsoft Access Driver] Not enough space on > temporary disk. Are you sure you have enough free space on the disk drive when this runs? Your ISP should be able to audit that for you, if necessary. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC Error 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: Strange ODBC Error
Could possibly be linked to your "licence" and available "concurrent" database connections. Check your transaction and locking code and also take heed of Micro$ofts recent security bulletin for securing IIS. You might be being fired upon by denial of service attacks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Connolly Sent: Thursday, 16 August 2001 8:07 PM To: CF-Talk Subject: Strange ODBC Error Fellow CFers, Has anyone ever seen an intermittent ODBC error, like the following: "ODBC Error Code = 01000 (General Warning) [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionTransact(GetOverlappedResults())" It occurs seemly at random, and is resolved by refreshing the current CF page in the client's browser. It doesn't appear to be isolated to one CF application, but to any hosted on our server. CF: 4.52 Enterprise IIS: 5.0 Op.Sys: Windows 2000 SQL Server: 7.0 Anyone got any ideas to a likely cause(s)? Regards Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Strange ODBC Error
Mike, Check your SQL Connection setting. It looks like it is using [Named Pipes]. Try changing to TCP/IP. Jeff Craig - Original Message - From: "Mike Connolly" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 16, 2001 5:06 AM Subject: Strange ODBC Error > Fellow CFers, > > Has anyone ever seen an intermittent ODBC error, like the following: > > "ODBC Error Code = 01000 (General Warning) > [Microsoft][ODBC SQL Server Driver][Named > Pipes]ConnectionTransact(GetOverlappedResults())" > > It occurs seemly at random, and is resolved by refreshing the current CF > page in the client's browser. > > It doesn't appear to be isolated to one CF application, but to any hosted on > our server. > > CF: 4.52 Enterprise > IIS: 5.0 > Op.Sys: Windows 2000 > SQL Server: 7.0 > > Anyone got any ideas to a likely cause(s)? > > Regards > > Mike > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange ODBC Error
Hi Mike; We would get that error whenever the connection to our SQL database failed, like is someone decided to reboot the database server while the site was still running. Melanie -Original Message- From: Mike Connolly [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 6:07 AM To: CF-Talk Subject: Strange ODBC Error Fellow CFers, Has anyone ever seen an intermittent ODBC error, like the following: "ODBC Error Code = 01000 (General Warning) [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionTransact(GetOverlappedResults())" It occurs seemly at random, and is resolved by refreshing the current CF page in the client's browser. It doesn't appear to be isolated to one CF application, but to any hosted on our server. CF: 4.52 Enterprise IIS: 5.0 Op.Sys: Windows 2000 SQL Server: 7.0 Anyone got any ideas to a likely cause(s)? Regards Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange ODBC Error
You might want to try using the tcp/ip network library instead of Named Pipes - in general people seem to have more success with it. You have to adjust the network library (the network protocol choice) on both the server and the clients (including the CF server); the server can support more than one library simultaneously (different clients connecting with different libraries) but a client can use only one library to connect to a given server. On the server you adjust this with the install/setup tool, on the client there's something called the Client Configuration utility that does this. All assuming your SQL server is set up to talk tcp/ip.. -Original Message- From: Melanie Maddix [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 8:33 AM To: CF-Talk Subject: RE: Strange ODBC Error Hi Mike; We would get that error whenever the connection to our SQL database failed, like is someone decided to reboot the database server while the site was still running. Melanie -Original Message- From: Mike Connolly [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 6:07 AM To: CF-Talk Subject: Strange ODBC Error Fellow CFers, Has anyone ever seen an intermittent ODBC error, like the following: "ODBC Error Code = 01000 (General Warning) [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionTransact(GetOverlappedResults())" It occurs seemly at random, and is resolved by refreshing the current CF page in the client's browser. It doesn't appear to be isolated to one CF application, but to any hosted on our server. CF: 4.52 Enterprise IIS: 5.0 Op.Sys: Windows 2000 SQL Server: 7.0 Anyone got any ideas to a likely cause(s)? Regards Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange ODBC Error
change your default Network protocol to TCP/IP in the SQL Server Client Config The named-pipes protocol does more than just shift data from A to B, it has some security mechanisms too. Any breaks in the network traffic between your web server and database can cause errors like this. Mark ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL 2000 ODBC Error?
All of a sudden our CF4.5 on Windows2000 started throwing this error when attempting to connect to SQL2000 datasources. ODBC Error Code = S1000 (General error) [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context Oracle, Access, and SAS datasources all work fine AND the SQL2000 DSN's work from the ODBC control panel, but not from the Cold Fusion control Panel. Anybody ever seen this before? Thanks, Mike __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ODBC Error S1009-Invalid path?
I am getting the following error when I try to a datasource that I was able to verify using the CF Administrator: ODBC Error Code = S1009 (Invalid argument value), [Microsoft][ODBC Microsoft Access 97 Driver] '\\Pluto\clients\highcaliber\PMT' isn't a valid path. Make sure that the, path name is spelled correctly and that you are connected to the server on which the file resides. The path shown does exist and, like I said, I can verify the datasource in CF admin. MS Access database running on Win NT server, IIS, CF v4.01. Other CF datasources are working fine on this server. What am I doing wrong? TIA Joe Tartaglia -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 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 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 > > > > >Select * from TGV.dbo.tablename.column_name WHERE some_column_name = '43' > > > >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]
Please help with ODBC error...
Hello everyone i am using the free CF hosting at CFresources, so i'm accessing the thing through an FTP account. Presumabley the ODBC datasource has been set for me. Yet when i run a simple insert or select * i get this error - Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'SOFTWARE\ODBC\ODBC.INI\MYDB'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:58). -- This leads me to think it has not been specified correctly in the datasource, which might be difficult because they are a bit hard to get a hold of by email, guess it gets kind of busy over there. Any one shed some light on this for me? Thanx in advance War-Ape ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC Error Code = 37000 UGH!!!!!!!!!!!!!
I have CF 4.5.1 SP2, MDAC 2.6, SQL SP3. Does this whenever I set a client variable. Anyone seen this before? Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '55'. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error 37000 Revisted
Yes there are limits to client variables: 1. Cookie client vars = 4000 chars. 2. Registry client vars = ?? 2. Database client vars for ORACLE 8i using native drivers = 4000 chars 3. Database client vars for ORACLE 8i using ODBC drivers = 2000 chars 4. Database client vars for MS SQL Server 7 = unlimited You would be shocked at how long a string becomes when you serialize it using WDDX! Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 10, 2001 7:58 AM To: CF-Talk Subject: ODBC Error 37000 Revisted Ok I found out what is causing the error. I am marking up a lot of data to insert as a client variable. Basically I am joining three queries in a structure then marking up the structure. When it is someone who only has a few customers to mark up, no error. Once I get to someone with around 100 it gives me the odbc error. Now I checked my odbc driver, it lets me use long text retrieval. The SQL field is set as long text. So in theory it should work no matter how much data I send to the SQL server. My question now is, is there really a limit to how big a client variable can be, and if not why am I getting this error. My next question will be going to allaire as I will have to buy a support ticket to get this resolved. Robert Everland III Web Developer Dixon Ticonderoga ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error 37000 Revisted
That sucks then because I am use client variables on MS SQL Server 7. Have a call into Allaire so we'll see what happens. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 10, 2001 11:06 AM To: CF-Talk Subject: RE: ODBC Error 37000 Revisted Yes there are limits to client variables: 1. Cookie client vars = 4000 chars. 2. Registry client vars = ?? 2. Database client vars for ORACLE 8i using native drivers = 4000 chars 3. Database client vars for ORACLE 8i using ODBC drivers = 2000 chars 4. Database client vars for MS SQL Server 7 = unlimited You would be shocked at how long a string becomes when you serialize it using WDDX! Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 10, 2001 7:58 AM To: CF-Talk Subject: ODBC Error 37000 Revisted Ok I found out what is causing the error. I am marking up a lot of data to insert as a client variable. Basically I am joining three queries in a structure then marking up the structure. When it is someone who only has a few customers to mark up, no error. Once I get to someone with around 100 it gives me the odbc error. Now I checked my odbc driver, it lets me use long text retrieval. The SQL field is set as long text. So in theory it should work no matter how much data I send to the SQL server. My question now is, is there really a limit to how big a client variable can be, and if not why am I getting this error. My next question will be going to allaire as I will have to buy a support ticket to get this resolved. Robert Everland III Web Developer Dixon Ticonderoga ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
odbc error connecting to datasource
Greetings
We are attempting to move the username/password from the cfadministrator and
place it in application variables. When this is done, we are getting the
following message
ODBC Error Code = 08001 (Unable to connect to data source)
[IBM][CLI Driver] SQL30082N Attempt to establish connection failed with
security reason "0" ("NOT SPECIFIED"). SQLSTATE=08001
When the username and password are left in the administrator, there is no
problems and everything seems to work well.
Any suggestions?
Thanx
Bill
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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
OT: ODBC error please help
Please help me, how to fix this:
ODBC Error Code = S1000 (General error)
[MERANT][ODBC SQL Server Driver]Unicode conversion failed
SQL = "select count(distinct tracker_id) as sessions, min(datetimestamp),
case Referrer when '' then 'No Referrer' else Referrer end as ref_site from
SiteTracker log1 with (NOLOCK) where Convert(datetime, datetimestamp) >= {ts
'2001-07-28 00:00:00'} and Convert(datetime, datetimestamp) <= {ts
'2001-08-29 00:00:00'} group by case Referrer when '' then 'No Referrer'
else Referrer end order by count(distinct tracker_id) desc"
thanks
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 2000 ODBC Error?
Hey - do you have more information? What network libraries are you using for example. Mark -Original Message- From: WebMaster [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 11:11 AM To: CF-Talk Subject: SQL 2000 ODBC Error? All of a sudden our CF4.5 on Windows2000 started throwing this error when attempting to connect to SQL2000 datasources. ODBC Error Code = S1000 (General error) [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context Oracle, Access, and SAS datasources all work fine AND the SQL2000 DSN's work from the ODBC control panel, but not from the Cold Fusion control Panel. Anybody ever seen this before? Thanks, Mike _ _ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 2000 ODBC Error?
Thanks, It's funny how great minds think alike. I reinstalled MDAC (actually, I upgraded from 2.5 TO 2.6 SP1) and everything is working again. It's just strange. It was working this morning and the only thing I changed was to add a "Virtual Directory" in IIS. How could that possibly cause CF to lose connection to the datasources, and why was it still working from the ODBC Control Panel? I'll probably never know. Thanks for the help anyway, Mike At 1/3/2002 01:19 PM, you wrote: >Hey - do you have more information? What network libraries are you using >for example. > >Mark > >-Original Message- >From: WebMaster [mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 03, 2002 11:11 AM >To: CF-Talk >Subject: SQL 2000 ODBC Error? > > >All of a sudden our CF4.5 on Windows2000 started throwing this error when >attempting to connect to SQL2000 datasources. > > >ODBC Error Code = S1000 (General error) > >[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context > > >Oracle, Access, and SAS datasources all work fine AND the SQL2000 DSN's >work from the ODBC control panel, but not from the Cold Fusion control >Panel. > >Anybody ever seen this before? > >Thanks, > >Mike >_ >_ > >Get Your Own Dedicated Windows 2000 Server > PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER > Instant Activation · $99/Month · Free Setup > http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb >FAQ: http://www.thenetprofits.co.uk/coldfusion/faq >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC error I can't explain
I am reading an excel file with an ODBC query and I am getting the following error. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel Driver] Too many fields defined. Can anyone explain this error, I am not sure why I am getting it. -- James Smith [EMAIL PROTECTED] ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184366 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: odbc error 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=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
odbc error 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
ODBC Error - Changed database context to...
Has anyone seen this error: ODBC Error Code = S1000 (General error) [MERANT][ODBC SQL Server Driver][SQL Server]Changed database context to 'dcwasa_dev'. You can see the full error at http://206.239.48.240/customercare/billing_questions.cfm A Google search led me to the MSDN site with something about running the INSTCAT.SQL script. Any help? =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Simon Park Computer Systems Management, Inc. Director, E-Business205 South Whiting Street #201 Ph: 703-823-4300 x119 Alexandria, VA 22304 fax: 703-823-4301 http://www.csmi.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Error Message: ODBC Error Code = 55019
This is a multi-part message in MIME format.
--924745534C59F24D8DA17653
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
I have never seen this error before, can anybody tell me what it means?
Thanks in advance. NEWREQ is the name of a table. Below is the code it
is referring to.
insert into oimdbadm.newreq (time, date, agency, reqtype, requester,
req_email, phone, due_date, title, descrip, attachment, id, assigned)
values ('#time#', '#date#', '#form.agency#', '#form.reqtype#',
'#form.requester#', '#form.req_email#', '#form.phone#',
'#form.due_date#', '#form.title#', '#form.descrip#',
'#form.attachment#', '#form.id#', '#form.assigned#')
---
ODBC Error Code = 55019 ()
[IBM][CLI Driver][AS] SQL7008N REXX variable "NEWREQ " contains
inconsistent data. SQLSTATE=55019
The error occurred while processing an element with a general identifier
of (CFQUERY), occupying document position (99:1) to (99:49).
--924745534C59F24D8DA17653
Content-Type: text/x-vcard; charset=us-ascii;
name="jtaavon.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for James Taavon
Content-Disposition: attachment;
filename="jtaavon.vcf"
begin:vcard
n:Taavon;James
tel;cell:(443) 506-2117
tel;fax:(410) 333-5203
tel;work:(410) 767-3415
x-mozilla-html:FALSE
org:Department of Labor, Licensing and Regulation;Office of Information and Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Senior Web Developer
adr;quoted-printable:;;1100 N. Eutaw Street,=0D=0ARoom 203;Baltimore;MD;21201;
fn:James Taavon
end:vcard
--924745534C59F24D8DA17653--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
ODBC Error: ?!? What in the world ?!?
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/" eudora="autourl">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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 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 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
