|
Help please - I have an INSERT query of the form:
INSERT INTO MyTable (Field1, Field2...) VALUES (Value1, Value2...)
into a SQL Server Database. It is failing due to invalid text in one of the Parameters.
Now, I want to report the SQL query and Parameter Values when the failure is detected to aid debugging any future issues.
But GetSQL() only returns the SELECT query - the m_strUpdateSQL contains the "INSERT ... VALUES (?, ?...)" but there is no access Function!
Also if I try to use GetFieldValue() (to try to report the parameter values) my application just dies with an exception - presumably because they are only valid for a SELECT?
Is there any way to get at the Parameter Values?
Any help from someone out there who is familiar with CRecordsets, etc. would be gratefully received.
|
|
|
|
|
Hi..
I use ADO to store Images in a SQL Server 2000 Database
I want to know how to get the size of th stored image..
second: The log file Gets full quickly as I save large data .. Is there a way to truncate it after completing the Image saving Operation ?
|
|
|
|
|
1) select DataLength(imagefieldname) from TableName
2) use the WriteText/ReadText stuff which is not looged.
|
|
|
|
|
I have created a ATL/COM project in VC6 that will run as a service. Then I added a OLE DB Provider and modified it to just return 2 rows of a very simple record layout.
It compiles with no errors or warnings!
Then I launch Visual Basic and create a standard exe projekt, the first thing I do is to add a DataEnvironment Designer. When I open the property dialog on "DataEnvironment1" I get a list of providers to choose from, and my provider is also listed there.
When I select the provider I have created and presses next button, I get an error message saying something like this: "The provider is not available, check that you have installed it correctly" !!!!!!
 What have I missed? How do I install/register my provider?
I have ofcourse started the service!
Don't give me a RTFM, cause I have!
Confused
|
|
|
|
|
Is there any way to create a Jet database using ADO? I was using
CreateDatabase() with DAO, but now my employer wants ADO code ( yes, i´m always way behind the technology curve  ) ). I found the
dao to ado migration guide on msdn but it uses ADOX. Any Idea???
Thanks
Gabriel
Old C programmers never die. They just cast into void
|
|
|
|
|
As far as I know ADO does not have db creation functionality.
database creating and structural management should be done via ADOX (which is very easy to implement!)
-chin-
|
|
|
|
|
I need to hook Visual C++ to a Visual Foxpro database. There is a mention of an OLE Provider (vfpoledb on the Micrsoft site) and there is even an example of this on Codepage. But where can I get it?
I have now installed Fox Pro itself but no joy, my machine is XP is that makes any difference.
Can someone please point out the obvious to me?
|
|
|
|
|
Found it! - Its supplied with Foxpro 7
|
|
|
|
|
Hello,
I'm working on an application where the user needs to be able to select an external database to use within the application. I can handle mdb, db files, etc. But I'm not really sure how to handle allowing the user the ability to select and ODBC data source for example. Does ADO have some functionality that would allow me, the developer, to surface a standard dialog that the user could either select an ODBC data source and/or create and OLE DB source to access the data?
I guess I'm looking for something similiar to ODBC's SQLConfigDataSource functionality. Perhaps this is my answer???
Thanks,
Rob
|
|
|
|
|
I'm not sure now but I remember in Open() function of your database there is a flag that specify if there is no ODBC database,open a dialog and user can choose database.
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
Found what I was looking for in the Interactive SQL tool example http://www.codeproject.com/database/isqlado.asp
It has some code showing the use of PromptNew. It was exactally what I needed for this project.
Rob
|
|
|
|
|
I am currently working on a system that uses an Access database to store a list of url's waiting to be processed. I need to be able to add to, and amend the database, and so, I have derived a class from the CRecordset class called CURLRecordset using the classwizard.
In my application, I can succesfully open a CDatabase object in order to connect to the database, but when it comes to opening the actual recordsets associated with it:
/*
CURLRecordset* unparsed_urls;
CDatabase* db;
CString sql;
*/
unparsed_urls = new ( CUnparsed ) ( db );
sql.Format ( "SELECT * FROM urls WHERE status = %d;", STATUS_NOT_CRAWLED );
unparsed_urls->Open ( CRecordset::snapshot, (LPCTSTR)sql );
I get the following exception:
"Invalid character value for cast specification on column number 2 (urladdress)"
I have traced the source of the exception to the final move() function call in the CRecordset class, but I have no idea how to deal with it. My database schema is as follows:
TABLE urls =
(
long urlid (PRIMARY KEY)
VARCHAR(256) urladdress
long status
long level
long keywordid
long sourceid
)
The header file for the CURLRecordset class is as follows:
class CURLRecordset : public CRecordset
{
public:
CURLRecordset(CDatabase* pDatabase = NULL);
DECLARE_DYNAMIC(CURLRecordset)
// Field/Param Data
//{{AFX_FIELD(CURLRecordset, CRecordset)
long m_keywordid;
long m_level;
long m_sourceid;
long m_status;
CString m_urladdress;
long m_urlid;
//}}AFX_FIELD
// Overrides
// ClassWizard generated virtual function overrides
//{{AFX_VIRTUAL(CURLRecordset)
public:
virtual CString GetDefaultConnect(); // Default connection string
virtual CString GetDefaultSQL(); // Default SQL for Recordset
virtual void DoFieldExchange(CFieldExchange* pFX); // RFX support
//}}AFX_VIRTUAL
// Implementation
#ifdef _DEBUG
virtual void AssertValid() const;
virtual void Dump(CDumpContext& dc) const;
#endif
};
Any help will be greatly appreciated!
|
|
|
|
|
I made a Visual C++ application that uses ADO to query a database, and to update the changes.
I send some simple SQL statement to the database (an Access DB until now), like SELECT, UPDATE, etc.
Now I would like to make this through the internet.
I mean I run my program on my computer and it query the database that instead is on another computer, and it connects to it via tha Internet.
Where I can find a guide on how to do it?
Thankyou.
P.S.
I also think that I will need to use SQL Server or Oracle to store my database remotely, ad than use this server. Are there any service that offers this kind of hosting for free, so that I can start experimenting, without the hassle of installing my own SQL Server or ORACLE ?
Thank you very much.
"Nelle cose del mondo non e' il sapere ma il volere che puo'."
|
|
|
|
|
First, yes you can query a database on another server across the wild web. This is done quite simply actually here is a DNSless connection string to a SQL Server
"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=sa;Initial Catalog=pubs;Data Source=127.0.0.1;Use Procedure for Prepare=0"
You then change the IP addy in the Data Source attribute to point to the intended server. I've left a lot of details out here as to how it works etc. I recommend you do some studing in that area, but this should get you rolling .
Good Luck
|
|
|
|
|
Hi.
After added a record into a Recordset(offline),how to access the new added record?
Scratch
|
|
|
|
|
If you move your cursor from added record(i.e MoveNext()),then it will be available and you have access to it.
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
When use VB your advice is work very well,while using VC++ this seem does not work.
Scratch
|
|
|
|
|
What is your cursor type?
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
I have seen the newest .NET show on the web recently and it introduced the ORM (Object Role Modeling). I think that this is a very good approach in order to build Object Orientated Models. Is there some kind of possibility to generate C# code stubs out of the ORMs yet. I think that this is the very missing stone in the whole idea. If we think further the information stored within the ORM would allow generating some kind of a Ralational-Object Mapper code including simple SQL. So if you changed your ER Model or add some new “Facts” you would just generate your ALTER-nation statements for the DB and generate new C# classes including the update of the Relational - Object mapping. Don’t you thing that this is actually the future of how applications will be created?
So long
Pawel
|
|
|
|
|
I have a fundamental question about
the way .NET handles the object orientated way of
persistence. I am coming from JAVA and WebObjects (Apple)
World and I am looking for a convenient way of working
with objects without seeing any SQL statements only
objects. I have used that approach for years on the
WebObjects Platform (Enterprise Object Framework) and in
Java recently (Container Managed Persistence). I am
looking for something like that in the Microsoft world.
As far as I understand Microsoft does not distinguish
between the Object Model and the Relational Model. The
main difference is that the Object model allows n : m
relationships and the Relational does not allow them. Here
a small example to visualize the problem:
Example:
There is a Patient object with following Attributes
String patientGUID;
String name;
Int age;
Hashtable diseases; (or some other Container like
Collection or Array)
And there is a Disease Object
String diseaseGUID;
String name;
In the object Model there is relation between Patient and
Disease where the patient has his diseases but on the
other site one disease can belong to 1..* patients. (n :
m)
That n : m relationship can not exist within a relational
database without a link table that contains the
connections between the tables: Patient and Disease.
Now, I would like to connect the object Model containing
TWO Entities (Patient, Disease) with the relational
database (containing THREE tables). Then I want to work
with my objects; e.g. create new diseases connect them to
existing patients by putting the diseases into the array
or create new Patients and connect them with already
existing diseases or just change a Patients name. When I
am finished I just want to say SAVECHANGES and the
database is updated accordingly including all link table
entries.
So all I have to care about are my objects and the
relations between them, some invisible layer does all the
dirty work like building SQL, converting the data types
and caching. So if I fetch a Patient with a specified GUID
I do not have to care about fetching his diseases. They
are fetched automatically. If there are too many Diseases
I do not care some kind of algorithm handles that problem
in such a way that if I have to search all of them for
something they are simply there. They are loaded on demand
(lazy evaluation)
Supposing that the disease has a further connection with
some DiseaseType Object/Table and that table has an
attribute/column "Description" I can access it by typing
the following code:
TextField1.Text = currentDisease.type().description()
Please note that to retrieve the description value I did
only fetch the Patient. The diseases and its types were
fetched automatically.
Is something like that possible or am I excepting too much
of the .NET?
Pawel
|
|
|
|
|
What you are talking about is not a .net feature per-say. What you are looking for is an application server (which is what WebObjects is).
.net can be used to develop an environment like you describe and once it is developed, you can do what you want. However, it does not remove the development aspect of back-end SQL calls, etc.
|
|
|
|
|
what I want is:
Object Role Modeling
see my other post!!
 )))
Pawel
|
|
|
|
|
Hi,
I am learning C++ and have been doing pretty well until I got to this project I needed to complete. It's just a simple database, nothing fancy. I've imported msado15.dll, and have done eveything by the book but I keep getting this error upon executing the program that says "Data source name not found and no default drive specified. My instructor simply said that some people have an ODBC on thier systems and others don't. If I don't then I wont be able to get this to work. I'd like very much to concentrate on database building and design and was wondering if there is any way around this. I have WinXP Home editiion, and have just gotten (although not installed yet) pro. Any ideas would be appreciated.
I did set up my DSN and just now I did it again thinking that maybe something went wrong the last time. Any other ideas?? Please?
Thanks,
Garry
|
|
|
|
|
As posted on MSDN newsgroup:
Hello,
I think that we've stumbled accross a bug in CDO2000 which
causes a massive memory leak. This leaks happens on
Windows 2000 Professional. I failed to reproduce on
Windows 2000 Advanced Server.
Here is the code:
/////
IMessagePtr iMsg ;
iMsg.CreateInstance(__uuidof(Message)) ;
FieldsPtr Flds = iMsg->GetFields() ;
Flds->Item[cdoTo]->Value="james@drinkinginthesun.com";
/////
Is this a known issue? The leak will become obvious if the
above code is thrown into an infite loop. I have tested
this on Windows 2000 Professional with SP2 and Office 2000.
Thanks.
Regards,
James Pullicino
Response from MS:
James,
I see the leak you are reporting. This is apparently a leak in ADO (MDAC),
not CDOSYS. By removing the lines:
FieldsPtr Flds = iMsg->GetFields() ;
Flds->Item[cdoTo]->Value="james@drinkinginthesun.com";
and instead doing:
iMsg->To = "james@drinkingthesun.com";
I eliminated the leak.
Since you can't repro this on your Advanced Server, try comparing the
versions of MDAC on those machines...perhaps that is the difference?
Jason Johnston
Microsoft Developer Support - Messaging
Best Regards,
James Pullicino
Drinking In The Sun
Forgot Password?
|
|
|
|
|
Hi,
Is it posible to change a System DSN database path, runtime from a C++ application. Maybe with an API function or??
I have a alias to the System DSN, with this alias I can change the System DNS and by this change the MS Access database connected through the System DSN, but this meens that I need to create a new System DNS for every Access database I use under the application.
Thanks!!
Thomas Vanting
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
