|
... using InstallShield. It has made a setup.exe with all things which are needed.
Thanks 
Friedrich
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Hi,
Is anybody knows the procedure to interact with an excel defined table from VC++?
thanks
|
|
|
|
|
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!
|
|
|
|
|
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!
|
|
|
|
|
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!"
|
|
|
|
|
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
|
|
|
|
|
When I am trying to do data manipulation in tables having CLOB columns
I have XML file which is having around file size of 10k bytes, not being able to insert more than 4000 bytes in LOBs column.
Can anyone have sample code to resolve this issue.
Current Environment :
C++ using ADOs in ORACLE. OLEDB provider is Oracle - OraOLEDB.
Oracle version details: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
parag
|
|
|
|
|
Install the 8.1.7.2.0 version of the Oracle OLEDB Provider from Oracle. 8.1.6.x is no longer supported.
|
|
|
|
|
Hi Guys,
I have been using ADO to execute queries asynchronisly. I am using adUserServer as Cursor location and adAsyncExecute flag to run the query using Recordset-->Open method.But the problem is if i cancel the query in between i get the following error:
Error No : 3712
Description: Opeartion has been cancelled by the user.
I don't understand why.
And if i use Command object's Execute method to run my query, then the query dosen't seems to run asynchrosnly.
Did anybody worked with ADO async queries?
Any help in this regard would be highly appreciated.
Cheers,
Mukesh
|
|
|
|
|
I have old code (prior to me even knowing how to code)
Global dsByJob as QueryDef
set dsByJob = db.OpenQueryDef("QryBrowseByJob")
How would this be handled in ADO. Is a recordset being created off the Query?
Thanks
Tim
|
|
|
|
|
Hello
I'm developying application for a pocketpc and i want to open a database, than i have imported from access (.mdb) as a .cdb file but i don't know how, i just start programming only for 2 months.
can't somedody help me to do this; it's really urgent!!!!
|
|
|
|
|
How do i use the RowFetchCount property for ADODataReader
Bascially what i want to implement is paging
|
|
|
|
|
hi
Im working on an application with VC++ MFC as front end and sybase installed on unix server as backend.
Can anyone tell me which method ADO or MFC DB Classes(CRecordset,CDatabase etc..) is better suited for DB Connections.
Please give detailed explanation?
YOur Help will be highly appreciated.
Aky
|
|
|
|
|
Hi Friends,
Uptill now I was developing database application using vc++ and MSAccess as database. Now I am developing vc++ application(with doc/view architecture) with SQL Server(2000) acting as back-end and which is installed on a file server(installed on windows 2000). I need your help regarding follwing two questions:
1) How to connect front-end vc++ application running on a computer which is different than file server where SQL Server is installed and on which database resides. Database contains two tables presently.
2) How to create or write stored procedure and use it with front-end vc++ application?
Your help will be greatly appriciated.
Thank you in advance.
Bharat Gadhia;)
Help is always welcome
|
|
|
|
|
I've just recently started programming for SQL Server as well. Carlos Antollini's "A Set of Database Classes" article (found under General/Database/ADO) has been very useful to me. Most of it you are probably familiar with already. The key change needed to make it work for SQL Server is the connect string.
strConn = _T("Trusted_Connection=yes;Driver={SQL Server};Server=MyServer; Database=MyDatabase;")
If you have your SQL Server set to use Windows Authentication set Trusted_Connection=yes, otherwise set it to 'no' and send username and password information with the Open().
When opening the Recordset if the options flag is set to other than an OpenQuery of OpenTable, your query will be treated as a call to a stored procedure. None of my work yet has involved stored procedures, so other than telling you the class can handle them there is not much help I can give you there.
|
|
|
|
|
Send me a mail to cantollini@hotmail.com with your questions that a will help you.
Carlos Antollini.
|
|
|
|
|
How can I schedule a backup for SQL data base? I tried to set it in the Enterprise manager by right click on the database and then backup data base-> choosing shedule but it doesn't keep my settings and doesn't run the backup at the requested time and date.
I would be grateful for an answer...
|
|
|
|
|
Hi
I have a method in a Dll, which will return ADO recordset. This Record set has been sorted by SORT property of ADO recordset in side the DLL. It is working fine inside the DLL. But When I call the DLL method from ASP I am unable to get the recordset in sorted manner.
I would be glad if any of you can let me know how to recive the recordset in a sorted manner.
Thank you for your precious time.
Thota
Houston TX
|
|
|
|
|
Hi All,
I'd like to know the exact steps to follow for setting up a File and System DSN with ODBC using the SQL Server driver.
I am testing with PWS server and ASP for now on Win98 OS, but the SQL Server connection keeps failing and the ADO object creation fails as well.
Any help is highly appreciated in advacnce.
Cheers!
Masoud
|
|
|
|
|
Hi all.
The following code is really annoying me...
<cpp>
Dim rsTable As New Recordset
rsTable.CursorLocation = adUseServer
rsTable.CursorType = adOpenStatic
rsTable.LockType = adLockReadOnly
rsTable.MaxRecords = 100
Call rsTable.Open("Select * From Table", cnConnection, , adLockReadOnly, adCmdText)
It should return just 100 records but it returns ALL of the records in Table...
I need to allow the user to enter any sql select statement and give them a preview of the top 100 records. However, this is just running EXACTLY their input sql.
Any ideas?
Thanks
Pete
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
