C / C++ / MFC

2-Jul-07 1:48

Hi....
I want to create dsn at runtime using mfc..
Is there any solution
plz help me!!!!!!

Thanks in advance

Y_Kaushik2-Jul-07 1:57

Y_Kaushik

2-Jul-07 1:57

I don't think we can do this.

Note : Please give detail which type of DSN you want to create at run time.

I think u will be aware about System DSN,User DSN,File DSN
Laugh | :laugh:

Regard's
Kaushik

meenakhisjoshi2-Jul-07 2:02

2-Jul-07 2:02

I want to use System DSN..

MANISH RASTOGI2-Jul-07 2:20

MANISH RASTOGI

2-Jul-07 2:20

Use SQLConfigDataSource()

Manish Rastogi

meenakhisjoshi2-Jul-07 3:44

2-Jul-07 3:44

Hi I use SQLConfigDataSource() API but it create User DSN & i want to create System DSN so plz help me.....

meenakhisjoshi2-Jul-07 4:00

2-Jul-07 4:00

Thanks it has been done.............

meenakhisjoshi2-Jul-07 4:03

2-Jul-07 4:03

But i have to done using Sql database so can it done using same API?

David Crow2-Jul-07 4:32

David Crow

2-Jul-07 4:32

A DSN does not know/care about the underlying DBMS. The third argument is where you specify the type, and the fourth argument contains the details of that type.

"A good athlete is the result of a good and worthy opponent." - David Crow

"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

meenakhisjoshi2-Jul-07 19:29

2-Jul-07 19:29

The third argument is "Microsoft Access Driver (*.mdb)" then what should changes are required?

meenakhisjoshi2-Jul-07 21:47

2-Jul-07 21:47

I wrote :

SQLConfigDataSource(NULL,ODBC_ADD_SYS_DSN,"Microsoft SQL Driver (*.sql)\0",(LPCSTR)szDesc))

sprintf(szDesc,"DSN=%s: DESCRIPTION=TOC support source: DBQ=%s: FIL=MicrosoftSQL: DEFAULTDIR=D:\\Database:: ","TestDB","root@localhost\\dtest.sql")

but it gives error so plzzzzzzzzz help me what should i changes?

David Crow3-Jul-07 2:08

David Crow

3-Jul-07 2:08

meenakhisjoshi wrote:
SQLConfigDataSource(NULL,ODBC_ADD_SYS_DSN,"Microsoft SQL Driver (*.sql)\0",(LPCSTR)szDesc))

Why the extra \0 character? This statement is missing a semicolon.

meenakhisjoshi wrote:
sprintf(szDesc,"DSN=%s: DESCRIPTION=TOC support source: DBQ=%s: FIL=MicrosoftSQL: DEFAULTDIR=D:\\Database:: ","TestDB","root@localhost\\dtest.sql")

If you are using MFC, why not use a CString object rather than mess with sprintf()? This statement is also missing a semicolon.

meenakhisjoshi wrote:
but it gives error...

And that error would be?

"A good athlete is the result of a good and worthy opponent." - David Crow

"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

meenakhisjoshi3-Jul-07 23:33

3-Jul-07 23:33

In this '\0' just for termination of string
the error is
SQLConfigDataSource is return False.

Is any problem in that syntax

David Crow4-Jul-07 11:42

David Crow

4-Jul-07 11:42

meenakhisjoshi wrote:
In this '\0' just for termination of string

Which string literals already have one of.

meenakhisjoshi wrote:
SQLConfigDataSource is return False.

So have you bothered to call SQLInstallerError() to find out why?

"A good athlete is the result of a good and worthy opponent." - David Crow

"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

MANISH RASTOGI2-Jul-07 19:03

MANISH RASTOGI

2-Jul-07 19:03

Use ODBC_ADD_SYS_DSN

Manish Rastogi

DATEDIFF function

El'Cachubrey2-Jul-07 1:08

El'Cachubrey

2-Jul-07 1:08

Hi Is exists in c++ a function similar to DATEDIFF in SQL or VB
THANK

Re: DATEDIFF function

CPallini2-Jul-07 1:44

CPallini

2-Jul-07 1:44

If you're using MFC, have a look at CTimeSpan class http://msdn2.microsoft.com/en-us/library/ay6ws8h3(VS.80).aspx[^].
Smile | :)

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.

Re: DATEDIFF function

benjymous2-Jul-07 1:59

benjymous

2-Jul-07 1:59

CompareFileTime is a win32 function that'll compare two FILETIME structs

Re: DATEDIFF function

vladfein2-Jul-07 9:20

vladfein

2-Jul-07 9:20

Unfortunately, none of the two suggestion above will do what DATEDIFF does...
You need to separate the DATE part of your time value. You didn't say what data type you use for your date/time variables.
The easiest way, I think, is to convert both dates to COleDateTime (which wraps double representation of date/time), truncate the fractional part and simply subtract one value from another.

-----------------------------
Get trial copy of FeinViewer - an integrated GDI objects viewer for Microsoft Visual Studio .NET 2005 (8.0) Visual C++ Debugger, and other convenience and productivity tools for Microsoft Visual Studio .NET at at www.FeinSoftware.com

Dynamic Structures

Programm3r2-Jul-07 0:32

Programm3r

2-Jul-07 0:32

Hi all,

I would liek to know if it is possible to create dynamic structures? And if it is possible, how would one go about doing it?

Many Thanks
Regards,

The Code Project...Where men are made and legends are born Green Alien | [Alien]

Programm3r
My Blog: ^_^

baerten2-Jul-07 0:45

baerten

2-Jul-07 0:45

Hi,

i think the only way is to use void* Pointer into your struct.
So you can store what-ever in your structure.
But the number of pointers must be specified in the code.

Good luck Smile | :)

CPallini2-Jul-07 1:04

CPallini

2-Jul-07 1:04

Programm3r wrote:
I would liek to know if it is possible to create dynamic structures?

What do you mean? Do you want to dynamically create statically declared structs?
If the answer is yes, then use the new operator. On the other hand, if the answer is no, please detail you request.

Smile | :)

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.

Programm3r2-Jul-07 2:29

Programm3r

2-Jul-07 2:29

CPallini wrote:
What do you mean?

Well for example, instead of creating five structures, is it possible to create one structure that can dynamically cater for each of the five structs during run time.

Makes sense ?
Thanks for the response ...

Regards,

The Code Project...Where men are made and legends are born Green Alien | [Alien]

Programm3r
My Blog: ^_^

CPallini2-Jul-07 2:47

CPallini

2-Jul-07 2:47

Programm3r wrote:
is it possible to create one structure that can dynamically cater for each of the five structs during run time

Why don't you use a container (such as std::vector) for your dynamically created structures?

(Maybe I haven't fully understood your requirements).
Smile | :)

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.

Programm3r2-Jul-07 2:59

Programm3r

2-Jul-07 2:59

Thanks for the info CPallini, never really used a std::vector before, but I'll give it a shot.

Thanks
Regards,

The Code Project...Where men are made and legends are born Green Alien | [Alien]

Programm3r
My Blog: ^_^