I use ADO and OLE provider to access mdb files(access 2000), just as following:_ConnectionPtr pCnn;pCnn->CreateInstance(__uuidof(Connection));pCnn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data source=temp.mdb","","",NULL);all go well when I running in my computer.(I have installed Microsoft Acc...

Environment: Windows NT/ VC++ 6.0 / ADOhello,How do i get some specific error codes and more detailed explanation of errors that i face in certain conditions while using ADO.e.g : When i try to excute an INSERT SQL for a table which has some field names that are keywords (like Password, Decimal etc....

I would like to know is it a normal procedure to use ADO in a NT Service application? Is it too much overhead involved? And is it thread-safe?<br/>Any info is appreciated.<br/>Thanks.

sorry my english is poor!///////////////// for(int i=1;iLoopAdd(i);/////////////////////void CADOBindView::LoopAdd(int size){ _RecordsetPtr rSet; CCDTable m_cd; rSet.CreateInstance(__uuidof(Recordset)); IADORecordBinding *binding; try{ rSet->Open("select * from CD where ID=-1",...

i have to receive to tables shall save time if i extract them simultaniously

Beginner needs help? I want to query my DB and return 3 columns with x,y,min where min column should be the minimum sqrt(x+y)? I want to be returned only the minimum value (only one row)!Also I want that MIN column returned is > 0 ?What is wrong with the following query?select x,y,((SELECT min(sq...

I've a small app created (VC++), with ADO Data Control and DataGrid. It works very well, add,change, delete, modify data in the DB. BUT:: if another user change the DB, the new records will not be visible in the DataGrid.How can I refresh the DataGrid with the DB Data??regards remo...

I'm trying to connect to a database on the net with c# using ado.I tried the following://start of code examplestring s = "Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=" + @" http://64.230.69.252/DocumentDatabase.mdb"; adoConnection = new ADOConnection(s); //end of code examplehowever this doesn...

How is the RETURN value from a stored proc accessed via ADO using C++? I have set up the parameters, the first one is defined as adParamReturnValue. Documentation on this has been quite elusive.<br/>Thanks.

Hello, I am saving several recordsets in to one (1) XML file and I want to re-read the file back and assign to several recordsets. Is there some sort of XML query so that I can only read back part of the XML file (like child1, in the example below) ? the root child 1 recordset child 2 recordset...

Hi there,we are using server side dynamic cursor. After openning of recordset (Open() method) we should detect if opened recordset is empty or not. We are using for this GetEndOfFile() method which takes a lot of time if recordset is large (more then 50.000 rows). Is is possible to detect created re...

I am trying to connect to a mdb on the network using aspx and c#. The connection string is"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:/abc/abc.mdb;Persist Security Info=False"But I keep getting the errorThe Microsoft Jet database engine cannot open the file 'F:\abc\abc.mdb'. It is alre...

hi,<br/>does any bbody knows how to concert a CString into _variant_t data taype<br/>I have to pass my Cstring variable as a parameter to a ColeSafeArray via its PutElement method

anyone can help me for the SQL Command. how to track a customer that having same record in one day when doing transaction and cout of number transaction.<br/>What is the SQL Command?<br/>Regards,<br/>Wilson Chai

Hello! Does anybody know how to obtain the list of the currently registered databases in ODBC? And how to obtain all the table names in a particular database?<br/> Thank you so much!

I have to update a value in a row. I use the code:dr["ValueField"] = newvalue;but it is not updated. I also tried to use the:dr.BeginEdit();dr["ValueField"] = newvalue;dr.EndEdit();or:dr["ValueField"] = newvalue;dr.AcceptChanges();or both of these ways together, and also the call the DataSet'sA...

hi,<br/>Does anybody know how to get the SQL SERVER names on my computer and associated database and the tabels of them <br/>with greetings<br/>zgr

Does anyone know ho to make all related records be deleted if you delete a record??<br/>syntax please :)<br/>i'm using sql serv 7.0

I am using ado in visual C++ with Oracle. I want to insert and retrieve images from the database table.I have stored procedure which takes image as input and puts in a BLOB column. I am doing like thisparamImage= objCmd->CreateParameter("image",adLongVarBinary,adParamInput,5000,filename);objCmd-&...

How to see (in C++) if a table exists in a database if we know its name? <br/>Criniere Damien<br/>-----

Hi all,I've got a problem with placing MS DataGrid control in CView in SDI application.I placed MS DataGrid control on dialog first and generated classes for further using of control.Then in OnCreate of View I added following code:int CTestGUIView::OnCreate(LPCREATESTRUCT lpCreateStruct) { if (...

Hi.<br/>How can i add LONG value in image column throw ADO?

Hi,I am just a beginner in this field.I want to learn more about how to retrieve database information as XML data from SQL Server.I got the basic concept,now i need some code snippets that can let me fly.All the information that i could find on internet was for Visual Basic developers..I am working...

I have written a small program to open a connection using ADO/Visual C++. Unfortunately, if the data source doesnt exist the catch fails to handle this properly. Causing on the Return statement the following:First-chance exception in ado_test_vc.exe (KERNEL32.DLL): 0xE06D7363: Microsoft C++ Exceptio...

i have the code bellow in VC++ ,using ADO:find("RecordID="+lRecID+"",0,adSearchForward,"");//"lRecID"is a long int variable that has been defined before,"RecordID"is a field name of a tabel//but the VC++ said: error c2110:cannot add two pointersi don't know what's the wrongthe problem both...

Now I am adding ADO to my project, but I didn't add AUTOMATION attibute when I construct it. Please tell me if it is possible to add AUTOMATION manully to my project? And how?<br/>Thanks a lot!!

I have to connect to an Informix Database using ADO in VC++.<br/>Can someone please tell me how to go about doing it.<br/>Thank you<br/>rgarf@hotmail.com

How will we be able to do updates and add new records with ADO.NET?According to Visual Basic Developer .NETworthy columnist Rob Macdonald (Rob also wrote a book called "Serious ADO," ISBN 1893115194), ADO.NET currently supports only forward-only, read-only, server-side cursors. "This is the only typ...

hi all,<br/>i would like to use the AllowNulls property of a column. ( in C++)<br/>But I don't manage to do it.<br/>Can someone help me?<br/>thanks.<br/>Damien Criniere<br/>Criniere Damien<br/>-----

I want the "ODBC Data Administrator", window to be poped up using ADODB programatically. Also I want to create a DSN in using this popped up window. Will you please let me know the VB code to do this.

1)Is their a registry value to store the informations of login type ( either Integrated or standard security ).2) Is their a way to change the login type for the server dynamically ( i mean change from integrated to standard and vice versa )3) Is it a way to detect SQL Server stanard account "Sa" pa...

I get exception message "The operation requested by the application is not supported by the provider" when I debug my program at the point of setting Index in ADO (pRS->Index = "UserID", I need to do a Seek). I suspect this is because of wrong setup in ADO. I get ComCheck.exe and run it. the syst...

One module in a mini-ERP is using ADO data Access Model whereas other modules are using OLEDB(Consumer Template) data access model. So, it means there are two different approaches to database connectivity and then calls to database for data operations. I would like to know if there will problems rel...

I have a recordset connected to a SQL Server database. I wish to be informed, or at least be able to detect new records when they are inserted by myself and by other users. A total re-execute of the current query is impractical because of the size of my database. I was hoping the event 'RecordC...

I encountered problem when I test the ADO support in my machine( running Windows 95). The program (enclosed) produce the following result::ADO Version : 2.1DBMS Name : MS JetDBMS Version : 04.00.0000OLE DB Version : 02.10Provider Name : MSJETOLEDB40.DLLProvider Version : 04.00.2927Index...

Hi, I wanted to make a generic data access component with ADO.I developed my component as a ActiveX dll(in VB) and pass a parameters collection(pComm->parameters)from C++ as an input to the method and assign that parameters collection to the command object's collection in the dll .I tried...

I need to find out some property of a recordset, but without using the sql "Select" statement. Did anyone know how to find out? (if the column is primary key or not..<br/>thanks<br/>Hello, Szilard wish you the best.<br/>You can mail me at:darkertemplar@hotmail.com<br/>bye

Why ADO is so slow? In Dynamic recordset function Move(10000) takes about 40 seconds? Is it normal? I use VC++ with SQL server 2000 (developer edition).<br/>Thanks in advice.<br/>P.S. Moving 10000 records in stored procedure takes about 0.01 sec.

Anybody met with the same problem?Pls helpthe code is list below: if(FAILED(::CoInitialize(NULL)))return; _ConnectionPtr pWorkConn = NULL; _RecordsetPtr rstCompletion = NULL; _RecordsetPtr rstTemp = NULL; if (FAILED( pWorkConn.CreateInstance(__uuidof(Connection))))return; if (...

I want to pass _ConnectionPtr pConn to dll as argument in interface and there i want to use this connection object instead of making new object because to connect database it take more time.so how can do?

Hi guys,<br/>how can catch errors in sql commands at run time?<br/>for example if i m trying to insert new and my primary key in the new line already exist in the table. how do i catch it so it wont show the user<br/>an error message?<br/>thanks,<br/>ohad.

what does the error at my subject line mean? how can i fix it? is there something to do with the SQL Server 2000?<br/>i can only connect it through windows authentication.<br/>i am using MS Visual Studio.Net Beta 2

Hi, on ADO2.5 we use have a Seek method to locate the row that has some value(s) on some column(s).<br/>I cant find it on ADO.Net.<br/>Can someone help me??<br/>Thanks <br/>Carlos Lopes

Hi,I need to execute a SQL statement to insert a new record in a database. The content of some string field has the character [ ], which is also used to delimitate the strings. This causes a syntax error in the query.Can someone tell me how to solve it?The statement I was executing is something lik...

How to Connect adoce with sqlserver?

hi , all i wrote one small VC++ program which uses ADO and it call ASP page which talks to database and returns the recordset as a XML wrapped ADO recordset. it is working fine with IIS 5 but it is giving error "Type mismatch: 'rsUser.Save'". (this line belong to ASP page.) with IIS 4. i...

hello!<br/>I wan't to connect VC++ with Access 2000, how can i proceed?<br/>thanks!

Hey all,The way it works now:The system consists of a 'Server' which takes readings from many devices. The Server sends changed values to a speical 'Client' program. The 'Client' program shares this data as memory-mapped files. Recent patches have been made to have t...

Hi all,I am currently working with an application which is designed in cobol to interact with the old DBMS (like Btrieve database) systems.My application has to support Oracle now. So I started to design a C module that is called by cobol and the C module uses ODBC to interact with Oracle.I cannot u...

Hi,<br/> I have installed MS Sql Server 7.0 on windows2000 Advanced Server and it is running fine. After few days I have changed the Name of the System. Now Sql Server is not running properly. How can change the settings in SQl Server sothat it can work with the New name.<br/>Ramesh A