Re: New to SQL, Problem setting up "Data Sources (ODBC)"

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Thanks for the response. I'm working with Win 2K machines, and I'll look
for the file.

The other part of that question, is what is the correct way to 'distribute'
the odbc drivers for MS SQL Server?

I have several MFC books that talk about how to use CRecordset, and so that
became the way I decided to go. Since my app is relativly simple on the
database end of things, the MFC classes seemed to do everything I needed,
just lookup and display.

c.

"Cindy Winegarden" <cindy_winegarden@xxxxxxx> wrote in message
news:u93K2TbVFHA.2520@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Corey,
>
> You haven't said which OS you are using. Mine's in the Administrative
Tools
> section of the Control Panel. Alternatively (in XP at least) you can run
> %systemroot%\system32\odbcad32.exe .
>
> Since you're starting new code have you considered OLE DB? ODBC has been
> deprecated.
>
> --
> Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
> cindy_winegarden@xxxxxxx www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
>
> "Corey Cooper" <CoreyC at InnovativeDesign dot com> wrote in message
> news:u%23YF1WSVFHA.2768@xxxxxxxxxxxxxxxxxxxxxxx
> > I'm an old C/C++ programmer, but new to SQL and MS SQL Server.
> >
> > I'm writing an application in C++/MFC (6.0) that happens to need some
> > access
> > to data from an SQL Server. When installing Visual C++, it has option
for
> > installing database components and ODBC Drivers, which I did a while ago
> > when I installed VC. This sets up a program in the Control Panel called
> > "Data Sources (ODBC)", all well and good. However I wanted to do some
> > work
> > on my Laptop, and it doesn't have that control panel. I went through
the
> > procedure talked about in the "Sams Teach yourself Database Programming
> > with
> > Visual C++ 6.0" to add the ODBC drivers from the Visual C++
installation
> > disks, and it says that they are all already installed.
> >
> > All this is frustrating, and I need to get this resiolved, but the
bigger
> > question is; how do I load this on my Client's machine? Is this the
> > "Client
> > Tools" or "Drivers" that can be loaded from the SQL Server installation
> > disk? I don't have a 'clean' machine available to try it out.
> >
> > Corey
> >
> >
>
>


.



Relevant Pages

  • Re: Administering MSDE
    ... Thanks for posting in our newsgroup and also for Costas's input. ... SQL Server Web Data Administrator ... Installing Microsoft Windows Server Update Services 3.0 on Windows Small ... Installing WSUS 3.0 won't affect the SharePoint database. ...
    (microsoft.public.windows.server.sbs)
  • Re: Moving From ProTools to Linux? Good or bad?
    ... I'm just using the computer's sound card. ... You have to select "control panel" which brings up the Maudio application. ... the Lynx, all of my audio computer I/O hardware is either Firewire or USB, and I ... is how of installing software with this system. ...
    (rec.audio.pro)
  • Re: RESTORING CRASHED SITE WEBS
    ... Well, when installing Sharepoint, the installer did display a message ... I can't login using any existing accounts. ... >> access using Windows Security the account returned in the failed ... I put in the database server name and ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: RESTORING CRASHED SITE WEBS
    ... they are already there) before installing WSS and then to add them back ... >>> I have everything kind of restored but can't access the SQL ... I can't login using any existing accounts. ... I put in the database server name and ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Bug in Jet engine ?
    ... I would agree with Bill. ... >> installing anything it didn't, ... >> clean database), reinstalling latest MDAC and JET engine. ...
    (microsoft.public.data.ado)