ExamGuru IT/.Net Guru : Creating a scaled down CRM on microsoft.public.dotnet.framework.odbcnet

.NETGURU

Creating a scaled down CRM

Messages

Related Types

This message was discovered on microsoft.public.dotnet.framework.odbcnet.

Steven Johnson

Hello, I am creating an Outlook 2003 based CRM for my organization and would
like to model the approach after Outlook BCM. Unlike BCM, this CRM will be
accessible throughout my company (20+ users).

First, I'll be creating a MSDE SQL Database on my SBS 2003 server and then
I'd like to customize an Exchange Public Folder (containing Contacts) to
pull extra data from the MSDE. I will create custom forms (public folder
wide) that link to this external datasource. The external datasource will
have to use the Contact's unique ID to perform lookups, I looked at the
accessible schema for outlook contacts but cannot figure out which field is
THE unique ID (maybe its a GUID) that the queries will reference. Can anyone
help?

Also, what tools (Visual Studio.Net?) do you suggest I use to create the new
outlook forms that can access a server based MSDE (with network listening
enabled) Has anyone done this? Any leads?

I've done research and found articles about "ado" ".net" and "com" kinda
stuff, what connection methods do you suggest.

Thanks,
Steven

Reply to this message...

eWolverine

1) Since you have SBS 2003, use SQL Server, not MSDE. My customer purchased
SBS 2003 and got SQL Server included. No limitations.

2) There are 2 billion integers (signed) available in the integer datatype
for .NET, so GUIDs are not necessary for unique IDs, unless you really want
them.

3) Use Visual Studio.NET and ADO.NET.

4) Make sure you use parameterized SQL.

"Steven Johnson" <Click here to reveal e-mail address> wrote in message
news:#Click here to reveal e-mail address...
> Hello, I am creating an Outlook 2003 based CRM for my organization and
would
[Original message clipped]

Reply to this message...

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification