Database

FirstPrevNext

Re: How to read parameter from stored procedure ? Rashid Thadha9-Aug-01 6:48 Rashid Thadha 9-Aug-01 6:48  You need to change the parameter declaration in your stored procedure .. DECLARE @file_id int OUTPUT, .. This will then return the value for you when you execute the code via ADO. One thing to remember is that you will need to close your recordset down before you can read the value. This is only if you are not also returning a recordset Creating a user in Oracle Dhanush26-Jul-01 0:16 Dhanush 26-Jul-01 0:16  Hi all, In Orcle is it possible to create a user without having the password? If anybody knows plz tell me the procedure. Thanx in advance. Exporting data from Excel v_krishnan25-Jul-01 19:31 v_krishnan 25-Jul-01 19:31  I have created an excel sheet by executing a query on an external database using MS Query. Now I want the data that I have changed in the sheet to be updated back into the database from where it actually came. Is this possible? Do VB/VBScript provide any way of doing this? Krishnan Need to send a string to running application - please help 20-Jul-01 13:48 20-Jul-01 13:48  Hi I want to create a simple windows that displays a message. The message would be passed to it from another application. How is this done. Any guidance would be appreciated. Is this a situation, would I use Remote procedure calls. Any help would be most appreciated. Regards, A Novice Find in ADO, how does it works? Gérald Mercet19-Jul-01 22:48 Gérald Mercet 19-Jul-01 22:48  I would like to know if the find method is the best if i want to open a field which the name is given by the user of my dlgbox application. For example, if the user write "1Y" in a edit box, my application will have to open the "1Y" field to catch value in it. So, do i have to use Find? thanks in advance gerald Re: Find in ADO, how does it works? Carlos Antollini20-Jul-01 5:33 Carlos Antollini 20-Jul-01 5:33  Depends. For example if the user write the EXACT text is better and more Quickly to use the command Seek, because this use the index, (you need that the field to be an index) But if the user write the no exact string how part to the string, in this case is better to use the Find. Other solution is make a query. Cheers!!! Carlos Antollini. SQL Server Stored Procedure Encryption 19-Jul-01 18:24 19-Jul-01 18:24  Is there a performance hit if I encrypt all my database stored procedures? ADO error adErrItemNotFound David Douglass17-Jul-01 5:39 David Douglass 17-Jul-01 5:39  Friends, I'm calling an ActiveX DLL I wrote in VB from VC++. In the VB, I'm using the VB data environment to do a parameterized insert. Everything is OK until I get a duplicate key. As soon as the DataEnvironment.Commands(1).Execute statement runs, VB immeadiately returns to the C++ caller; the hResult is 0x800A0CC1, which doesn't make any sense being that the previous 812 insert suceeded. What I'm trying to do is trap the error on the VB side (using on error goto) so I can log it prior to returning to the caller. But, the error routine never runs due to the immeadiate return. Any help will be much appriciated! Thanks, David Douglass Bloomingdale, NJ How To Set OBDC In Installshield? nemati17-Jul-01 1:24 nemati 17-Jul-01 1:24  i have a program that connect to odbc((user DSN)) and i want to install it with installshield i don't know that set odbc connection in install shield. thanks Recommend a Report tool for c++ Rod Hamilton16-Jul-01 11:51 Rod Hamilton 16-Jul-01 11:51  Can anyone suggest a report tool, add-in or something that I can use in my C++ project that tracks some basic usage data. Do most developers roll their own when they need to provide 10 or so, simple reports to screen and printer? Any ideas would be appriciated. Regards Rod Hamilton SQLXML. Type Library Özgür12-Jul-01 22:27 Özgür 12-Jul-01 22:27  hi, Does anybody know how to use SQLXML Type Library in Visual C++ programs... I need it to do some XML-data retrieving from SQL server 7.0.Or if there is another way to use SQL Server 7.0's XML features through ADO,please let me know... Greetings from Germany Özgür Bachelor of Control&Computer Engineering from IStanbul Technical University Worked with Delphi for 6 Months Worked with Java for 3 Months Now ,Working with MFC,VIsual C++6.0 and ADO Help!! ADO and NT Ralf Friedrich Hain12-Jul-01 6:35 Ralf Friedrich Hain 12-Jul-01 6:35  I've got my application ready and it is running perfect under my developing computer (win95), but on an other machine (winNT) it doesn't start at all!!! No error-message is shown! I think the proplem has to do with the control "Microsoft ADO Data Control, version 6.0 (OLEDB).lnk" It is a matter of different paths? "c:\windows\system\msadodc.ocx" on w95 and "c:\winnt\system32\msadodc.ocx" on NT ? I already use the MFC as a static lib. ADO 2.5 is installed on both computers. Please help me! Friedrich Re: Help!! ADO and NT Sardaukar12-Jul-01 6:45 Sardaukar 12-Jul-01 6:45  Try to load dynamically the component... The #import <filename> is almost always a bad idea. LoadTypeLibrary, CoCreateInstance, even old LoadLibrary can help. Or it can be a different version control that has some methods on 95 and other on NT. Trying to call the method "7" when the interface implements only "6"... By the way, application doesn't tell nothing? No crash, no "Debug", nothing? What does it mean "doesn't start at all"? Re: Help!! ADO and NT Ralf Friedrich Hain12-Jul-01 7:13 Ralf Friedrich Hain 12-Jul-01 7:13  Sorry, I was not precise enough. I didn't use the #import, I used "Project | add | Controls | Registred Active-X controls"... (sth like that, I'm using a german visual studio) I dragged the control with the mouse to a dialog in the dialog-editor ( and a MS-Data Grid etc ) "Nothing" means, nothing happens if i double click on the Icon in Win Explorer. Just as it wasn't there. To Debug, i would have to install Visual sudio to the NT system. But I wanted to avoid it, cause it is always a matter: running on the development-computer is successfull, running on an other system fails: On another NT System with Visual Studio, the application started, the starting querie succeded, but the user-queries failed (access error). ? Thanks for your answer. Friedrich Re: Help!! : I've solved my problem ... Ralf Friedrich Hain17-Jul-01 2:03 Ralf Friedrich Hain 17-Jul-01 2:03  ... using InstallShield. It has made a setup.exe with all things which are needed. Thanks Friedrich retrieving XML Özgür11-Jul-01 23:20 Özgür 11-Jul-01 23:20  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 with Visual C++ and ADO and SQL Server 7.0.Can anybody show me some code or some internet sites devoted to Visual C++ developers..Also what else,i need to be able to use XML features of SQL Server? with greetings from Germany Özgür Bachelor of Control&Computer Engineering from IStanbul Technical University Worked with Delphi for 6 Months Worked with Java for 3 Months Now ,Working with MFC,VIsual C++6.0 and ADO CRecordset object of type snapshot turned into dynaset => recordset readonly! 9-Jul-01 21:01 9-Jul-01 21:01  Hi I tried to make my CRecordset derived class using a dynaset instead of a snapshot, and suddenly the recordset object was readonly. Why? How can I fix it? I'm letting the CRecordset-derived object manage my CDatabase object, and uses only default open and construction parameters. ADO and JRO question Roger Cornell9-Jul-01 12:08 Roger Cornell 9-Jul-01 12:08  I have a need to replicate and synchronize an .mdb file in VC++ 6.0. I see that the JRO contains CreateReplica() and Synchronize() methods, these are precisely what I need to do. What I need to know is how to create the Replica object, I've seen reference to IReplica in the msjro.tlb file but I'm not sure what is the Replica equivalent of _ConnectionPtr. Once I know how to create the Replica object the rest should fall into place. Roger Cornell Re: ADO and JRO question Roger Cornell11-Jul-01 12:05 Roger Cornell 11-Jul-01 12:05  I've got a solution for my own question now, here it is. I've found out how to create a replica of an Access .mdb file through VC++. Here's the code. This code goes at the end of STDAFX.H #import "C:\\program files\\common files\\system\\ado\\msado21.tlb" \ no_namespace \ rename("EOF", "adoEOF") #import "C:\\program files\\common files\\system\\ado\\msjro.dll" MSJRO.DLL uses a namespace JRO. This code goes in a .CPP file CoInitialize(NULL); JRO::IReplicaPtr m_pReplica; HRESULT hr0; hr0 = m_pReplica.CreateInstance(__uuidof( JRO::Replica ) ); if(SUCCEEDED(hr0)) { CString m_connectString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\\JDOCS\\Data\\JDOCS.mdb"; m_pReplica->PutActiveConnection(_bstr_t(m_connectString)); CString m_repName = "D:\\JDOCS\\Data\\JDOCSRep2.mdb"; CString m_repDesc = "JDOCS Database Replica"; m_pReplica->CreateReplica(_bstr_t(m_repName), _bstr_t(m_repDesc), JRO::jrRepTypeFull, JRO::jrRepVisibilityGlobal, -1, JRO::jrRepUpdFull); } CoUninitialize(); Roger Cornell help! source code on buffer manager and page thinker8-Jul-01 12:07 thinker 8-Jul-01 12:07  Anyone can tell me where I can find the C/C++ source code on how page and buffer manager are implemented in a database system? I need to get some ideas about this. Thank you ADO and excel Gérald Mercet4-Jul-01 22:39 Gérald Mercet 4-Jul-01 22:39  Hi, Is anybody knows the procedure to interact with an excel defined table from VC++? thanks ADO AddNew problem 3-Jul-01 13:35 3-Jul-01 13:35  I have been staring at this for 2 hours now and can't put my finger on the problem. Any comments would be helpful: rs is a recordset that is already opened. Platform is IIS 5 running on Windows 2000 Pro. Database is SQL Server 2000 <br /> if rs.supports(adAddNew) and rs.supports(adUpdate) then<br /> rs.AddNew<br /> ... update fields here<br /> rs.Update<br /> end if<br /> the problem is that I get an error telling me that the database can't be updated on the rs.AddNew line! IDE for SQL Store procedure - Emanuele -2-Jul-01 22:35 - Emanuele - 2-Jul-01 22:35  I'm looking for an IDE for developing store procedure in SQL Server with debugging, context help, code assist, ecc.... Does anybody know something for me? Thanks! Re: IDE for SQL Store procedure Anders Molin3-Jul-01 0:31 Anders Molin 3-Jul-01 0:31  VC 6 or InterDev 6... You can set both up to support debugging of Stored Procedures on SQL Server. - Anders Money talks, but all mine ever says is "Goodbye!" printing MS Data-Grid? or copying? Ralf Friedrich Hain1-Jul-01 4:59 Ralf Friedrich Hain 1-Jul-01 4:59  I've got a MS Data-Grid Control V6.0 OLEDB in my application. Is there an easy way to print it? Or alternavtively: Is there a way to copy it and paste to Excel? :-| Thanks. Friedrich

Last Visit: 31-Dec-99 18:00     Last Update: 12-Jun-24 4:24 Refresh ᐊ Prev1...2454245524562457245824592460246124622463 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.