How to link database using vc?

Hello all:
I want to program a code about database using vc,I want to put the database
in the server and the application is put in the local PC.I want to know how
to link the database,and how to link automatically with code? thanks


0
fbjlt (155)
8/14/2005 12:43:27 AM
vc.mfc 33608 articles. 0 followers. Follow

2 Replies
441 Views

Similar Articles

[PageSpeed] 7

Your question seems very general and far-reaching!  I would suggest you start with using the MFC 
class CRecordset, which uses ODBC to connect using a Data Source Name (DSN) that is defined for your 
database.

"Lee Tow" <fbjlt@pub3.fz.fj.cn> wrote in message news:OQt4jlGoFHA.1204@tk2msftngp13.phx.gbl...
> Hello all:
> I want to program a code about database using vc,I want to put the database
> in the server and the application is put in the local PC.I want to know how
> to link the database,and how to link automatically with code? thanks
>
> 


0
ScotB (233)
8/14/2005 2:17:48 PM
>>Hello all:
>>I want to program a code about database using vc,I want to put the database
>>in the server and the application is put in the local PC.I want to know how
>>to link the database,and how to link automatically with code? thanks

Search the MSDN help for "database tutorial".

-- 
Scott McPhillips [VC++ MVP]

0
Scott
8/14/2005 8:31:31 PM
Reply:

Similar Artilces:

Why does outlook 2007 create archive2.pst and how do I get it to only use archive.pst
Hi, I am wondering why outlook 2007 has suddenly created an archive2.pst. The problem is that now I have 2 "Archive Folders" in my folder list. I'd prefer to have the archive as one file. archive.pst is less that 1GB in size, so I can't imagine that would be the issue. Thanks for your help!! Perhaps some one has changed the archive options and directed at a new archive pst? "Jim" <jimhub@gmail.com> wrote in message news:1189159845.353387.55050@g4g2000hsf.googlegroups.com... > Hi, > > I am wondering why outlook 2007 has suddenly created an archi...

Which solution to use?
I've no working experience with high availability scenarios but am a long time SQL Server user. I need to look at an option for work. Log shipping? Replication? Mirroring? Other? This will be SQL 2005. The DB/application is not hugely busy... maybe 30+ users using it for customers, invoicing, etc. Some of the procedures are quite complex though with heavy usage of transactions. Downtime is not fatal but needs to be limited to as little as possible should something happen. The idea would be to switch to server B, switch a config setting in the application and get back ...

Utility to convert Borland to VC++?
I've downloaded source code in Borland C++ 5.02 (MSWLogo) which I would like to make some small changes to. Is there anything around that would be able to convert it to VC++ 6? Thanks --------------------------------------- What could possibly go wrong? ...

VC IDE 'go to definition' doesn't work
Hello and thanks for trying ti help, This problem has been driving me nuts, the 'go to definition' item in the context menu in .cpp files always says "symbol 'symbol' undefined". It will find something defined in MFC, but IT WONT FIND ANYTHING DEFINED IN MY PROJECT. Yes I have deleted the .clw file and have rebuilt and run, what else could be causing this problem??? I tried posting this in the vc.ide.general newsgroup a few weeks ago. Thanks, Ivan "Ivan Starr" <ivan@ivanstarr.com> wrote in message news:%23l3ANp9oDHA.2528@TK2MSFTNGP12.phx.g...

The data at the root level is invalid. Line 1, position 2. -- using LoadXML
I've discovered I need to use LoadXML instead of Load for an xml string versus an xml file. HOWEVER, I get the above message when .net goes to load the string. The string comes from an xmlDoc.OuterXML save resulting in: <?xml version="1.0"?> <WorkFlow> etc., etc. So, when I save this xmlDoc.outerxml to a database field, do I need to remove that first? If so, wouldn't it not work when I then load the string as xml again? Also, I can't figure out how to delete that particular node... Any clues appreciated...as always. Thanks, Kathy It works for me: s...

How do I use a Publisher letterhead template that I created
I just created some letterhead using Publisher and have saved it in my C drive. I now want to use this template to write some letters. How do I do this? What version Publisher? Did you save it as a template? In 2000, File, new, when the catalog opens, click templates on the bottom of the page. In 2003, file, new, expand templates, click My Templates. -- Mary Sauer MS MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "GuatemalaPete" <GuatemalaPete@discussions.microsoft.com> wrote in message news:CCAF09C4-B7E1-4FF9-919C-2E99A40551E9@micr...

updating macros and links
How do I get macros and hyperlinks to update when I change the name of a worlbook? I am inexperienced with v.b.a. but I have created a workbook that I want to change each day to log productivity. It has macros and hyperlinks that stop working when the name's changed. How do I make it so the macros and hyperlinks work, when given a new name? Instruct on Installation of modules please. Thanks, Lane __________________ Thanks, Lane --- Message posted from http://www.ExcelForum.com/ ...

Useless identity database? #2
Hi, my "Documents/Microsoft User Data/Office X Identities/Main Identity/Database" has 300KB, the Office 2008 one 22MB. And I didn't even install Entourage! Can that file go in the trash? -- Tobias Weber ...

Linking tables with forms
Hi, I'm still a relative beginner with Access, but I've not done too bad :P However, I'm finding one thing very confusing. Here's the scenario: I am writing a multi table db, and I need to link them all up via an index, so one form can easily display data from the others. For example: I need to display a name, located from one table, and then in a seperate table, store values from yet other tables. For some reason, I am finding this a little bit of a pain to do - I can't seem to get the values loaded correctly. It's no problem if they are simply from a table, but t...

Selective Link to Picture #2
I want to show a linked (not embedded) picture based on entry in a cell. This way, I can keep the excel spreadsheet light. Any help? Insert|Hyperlink and point to your picture file or use the worksheet =hyperlink() worksheet function: =HYPERLINK("file:////c:/my pictures/myfolder/somepict.jpg") I think if you use the =hyperlink() worksheet function, your workbook will be "lighter". mloffler@simmax.com wrote: > > I want to show a linked (not embedded) picture based on entry in a > cell. > This way, I can keep the excel spreadsheet light. > > Any he...

Exchange 2003 run database defragment show [Out of database page buffers]
run eseutil/p command on yesterday, after less than 24 hours, we found the error message "Operation terminated with error -1014 (JET_errorOut ofBuffer, Out of database page buffers) after 847,402.35 seconds" appear. ...

What function would I use?
I am making a spreadsheet for my work. In this spreadsheet I enter data such as the name of a customer, additional products they may have purchased, and the price paid for the additional product. I have to list all customers on this sheet wether or not they bought any of the additional products. Then I have to do a second sheet only for those who bought the additional products. Is there someway to make the spread sheet go through itself and pick out those who bought the additional products and then transpose those onto the second sheet. Thank you in advance for any help that you ca...

using outlook in a network
I would like to set up a peer to peer network using microsoft XP. I would like the user of computer A to be able to view Outlook on computer B. How do I go about setting this up? parehir@yahoo.com wrote: > I would like to set up a peer to peer network using > microsoft XP. I would like the user of computer A to be > able to view Outlook on computer B. How do I go about > setting this up? Move the pst on computer B to a shared folder and just point Outlook on computer A at it. One point - only ONE computer will be able to open and use the pst at any one time. HTH ...

Cannot Unload Assemblies in XSLT Using Script: patch??
Dear all Anyone knows that this problem has been patched? Is this a .NET 1.1 or 1.0 problem PRB: Cannot Unload Assemblies That You Create and Load by Using Script in XSL http://support.microsoft.com/default.aspx?scid=kb;EN-US;316775 Sorry. It's impossible in .NET v.1 to unload assembly once it was loaded. And scripts are always compiled to assemblies. It's unlikely that this problem will be solved in V.2 as well. You can keep XslTransform object in separete AppDomain and unload this AddDomain time to time. -- Sergey ------- This posting is provided "AS IS" with no warran...

Access Database to Track Employee Times
Yesterday I had posted a question to see if anyone had an Access database that tracks employee times, very similar to a time clock. What I would like is to have a form that has all of the buttons on (Login, Break 1 Out, Break 1 In, Lunch, etc.) and when the user clicks these buttons, the time will be logged into a table. I would then like to report ONLY the times a person does not meet the rules of logging in, break times, etc. For example, if an employee clicks the login button anytime after 8:05 AM, I would like that time to first be copied to the master time table, and then...

Query using date and time in seperate fields
I am having problems generating a query to find records between a start date and time and a finish date and time. As the table I am querying stores the two valuse in seperate fields, using BETWEEN is not working. The table I am querying, called imt_log, stores the date and time in seperate fields. The fields are called imt_log.date and imt_log.time Example: Find records from 7-Jan-2008 08:00:00 to 14-Jan-2008 07:59:59 Do I need to create some Vb code or is it possible to do it with a nested query. Thanks in advance. If your fields are datetime datatype then use a calculated field like ...

Filter on subform using unbound text box
Hello Forum Members: I'd like to have some help on the following codes on the Access 2000: On the Form Header, I have an unbound text box called FindWord, in which I type some words to search. The code below works on the main form. {code} Private Sub cmdFilter_Click() Dim strWhere As String Dim lngLen As Long If Not IsNull(Me.FindWord) Then strWhere = strWhere & "([English] Like ""*" & Me.FindWord & "*"") AND " End If lngLen = Len(strWhere) - 5 If lngLen <= 0 Then MsgBox "Nothing is speci...

Can a Vlookup be used when creating a chart
1. Is it possible? 2. where would it be entered? the values line? 1. Probably 2. Not enough detail to provide even a guess. Gord Dibben MS Excel MVP On Tue, 26 Jan 2010 11:23:02 -0800, Confusicous <Confusicous@discussions.microsoft.com> wrote: >1. Is it possible? >2. where would it be entered? the values line? Here is my data: 2010 spreadsheet = Entities = A18:A45 Numbers = N18:N45 2009 spreadsheet= Entities A18:A41 Numbers = N18:N41 The reason I would like to have the Vlookup is because new data was entered in 2010 but if I just enter the ...

Where to find AdventureWorks database samples
Does anybody know where I can find the sample Adventureworks database? I need the most recent one for sql server 2008 sp1. Try this link http://www.codeplex.com/MSFTDBProdSamples Dave Ballantyne http://sqlblogcasts.com/blogs/sqlandthelike/ Andy B. wrote: > Does anybody know where I can find the sample Adventureworks database? I > need the most recent one for sql server 2008 sp1. > > Just what I needed. "Dave Ballantyne" <symlink@no5p323mmer> wrote in message news:%23EzXe6bxKHA.3560@TK2MSFTNGP02.phx.gbl... > Try this link > &g...

FTP
This may be better posted in a developer's forum, but I'll put it here because I'm using it in a script, and I hope to get an answer that doesn't require 10 years experience in DotNet development... I've been using the Win32 COM object, Shell, to do FTP transfers, though I must admit I barely understand enough of it to use it. It seems like a better solution than an external call to the OS native FTP, but I have hit a snag with the initiation of the server connection in an environment that includes a FTP proxy server. The object is instantiated with: ...

Filegroup restore used to refresh database copy
I have TestDB1 comprised of 5 filegroups, which I've completed full/log backups to restore as TestDB2. When data changes within one filegroup on TestDB1, I've taken a diff' + tlog backup and tried to use it to restore on TestDB2 so that same filegroup would be essentially refreshed. My execution sequence uses the last full, last diff', and tlog from TestDB1 but this doesn't work? Why? Is there a way to do this ? Thx. -CqlBoy What do you mean by doesn't work? Are you getting an error or different results than you expected. Please provide more detai...

What's wrong with using GOTO ?????
As a tool to move within code whats wrong with using goto to - as an example - 3 buttons on a form, 1st button is clicked and the code sets a textbox value to say 1, then exit sub. Clicking one of the other buttons calls the button 1 code to run and at the start of the is a case to determine wich button was pressed and then using GOTO go to a portion of the code related to that action, and so on for each button. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/201003/1 "trevorC via AccessMonster.com" <u44860@uwe>...

How to send out email blasts using an .html file
Hello, I've been setting up email blasts using MS Word and then going Tools / Letters & mailings / Mail Merge but I am limited to what I can do in MS Word in terms of formatting. So, I've just created my first .html page in Dreamweaver that I want to send out but I don't know how to now merge this into Outlook to send out. Can someone please tell me how to get this started? I need to know how to get the greeting line, etc in my .html document - do I just go back into MS Word and import the .html file and then follow the same steps? Or do I need MS Word at all? Than...

How to clean one book using data from another?
Hello, I'm an intern and a relative new user of Excel. I've used it before, but only for simple sorting. Here's my problem: I am using Excel '03 to sort e-mail address lists. I have two separate files, one with names, email addresses, and postal addresses, and a "cleaned" list with all non-working e-mail addresses removed. What I want to know is, is there any way to use the second list to clean the first list of all the people whose e-mail addresses no longer work, without manually searching through them one row at a time? I have nearly 10,000 names on one an...

Using combo box(s) to create a query
I have a two part question as follows: 1st part: I am wanting to create a query that is driven by the user selecting a value from a combo box on a form. the combo box on the form is called "TypeofIssueID" and it's control source is "TypeofIssueID" in a table called"tblEngineering". it would be nice if when the user selects the value he wants to query from the combo box the query is automatically generated at that point. the user wouldn't have to select a "do this now" button. 2nd part: the second part to this would be adding mor...