PayDirt

How many of you out there have to write LotusScript  code to access MS SQL Server?  Lucky for me, I get to do it all the time.  Since I'm in a Windows-based environment, I tend to use 'ado' objects to do my connecting.  One of the advantages of using ado is that there are thousands of VB examples of connecting to SQL Server.  So, I started by simply copying and pasting those examples into my LotusScript and viola....Error messages!  But, most of those errors were because I hadn't defined all of those constants that VB uses.  Things like 'adCmdText'.  Well, rather than define those over and over, here's a quick little tip.

Find the file called 'adovbs.inc'  It's usually located in the '\\Program Files\Common Files\System\ado' directory.  Open it with Notepad, copy it, paste it into a new script library and save the library.  (I save mine as adovbs.inc.)  Now, simply "Use" that script library and you never have to worry about defining those VB constants ever again.

If you ever have any other questions about connecting to SQL Server, drop me a line, I'd be happy to help where I can.  Then, you too, can be writing things like "SELECT * FROM Users WHERE clue >0" and get empty result sets.

Have fun!

 Well, vacation's over.  I'm back in the office.  But, I do have to ask, can time spent with family and in-laws really be counted as "vacation"?  In a sense, I guess it could, because it means I wasn't here.  But, what I really need is some time to let the stress levels in my body subside.  Spending time with family and in-laws doesn't help much there.  OK, at least with my family and my in-laws.  Combine that with the constant barrage of emails from work (curse you RIM and your Blackberries too!) and it's almost like I never even took time off.  However, it all counts as PTO on the timesheet.  Next vacation I take is going to be somewhere with no cellular service and no high-speed access available. 

Having a degree in  mathematics and being a general, all-around geek,  I feel compelled to wish everyone a Happy Pi Day.  March 14th.

My much needed vacation starts tomorrow!!!