What do you do when you see this error in SQL Server 2005?

Look further down the error message and you may notice something like this... "Could not set \Package\Job.Disable value to false"

This is usually caused by the dynamic linked library (dll) dts.dll becoming unregistered. Whether due to an in-place upgrade or service pack install, even some hot fixes may cause this. Never fear though - crack open a DOS prompt or Start->Run and issue the following command

regsvr32 dts.dll

You should receive a message from the OS stating that the dll was successfully registered. Try to run your job again and you should find that it runs this time.

Progress!

I must say I'm a bit perturbed by what I found in researching this problem. I also need to make a clarification in my test code, I over simplified the simple query. If you were to run that query, after setting up the table, you would find that it does indeed work and you'd be saying "that guy's crazy, it works fine!" The problem comes in when records are eliminated due to aggregation, GROUP BY and such.

The following two links will be of help.

Adobe forum where it's being discussed:
http://forums.adobe.com/message/2631903

More importantly, the bug tracker entry.
http://cfbugs.adobe.com/cfbugreport/flexbugui/cfbugtracker/main.html#bugId=80384

Notice how they list this as a BENIGN problem and that there is a work around. Benign my ass! I urge everyone to go to the bug tracker and VOTE for this to be fixed.

So, for the work around? One acceptable temporary (IMO) solution is to set up a JDBC DSN to connect to your SQL Server database. In my case I needed a 2008 JDBC driver.

This brings me to another sore point with information on the internet. Far too often I've seen "helpful" people post solutions to problems only to gloss over 90% of the information used to FIX it. Not everyone is born with the knowledge to construct a JDBC connection string, or the ability to pull a driver class out of their ass. So here's my contribution to the half-assed help pile.

This will help those using Coldfusion 9.0

Microsoft JDBC 2.0 and 3.0 driver links.

MS JDBC 3.0 http://www.microsoft.com/downloads/details.aspx?FamilyID=%20a737000d-68d0-4531-b65d-da0f2a735707&displaylang=en#filelist
MS JDBC 2.0 http://www.microsoft.com/downloads/en/confirmation.aspx?familyId=99b21b65-e98f-4a61-b811-19912601fdc9&displayLang=en

1. Download one of those two, which ever you want. I'm using 3.0
2. Extract to a directory, any will do we're going to move the files when we're done anyway
3. Now, if you're using 3.0 you will find, buried in the directory structure that just extracted, two files
   • sqljdbc.jar
   • sqljdbc4.jar
   Only use ONE of these, for CF 9 you will want to use sqljdbc4.jar
4. Copy the sqljdbc4.jar to
   • cf_root/cfusion/lib (server configuration)
   • cf_webapp_root/WEB-INF/cfusion/lib (multiserver or J2EE configuration).
   I'm using Multiserver for this example so I put it in
   • "Z:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\lib\"
5. RESTART COLDFUSION

Now, you will need to log in to the CF Administrator and create a new datasource.

1. Give it a name,
2. and then select "OTHER" from the drop down list
3. and click ADD
4. Now for a JDBC URL, if you're super leet you don't need me to tell you, but for those "lamers" out there here's the JDBC URL that should get you by.
   jdbc:sqlserver://server name;databaseName=database name
   If you happen to be running multiple instances of SQL Server or are on a different port then this should work for you
   jdbc:sqlserver://server name/instance name:port number;databaseName=database name
5. Driver Class will be
   com.microsoft.sqlserver.jdbc.SQLServerDriver
6. Driver Name (you can name it whatever you want) SQL Server 2008 JDBC
7. Username: database user name
8. Password: database user password

The driver works great so far. If I run into any idiosyncrasies I'll post about it!

I've run into an interesting problem on one of our CF 9 servers. Here's the skinny, there's some code that looks like

Now this is obviously a much more simplified (not to mention completely different data/tables/etc from what the real system is doing) this is just an example.

This code works as you would expect, the query executes and returns some data, the IF block does its thing and all is well, right? Unless the query doesn't return anything. Now in past versions of CF this has never been a problem, an empty query object is returned and again, all is well.

The problem I've encountered on one of our CF 9 servers is this: If the query returns nothing, the IF block fails stating that recordcount is undefined in qryInfo. If I dump qryInfo, the same error: "qryInfo is undefined"

I created some test code and placed it on another CF 9 server in the center and it works as expected, no error, just an empty query object. How bizarre I say! The only difference I've been able to see is that one box (the one that flips out) is 64 bit, and the other (the one that plays nice) is 32 bit.

This warrants further testing and investigation. I'll keep you posted.

UPDATE:
Tested on another CF 9 x64 server and it works just fine. Maybe the install is borked?

Welcome to Version 1.103 of Loto's Character Workshop. In this version you will find the latest updates from DAoC 1.103

New in this version is the ability to disable the auto update feature, though I'm not sure why you would ever want to. To use this new feature, go to Options -> Settings and remove the check from the Auto Update on Startup box. You may then go to the Help -> Check for Updates menu to have the workshop check for updates and patch itself if there is one available.

Class/Balance Changes:

Nightshades

All Nightshade magical abilities will now base their damage and variance off of the Stealth skill.
The single-target casted damage spell has had its damage values adjusted:

Level 1 - Lesser Dusk Strike - 3s cast - 1500 range - 8 damage (Cold) - 2 power
Level 3 - Dusk Strike - 3s cast - 1500 range - 13 damage (Cold) - 3 power
Level 5 - Lesser Twilight Strike - 3s cast - 1500 range - 19 damage (Cold) - 4 power
Level 8 - Twilight Strike - 3s cast - 1500 range - 27 damage (Cold) - 5 power
Level 12 - Lesser Gloaming Strike - 3s cast - 1500 range - 37 damage (Cold) - 8 power
Level 16 - Gloaming Strike - 3s cast - 1500 range - 48 damage (Cold) - 10 power
Level 22 - Lesser Nocturnal Strike - 3s cast - 1500 range - 65 damage (Cold) - 13 power
Level 28 - Nocturnal Strike - 3s cast - 1500 range - 81 damage (Cold) - 17 power
Level 35 - Lesser Midnight Strike - 3s cast - 1500 range - 99 damage (Cold) - 22 power
Level 45 - Midnight Strike - 3s cast - 1500 range - 125 damage (Cold) - 29 power

The single-target instant damage spell has had its damage values adjusted:
Level 6 - Dart of Night - 0s cast / 20s recast - 700 range - 20 damage (Cold) - 4 power
Level 9 - Dagger of Night - 0s cast / 20s recast - 700 range - 27 damage (Cold) - 6 power
Level 13 - Knife of Night - 0s cast / 20s recast - 700 range - 38 damage (Cold) - 8 power
Level 18 - Stiletto of Night - 0s cast / 20s recast - 700 range - 50 damage (Cold) - 11 power
Level 24 - Arrow of Night - 0s cast / 20s recast - 700 range - 65 damage (Cold) - 15 power
Level 31 - Rapier of Night - 0s cast / 20s recast - 700 range - 83 damage (Cold) - 19 power
Level 39 - Spear of Night - 0s cast / 20s recast - 700 range - 102 damage (Cold) - 25 power
Level 48 - Lance of Night - 0s cast / 20s recast - 700 range - 125 damage (Cold) - 31 power

Ok, so maybe I'm obsessing a bit but I just couldn't help myself. I have created a... 1TB (yes that's terabyte) database on my home PC. Not only is the database itself 1TB but there is also a 500GB log file and 500GB tempdb (all pre-grown) to total 2TB of database goodness.

Now, why the madness you ask?

If you read the two previous posts, those probably have something to do with it. You see my web server ran out of space trying to do this little exercise so I had to change venue. To date I have generated permutations of strings from 1 to 6 characters in length to total a a staggering

2,238,976,116 rows of data. (yes that's billion with a B)

How long does a query take to execute? Oh, just a few milliseconds. The first query against the data took about 23 seconds, not bad considering this is on what is classified as a "home PC" sporting a quad core 2.8GHz processor with 8GB of RAM and a 7TB RAID 5 on 6 disks. After the query plan is cached, it takes merely the blink of an eye to return a word from the dictionary.

To populate this table took an ever increasing amount of time. The first strings of length 1 to 4 took from only a blink to just under 30 seconds. 5 characters took just over 9 minutes with 6 characters pushing 13 hours.

What's next? Why 7 character strings of course, that will put this at over 70 billion rows and pushing 600GB of data space.

One word of caution, if you decide to actually generate a dictionary, you will need loads of disk space. Let's do some math!

In order to calculate the number of permutations you need the follow information:

1. How large is your base set (alphabet in our case) for this example that I've laid out that number would be 36, 26 letters and 10 numbers
2. How long is the string you are constructing?

Knowing this information, we can plug this into the formula n^r where n = base set size and r = length of string to construct. You can see how this can get out of control quite quickly :)

Here is a list containing the number of permutations for a given string length from 1 to 10

1. 36
2. 1296
3. 46656
4. 1679616
5. 60466176
6. 2176782336
7. 78364164096
8. 2821109907456
9. 101559956668416
10. 3.65615844006298e+15 (big damn number)

Let's take this a step further. If we are going to store the permutations we need to know how much disk space we're going to need. In order to get a rough estimate let's assume we are going to store this as non-unicode data so 1 byte per character. That would give a result of 548,549,148,672 bytes (548 GB) to store all of the permutations of a 7 character string! How much for 10 you say?

3.65615844006298e+15 * 10 = 3.65615844006298e+16 bytes so that gives us 36.5 Petabytes :)

This brings us to the question, how long of a password is good enough to escape most brute force attacks? It depends on who your attacker is, but if you look at the data it would take quite awhile to produce let alone process a list of passwords longer than 6 characters. Keep in mind however that most dictionaries are just that, dictionaries containing all words in a given language so don't choose something that's in one! ever! and you might just be ok, then again...maybe not :)

Look no further than your very own DBMS. Utilizing some basic sets we can have the DBMS produce anything we ask. For this example I have created two tables as follows.

This table shall hold our alphabet (in case that wasn't totally obvious) I will be using A-Z and 0-9 as my alphabet.

and this table shall be our permanent storage of our generated dictionary.

That's all you need, right there, yep...that's it. OK OK I'll write the query for you too.

Execute that query and wait a few seconds and you will then have a complete list of every 3 alphanumeric character combination. Pretty neat eh?

Welcome to Version 1.102 of Loto's Character Workshop. In this version you will find the latest updates from DAoC 1.102.

The following changes have been added.

Class Race Combinations

• The Nightshade Class is now available to Celts.
• The Mauler Class is now available to Inconnu, Kobolds and Lurikeens.
• The Friar Class is now available to Highlanders and Avalonians.
• The Shaman Class is now available to Dwarves.

Bards

• A self-only Mezz Dampening Buff has been added to the Bard Nurture Specialization Line:
• Level 16 - Cadence of Musing - 4s cast / 20m duration - 10% Mezz Reduction - 10 power
• Level 26 - Cadence of Meditation - 4s cast / 20m duration - 25% Mezz Reduction - 16 power
• Level 35 - Cadence of Focus - 4s cast / 20m duration - 40% Mezz Reduction - 22 power
• Level 44 - Cadence of Concentration - 4s cast / 20m duration - 55% Mezz Reduction - 28 power

Hunters

• The following styles in the Spear Specialization Line have been adjusted as follows:
• Level 2 – Dazzling Spear – No Prerequisite – No Attack Bonus – No Defense Bonus – Medium Fatigue Cost – High Damage – No Effect
• Level 12 – Dismissal – No Prerequisite – No Attack Bonus – High Defense Bonus – Low Fatigue Cost – Low Damage – Detaunt
• Level 21 – Perforate – To Side of Target – Low Attack Bonus – Medium Defense Penalty – Medium Fatigue Cost – High Damage – Hindered (40%, 19s duration)
• Level 25 – Lunging Thrust – Lancer – Medium Attack Bonus – No Defense Bonus – Medium Fatigue Cost – High Damage – Slowed (21%, 19s duration)
• Level 29 – Raze – Stab – Medium Attack Bonus – No Defense Bonus – Low Fatigue Cost – High Damage – Bleeding

Valkyries

• The following styles in the Spear Specialization Line have been adjusted as follows:
• Level 2 – Dazzling Spear – No Prerequisite – No Attack Bonus – No Defense Bonus – Medium Fatigue Cost – High Damage – No Effect
• Level 12 – Dismissal – No Prerequisite – No Attack Bonus – High Defense Bonus – Low Fatigue Cost – Low Damage – Detaunt
• Level 21 – Perforate – To Side of Target – Low Attack Bonus – Medium Defense Penalty – Medium Fatigue Cost – High Damage – Hindered (40%, 19s duration)
• Level 25 – Lunging Thrust – Lancer – Medium Attack Bonus – No Defense Bonus – Medium Fatigue Cost – High Damage – Slowed (21%, 19s duration)
• Level 29 – Raze – Stab – Medium Attack Bonus – No Defense Bonus – Low Fatigue Cost – High Damage – Direct Damage (50 damage, Spirit)
• Level 32 – Windmill – No Prerequisite – Low Attack Bonus – No Defense Bonus – Low Fatigue Cost – Medium Damage – No Effect
• Level 41 – Roundhouse – Windmill – High Attack Bonus – Low Defense Penalty – High Fatigue Cost – High Damage – PBAOE Damage (200 damage, 250 radius, Crush)

Special Thanks to Seren for the detailed reports that facilitated these updates!

- Procs and Effects - Arcane Siphon is located under PvE Bonus Heal Group has been added to the Effect lists (Reactive, Charged, Offensive)

Replenish Power (Group) has been added to the Effect lists (Reactive, Charged, Offensive)

Self Melee and Magic Health Buffer has been added to the Effect lists (Reactive, Charged, Offensive) Replenish Power Over Time has been added to the Effect lists (Reactive, Charged, Offensive)

- Craft Bar Tool - Setup Craft Bar window will now only load spellcrafters in the drop box.

- Stats and Calculations - Duplicate stats where one stat resides in a 5th slot will now calculate correctly. For example if you have a pair of leggings with +15 Con imbued and their 5th slot bonus is also +15 Con, you will now see a total of 30 Con on the leggings.

Fixed a bug that prevented the Mythirian bonuses from showing up in some areas.

- Imports - Fixed the Kort's Import routine to only load those items that are marked as equipped. For example, if you have a Kort's template that has 3 rings on the Right Right slot and the 2nd one is marked as equipped, the Workshop will now correctly load ring #2 instead of the last ring (#3).