Groups | Blog | Home
all groups > sql server odbc > may 2005 >

sql server odbc : New to SQL, Problem setting up "Data Sources (ODBC)"


Corey Cooper
5/9/2005 11:01:27 PM
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
5/10/2005 6:43:24 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%\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@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden


[quoted text, click to view]

Corey Cooper
5/11/2005 1:24:20 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.

[quoted text, click to view]

Cindy Winegarden
5/11/2005 9:00:16 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


[quoted text, click to view]

AddThis Social Bookmark Button