Please help with ODBC error...

2000-12-10 Thread war ape
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

Access ODBC error

2000-12-09 Thread war ape
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

HELP with ODBC Error Code S1109 (Invalid cursor position)

2000-12-06 Thread Mark Fragnoli
My apologies for being a bit OT. I'm getting this error message: ODBC Error Code = S1109 (Invalid cursor position) I'm running CF 4.01 on Windows 2000 Server, Access db. This is a real estate leasing application on a company intranet that searches the database of properties according

HELP! - ODBC Error Code = S1109 (Invalid cursor position)

2000-12-05 Thread Mark Fragnoli
My apologies for being a bit OT. I'm getting this error message: ODBC Error Code = S1109 (Invalid cursor position) I'm running CF 4.01 on Windows 2000 Server, Access db. This is a real estate leasing application on a company intranet that searches the database of properties according

RE: ODBC error

2000-11-20 Thread Scott, Andrew
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

ODBC error

2000-11-20 Thread thanh nguyen
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

RE: ODBC error

2000-11-20 Thread Eric Fickes
y it gives errors, I verify the datasource in the cold fusion administration it looked OK Please help ODBC Error Code = 08001 (Unable to connect to data source) --_=_NextPart_001_01C05350.8DF0 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3

ODBC Error: Timeout Expired

2000-11-13 Thread Geoffrey V. Brown
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

ODBC Error Code = S0002 (Base table not found)

2000-10-29 Thread Martin S
, and run the page the following error occurs (however, as I said this error didn't occur in the ColdFusion Query Builder) : Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid

Re: ODBC Error Code = S0002 (Base table not found)

2000-10-29 Thread Brian bouldernet
take off all references of dbo. - Original Message - From: Martin S [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 5:14 PM Subject: ODBC Error Code = S0002 (Base table not found) Hello all, I have been using coldFusion now for almost a year, including

Re: ODBC Error Code = S0002 (Base table not found)

2000-10-29 Thread Stephen M. Aylor
_Name FROM sql_server_name.database_name.dbo.Billers WHERE .. --- Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL

Re: ODBC Error Code = S0002 (Base table not found)

2000-10-29 Thread Stephen M. Aylor
Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" The erro

Re: ODBC Error Code = S0002 (Base table not found)

2000-10-29 Thread Martin S
myDB.db.blahblah or something else, if so can you elaberate a little further. I know about th * being bad form..just a temp test DB page :-) Thanks anyway. Thanks again all. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC

Re: ODBC Error Code = S0002 (Base table not found)

2000-10-29 Thread Marius Milosav
/login.cfm - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:22 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) I have tried removing the .dbo before and no that didn't seem to work. I ha

Re: ODBC Error Code = S0002 (Base table not found)

2000-10-29 Thread Brian bouldernet
: Sunday, October 29, 2000 7:15 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) If the database name is correct, check that you authenticate using SQL server authentication and you provide the same login information in ColdFusion Administrator. Also, I hope that you created the ODBC

Re: ODBC Error Code = S0002 (Base table not found)

2000-10-29 Thread Martin S
arius Milosav" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 21:15:15 -0500 If the database name is correct, check that you authenticate using SQL server authentication and y

Re: ODBC Error Code = S0002 (Base table not found)

2000-10-29 Thread Martin S
-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 20:25:14 -0700 Hey... to make it simple go through Cold Fusion ODBC. do this by pointing your browser to something like http://yourserver.com/cfide/Administrator/index.cfm Create the ODBC

Re: ODBC Error Code = S0002 (Base table not found)

2000-10-29 Thread Stephen M. Aylor
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

Re: ODBC Error Code = S0002 (Base table not found)

2000-10-29 Thread Stephen M. Aylor
Post your query.. - Original Message - Marius et al. Yes, that is all correct as far as I can tell thus can't be causing the error. the dot notion in the query..hould I do datasourcename.db.fieldname or something else? Cos someone was touching on that before..but I

Re: ODBC Error NO MORE

2000-10-29 Thread Martin S
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, 2

ODBC Error: ?!? What in the world ?!?

2000-10-13 Thread Peter Theobald
html font size=3I have a small bit of SQL that runs in a loop. It runs successfully several hundred times and then I get this bizarre error:br br br ODBC Error Code = 37000 (Syntax error or access violation) br br [MERANT][ODBC Sybase driver][SQL

Re: ODBC Error: ?!? What in the world ?!?

2000-10-13 Thread Peter Theobald
t 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 pr

RE: ODBC Error: ?!? What in the world ?!?

2000-10-13 Thread mherbene
: Friday, October 13, 2000 3:51 PM To: CF-Talk Subject: Re: ODBC Error: ?!? What in the world ?!? Oddly, I checked in my Sybase server and "sp_server_info" is a standard system stored procedure. But "Sp_SeRvEr_InFo" is not. I am so baffled?! I never called this stored procedure.

Error Message: ODBC Error Code = 55019

2000-09-27 Thread James Taavon
cy#', '#form.reqtype#', '#form.requester#', '#form.req_email#', '#form.phone#', '#form.due_date#', '#form.title#', '#form.descrip#', '#form.attachment#', '#form.id#', '#form.assigned#') /cfquery --- ODBC Error Code = 55019 () [IBM][CLI

ODBC Error Code=S0002(Base Table Not found)

2000-09-01 Thread John Crawford
Newbie Question. NT 4.0 sp6 Running SQL 6.5 sp5 I have a datasource=cresthollow with one table=contacts I get the following error Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server

RE: ODBC Error Code=S0002(Base Table Not found)

2000-09-01 Thread David E. Crawford
This is a multi-part message in MIME format. --=_NextPart_000_0158_01C01416.6FC80770 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit ODBC Error Code=S0002(Base Table Not found)If the "sort order" of the database has been set to

RE: ODBC Error Code=S0002(Base Table Not found)

2000-09-01 Thread Dave Watts
I have a datasource=cresthollow with one table=contacts I get the following error Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Contacts'. Make sure

Re: ODBC Error Code=S0002(Base Table Not found)

2000-09-01 Thread John Crawford
Thanks Dave, That did it. JC From: "Dave Watts" [EMAIL PROTECTED] Subject: RE: ODBC Error Code=S0002(Base Table Not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Contacts'. Make sure you specified the name of the database (not just the name of the

odbc error code = s1000 (general error)

2000-08-16 Thread Kelvin Hicks
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

RE: odbc error code = s1000 (general error)

2000-08-16 Thread Scott J. Brader
It Wrong Any opinions expressed herein are mine and are not representative of USAV Communications Group. -Original Message- From: Kelvin Hicks [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 16, 2000 11:56 To: [EMAIL PROTECTED] Subject: odbc error code = s1000 (general error) Situation

ODBC Error S1009-Invalid path?

2000-07-29 Thread Joe Tartaglia
I am getting the following error when I try to CFQUERY 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

ODBC Error = IM002

2000-07-24 Thread KAREN REITER
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

Oracle... ODBC error messages different than native drivers?

2000-07-18 Thread Mike Amburn
Error messages returned from the Oracle ODBC driver do not provide much information. For example, the message "invalid argument" doesn't provide any information about the table or field that causes the error, which is very helpful in a large join. However, when I plug the query into something

RE: Oracle... ODBC error messages different than native drivers?

2000-07-18 Thread Dave Watts
Which leads me to ask... Would the native driver return a different (or even better) error message than the Oracle ODBC driver? In my experience, the Oracle native drivers return a different error message than the ODBC error messages - they're even more obtuse. In fact, the Allaire knowledge

Re: Oracle... ODBC error messages different than native drivers?

2000-07-18 Thread Ricq Pattay
] Sent: Tuesday, July 18, 2000 11:56 AM Subject: RE: Oracle... ODBC error messages different than native drivers? Which leads me to ask... Would the native driver return a different (or even better) error message than the Oracle ODBC driver? In my experience, the Oracle native drivers return

ODBC Error: Text driver cannot open file

2000-07-11 Thread Billy Mulvey
When attempting to access a comma delimited text database, I receive this error: ODBC Error Code = S1000 (General error) [Microsoft][ODBC Text Driver] The Microsoft Jet database engine cannot open the file 'filename.txt'. It is already opened exclusively by another user, or you need permission

RE: ODBC Error-MS Access / locking problem

2000-06-25 Thread Craig M. Rosenblum
Usually that means someone has access running with that database open in design or databiew mode... -Original Message- From: Joe Tartaglia [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 14, 2000 9:59 AM To: [EMAIL PROTECTED] Subject: ODBC Error-MS Access / locking problem I am

ODBC Error-MS Access / locking problem

2000-06-15 Thread Joe Tartaglia
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

odbc error

2000-05-08 Thread Shane Witbeck
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

Re: odbc error

2000-05-08 Thread WBB
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

Re: odbc error

2000-05-08 Thread KChapman
cc: Subject: odbc error 05/08/0

RE: odbc error

2000-05-08 Thread Shane Pitts
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

ODBC error

2000-03-29 Thread stas
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

<    1   2