-2147467259 [MySQL][ODBC 5.1 Driver]Optional feature not implemented

Thanks in Advance "-2147467259 [MySQL][ODBC 5.1 Driver]Optional feature not implemented" I am getting the Above error while try to save a image in mysql5.0 from vb 6.0 Plz help me how to reslove this issue. ...

the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction. [MySQL][ODBC 3.51 Driver]Optional feature not supported]

when i try to insert row into mysql 5.1.29 from a trigger which is written in ms sql server 2000 it states that... " The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction. [OLE/DB provider returned message: [MySQL][ODBC 3.51 Dri ...

Oracle ODBC connection throwing "Optional feature not implemented" error

I have been trying to get my TIBCO Active DataBase (ADB) adapter to connect properly to my Oracle XE database. I have tried various drivers (Oracle 10g, 11g and TIBCO/DataDirect 5.3) drivers. After some effort it is now connecting but when it runs the required select query it throws an error. WHat i ...

Optional feature Not Implemented Problem

I am using PowerBuilder version is 8.0 to connect to Access Database.Version of Access is Office 97 Access To get some data when I use cursor in my code, and try to fetch datafrom database, it is giving me error :"SQLSTATE = S1C00[Microsoft][ODBC Microsoft Access Driver]Optional featurenot impl ...

Optional feature not implemented???

I'm using MS Access 2000 and Visual C++ 6.0 with MFC (dialog based) to create an program which reads and writes to a Database.At every SELECT statement I execute, I get the following "error":Optional feature not implemented State:S1C00,Native:106,Origin:[Microsoft][ODBC Microsoft Access Dr ...

Rational Product Updater - Optional Feature - Update Portal Test Env 5101 Fails

When I attempt to install this feature I get the following exception. Unable to complete action for feature "Update Portal Test Env 5101" due to errors. Unable to complete action for feature "5100 UTE Verifier" due to errors. Command failed: "C:\Program Files\IBM\Rational\SDP\6.0\updater\workspace\p ...

Query issues - ODBC Microsoft Access Driver error

I have some issues with the execution of an ordinary query over MS Access database table. On my machine I installed Access 2007 and my database Access format is 2002 to 2003 is compatible mode.My connection string is: Driver={Microsoft Access Driver (*.mdb)}; DBQ=D:\\myAppPath\\myDatabase.mdb.I conn ...

Oracle RDB Odbc drivers and Visual Express 2005 !!!

i'm having troubles with MS Web Developper Express 2005 and RDB database ODBC driver 3102.When i try to declare a link to a dsn previously delared in ODBC manager (win xp sp2), i click the "test connection" then it's succesfull, but when i want to browse thru the tables within the rdb db, i receive ...

SSIS Package Issue (Odbc driver)

I am hoping someone has a good idea on how to solve this issue. I am out of ideas. I did a search. But I have no luck.I am currently using Sql server 2005. It is running on Windows 2008 server.I am using odbc driver to connect to Progress database. The driver name is Merant 3.60 32 bit process sql92 ...

ODBC 3.51 Driver with Visual CE(www.syware.com) application development

I am developing pocket pc application using Visual CE (www.syware.com) I am using MySql as database and connecting to MySql using Mysql ODBC driver 3.51. However when I try to synchronize database on my server from pocket pc using mEnable,i get following error. [MySql][ODBC 3.51 Driver][mysqld-4.1.2 ...

ODBC Error with transactions

When I use transactions with the Odbc 3.51 driver in c# code I receive the following error. System.Data.Odbc.OdbcException: ERROR[HYC00][MySql][ODBC 3.51 Driver]Optional feature not supported. Stack trace at System.Data.Odbc.OdbcConnection.Open_EnlistTransaction(Transaction transaction) At an other ...

MySQL ODBC driver 3.51.9 incompatible with mEnable

I'm developing an application on a Pocket PC (PPC) running Windows CE 3.0 using a product called mEnable. The product mEnable allows portable devices to send/receive SQL transactions. I'm having no problems using MS Access and MS SQL drivers on the PPC. When I switch to MySQL using the latest ODBC d ...

ODBC connection error to InterBase DB

I have an ODBC connection to a remote Interbase DB that works without any problems from one C# ASP.NET application but errors out on another PC. Both PCs are set up with the same version of Visual Studio 2002 and have the same INTERSOLV InterBase ODBC Diver System DSN set up. When I run the code I g ...

Odbc problem

I have recently been creating a website using SQL Server 2005 Express...however the person who I am making the site for is restricted by cost and so I am having to convert to ODBC which is substantially cheaper (for web hosting).I have created the ODBC database using Access, however am experiencing ...

ORACLE ODBC DRIVER

I am trying to connect using Oracle ODBC Drivers (10.01.x and 10.02.x) to Oracle ebusiness suite ( Oracle database 10gR1).I am geeting the following error in the ODBC log:[ORACLE] [ODBC] Optional feature not implemented.Could you please help to resolve this issue. ...

Ubuntu ODBC Error, Mozilla, postgresql

I had the following Error, when I started a internal website, where I had to work with. I could fix this with the installation of "odbc-postgresql".-------------------------------------------Error Diagnostic InformationODBC Error Code = S1C00 (Driver not capable)[MERANT][ODBC Oracle 8 driv ...

ODBC Microsoft Access Driver Problem

I want to specify a array parameter with following function: retcode = SQLSetStmtAttr(hstmt, SQL_ATTR_PARAMSET_SIZE, (SQLPOINTER)ARRAY_SIZE, SQL_IS_INTEGER); But I got Error: SqlState = S1C00 [Microsoft][ODBC Microsoft Access Driver]Optional Feature not implemented. Someone know what's that meen..I ...

ODBC Drivers not capable? Huh?

I'm a little confused as to what's going on here, as I've had no problems on the SELECT queries I've had, and I know that the tables are set in such a way that there's no denial of permissions...I'm trying to perform a write to a specific SQL database table (Through SQL Server 2K) using a ColdFusion ...

Soda Integration Feature in RSA

i 've installed RSA 6.0 then used the Updater to have the latest version installed.But l couldn't find the feature Soda Integration in the list of optional Feature.( even from the 6.0 instal)does someone has an idea why?thanx ...

Is curly brace syntax and OPTIONAL realy enabled in Oracle 11g? (11.1.0.7)

I have just installed Oracle 11g patchset to upgrade from 11.1.0.6 to 11.1.0.7.Oracle documentation states, that since 11.1.0.7 Curly brace syntax is allowed (http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28397/sdo_rdf_concepts.htm#CIHHDGDI).When I try to execute following SQL on sample f ...

Ubuntu Someone should develop a feature that...

Would make the mouse pointer disappear when the computer senses you are typing. i.e. when hitting letter keys continuously, and not special keys such as alt, which might use the pointer simultaneously. To be an optional feature, of course. This can do wonders for laptop users and put linux ahead of ...

Ubuntu Dangerous rhythbox feature makes it a bad choice as default software.

Two things happened this weekend that worry me.#1 - "Move to Trash" in rhythmbox is to easy to do. It's in a right click menu that is easily clicked accidently (Guilty - My Entire Music Library)It doesn't prompt you with a warning you. (No other sane music player does this without a chance ...

Need help connecting to Informix db from win2k

I’m running around in circles trying to figure this one out. I’ve never connected to an Informix DB and am using a 3rd party vendor’s code. The connection fails when trying to open it using a system DSN:23> SET CN = Server.CreateObject("ADODB.Connection")24> CN.ConnectionString= ...

informix error 11004

I believe I pick up a virus a couple of days ago, now when I try to access my Factor database (AIX 4.3.3) through Microsoft Access I receive this error message.[INTERSOLV][ODBC Informix driver] Drivers SQL SetComectAttr failed. [INTERSOLV][ODBC Informix driver] Optional feature not implemented. [INT ...

CRecordset class

HiI am developing an application in VC++6.0. Database is MS Access.On my debugging window a warning message is always appear.Optional feature is not implemented.State:S1C00,native:106,Origin:[Microsoft][ODBC Microsoft Access Driver]Actually my application collects real time data from serial port and ...

Problem adding records to Excel data table

I am trying to use a C++6 MFC program to add records to an Excel data table. There are three fields in each record - one numeric, one text, and one date. When I attempt to add a new record, I receive the message "Optional feature not implemented". The debug information is:Error failure upd ...

Why doesnt my open CRecordset object process update commands ?

I have an MSAccess database DBX1.MDB with a table, 'Customer'.I am able to open the database using the proper connection string which is the CString csConnect and the CDatabase object m_db:m_db.OpenEx(csConnect); I can verify that the database is opened:if(m_db.IsOpen()) TRACE0("database is ope ...

Inserting, Updating, Deleting Data from MS SQL 2005 to MySQL

I am really struggling here, I have read numerous pages on this subject but nothing that ever really solves it.I have an MS SQL 2005 Express database that I want to sync the data from a few tables into a MySQL database with the identical tables and coloumns (created using mssql2mysql).I have downloa ...

SeeBeyond Oracle Problem on Unix

We're trying to connect to an Oracle Database via an ODBC connection in SeeBeyond e*Gate.In Windows it works perfectly, but in Unix we receive the following errors :10:48:51.113 COL I 7 (java_extensions.cxx:1366): StackTrace: com.stc.common.collabService.CollabConnException: Fail to openconnection; ...

Recordset read-only for unicode application.

Hi, I guess someone here may have similar problem before. I'm using VS.NET 2002 and MDAC 2.8. Previously I was using ODBC driver and writting data to access database. Everything worked just fine under MBCS (Multi-Byte Character set) build. class CTestRecordset : public CRecordset // derived from CRe ...

Recordset read-only problem.

Hi, Previously I was using ODBC driver and sending data to MS Access database. Everything seems work fine. Now I want to use SQL Server instead of Access but always get this "Recordset read-only" problem and could not figure out. I'm using the free SQL Server 2000 Desktop Engine installed ...

FileMaker Pro - MySQL Migration Toolkit

I am attempting to utilize the Migration Toolkit on a FileMaker Pro 8.5 database using DataDirect JDBC driver to connect to the FileMaker Pro database. After configuring the source and targets, I receive the following stack trace. Does anyone know if this means that the database does not support the ...

storing latin extended characters

How can I store "latin extended A" characters in Sybase???I am trying to store 'latin extended A' characters in a Sybase ASE 12.5.1 database.The database is updated through an Access 2000 front end editing tool which can handle the extended latin character set.Access connects to Sybase thr ...

Microsoft SQL Server Unable to begin a distributed transaction

Synchronize data between two Windows 2003 servers. MS/Server 2003 Database --> MySql Database in MS/Server 2003. I have successfully created a linked server connection [TT-DEV] to a remote Windows server 2003 running MySql using MySql ODBC drivers 3.51 and 5.1 with SSL certificates applied via a ...

Using a datetime parameter with a stored procedure (VC++)

bool CLogBuilderDlg::OpenResultSet( _ConnectionPtr connection, _RecordsetPtr recordset, COleDateTime start_date) {_CommandPtr objCmd = NULL;objCmd.CreateInstance(__uuidof(Command));_variant_t date;date = start_date;date.vt = VT_DATE;try{objCmd->ActiveConnection = connection;objCmd->CommandText ...

How to handle Transactions in Paradox database?

I am quite new to Paradox database. I am trying to handle database operations like insert and delete as a transaction using C#. But I am getting an exception saying "ERROR [HYC00] [Microsoft][ODBC Paradox Driver]Optional feature not implemented". So I am wondering whether Paradox supports ...

show a data report with condition

I made data report with condition. I want to input a student id number in a text box and press a button to show all data of this student, but a problem when i input a number in the text box (and press the button) for show the report a msg show.Run time error 2147217887(80040e21)[micorsoft][ODBC micr ...

problem with many parameters from vba in excel

I'm trying to pass many input parameters to a SqlServer SP from Ado in VBA for Excel. When i'm passing only first paramener everything's ok but while trying to pass two parameters i always get mesage:Run - time error '2147217887' (80040e21)':[Microsoft][ODBC SQL DRIVER] Optional feature not implemen ...

CQWeb DB2 connection Issue (DB2_SECURE_LOGIN)

I am performing at test upgrade of ClearQuest 2003.06.15 to 7.0.1 and I have been having a few problems since we are using server_encrypt on our DB2 server. Some of my earlier issues:http://www.ibm.com/developerworks/forums/thread.jspa?threadID=234542&tstart=0I have the ClearQuest windows client ...

CRecordset-derived object is Readonly one minute, but Writeable the next...?

I have a somewhat interesting problem. At any given time, I will create a CRecordset-derived object, and open the database with one the following calls (I have tried them both):rsObject.Open( CRecordset::dynaset, NULL, CRecordset::appendOnly );-And-rsObject.Open()(The default recordset type is ...

Connecting to a database through ISAPI/ASP

I have a problem I hope someone knows the answer to. I have a Interbase database I want to connect to by using ODBC. I created an ISAPI extention and it won't connect to the database. However, when I create a simple application and connect to the database in exactly the same way I don't get any erro ...

Access Driver

HiI am using CDataBase and CRecordSet objects, to query tables from a Microsoft Access Database.On execution, i get the following warning in the output window (get a lot of them, actually!):Optional feature not implemented State:S1C00,Native:106,Origin:[Microsoft][ODBC Microsoft Access Driver]What e ...

MTS with ORACLE - Myth or Reality ?

I'm trying (for several weeks now) to enlist an Oracle connection in a MTS transaction.It fails whatever I try.Using the Microsoft ODBC driver, my SQLConnect statement returns SQL_ERROR and the associated message is always the same (who never had this f%#2ing message with MTS ?):"Microsoft][ODB ...

MTS and ORACLE - Myth or reality ?

I'm trying (for several weeks now) to enlist an Oracle connection in a MTS transaction.It fails whatever I try.Using the Microsoft ODBC driver, my SQLConnect statement returns SQL_ERROR and the associated message is always the same (who never had this f%#2ing message with MTS ?):"Microsoft][ODB ...

Error in Executing a Stored Procedure

Hi. I have a stored procedure which takes a single input and a single output parameters. The input parameter comes from a textbox. When I run my program in VB, I get this run-time error[Microsoft] [ODBC SQL Server Driver] Optional feature not implementedhighlighting the lineadoCmd.Execute adoCmd is ...

Oracle Sporadic sync failures using 10g express with clearquest multisite

We just started using clearquest multisite with oracle 10g express. I get the following error occassionally when the importing the replica sync packetD:\Rational\ClearCase\config\scheduler\tasks>multiutil syncreplica -import -clan datalink -site redmond2 -family DL -user admin -pas sword "" -rece ...

Error while verifying database on crystal report

I am using crystal report 7 to connect with stored proc on a sybase 11 server. I am getting the following error when tried to refresh the database.ODBC error:[intersolv][odbc sql server driver]optional feature not implemented. Error in parameter 1. How can this be resolved? :confused: Stored proc is ...

Oracle ORA-28500 when accessing an Excel file

I'm getting the dreaded ORA-28500 "Optional feature not implemented" when trying to access an Excel file through HS ODBC. This is a known bug in 11.1.0.6 (6701400), however my flavor is 11.1.0.7 fully patched. Since I'm trying to use the OLAP option on Windows XP 32, I installed version 11.1.0.6 and ...

Oracle11g (windows) DG4ODBC-Connection to MSExcel

I am having issues with Oracle 11g (windows) setting up a connection to an Excel workbook. I have set up the config files as follows:listener.ora SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(GLOBAL_DBNAME = orcl)(ORACLE_HOME = C:\oracle\product\11.1.0\db_1)(SID_NAME = ORCL))(SID_DESC = (PROGRAM = DG4OD ...

Oracle connection problem in websphere datastage unicode/nounicode

Os : red hat 5Db : oracle 10.1.2Client using websphere datastage.but i don't know anything about that.I am dba.they got the error while They are trying to connect the server. they are able to run for Oracle tables that are Non-Unicode in nature, but I cannt get them to run where the Oracle tables co ...