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 581 posts 1385 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 581 posts 1385 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 4035 posts 12842 karma points MVP
    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 581 posts 1385 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 581 posts 1385 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

Please Sign in or register to post replies

Write your reply to:

Draft