GIDForums  

Go Back   GIDForums > Computer Programming Forums > MS Visual C++ / MFC Forum
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

 
 
Thread Tools Search this Thread Rate Thread
  #1  
Old 11-Apr-2008, 00:27
-girl- -girl- is offline
New Member
 
Join Date: Apr 2008
Posts: 11
-girl- is on a distinguished road
Exclamation

Connect MS SQL Server 2005 to MFC Dialog application


Hey there experts...

i'd like to know, how do i link the database on the MS SQL Server 2005 to the MFC dialog Application?

im gladly appreciate if u show me step by step n some examples...

thanx in advance..
  #2  
Old 20-Apr-2008, 20:29
Peter_APIIT Peter_APIIT is offline
Regular Member
 
Join Date: May 2007
Location: Malaysia
Posts: 405
Peter_APIIT is on a distinguished road

Re: ASAP!!!! connect MS SQL Server 2005 to MFC Dialog app


I also want to know.
__________________
Linux is the best OS in the world.
  #3  
Old 22-Apr-2008, 01:17
Jana Jana is offline
New Member
 
Join Date: Apr 2008
Posts: 10
Jana is on a distinguished road

Re: ASAP!!!! connect MS SQL Server 2005 to MFC Dialog app


i can give u some startup tips....

  • Select which type of MFC appliation you would want to create.
    As you move on with the options in the wizard, you will need to specify the database options...
    Here you have 2 options. ODBC or OLE DB.
    You may wanna ODBC. But you should have SQL ODBC driver installed.
    In general, you may wanna use OLE DB...
    Then You should select your Datasource. eg: Microsoft OLE DB Provider for SQL Server
    Now you have to specify the server and the optional details such as username , password and the name of the database.
    once you are done wit this you shud b able to move on with programming...

I know its not an elaborated guide...But in case if u don;t know where to start..this shud help u a bit.....
  #4  
Old 30-Apr-2008, 00:54
-girl- -girl- is offline
New Member
 
Join Date: Apr 2008
Posts: 11
-girl- is on a distinguished road

Re: ASAP!!!! connect MS SQL Server 2005 to MFC Dialog app


thanx.... but the problem is, the dialog based option did not ask for the databse support... this is the problem...
  #5  
Old 30-Apr-2008, 23:06
Jana Jana is offline
New Member
 
Join Date: Apr 2008
Posts: 10
Jana is on a distinguished road

Re: ASAP!!!! connect MS SQL Server 2005 to MFC Dialog app


hi there,
I think you are clicking the finish button at the beginning. When you keep on pressing Next instead of clicking Finish, you will get to the dialog where you can enter the database information.

Check it out!!!!
  #6  
Old 01-May-2008, 00:02
-girl- -girl- is offline
New Member
 
Join Date: Apr 2008
Posts: 11
-girl- is on a distinguished road

Re: ASAP!!!! connect MS SQL Server 2005 to MFC Dialog app


hey there Jana,

i already click next, and i choose the dialog based type...
however, the database support are not shown... as in the dialog for me to choose which database support... However, the single document type and the multiple document type does have the database support.. except for the dialog based type...
  #7  
Old 01-May-2008, 00:32
Jana Jana is offline
New Member
 
Join Date: Apr 2008
Posts: 10
Jana is on a distinguished road

Re: ASAP!!!! connect MS SQL Server 2005 to MFC Dialog app


Oh...yeah you are correct....This problem gives me an answer for me not being able to use the database option...bcoz my existing project was made on dialog based application...

I'm not in a capacity to answer you, But will do my research and will get back to you if I come across any solution...Meanwhile there r others who knows better so try ur luck.....

There must b a reason why dialog based mfc application does not support database in the wizard......
  #8  
Old 01-May-2008, 03:17
-girl- -girl- is offline
New Member
 
Join Date: Apr 2008
Posts: 11
-girl- is on a distinguished road

Re: ASAP!!!! connect MS SQL Server 2005 to MFC Dialog app


hey jana,

thanx... I have been trying to find the solution to these problems, but to no avail... but i will try to search for it again.. keep ourselves updated to these problems ya...

cheers,
-girl-
  #9  
Old 01-May-2008, 18:50
rvicta rvicta is offline
New Member
 
Join Date: Mar 2008
Posts: 7
rvicta is on a distinguished road

Re: ASAP!!!! connect MS SQL Server 2005 to MFC Dialog app


What about adding the ADO ActiveX control to your dialog? You can get at your SQL Server that way. Or you can #import ADO into you dialog application.
  #10  
Old 01-May-2008, 20:41
-girl- -girl- is offline
New Member
 
Join Date: Apr 2008
Posts: 11
-girl- is on a distinguished road

Re: ASAP!!!! connect MS SQL Server 2005 to MFC Dialog app


hey rvicta,

hmm.. that is what i thought so... but im not sure how to start and how to do it... bcoz im really new to MFC and ADO or ODBC stuffs...

could u help me?
 
 

Recent GIDBlogFirst week of IA training by crystalattice

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Named virtual host not working Johnnyrotton Apache Web Server Forum 4 04-Sep-2007 20:32
Develop a simple chat application consisting of a client and a server. HELP MEEEEEEE elcrazy CPP / C++ Forum 1 11-Mar-2007 21:42
Microsoft SQL Server :: SQL Server message 241, state 1, severity 16 lyuboe MySQL / PHP Forum 0 11-May-2005 04:31
Apache2 config issues monev Apache Web Server Forum 2 28-Jun-2004 06:19
Can't view pages from another machine on the Intranet aevans Apache Web Server Forum 9 14-May-2004 02:26

Network Sites: GIDNetwork · GIDWebHosts · GIDSearch · Learning Journal by J de Silva, The

All times are GMT -6. The time now is 04:33.


vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.