ExecuteReader: CommandText property has not been initialized

elstx

I'm experiencing an issue with the command line data compare sample that was previously raised in this forum. The original solution was to upgrade, but I'm already running the latest version.

The result/error I'm seeing is:
Getting database 1 .
Getting database 2 .
Comparing databases
FAILED TO COMPARE DATABASES
ExecuteReader: CommandText property has not been initialized

I'm running SQL Data Compare Version 3.3.7.256.
I ran the database creation scripts.

Is there another step I have missed or corrective action I can take to make this work?

Brian Donahue

Hi,

Sorry I neglected your last post. I think there is a newer, unreleased patch for the SQLDataCompare.Engine that I can send that might fix it.

Can I send it to you in an email to the address that you're registered under with the bulletin board tomorrow?

Brian Donahue

Hi,

Apparently I can't send email to that address. Can you please send me an email to support@red-gate.com and I will reply to it with the patch attached!

elstx

Placed all the objects in the Red Gate SQL Bundle directory, rebooted machine, retried test:

Getting database 1 .
Getting database 2 .
Comparing databases
FAILED TO COMPARE DATABASES
The invoked member is not supported in a dynamic module.

Brian Donahue

The error that you get now can happen if you haven't set up the licensing (licenses.licx) file up correctly. Please have a look at the article about setting up licenses for Toolkit:

http://www.red-gate.com/messageboard/vi ... .php?t=491

chris sampson

Hi there,

If you have already activated you toolkit then you will not get prompted again to enter the licence information. Can you check to see if a Toolkit.lic file has been created? The existance of that ile will verify that everything is working OK.

elstx

There is a SQLToolkit.lic in C:\Program Files\Red Gate SQL Bundle.
I still get the same error:

Getting database 1 (local).
Getting database 2 (local).
Comparing databases
FAILED TO COMPARE DATABASES
ExecuteReader: CommandText property has not been initialized

Neil Davidson

Hi,

Can you tell me what parameters you're passing in to the command line sample please.

- Neil

elstx

sqldatacomp.exe /s1: esmith-g40 /s2: esmith-g40 /db1: hercules /db2: herculessite1

Neil Davidson

Can you try removing the spaces between the : and the parameters please, so the command becomes:

sqldatacomp.exe /s1:esmith-g40 /s2:esmith-g40 /db1:hercules /db2:herculessite1

elstx

That was the issue, user error.
Thanks for the assistance.

Neil Davidson

No such thing as user error - poor error messages on our part.