|
Hello,
I wrote an sql client application using VS2008 and ODBC driver.I am using sql express 2008 as server.
I want to prepare installer application to install it. How can I create ODBC and configure it for my application?
I am doing it manually using administrative tools. And I have database creation scripts and running them within managment studio of sql server. How can i install and run scripts automaticly during installtion?Any links or tutorials ..
Regards
|
|
|
|
|
And this should be on the C++ forum because?
It is a crappy thing, but it's life -^ Carlo Pallini
|
|
|
|
|
You're right, OP indeed forgot: "send me C++ codez, sir, plz, plz, urgentz".
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[My articles]
|
|
|
|
|
Hello,
Sorry for my mistake first.
I never keep my words OP.I always write my own code and never request code.
If it is not the right forum , you should only point me to correct forum.
You sholud at least be polite and without pre-judgment.
Regards
|
|
|
|
|
Well, I was just kidding with my good friend Rajesh and in fact you're right, no code request came from you.
(You know kidding often implies a big stretch of reality: I was just mocking some typical requests you may find in this forum). I'm sorry if my words hurted you.
BTW from your post it's difficult to understand what is the most appropriate forum.
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[My articles]
|
|
|
|
|
Bilge Kaan wrote: How can i install and run scripts automaticly during installtion?Any links or tutorials
For installing SQL Express I think I remember seeing some deployment documentation on MSDN for SQL Express. I imagine there is a MSI for it.
For investigating things in Windows Installer I always start with InstallSite.org[^]
|
|
|
|
|
To create an ODBC data source.
1.You might create a file DSN in designated directory. It's a ".ini" like text file. You can examine it for an analogy. Default directory is "Program Files\Common Files\ODBC\Data Sources".
2.You might create registry keys for User or System DSNs, respectively under the keys below. You can also examine them.
HKCU\Software\ODBC\ODBC.INI
HKLM\SOFTWARE\ODBC\ODBC.INI
BTW, I'm speaking mostly for XP OS because the others may somewhat differ.
Additionally, you don't have to create any kind of DSN, you can open your connection on the fly in your code by a proper connection string like below.
"DRIVER=SQL Server;SERVER=%s;DATABASE=%s;UID=%s;PWD=%s"
You may need to use "DRIVER=SQL Native Client" for 2008.
You can also execute DDL scripts to create your schema using CDatabase::ExecuteSQL(). To do this, you can open your database connection using string below with an administrator user/password.
"DRIVER=SQL Server;SERVER=%s;DATABASE=master;UID=sa;PWD=%s"
|
|
|
|
|
plz tell me the usage of storing data in sqlite & storing data in BLOB ,and another one is in sqlite when we creating tables where it stored .......thanks
|
|
|
|
|
Its just as simple as clicking this link[^]
I hope this board is to help you in C/C++/MFC
|
|
|
|
|
|
More explanation to adress the problem:
Hi Chandu:
My problem is, i created one new databse from a existed template database, add a document to this new databse, and set body ,bcc,cc, subject to this databse, and add this document to inbox folder,Suppose we did't mention any database default it will be saved in All Document.If we mention any folder name, that should be saved in that folder,.
Both views and folders are same, but when i try to save this newlly created document into sent views, iam getting problem, unable to add to that views,
For folders its working fine and incase of views its raising some problem, what is the proble, for folder i use
db.GetViewFolder("inbox",&tempFolder);
tempFolder.FolderAddDocument(newdoc)function,
if i want to work with views, which function can i use to save the document in a particular view.
Revert me back with some suitable function which are the sufficient to achieve this one.
|
|
|
|
|
its a bit to understand what you are trying to explain. Please explain a little more
|
|
|
|
|
hi
please tell me how to display the message submit time. I know the property that is PR_CLIENT_SUBMIT_TIME. at least give me links for displaying the message time.
thanx in advance
sampath-padamatinti
|
|
|
|
|
|
sampath-padamatinti wrote: please tell me how to display the message submit time
Which message are you talking about ? What is this display time you are talking about ?
You know, "message" is such widely used in software that without background information, nobody will be able to help you...
|
|
|
|
|
Are you talking about mail message time in MAPI?
Manish Patel.
B.E. - Information Technology.
|
|
|
|
|
yes, write now I able to get every property like cc,bcc etc except time.
how it is possible.
sampath-padamatinti
|
|
|
|
|
Which time are you talking about sent time or recieved time?
Try to use PR_MESSAGE_DELIVERY_TIME .
Is it what you want?
Manish Patel.
B.E. - Information Technology.
|
|
|
|
|
sent time
sampath-padamatinti
|
|
|
|
|
Then PR_CLIENT_SUBMIT_TIME is right.
For Recieved: PR_MESSAGE_DELIVERY_TIME
Manish Patel.
B.E. - Information Technology.
|
|
|
|
|
yaa, I know this property. and it returns the PT_SYSTIME. but the problem is i unable to display the time value. If you know plz explain indetail.
sampath-padamatinti
|
|
|
|
|
You are getting value as SPropValue .
Suppose its prop .
Now use following code to convert FILETIME to SYSTEMTIME
SYSTEMTIME sTm;
FileTimeToSystemTime(&(prop.Value.ft), &sTm);
Manish Patel.
B.E. - Information Technology.
|
|
|
|
|
I wrote like this but it is not showing the value.
SPropValue prop;
prop.ulPropTag = PR_MESSAGE_DELIVERY_TIME;
SYSTEMTIME sTm;
FileTimeToSystemTime(&(prop.Value.ft), &sTm);
printf("%d\n",sTm.wDay);
sampath-padamatinti
|
|
|
|
|
You are not retriving value from MAPI.
Use this code:
LPSPropValue prop;
ULONG ulPropCount;
ULONG p[2]={ 1,PR_MESSAGE_DELIVERY_TIME };
HRESULT hr = m_pItem->GetProps((LPSPropTagArray)p, MAPI_CREATE, &ulPropCount, &prop);
SYSTEMTIME sTm;
FileTimeToSystemTime(&(prop->Value.ft), &sTm);
printf("%d\n",sTm.wDay);
where m_pItem is your message object.
Hope this helps you.
Manish Patel.
B.E. - Information Technology.
|
|
|
|
|
Thanx ,so much I got now, I made a small change like follow.
SYSTEMTIME sTm;
FileTimeToSystemTime(&(pRows->aRow[i].lpProps[ePR_MESSAGE_DELIVERY_TIME].Value.ft), &sTm);
printf("%d\n",sTm.wDay);
sampath-padamatinti
|
|
|
|