MS SQL Server ODBC - New to SQL, Problem setting up "Data Sources (ODBC)"

Author

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

Corey Cooper

2005-05-10, 3:23 am

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

Cindy Winegarden

2005-05-10, 8:23 pm

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%\system3
2\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@msn
.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden

"Corey Cooper" <CoreyC at InnovativeDesign dot com> wrote in message
news:u%23YF1WSVFHA.2768@tk2msftngp13.phx.gbl...
> 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
>
>

Corey Cooper

2005-05-11, 3:23 am

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@msn
.com> wrote in message
news:u93K2TbVFHA.2520@TK2MSFTNGP09.phx.gbl...
> 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%\system3
2\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@msn
.com www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
>
> "Corey Cooper" <CoreyC at InnovativeDesign dot com> wrote in message
> news:u%23YF1WSVFHA.2768@tk2msftngp13.phx.gbl...
for[color=darkred]
the[color=darkred]
installation[color=d
arkred]
bigger[color=darkred
]
>
>

Cindy Winegarden

2005-05-11, 9:23 am

They should already be on the machines.

--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden

"Corey Cooper" <CoreyC at InnovativeDesign dot com> wrote in message
news:e4ojWLgVFHA.2128@TK2MSFTNGP15.phx.gbl...
> The other part of that question, is what is the correct way to
> 'distribute'
> the odbc drivers for MS SQL Server?

Sponsored Links