Logo

Advertisement

SQL Error ODBC Visual FoxPro Driver: Syntax Error

www.vbforums.com

Can somebody tell me what is wrong about the query (bold) and a solution for it? VB Code:Public cn As New ADODB.ConnectionPublic rs As New ADODB.RecordsetPublic cn2 As New ADODB.ConnectionPublic rs2 As New ADODB.Recordset Private Sub cmdOpenBron_Click()    Dim naam As String        Set cn = New ADODB.Connection    cn.Open "Driver={Microsoft Visual FoxPro Driver};" & _            "SourceType=DBC;" & _            "SourceDB=J:BjornDatadubois.dbc;" & _            "Exclusive=No"    Set rs = cn.Execute("Select * from KLPX")        Set cn2 = New ADODB.Connection    cn2.Open "Driver={Microsoft Visual FoxPro Driver};" & _            "SourceType=DBF;" & _            "SourceDB=C:WINBOOKSdataParfiNV;" & _            "Exclusive=No"                Set rs2 = cn2.Execute("Select * FROM PARFINV_csf")     While Not rs.EOF        While Not rs2.EOF            If Not rs![KL_NAM] = rs2![NAME1] Then                naam = rs![KL_NAM]                  [b]cn2.Execute "INSERT INTO PARFINV_csf [(NAME1)] VALUES '" & naam & "'"[/b]            End If        Wend    Wend     cn.Close    Set rs = Nothing    Set cn = Nothing    cn2.Close    Set rs2 = Nothing    Set cn2 = Nothing Thanx alot in advance

View Answers
Very similar questions

Advertisement

Advertisement

DTS Export Wizard Error forums.databasejournal.com

I am trying to export data from SQL Server to a Visual FoxPro database using the DTS export wizard and I get the same error message every time. After I select a destination (Microsoft Visual FoxPro Driver) and select a DSN is get a DTSA wizard error. It says: Error Source: Microsoft OLE DB Provider for ODBC Drivers. Error Destination: (Microsoft)(ODBC Visual FoxPro Driver) SourceDB Any help will be greatly appreciated. Mike

Replication From SQL 7.0 To Visual Foxpro 6.0 forums.databasejournal.com

I am attempting to set-up replication from a SQL DB to a database in Visual Foxpro 6.0. The problem that I am runnning into relates to setting-up the ODBC. When I either select Visual Foxpro (databases) or Visual Foxpro (free tables), I receive an error message indicating an invalid ODBC name. The message indicates tha

Error To Executing Job On Sql Server Enterprise Manager bytes.com

.... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnError: DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005) Error string: [Microsoft][ODBC Visual FoxPro Driver]Cannot open file e:private.dbc. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 171 (AB) Error string: [Microsoft][ODBC Visual FoxPro Driver]Cannot open file e:private.dbc. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_3 DTSRun OnError: DTS... Process Exit Code 4. The step failed. anyone know becaouse if i execute this job whit the Schedule package dont work but i execute manually it's work ? pls help me ...

How To Avoid The ODBC Dll Overwriting During New Version Softwares Installing www.codeguru.com

Please help me out I am using backend of Oracle Database. Now I want to convert database to foxpro 2.6a Version which working on DOS OS. I have taken a support of ODBC DSN creation. But I am fail when (I was chosen the 'Microsoft Driver for FOXPRO (*.DBF)) it is giving the error the driver had been overwritten by VISUAL FOXPRO drivers. Now how to load the driver of FOXPRO onlyplease give me solutionhans

INSERT INTO Syntax Error www.vbcity.com

Hi,I'm having trouble with using the INSERT INTO statement - I keep getting a syntax error with no explanation. I'm trying to insert data into an Access 2000 database from FoxPro 8.0 (I think) using ADO 2.7 in Visual Basic .NET 2003. I've tried both the OLEDB and ODBC database drivers but I get the same result. If I use Access to connect to FoxPro and paste the contents of the SQL1 variable into the SQL window it works and does append the correct database.My connection is:Code:conBuchan.Open("Driver={Microsoft Visual FoxPro Driver};" & _  "SourceType=DBC;" & _  "SourceDB=" + strFileName + ";" & _  "Exclusive=No")and the SQL sommand is:Code:strSQL1 = "INSERT INTO BuchanTemp IN '" & strDataStoreLocation & "' 'Microsoft.Jet.OLEDB.4.0' " & _  "SELECT bucin.ident_no AS RecordNo, bucin.e_type AS EquipType, bucin.desc AS Description, " & _  "bucin.manu_date AS DateManuf, bucin.manufact AS Manufacturer, bucin.swl AS SWL, " & _  "bucis.location AS Location, bucis.date AS InspDate, bucis.defects AS Defects, " & _  "False AS Failed " & _  "FROM bucin INNER JOIN bucis ON bucin.ident_no = bucis.key " & _  "WHERE (((bucis.pass)='Y')); "conBuchan.Execute(strSQL1)Any insight into what I'm doing wrong would be appreciated,Thanks,Chris.Edited by - CJMills on 8/18/2004 4:13:44 AM

Coding With Foxpro. www.xtremevbtalk.com

Hi there,I am the beginer with Foxpro so I need some help. Pls show me if you can.- I have installed Visual Foxpro 6.0, and when I want to connect to a free table(created by Visual Foxpro) I must use an ODBC to this table. Is there any way? (Like Access we can use Microsoft Jet 3.51 OLE DB Provider).- When I created an ODBC to Foxpro I choose Microsoft Foxpro Driver(*.dbf) but I get an error "Microsoft Foxpro Driver is no longer supported, and has been replaced by Microsoft Visual Foxpro". So can I run my program on the PC with an ODBC by Microsoft Foxpro Driver?- When I use the delete sql it returns that delete successfully. But when I open the Foxpro database the records I have deleted still there. If I make the delete sql in the Fox command window the records will be removed when I used "PACK" command after deleting command. How can I do this by coding in VB?- When I use the insert or update command in VB, in case of the whole of this command returns some errors such as Type mismatch, or some things else...at some fields but the data still insert or update into the fields with no error. What I want to do is using transaction. If there're something wrong in my sql command it must rollback. (raise error and do nothing.)It seems many questions, but it really help me at this time .Thank you very much.

Replication From SQL 7.0 To Visual Foxpro 6.0 forums.databasejournal.com

I am attempting to set-up replication from a SQL DB to a database in Visual Foxpro 6.0. The problem that I am runnning into relates to setting-up the ODBC. When I either select Visual Foxpro (databases) or Visual Foxpro (free tables), I receive an error message indicating an invalid DSN name. The message indicates that the DSN cannot have a space in the name. When I create a new DSN for the Visual Foxpro driver (in the control panel), the subsribers tab in SQL fails to see the new DSN. I have researched all available resources and need to find an answer. How can I get SQL to see the new DSN that I have set-up for Visual Foxpro.

Cannot Insert Record To Visual Foxpro Table www.vbcity.com

"Run-time error'-2147217900(80040e14)[Microsoft][ODBC Visual Foxpro Driver]Must specify additional parameters." This error occurs whenever im inserting a record on a visual foxpro table. This table is not a Free table. It is included on the DBC.Please HELP !!!

BCP With ODBC Native Driver social.msdn.microsoft.com

We are using Visual Studio 2003 to develop a VC++ application to support SQL Server 2000 and 2005 through ODBC driver. I was able to successfully test the application with ODBC driver for 2000. But when it comes to the SQL Server 2005 using native ODBC driver it fails with "ODBCBCP.dll is not compatible with 'SQL Native Client' driver. Please configure 'SQL Server' driver for the DSN or connection string. � Then I tried to use the sqlncli.h inplace of odbcss.h and replaced the odbcbcp.lib with sqlncli.lib pointing to the C:Program FilesMicrosoft SQL Server90SDKLibx86 folder. � Code Snippet #include <sql.h> #include <sqlext.h> #include <sqltypes.h> #define _SQLNCLI_ODBC_ #include <sqlncli.h> � � Now I can not compile the program. The errors I am getting are as follows: � c:Program FilesMicrosoft SQL Server90SDKIncludesqlncli.h(2894): error C2061: syntax error : identifier 'DB_UPARAMS' c:Program FilesMicrosoft SQL Server90SDKIncludesqlncli.h(2901): error C2061: syntax error : identifier 'DB_UPARAMS' etc c:Program FilesMicrosoft SQL Server90SDKIncludesqlncli.h(2938): error C2061: syntax error : identifier 'HCHAPTER' c:Program FilesMicrosoft SQL Server90SDKIncludesqlncli.h(2944): error C2061: syntax error : identifier 'HCHAPTER' etc � The same code just works fine in the Visual Studio 2005, but we need the dll in Visual studio 2003. � I think I am missing pretty obvious. Your help is appreciated. �

Where Is The Visual Foxpro Odbc Driver For Windows Xp? www.vbcity.com

Hi,I have a vba application which reads some data from foxpro tables. It works perfectly in windows 98.The user migrated to windows xp, and can't create de ODBC driver.It asks me to update Visual Foxpro from microsoft page. When I go to that page, it says not to update with windows 2000 or windows Me. It doesn't say anything about windows xp.Where can I find the Visual foxpro odbc driver for windows xp?I downloaded MDAC 2.8, vfpoledb for windows xp.Please, I don't know what to do!!!Thanks,Amota

Advertisement

Linked Server To ODBC forums.databasejournal.com

Hi,, I am trying to create linked server in sql2000 using odbc which point to foxpro free files. I tryed a lot but the following errro message is displayed: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDASQL' reported an error. [OLE/DB provider returned message: [Microsoft][ODBC Visual FoxPro Driver]File 'data1020.dbf' does not exist.] thanks

Another Problem With Dates And .dbf Files www.vbcity.com

I am using VB to connect to Visual FoxPro .dbf files via a .dbc file. I am able to perform most queries just fine, but when I include a field of type Date in my where clause I get the error:Run-time error '-2147467259 (80004005)' [Microsoft][ODBC Visual FoxPro Driver]Missing operand.This error occurs when I execute the query. Below is the code that I am using.  Code:Dim strSQL As String  Dim rst As Recordset  Dim conStr As String  Dim db As Connection  'Setup connection to Database  Set db = New Connection  conStr = "Driver={Microsoft Visual FoxPro Driver};" & _     "UID=;SourceDB=\ServerCommonData.DBC;" & _     "SourceType=DBC; Exclusive=No;BackgroundFetch=Yes;" & _     "Collate=Machine;Null=Yes;Deleted=Yes;"  db.Open (conStr)  'Attempt select query with where clause checking a field of type Date  strSQL = "Select * from JCARDMAN where jc_run_date = #09/12/2002#"  Set rst = db.Execute(strSQL) '<<<Error occurs hereAny help would be greatly appreciated.

Foxpro Error www.codeguru.com

I keep getting the following error:S1000: [Microsoft][ODBC Visual FoxPro Driver]Missing operand.40002It has something to do with the date. When I use "AcctNo = 1231" as the criteria it works fine.Running this code:Private Sub Command2_Click()On Error GoTo ErrorHandler cn.Connect = "SourceType=DBF;" _ & "SourceDB=C:jonAppts;" _ & "Driver={Microsoft Visual FoxPro Driver}" cn.CursorDriver = rdUseOdbc cn.EstablishConnection "rdDriverNoPrompt" SQL = "Select account from Appts where ApptDate = #04/10/2003#;" Debug.Print SQL Set rs = cn.OpenResultset(SQL, rdOpenKeyset) ', rdConcurRowVer) rs.MoveFirst Debug.Print rs(0) 'Debug.Print rs(1) Exit SubErrorHandler:Debug.Print Err.Description & vbCr & Err.NumberEnd SubAny suggestions?ThanksLJ

Using VB2008 With Access To Import A FoxPro 2.6 Table? social.msdn.microsoft.com

As part of a larger application, I need to IMPORT (not link) a FoxPro 2.6 DBF into a Access DB.I toyed with using a Access MODULE and in the module, using the docmd.TransferDatabase method.I have looked for days at different samples and I cannot seem to find the answer.This application is intended to be distributed with NO ASSURANCE the user will have the FoxPro OLE driver installed. Knowing that the ODBC driver will most likely be installed as part of MDAC, it is pretty safe to use the ODBC driver that is already installed - Visual FoxPro Tables

Update Field visualbasic.ittoolbox.com

Hi All,does anybody know how to update a field in a FoxPro Database defined as DateTime out of a Visual basic environment??I tried to format '#dd.mm.yyy hh:mm:ss#' and 'ts {ts dd.mm.yyy hh:mm:ss}' but I always got an syntax error from the ODBC driver.Thanks a lotRainer

SQLAllocHandle www.sqlteam.com

I am getting an error while accessing sql server 2000 is that : Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed with regards,

FYI: ODBC And SQL Server: List Of Useful Articles From MS KB forums.databasejournal.com

INF: Differences in SQL Behavior Between ODBC and ISQL ArticleID: Q135533 INF: SQL Server 6.0 ODBC Driver Changes TempDB Usage ArticleID: Q135532 INF: Relationship of the ODBC Driver to INSTCAT.SQL ArticleID: Q137636 INF: Using Version 3.6 MS SQL Server ODBC Driver ArticleID: Q195927 PRB: Unexpected Errors (hmm, like some other errors are expected...?!) Using OLE DB Provider for SQL Server ArticleID: Q193339 INF: Reading ODBC SQL Server Driver Network Messages ArticleID: Q137 INF: ODBC SQL Server Connection Parameters ArticleID: Q137635 INF: Frequently Asked Questions About ODBC Connection Pooling ArticleID: Q169470

Databases :: Unable To Enter Apostrophe ( ' ) In The Textbox (Asp.net C#)? forums.asp.net

Im unable to enter apostrophe(') in the textbox as got error message as per below . How to solve this ? Pls help .thanks Server Error in '/' Application. ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Agriculture, forestry and fishing(cultivation of land or animals).',''','Mr','',' at line 1 Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.Odbc.OdbcException: ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Agriculture, forestry and fishing(cultivation of land or animals).',''','Mr','',' at line 1 Source Error: [Code].... Stack Trace: [Code]....

Generation_term : Syntax Trouble forums.databasejournal.com

Hi, i'm using the following query and it doesn't work Any idea ? TIA select top 300 i.itemkey, i.artist, i.title from items i with (nolock) join tontrarten t with (nolock) on (i.intlinknr3 & 147848 <>0) and i.configtype = t.tontrart where contains(' FORMSOF (INFLECTIONAL, halidai) ') The error : ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 5: Incorrect syntax near ' FORMSOF (INFLECTIONAL, halidai) '.

How To Create Second Record Set With Same Table visualbasic.ittoolbox.com

I created the record set using ODBC connectivity & taking Foxpro TableHow to solve the following problem. I want to use Foxpro as BackEndHow can I create the second record set with same tableEg.sql = "select * from nameadrs"rsHelp1.Source = sqlrsHelp1.openFirst time is working fine & gives required result,But suppose I define second record setsql = "select * from nameadrs"rsHelp1.Source = sqlrsHelp1.openerror no : -2147467259 it gives error as [Microsoft] [ODBC d Base Driver] The Database enginecould notlock the table 'nameadrs'. Because it is already used by another personor processBharat

Databases :: Does Command Parameter Work While Using Mysql As A ODBC Connection forums.asp.net

I have a problem whenever i run my code i get the following error ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.46-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' ('b'), ('Manager'), ('c'), ('d'), ('e')' at line 1 my code works with connector/net but my host does not have it installed so i've had to change my code to odbc which they do have, i have found out the syntax is different and changed my code accordingly my code is as follows [Code]....

Access Stored Procedure In ADO www.codeguru.com

Need Help to access Stored Procedure in ADO.I use ADO to connect to ODBC data source (OLE DB Provider for Visual Foxpro).Try to call a stored procedure in this data base but a Visual Basic raise an error.Please help me to solve this problem as well as help me call a stored procedure in Visual Foxpro database throught ODBC (use ADO)Thanks in advance.Cuong.

Receiving Error From The ODBC SQL Driver www.vbforums.com

I'm receiving this error from the ODBC SQL Driver as mentioned :- ERROR [07002] [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error. Here's my VB CODE: And this is the stored procedure i'm calling :- CODE:

Deadlocks forums.databasejournal.com

Ah yes, those dreaded deadlocks!! Well I've removed the clustered indexes, I've created non-clustered indexes, I've tried to streamline the code, but I'm still getting deadlocks. The worst thing about them is that I don't appear able to trap them at the client end. I'm using Visual Foxpro 6, and I get an ODBC error window with "Driver is probably out of resources..." and that's that. Are there any known methods of trapping these ODBC errors? TIA, Simon UK

Convert Data To Currency www.dbforums.com

I have a column - datatype 'money' and my price variable is (for instance) 8450 how do I put this value into the money column without getting this error? Microsoft OLE DB Provider for ODBC Drivers error '80040e07' [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type varchar to data type money, table 'db196009544.dbo196009544.vehicles', column 'price'. Use the CONVERT function to run this query. ASP VBScript I am using this syntax: price = Upload.Form("price") '---this gives 8450--- SQL="UPDATE vehicles SET price='" & price & "' WHERE id=" & request.queryString("linkID") & "" Thanks mark

A Failure Of DBCC CheckDB www.sqlteam.com

I got error after running DBCC checkDB, the error was: ----------- [10] Database MyDB: Check Data and Index Linkage... [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8921: [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKTABLE terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is corrupt. Check previous errors. [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object. [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in database 'MyDB'. [Microsoft][ODBC SQL Server Driver][SQL Server]repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (MyDB ). The following errors were found: [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKTABLE terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is corrupt. Check previous errors. [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object. [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in database 'MyDB'. [Microsoft][ODBC SQL Server Driver][SQL Server]repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (MyDB ). ** Execution Time: 1 hrs, 44 mins, 34 secs ** --------- Then after running DBCC CheckDB (MyDB, repair_fast), the error was: --------------- Server: Msg 8966, Level 16, State 2, Line 1 Could not read and latch page (1:1879304) with latch type SH. Latch failed. CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object. CHECKDB found 0 allocation errors and 1 consistency errors in database 'MyDB'. repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (MyDB, repair_fast). -------- If I run DBCC CheckTbale for each table, there is no error on those tables. Please help. Thanks. Linda

Visual Foxpro Driver 6.0 Needed While Installation visualbasic.ittoolbox.com

Hai,I developed an application using vb-frontend and foxpro 6 as backend. I created a package using packaging and depolyment wizard. Now i want to install this to vendors who has no foxpro driver installed.when i went to odbc Data source administrator there is no listing of visual foxpro driver.Just running my setup is enough for me(which has madc_type exe packed in it) or i have to install any foxpro driver for running my exe. Please help me out from this problem.

DTS - Updating Data forums.databasejournal.com

I know that using DTS I can export the contents of a table to an ODBC destination (Visual FoxPro in this case) but is it possible to then update the destination data ? The reason (greatly simplified) is that I have a table in SQL as follows : product C(16) option1 bit option2 bit and a table in visual foxpro as follows product C(16) option1 bit option2 bit option3 int option4 C(1) I need to maintain option3 and option4 in visual foxpro but update option1 and option2 from SQL.

Does Visual Foxpro ODBC Driver Support Select Into Clause? www.vbforums.com

Dim rdocon As rdoConnectionDim rdoqry As rdoQueryPrivate Sub Form_Load() Set rdocon = New rdoConnection rdocon.CursorDriver = rdUseOdbc strcon$ = "dsn=vfpdsn;uid=;pwd=" `vfpdsn is a DSN buid in odbc vfp driver 6.00.8428 rdocon.Connect = strcon rdocon.EstablishConnection Set rdoqry = rdocon.CreateQuery("aa", "select * into dbf c: emp.dbf from customer.dbf") rdoqry.ExecuteEnd SubThe program execute with no error message,but can not producetemp.dbf. Does not Visual Foxpro ODBC Driver (6.00.8440.00) support Select into Clause?

VB 6 And FoxPro Database Connection www.vbcity.com

I am trying to connect a vb 6 program to a FoxPro 6 .dbc.I am trying to connect it with Jet 3.51 OLE but, I keep gettingan error saying "Run-time error 'number(number)'[Microsoft][ODBC visual FoxPro Driver] Unrecognized comand verb"This is the code I am using:Dim oConn As ADODB.ConnectionDim adoRS As ADODB.RecordsetDim connString As StringSet oConn = New ADODB.ConnectionSet adoRS = New ADODB.RecordsetoConn.Open "Driver={Microsoft Visual FoxPro Driver};" & _                   "SourceType=DBC;" & _                   "SourceDB=C:Documents and SettingsAll UsersDesktopsoftware projectVisual Fox Pro DBF21 estdb1.dbc;" & _                   "Exclusive=No;"adoRS.Open "ClientInfo", oConnDo Until adoRS.EOFList1.AddItem adoRS!lastnameadoRS.MoveNextLoopadoRS.CloseoConn.CloseSet adoRS = NothingSet oConn = NothingI have tried many different ways to connect and all of them give me an error. I really need some help connecting thesetwo MS products. 

ODBC Error www.dbforums.com

Hi there Any one can help me !!!!! If i add the user in the database userid table, it indicates the error as follows (given user name is not added in the userid table due to this error) [Microsoft][ODBC SQL Server Driver][SQL Server] The updatelineage function requires 2 arguments [Microsoft][ODBC SQL Server Driver][SQL Server] GETMAXVERS is not recognized [Microsoft][ODBC SQL Server Driver][SQL Server] The updatelineage function requires 2 arguments [Microsoft][ODBC SQL Server Driver][SQL Server] GETMAXVERS is not recognized Thanks in advance by yasin

Unspecified Error While Attempting To Query Failed To Execute www.vbcity.com

Getting following error while attempting to show Oracle 8i CLOB object value (using Oracle ODBC 8i Driver) in Crystal report 9.0 at run time: "Crystal Report Error : Exception 'Unspecified error' while attempting to Query failed to execute - Check SQL syntax".But the same is working in oralce 9i database (using Oralce in OraHome driver) in Crystal report at runtime.Can any one of you, help me on how to get Oracle clob / blob value in Crystal Report using oracle database and oracle odbc driver?thanks in advance

Consistency Errors www.sqlteam.com

Hi all, long time reader, first time poster, budding dba passionate about SQL Server. I received the following Consistency errors: 4] Database IMM481_Nidderdale_Visitor: Check Data and Index Linkage... [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8970: [Microsoft][ODBC SQL Server Driver][SQL Server]Row error: Object ID 573245097, index ID 0, page ID (1:170), row ID 0. Column 'p_created_date' was created NOT NULL, but is NULL in the row. [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 573245097. The text, ntext, or image node at page (1:102), slot 1, text ID 1122172928 is not referenced. [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 573245097. The text, ntext, or image node at page (1:102), slot 2, text ID 1122238464 is not referenced. [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 3 consistency errors in table 'page_data' (object ID 573245097). [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 3 consistency errors in database 'IMM481_Nidderdale_Visitor'. [Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (IMM481_Nidderdale_Visitor ). The following errors were found: [Microsoft][ODBC SQL Server Driver][SQL Server]Row error: Object ID 573245097, index ID 0, page ID (1:170), row ID 0. Column 'p_created_date' was created NOT NULL, but is NULL in the row. [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 573245097. The text, ntext, or image node at page (1:102), slot 1, text ID 1122172928 is not referenced. [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 573245097. The text, ntext, or image node at page (1:102), slot 2, text ID 1122238464 is not referenced. [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 3 consistency errors in table 'page_data' (object ID 573245097). [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 3 consistency errors in database 'IMM481_Nidderdale_Visitor'. [Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (IMM481_Nidderdale_Visitor ). ** Execution Time: 0 hrs, 0 mins, 1 secs ** I'm trying to see the extent of the problem by running: Begin Tran TranStart DBCC CheckDB ('IMM481_Nidderdale_Visitor', Repair_Allow_Data_Loss) However, SQL Server is bitching about the db not being in Single User Mode. I've refreshed the process info to only find the sa using the db. What have I missed? Many thanks, Drew (You will get sick of this name)

Sudden Insert Error. www.sqlteam.com

I have an asp page that inserts several pieces of input into an SQL database. Page was working fine, and Im not sure what could have changed to cause the following error when data is entered into one of the fields: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'room'. /Global.asp, line 20 where global.asp line 20 is oConn.execute cSql In this case the text I input was: this room is big I also tried input of fdsa, and recieved the following error: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'fdsa'. /Global.asp, line 20 More Details: The field I am inserting this value into is a (nvarcar(1000),null). None of the other fields on the page have a problem, and this is the last value insert into the database. Any suggestions or ideas on where I should look to begin solving this issue. Thanks!

ODBC Error Message - HY001 System Resource Exceeded forums.asp.net

I have a page that was working but now I am getting the following errors. Server Error in '/' Application. ERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded. ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.Odbc.OdbcException: ERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded. ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [OdbcException (0x80131937): ERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded. ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute Extended Properties ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute HDR ERROR [01S00] [Microsoft][ODBC Text Driver]Invalid connection string attribute FMT ERROR [HY001] [Microsoft][ODBC Text Driver] System resource exceeded.] System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +35 System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) +131 System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +98 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.Odbc.OdbcConnection.Open() +37 DevSite_ImportStep1.btnUpload_Click(Object sender, EventArgs e) +219 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102 I am uploading a text file to a MS SQL 2000 database using an ODBC driver.  Here is the code:  <code> FileUpload1.SaveAs(fpath + "" + fn) litStep1.Visible = TrueDim FieldCount As Int16 Dim FileType As Int16Dim cmd As SqlCommand Dim dr As SqlDataReaderDim conn2 As OdbcConnection Dim dr2 As OdbcDataReader Dim cmd2 As OdbcCommand conn2 = New OdbcConnection("Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + fpath + ";Extended Properties='text;HDR=YES;FMT=Delimited'") conn2.ConnectionTimeout = 200 cmd2 = New OdbcCommand("Select top 5 * from [" + fn + "] ", conn2) cmd2.CommandType = CommandType.Text cmd2.CommandTimeout = 300 conn2.Open() dr2 = cmd2.ExecuteReader() FieldCount = dr2.FieldCount conn2.Close()   </code>  Before when this happened a reboot of the sql server resolved the problem.  That's not working this time and it's certainly not a practical solution.  Any suggestions?  

How To Delete The ODBC Drivers www.codeguru.com

Hi,I am facing problem with Foxpro Drivers. Actually I have to Use Foxpro2.6 Drivers. But In my system I am having Visual Foxpro Drivers. So when I am using data transfer from SQL Server to Foxpro, SQL Server is using Visual Foxpro Drivers and generating the DBF Files. These files I am not able to open in application developed in Foxpro 2.6. Somebody suggested me that if u delete visual Foxpro drivers then system will allow u to user Foxpro 2.6 drivers.(These are available in the system.). Now the question is how to delete the drivers ?? Can anybody suggest me in this regard ?If there is any otherway to do the same Please suggest me.Thanx in Advance Subbu

WinXP Run-time Error www.vbforums.com

I am using VB 6.0 as front end and Visual Foxpro as backend.I created a package through Installshield.I have included all the runtime files needed for a vb application in my package It installed on winXP successfully. But when i run my Programe it gives Error[microsoft][ODBC Driver Manager] Driver Does Not Support This Function.run-time error -2147467259when it tries to make connection with database. any body suggest a solution,its urgent.

Connecting To A Foxpro DB www.xtremevbtalk.com

I'm trying to connect to a Foxpro database file (.dbf) and I'm receiving the following error:"Run-time error '-2147467259(80004005)': [Microsoft][ODBC Driver Manager] Data source name not found and no default diriver specified"Here is the offending code: Code:Dim sConnString As StringSet dbConn = New ADODB.ConnectionsConnString = "ODBC;" & _"Driver={Microsoft Visual FoxPro Driver};" & _"SourceType=DBF;" & _"SourceDB=C:XMLes.dbf;" & _"Exclusive=No"MsgBox (sConnString)dbConn.Open sConnStringI also have my Foxpro DSN installed, but I'm not sure if it is configured correctly. Thanks for any help.

DTS Execution Error In SQL Server 2000..please Help Asap social.msdn.microsoft.com

� Hi, � when i execute a dts to copy one database from one server to another i am getting the following error: � [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB 'SQL OLEDB' reported an error.Authentication Failed. [Microsoft][ODBC SQL Server Driver][SQL Server]OLE/DB provider returned message: Invalid authorization specification] [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDB Initialize: Initiliaze returned 0x80040e4d: Authentication failed.]. � Please help me solve it.

Login Failing.... forums.databasejournal.com

this is the message that i'm getting and i dont know what to do so that i can access my SQL databases thru cold fusion: ODBC Error Code = 37000(Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. i didnt have any problems with this database until i moved it over to another SQL server and tried the cold fusion front end to it. i dont know what to do now.

Foxpro 2.6 Database www.vbcity.com

hi to all, hope u will be able to extend your expertise with this problem of minei hav this vb application wherein using a foxpro 2.6 database formatthus my ODBC dbase setup, database version used is dbase IVERROR:during UPDATING selected record a run time error would appear quoting; [Microsoft][ODBC dBase Driver]Operation must use an updateable queryduring DELETING selected record a run time error would appear quoting [Microsoft][ODBC dBase Driver]Could not delete from specified tablesplease help me .....

Connect To Ms Access Using Php? www.phpfreaks.com

ive already set the odbc in control panel for ms access driver but there is still an error: Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:wampwwwfirst projectmsaccess_conn.php on line 10 Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in C:wampwwwfirst projectmsaccess_conn.php on line 17 Error in SQL Code:

Newbie: Why Do I Have To Use OPENQUERY To A Linked Server? (ODBC To Firebird Database) social.msdn.microsoft.com

Hello, pls. let me know where I could post if this is the wrong place. I have a Firebird 1.5 application. I created a linked server from my SQL Server 2000 to the firebird database.�In SQL Server Query Analyzer I get errors from�various ODBC drivers with "normal" queryies like � SELECT LVNR FROM LINKEDSRV...LVVERW � Pls. note, this all works perfectly in MS Access databases with ODBC-Links to Firebird! � From a programmer of a commercial ODBC driver I heard that this problem may be caused internally by SQL Server, there may be no solution possible in the ODBC driver. One workaround would be to use the OPENQUERY-Syntax like � SELECT * FROM OPENQUERY(LINKEDSRV, 'select LVNR from LVVERW ') � Are there any other solutions? Are there any known issues with firebird odbc-drivers and sql server? Are there any known good drivers for the use with sql-server? What is the purpose of OPENQUERY - workaround ODBC problems? Are there any settings in SQL Server 2000 (2005 Express) that could help? Are there any settings in ODBC DSN that would help? regards arno PS: Here are my favorite error messages Error -2147217900 [OLE/DB provider returned message: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 89 "Col1014"] (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 01000) (NativeError: 7312)Error -2147217900 OLE DB-Fehlertrace [OLE/DB Provider 'MSDASQL' ICommandPrepare:repare returned 0x80004005: ]. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 01000) (NativeError: 7300)Error -2147217900 Der OLE DB-Provider 'MSDASQL' meldete einen Fehler. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 42000) (NativeError: 7399) This "tricky" query does not work: SELECT LVNR FROM LINKEDSRV...LVVERW; Error -2147217900 OLE DB-Fehlertrace [Non-interface error: Column 'ERHALTENABSCHLAG' (compile-time ordinal 35) of object 'LVVERW' was reported to have a DBTYPE of 5 at compile time and 131 at run time]. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 01000) (NativeError: 7300)Error -2147217900 Der OLE DB-Provider 'MSDASQL' hat inkonsistente Metadaten für eine Spalte übergeben. Die Metadateninformationen wurden zur Ausführungszeit geändert. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 42000) (NativeError: 7356)

Cannot Connect To Foxpro Database - HELP PLEASE!!! www.vbforums.com

PLEASE HELP!I am trying to connect to a foxpro database from VB.NET.Here is my code.VB Code:Dim connectionString = "DSN=VFPD;Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=\name_of_server_with_dta;Exclusive=No"        Dim connection As New OdbcConnection(connectionString)        Dim strSql = "select * from title where upper(titlenum)=testtitlenum"        Dim adapter As New OdbcDataAdapter        adapter.SelectCommand = New OdbcCommand(strSql, connection)        Dim result As New DataSet        adapter.Fill(result) Here is the error i am getting.. and the line its breaking out on is adapter.fill.ERROR [42S02] [Microsoft][ODBC Visual FoxPro Driver]File 'title.dbf' does not exist.PLEASE CAN ANYONE HELP ME WITH THIS ITS GETTING QUITE URGENT.one interesting thing to note is when i moved the data to my local machine it worked... any ideas...

SQL Advice www.sqlteam.com

I tried to run a SQL script and i get the following message quote:Error Message = Native SQL Error Code [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ''. SELECT name, id, description FROM products WHERE id=4INSERT INTO ''admin_login'' (''login_id'', ''login_name'', ''password'', ''details'') VALUES (252,''neo2'',''newpas5'',''NA'')-- Error Code : 350 F:InetpubParexeldefault.ihtml iSQL dbname="Parexel" ALIAS="prod" SQL="SELECT name, id, description FROM products WHERE id=4INSERT INTO 'admin_login' ('login_id', 'login_name', 'password', 'details') VALUES (252,'neo2','newpas5','NA')--" [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ''.SELECT name, id, description FROM products WHERE id=4INSERT INTO ''admin_login'' (''login_id'', ''login_name'', ''password'', ''details'') VALUES (252,''neo2'',''newpas5'',''NA'')-- Im new to SQL and i dont know what im doing Also what does this mean quote:iSQL dbname="admin" ALIAS="prod" SQL="SELECT name, id, description What do SQL databases do and what would i need to do to enter data in to SQL such as a email address or cant that be done? I think dbname is the database name ALIAS is that the table name? im just trying to enter data in to my database database and i have no clue what im doing. Iv read guides online but i get the above error 350 D

Cannot Connect To Foxpro Database - HELP PLEASE!!! www.dbforums.com

PLEASE HELP! I am trying to connect to a foxpro database from VB.NET. Here is my code. Dim connectionString = "DSN=VFPD;Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=\name_of_server_w ith_dta;Exclusive=No" Dim connection As New OdbcConnection(connectionString) Dim strSql = "select * from title where upper(titlenum)=testtitlenum" Dim adapter As New OdbcDataAdapter adapter.SelectCommand = New OdbcCommand(strSql, connection) Dim result As New DataSet adapter.Fill(result) Here is the error i am getting.. and the line its breaking out on is adapter.fill. ERROR [42S02] [Microsoft][ODBC Visual FoxPro Driver]File 'title.dbf' does not exist. PLEASE CAN ANYONE HELP ME WITH THIS ITS GETTING QUITE URGENT. one interesting thing to note is when i moved the data to my local machine it worked... any ideas...

ASP Script Update Date Error, Please Help social.msdn.microsoft.com

Datebase user_id���������� int(4) user_name���� varchar(20) rec_date������� datetime � code <% c_user_id = trim(request("user_id")) c_user_name = trim(request("user_name")) c_rec_date = now() Set rs = Server.CreateObject("ADODB.Recordset") � sql = "update ABC.dbo.member set user_name = '"& c_user_name &"', rec_date = #"& c_rec_date &"#� where user_id='"& c_user_id &"'" � conn.Execute sql conn.close set rsinsert=nothing %> � error : � 錯誤類型: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '上�?�'.

ODBC VB Throwing Syntax Error stackoverflow.com

I cant see what is wrong with my SQL statement syntax [code]... ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.41]You have an error in your SQL syntax;check the manual that corresponds to your MySQL server version for the right syntax to use near 'Int,Agi,Money) VALUES('MyUsername','MyPassword',0,0,0,0)' at line 1

Php - Which Odbc Connector To Use? stackoverflow.com

I am getting this error from the following code: $result = odbc_connect("DRIVER={MySQL ODBC 3.51 Driver};Server=localhost;Database=$database_name",$database_username, $database_password); Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in /dbconnect.php on line xx odbc not connected I am using MySQL version 5.1.41-3ubuntu12.3 My phpinfo gives the following output: Additional .ini files parsed /etc/php5/apache2/conf.d/odbc.ini, /etc/php5/apache2/conf.d/pdo_odbc.ini odbc ODBC Support enabled <br>

Package Fails When I Use ODBC Connection (Fails On SQL Server Agent, OK In Visual Studio) social.msdn.microsoft.com

I did a small package with�only one ODBC connection (Merant 3.70 32-Bit Progess).��This package runs well in Visual Studio and fails when�runs by SQL Server Agent. Configuration: SQL Server Agent on a 32Bit server.� The ODBC connection configuration in available on System DSN on this server. The user of Server Agent have full access (Admin). Connect Manager Provider: ".Net ProvidersOdbc Data Provider" SQL Server version: 9.0.3042 � Error Message: Executed as user: TEKCON cadmin. ...ion 9.00.3042.00 for 32-bit� Copyright (C) Microsoft Corp 1984-2005. All rights reserved.��� Started:� 16:50:33� Error: 2007-06-11 16:50:33.62���� Code: 0xC0047062���� Source: Data Flow Task DataReader Source [1]���� Description: System.Data.Odbc.OdbcException: ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented.� ERROR [HY000] [MERANT][ODBC PROGRESS driver]msgOpen: unable to open message file: PROMSGS� ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed.� ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented.� ERROR [HY000] [MERANT][ODBC PROGRESS driver]msgOpen: unable to open message file: PROMSGS� ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed.���� at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)���� at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcCon...� The package execution fa...� The step failed. I created a .bat file with this instruction and It's run well: dtexec /f "C:Program FilesMicrosoft SQL Server90DTSPackagesIntegration Services Project estcom.dtsx" pause Why it's not running with SQL Server�Agent???

Error 4002 'odbc Sql Server Driver' www.vbforums.com

ERROR 4002 ODBC SQL SERVER DRIVER SQL CHANGED DATA BASE CONTENT 'RM97' I get this error and I don't know why?How do I fix this?Mike

Visual FoxPro6 And VB Still Doesn't Work - "The Data Provider Or Other Service Returned An E_FAIL St www.codeguru.com

Can anyone tell me why I am getting this error message when trying to connect to a particular Visual Fox Pro 6 table? I only encounter errors when using this table and its associated form. I tried creating a new form, new ADO controls, etc. which worked until until I tried to bind the text boxes to the fields in the database. Should I try re-building the table in FoxPro? Has anyone ever received this message? I am not using Jet as the ODBC driver, I am using Visual FoxPro 6 ODBC driver-is that the problem? If so, why do my other tables and forms work within the same database container...HELP, PLEASE!!

Help-opening Ado From Asp Page forums.databasejournal.com

hi friends, When i connnect sql-server from visual interdev the connection is geting established,but when i tried to open the recordset, i am geting the following error "Microsoft OLE DB Provider for ODBC Drivers error '80040e21' " "The request properties can not be supported by this ODBC Driver " i will be grateful to u if u can help me in this regards ASAP. REGARDS RAJESH, CODE ------ <%@ Language=VBScript %> <% uid=Request.Form("usr") pwd=Request.Form("pwd") const adOpenKeyset = 1 set cn=CreateObject("ADODB.Connection") set rs=CreateObject("ADODB.RecordSet") cn.Open "golmal" str = "SELECT user_id,password from user_details where user_id='uid' and password='pwd'" rs.open str,cn,adOpenKeyset '-------Error line Response.Write "recordset opened" cn.close

Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server] forums.asp.net

Hi Everybody, On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help. Thanks, Arif Server Error in '/' Application. -------------------------------------------------------------------------------- ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.] Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) +27 Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +838 Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery() +80 Calgary.venues.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootCalgarySitevenuesvenues.aspx.vb:32 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +731

Programmatically Create DSN For VFPfree-table Dir www.eggheadcafe.com

Greetings!I am creating an ODBC DSN for Microsoft FoxPro VFP Driver (*.dbf) using Functions RegCreateKey Lib "advapi32.dll" Alias "RegCreateKeyA" andRegSetValueEx Lib "advapi32.dll" Alias "RegSetValueExA" with the following arguments: DataSourceName = strNameDescription = strDescDriverPath = "C:WINNTSYSTEM32"DatabaseName = ""LastUser = ""Server = ""DriverName = "Microsoft FoxPro VFP Driver (*.dbf)"The problem is: it creates a DSN with a database type of Visual FoxPro Dababase(.DBC) while what I need is a Free Table directory. I do not have a database and server, but I do need to somehow pass the info that it is Free Table directory and Path to it. Any ideas?TIA!

SQL Connection Instructions Between SQL 2005 Express And FoxPro Database social.msdn.microsoft.com

I want to create a function that copies tables from a Visual FoxPro database to�a SQL 2005 Express database.� I first need to establish a SQL connection from SQL 2005 Express to the Visual FoxPro database.� Is there a simple set of commands to do this?� I have created ODBC connections to both from a 3rd part app, but not between the two. � Thanks, Tim

Can't Connect To SQL Server Via ODBC bytes.com

I just installed PHP 5.1.4 with SQL Server 2005 on my laptop. PHP is running fine and so is SQL Server 2005. When I try to connect to SQL Server from my my PHP code I get this error. Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:Inetpubwwwrootindex.php on line 5 Here's my connection string that is causing the error $connect_id = odbc_connect("Driver={SQL Server};Server=mydbname;Database=myDB","myUser", "myPass");

Databases :: Function Name Missing (Error S1000) forums.asp.net

I am continuously getting error for following line of code. It work fine in other Database. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver] Function name is missing. Am I doing any mistake [Code]....

Proper Syntax For Adding Object Name Owned By Domain User forums.devshed.com

I am receiving an error based on my query that is giving me the following error: Code: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Config'. I'm assuming that this is because the table was not made by dbo, but my domain account. The query is currently defined as: Code: SQL = "SELECT * FROM Config" but I'm assuming it needs to be defined with the syntax of ownername.objectname. My problem is when I change the string to this: Code: SQL = "SELECT * FROM sanm.APHinzeE.Config" I get this error: Code: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ''. I tried to escape the slash using / but then I get the error on that. How do I specify my account name with the slash?

Can&#39;t Add Index, Too Many Statistical Indexes? forums.databasejournal.com

I was trying to add an index to a heavily used table which has one other index. When I did I recieve the following error message Unable to create index 'IX_PATIENT__1'. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create more than 249 nonclustered indices or column statistics on one table. [Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint. See previous errors. Do I need to wack the statistical

Connection Failed: www.dbforums.com

Hi Guys, I encountered an error while opening my third SQL Connection in Enterprise Manager --------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '01000' SQL Server Error: 232 [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionWrite (WrapperWrite()). Connection failed: SQLState: '08S01' SQL Server Error: 11 [Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation. --------------------------- OK --------------------------- I am using the following SQL Server 2000 Enterprise Edition (SP4) Windows 2000 Professional (SP4) first two connections are with Query Analyzer, the third attempt is when opening a table inside Enterprise Manager anyone experienced this?

Can't Connect To SQL Server 2005 Express social.msdn.microsoft.com

PLEASE HELP ME�� � I ran the upsize wizard on one of my databases to SQL Server 2005 Express.� I can connect to it just fine.� I have 3 test users and they cannot.� They get the following: Connection failed: SQL State:� '01000' SQL Server Error:� 11004 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connt()). Connection failed: SQL State:� '08001' SQL Server Error:� 6 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found. � I tried adding the SQL Server to 1 users System DSN, but I got this message: Connection failed: SQL State:� '01000' SQL Server Error:� 53 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connt()). Connection failed: SQL State:� '08001' SQL Server Error:� 17 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. � What am I doing wrong??? �

ODBC_connect And SQL Error MSG phpbuilder.com

I am trying to connect to a SQL db and I am receiving the following error msg: Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:WINDOWSTempIW718E.tmp on line 5 I have created an ODBC and tested it and it does connect. Here is my code: <?php $sqlconnect="DRIVER={SQL Server};SERVER=xxx;DATABASE=yyy"; $DB_User=""; $DB_Passwd="";.....

DTS Import Works Directly, Fails When Scheduled www.dbforums.com

I'm new to DTS packages, but managed to create one that successfully empties a table in SQL Server then imports data from a Foxpro file on another server into it. It runs fine if I execute it from DTS, but fails if I schedule it to run in SQL Server Agent (using the "Schedule Package" option in DTS). I think the relevant portion of the error returned when the job fails is: Error string: [Microsoft][ODBC Visual FoxPro Driver]File 'hrpersnl.dbf' does not exist. The file does exist. I also tried to execute it from a stored procedure, but got a similar error. Any thoughts on why it runs one way but not the other? TIA

Using Linked Server With Visual FoxPro forums.databasejournal.com

I have a Foxpro database that I have successfully setup as a linked server. I can run select statements and have data returned but what I really need to do is an insert to the table. When I try running the following statement I get an error. Could some explain to me how to get this to work? SELECT * FROM OPENQUERY(ARISTO, 'INSERT INTO StopOrd VALUES ; ("03261", "ST", "CV", "Testing", "C")') Server: Msg 7321, Level 16, State 2, Line 1 An error occurred while preparing a query for execution against OLE DB provider 'MSDASQL'. [OLE/DB provider returned message: [Microsoft][ODBC Visual FoxPro Driver]Syntax error.]

Plesk 11.x / Windows :: Cannot Create New Customers - ODBC Error forum.odin.com

I suddenly started to get the following error Windows 2008 server 64 bits 24 gigs ram sql express php plesk 11.5.30 latest update passed the latest self test with no problem Internal error: ODBC error #42S02: [MySQL][ODBC 3.51 Driver][mysqld-5.5.31]Table 'apsc.aps_package' doesn't existODBC error #42S02: Message ODBC error #42S02: [MySQL][ODBC 3.51 Driver][mysqld-5.5.31]Table 'apsc.aps_package' doesn't existODBC error #42S02: File aps_php.php Line 11933 Type Exception Go To Previous Page

Import FoxPro Table Using A Macro - Version: 2000 (9.0) www.utteraccess.com

I am trying to import a FoxPro table on the network into my local database. This needs to be a macro as I want it to be a run command option. The ultimate plan is to copy the db from the network to my hard drive and import this table on startup. According to Access help, I need to put the ODBC connection in for the database name. I have entered: ODBC;DSN=Visual FoxPro Tables;SourceDB=K:LT;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;; I copied this from a table that is linked to this database, and changed the directory name. I put the name of the table in the Source. When I run the macro, I get ODBC call failed. Microsoft ODBC Visual FoxPro Driver Driver not capable #0. Any ideas what I did wrong or what I should do now? thanks Helena

Bcp Failed When Special Characters {;&&" Were Used In The Password From Command Line In Win 2003 social.msdn.microsoft.com

bcp worked with password in normal characters, but failed with {;" I tried for SQL 2005 and SQL 2000, from Window 2003 SP1. Is this a bug? � When the special character { was used in the password, bcp failed with Native error 0. >> F:ftplogCases>bcp "sem5.sem5.server_system_log_1" in server_system_log_1.dat -n -Smodonald -Usem5 -P{ SQLState = 08001, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Neither DSN nor SERVER keyword supplied SQLState = 01S00, NativeError = 0 Warning = [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute >> � When the special character�; or�"�was used in the password, bcp failed with Native error 18456. >> F:ftplogCases>bcp "sem5.sem5.server_system_log_1" in server_system_log_1.dat -n -Smodonald -Usem5 -P; SQLState = 28000, NativeError = 18456 Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sem5'. F:ftplogCases>bcp "sem5.sem5.server_system_log_1" in server_system_log_1.dat -n -Smodonald -Usem5 -P" SQLState = 28000, NativeError = 18456 Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sem5'. >>

Advanced Editor For DataReader Source / SQLServer 2005 social.msdn.microsoft.com

I want to import data from a remote MySql Database � So, I created an New Connection (ADO.Net), connection Test is successful but when I try to set the sql string in the advanced editor i get the following error: � Error at Data Flow Task [DataReader Source [2182]]: System.Data.Odbc.OdbcExeption: ERROR [HY010][MySQL][ODBC 3.51 Driver][mysqld-4.1.10a] ERROR [HY010][MySQL][ODBC 3.51 Driver][mysqld-4.1.10a] ERROR [HY010][MySQL][ODBC 3.51 Driver][mysqld-4.1.10a] ERROR [HY010][MySQL][ODBC 3.51 Driver][mysqld-4.1.10a] ...... �bei System.Data.Odbc.OdbcDataReader.NextResult(Boolean.disposing, Boolean allresults) �bei System.Data.Odbc.OdbcDataReader.Close(Boolean Disposing) �bei System.Data.Odbc.OdbcDataReader.Close() �bei Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.ReinitializeMetaData() �bei Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.ReinitializeMetaData(IDTSManagedComponentWrapper90 wrapper) �the sql string is very simple, this should not be the problem: SELECT Objektnr FROM� m02a_tblObjektstamm � Thank you very much for your support Martin �

DTS Error When Copying Objects www.dbforums.com

I am getting the following error when executing a Copy SQL Server Objects Task. If it helps these objects are User Defined functions and also this had worked in the past it is only after changing the destination server to one that is offsite, has a different OS then the source and also runs as a DC. We are running SQL 2000 Server Standard with Spk 3a on both boxes. Step 'DTSStep_DTSTransferObjectsTask_6' failed Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 42S02) Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.GetRightsAbbreviations'. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.GetRights'. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.GetTerritoryAbbreviations'. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.GetTerritories'. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.GetShow'. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.GetTvEpisodes'. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.GetTvSegments'. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.GetTvSegmentsString'. Step Error code: 800400D0 Step Error Help File:SQLDMO80.hlp Step Error Help Context ID:1131

SQL - Unable To Load Communication Module www.sqlteam.com

Dear All, I am facing one problem on my SQL server 2000. While accessing some records from the database I am getting this error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver]Unable to load communication module. Driver has not been correctly installed. I am using ODBC connection with sql authentication How to solve this issue. with regards Shaji

Got Microsoft OLE DB Provider For ODBC Drivers Error '80004005' When Running Stored Procedures social.msdn.microsoft.com

when i am running a Stored Procedures, system always returns me error message below and Stored Procedures stops. please help Microsoft OLE DB Provider for ODBC Drivers error '80004005'� [Microsoft][ODBC SQL Server Driver] Received an unrecognized datatype 0 from TDS data stream � � sometime it returns error messge like, TDS Buffer Length Too Large or Unknown token received from SQL Server� or� Protocol error in TDS stream � or� Bad token from SQL Server: Datastream processing out of sync. � or� Invalid cursor state � or� TDS Buffer Link Too Large� or� Function sequence error Many thanks, Please help, appreciated

ODBC SQL Server Driver www.vbforums.com

I have an application that I have created. It works fine from my computer, a server, and a laptop. However, when I install it on another server I get this error "[Microsoft][ODBC SQL Server Driver]Syntax error or access violation -2147217900"I don't really think that it is a syntax error because of all the other locations it is installed. Has anyone ever had this problem. Do you know how to fix it or where I should look?Thanks

Error ODBC Sql Server Driver - Timesout Expired www.vbcity.com

Hi everyoneI am facing this error while try to run my VB program.error ODBC sql server Driver - Timesout expiredPlease help me outWaiting for reply.Best regards,ASIF

Insert Query - Executing On Phpmyadmin ? stackoverflow.com

What's wrong with my code, the query seems to be fine, I tried executing it on phpmyadmin. CODE: I got this error: ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.36-community-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

SHAPE Command Chokes SQL Engine forums.databasejournal.com

I'm trying to run this parent/child sql SHAPE command against SQL Server 7 thru query analyzer but I'm getting an error: [Microsoft][ODBC SQL Server Driver]Syntax error or access violation The query is: SHAPE {SELECT BillNum, Sponsor, Title, CommitteeDate, OriginalCommittee FROM Bill} AS rsBill APPEND ({SELECT BillNum, Requester FROM Requests} RELATE BillNum TO BillNum ) AS rsRequests Can anyone help? I tried it with dbo. in front of each field but it gave me the same error. Thanks in advance.

DBCC CHKDB Error - Error 8964 www.sqlteam.com

I got a error message with SQL 2000 SP3. I do not know this is a bug or table is real corrupted. need help with this one. (1) DBCC CHKDB output: Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'TAMVSQLNYUNYU' as 'NYUMC amnyuclustadmin' (trusted) Starting maintenance of database 'PowerPath_NYU' on 9/6/2005 4:20:03 AM [1] Database PowerPath_NYU: Check Data and Index Linkage... [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8964: [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 405628538. The text, ntext, or image node at page (1:1001056), slot 10, text ID 1595707686912 is not referenced. [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in table 'audit_record' (object ID 405628538). [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in database 'PowerPath_NYU'. [Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PowerPath_NYU ). The following errors were found: [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 405628538. The text, ntext, or image node at page (1:1001056), slot 10, text ID 1595707686912 is not referenced. [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in table 'audit_record' (object ID 405628538). [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in database 'PowerPath_NYU'. [Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PowerPath_NYU ). ** Execution Time: 0 hrs, 2 mins, 20 secs ** [2] Database PowerPath_NYU: Check Data and Index Allocation... WARNING: Database PowerPath_NYU is currently being used by 36 user(s). This may cause spurious problems to be reported. ** Execution Time: 0 hrs, 0 mins, 1 secs ** [3] Database PowerPath_NYU: Check System Data... ** Execution Time: 0 hrs, 0 mins, 3 secs ** Deleting old text reports... 1 file(s) deleted. End of maintenance for database 'PowerPath_NYU' on 9/6/2005 4:22:27 AM SQLMAINT.EXE Process Exit Code: 1 (Failed) I also run DBCC CHKTABLE and follwoing is the output. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 405628538. The text, ntext, or image node at page (1:1001056), slot 10, text ID 1595707686912 is not referenced. DBCC results for 'audit_record'. There are 1958345 rows in 42549 pages for object 'audit_record'. CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'audit_record' (object ID 405628538). repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (PowerPath_NYU.dbo.audit_record ). Thanks, KT