Author |
Topic |
-wing-
Starting Member
12 Posts |
Posted - 2006-11-17 : 12:07:29
|
It's me again guys. First let me say that I truly appreciate the knowledge that I see on this forum. Now on to my question.How can I use SQL Server to import the active accounts from our Exchange Server? Thanks.Everything I know I learned from the web. |
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
-wing-
Starting Member
12 Posts |
Posted - 2006-11-17 : 12:56:37
|
Thank you for the response. The link you had did help but ultimatley it was this link to got the answer for me. I got an errorServer: Msg 7321, Level 16, State 2, Line 1An error occurred while preparing a query for execution against OLE DB provider 'ADSDSOObject'. OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ICommandPrepare::Prepare returned 0x80040e14]. googled it and found the below link. It's a little rough but workable now.http://adsdsoobject.codebetter.com/blogs/brendan.tompkins/archive/2003/12/19/4746.aspxThanks for the lead :)Everything I know I learned from the web. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-11-17 : 13:08:47
|
http://www.codeproject.com/aspnet/LikeDataStores.aspI like the quote at the end of your postings. "Everything I know I learned from the web." A good practice in troubleshooting errors from SQL Server is to take that first line starting with "Server:" and post it into the Google search bar. You'll find answers pretty quickly to many of the errors. MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
-wing-
Starting Member
12 Posts |
Posted - 2006-11-17 : 16:38:16
|
Thank you very much Derrick. When I learned about google, I hardly ever hit news groups or forums unless I can't find it on the net somewhere. Most times, it's a combination of 2 or 3 sites that gives me the full answer of whatever I am searching for. I learned more about programming from the internet that anything that college tried to make stick in my head. :)Everything I know I learned from the web. |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-11-18 : 02:33:14
|
You need to be careful though - there is plenty of useless/bad/harmful code out there. SqlSpec - a fast, cheap, and comprehensive data dictionary generator forSQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
|
|
-wing-
Starting Member
12 Posts |
Posted - 2006-11-18 : 12:12:22
|
I appreciate the tip Jezemine. One thing I don't like to do is copy and paste code. I use the code that I find as an example and tweek it to what I need. Like I stated in my previous post, very rarely do I find the answer to my question on one site. It's generally a combination of two or more. I am sure I will be posting here again for some solutions or questions. This site seems to have a wealth of knowledge that a sponge like myself can suck up.Everything I know I learned from the web. |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-11-18 : 13:03:57
|
Here's an example of harmful code that I ran across the other day. It shows you how to "encrypt" connection strings using base64. DO NOT DO THIS! It's totally bogus as it's not a method of encryption at all. This guy would have done better just to keep quiet, as I am sure there are plenty of copy/pasters out there using this code... :) I admit, he does say it's not real encryption in the article. But why not do it right and use DPAPI or some such if you are going to all the trouble of writing an article??? http://www.dotnetbips.com/articles/displayarticle.aspx?id=254 SqlSpec - a fast, cheap, and comprehensive data dictionary generator forSQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
|
|
|