Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Sebastian Dammark 583 posts 1407 karma points
    May 11, 2015 @ 15:56
    Sebastian Dammark
    0

    Error validating the Data source: ExecuteReader: CommandText property has not been initialized

    I've donwloaded version 3.1.1 and the latest Umbraco DataProvider.

    The umbraco solution is latest.

    When I try to connect to another SQL server, hosted on RackSpace, I get the following error

    Error validating the Data source: ExecuteReader: CommandText property has not been initialized

    I can connect to the SQL server from a local machine through Management Studio, without any problems, with the same credentials.

    Any ideas ?

  • Sebastian Dammark 583 posts 1407 karma points
    May 11, 2015 @ 16:44
    Sebastian Dammark
    0

    I think I figured it out.

    The Umbraco DataProvider only works in PRO mode.

  • Richard Soeteman 4054 posts 12927 karma points MVP 2x
    May 12, 2015 @ 07:45
    Richard Soeteman
    0

    Hi Sebastian,

    Indeed but you should not see the import provider option without a license enabled. Did it show up in your environment?

    Best,

    Richard

  • Sebastian Dammark 583 posts 1407 karma points
    May 12, 2015 @ 13:44
    Sebastian Dammark
    0

    No it didn't. It was my mistake.
    But I've run into another problem.

    I have an import where I use the Umbraco DataProvider and a Child Definition.
    The import is totally about 1000 records, but it fails after a while.

    The remote server running fine without any problems

    This is what the log says:
    An error occurred with the scheduled publishing. The base url used in the request was: http://www.dynaudio.com:80/umbraco/, see http://our.umbraco.org/documentation/Using-Umbraco/Config-files/umbracoSettings/#ScheduledTasks documentation for details on setting a baseUrl if this is in error System.Net.WebException: The remote server returned an error: (503) Server Unavailable. at System.Net.WebClient.UploadDataInternal(Uri address, String method, Byte[] data, WebRequest& request) at System.Net.WebClient.UploadString(Uri address, String method, String data) at System.Net.WebClient.UploadString(String address, String data) at Umbraco.Web.Scheduling.ScheduledPublishing.Run() 

  • Sebastian Dammark 583 posts 1407 karma points
    May 12, 2015 @ 14:29
    Sebastian Dammark
    0

    Now I've tried to movethe source database to the same server as the destination database.

    But it doesn't make a difference.

    Still the same error

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies