Re: deploying ms sql application - C / C++ / MFC Discussion Boards

Re: parallel communication

CPallini2-Jul-09 2:20

CPallini

2-Jul-09 2:20

kir_MFC wrote:
acheive snnchrinization

You should first achieve synchronization between brain and fingers. Roll eyes | :rolleyes:

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]

deploying ms sql application

Bilge Kaan2-Jul-09 1:33

Bilge Kaan

2-Jul-09 1:33

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

Re: deploying ms sql application

Rajesh R Subramanian2-Jul-09 1:35

Rajesh R Subramanian

2-Jul-09 1:35

And this should be on the C++ forum because?

It is a crappy thing, but it's life -^ Carlo Pallini

Re: deploying ms sql application

CPallini2-Jul-09 1:42

CPallini

2-Jul-09 1:42

You're right, OP indeed forgot: "send me C++ codez, sir, plz, plz, urgentz".
Smile | :)

Re: deploying ms sql application

Bilge Kaan2-Jul-09 2:21

Bilge Kaan

2-Jul-09 2:21

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

Re: deploying ms sql application

CPallini2-Jul-09 2:32

CPallini

2-Jul-09 2:32

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.
Smile | :)

Re: deploying ms sql application

led mike2-Jul-09 5:01

led mike

2-Jul-09 5:01

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[^]

Re: deploying ms sql application

Ozer Karaagac2-Jul-09 5:34

Ozer Karaagac

2-Jul-09 5:34

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"

sqlite

sriharichowdary2-Jul-09 0:27

sriharichowdary

2-Jul-09 0:27

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

Re: sqlite

Madhu Nair2-Jul-09 0:36

Madhu Nair

2-Jul-09 0:36

Its just as simple as clicking this link[^]

I hope this board is to help you in C/C++/MFC Sniff | :^)

Re: sqlite

manish.patel2-Jul-09 1:07

manish.patel

2-Jul-09 1:07

You can use this An Easy to Use Wrapper for SQLite3 (Totally Free Embedded Database Engine!)[^]

Is this what you need?

Manish Patel.
B.E. - Information Technology.

Regarding views

kirankatta2-Jul-09 0:16

kirankatta

2-Jul-09 0:16

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.

Re: Regarding views

Chandrasekharan P2-Jul-09 0:56

Chandrasekharan P

2-Jul-09 0:56

its a bit to understand what you are trying to explain. Please explain a little more

how to get message submit time.

santhosh-padamatinti1-Jul-09 23:23

santhosh-padamatinti

1-Jul-09 23:23

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

Re: how to get message submit time.

Madhu Nair1-Jul-09 23:29

Madhu Nair

1-Jul-09 23:29

Curious to know whether you solved the PATH problem

Re: how to get message submit time.

Cedric Moonen1-Jul-09 23:35

Cedric Moonen

1-Jul-09 23:35

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...

Cédric Moonen
Software developer

Charting control [v2.0]
OpenGL game tutorial in C++

Re: how to get message submit time.

manish.patel1-Jul-09 23:42

manish.patel

1-Jul-09 23:42

Are you talking about mail message time in MAPI?

Manish Patel.
B.E. - Information Technology.

Re: how to get message submit time.

santhosh-padamatinti2-Jul-09 0:08

santhosh-padamatinti

2-Jul-09 0:08

yes, write now I able to get every property like cc,bcc etc except time.
how it is possible.

sampath-padamatinti

Re: how to get message submit time.

manish.patel2-Jul-09 0:12

manish.patel

2-Jul-09 0:12

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.

Re: how to get message submit time.

santhosh-padamatinti2-Jul-09 0:19

santhosh-padamatinti

2-Jul-09 0:19

sent time

sampath-padamatinti

Re: how to get message submit time.

manish.patel2-Jul-09 0:31

manish.patel

2-Jul-09 0:31

Then PR_CLIENT_SUBMIT_TIME is right.

For Recieved: PR_MESSAGE_DELIVERY_TIME

Manish Patel.
B.E. - Information Technology.

Re: how to get message submit time.

santhosh-padamatinti2-Jul-09 0:41

santhosh-padamatinti

2-Jul-09 0:41

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

Re: how to get message submit time.

manish.patel2-Jul-09 0:53

manish.patel

2-Jul-09 0:53

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.

Re: how to get message submit time.

santhosh-padamatinti2-Jul-09 1:23

santhosh-padamatinti

2-Jul-09 1:23

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

Re: how to get message submit time.

manish.patel2-Jul-09 1:32

manish.patel

2-Jul-09 1:32

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. Laugh | :laugh:

Manish Patel.
B.E. - Information Technology.

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