How can we help you today? How can we help you today?

ExecuteReader: CommandText property has not been initialized

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?
elstx
0

Comments

11 comments

  • 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
    0
  • 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!
    Brian Donahue
    0
  • 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.
    elstx
    0
  • 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
    Brian Donahue
    0
  • 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.
    chris sampson
    0
  • 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
    elstx
    0
  • Neil Davidson
    Hi,

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

    - Neil
    Neil Davidson
    0
  • elstx
    sqldatacomp.exe /s1: esmith-g40 /s2: esmith-g40 /db1: hercules /db2: herculessite1
    elstx
    0
  • 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
    Neil Davidson
    0
  • elstx
    That was the issue, user error.
    Thanks for the assistance.
    elstx
    0
  • Neil Davidson
    No such thing as user error - poor error messages on our part.
    Neil Davidson
    0

Add comment

Please sign in to leave a comment.