OPENDATASOURCE to another database
Last Post 04-12-2013 05:57 AM by Ryan Bakerink. 10 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Not Resolved
hichamUser is Offline
wading in the water
wading in the water
Posts:21
Avatar

--
04-11-2013 03:14 AM

    Gents,
    I have a dynamic form field (combobox) and I want to fill the combo box with data from another database (not the database of the dnn website), I have the following query:
    select guid as QuestionOptionValue, Naam as QuestionOption from opendatasource ('SQLNCLI','Data Source=srvrname;Database=dbname;User ID=usrlogin;Password=pswrd').[dbname].[dbo].[Tabelname]
    where guid ='some value'
    the query in host / sql works well, but in the combobox field not.
    what am I doing wrong?


    Thanks,
    Hicham.


     

    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    04-11-2013 05:02 AM
    Hello Hicham,

    Dynamic Form fields doesn't seem to support the OpenDataSource technique in SQL.

    If you have an external database that you need to connect your form to, you'll need to use the SQL Data Provide to override the default DNN Database.

    What type of Database is the one that you're attempting to connect to? Is it on the same server?

    Please let me know.

    Thanks,

    Ryan
    hichamUser is Offline
    wading in the water
    wading in the water
    Posts:21
    Avatar

    --
    04-11-2013 05:47 AM
    Hi Ryan,

    2 databases are in the same server, i tried another provider 'SQLOLEDB' and it's works, but when I select an item from the combobox, by postback, the value of combobox goes back to the first value 'select a value'.
    Is this a configuration issue of the combobox? or the module?

    Thanks,
    Hicham.
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    04-11-2013 05:54 AM
    Hello Hicham,

    If both db's are on the same server, try accessing the other database by name:

    Lets say these are the names of your two databases:

    1.) customer
    2.) dnn

    On your DNN site you should be able to access the customer database by the following format:

    [customer].[tableName] or [customer].[dbo].[tablename]

    Let me know if you can gain access to the other database using this method.

    Thanks,

    Ryan

    I
    hichamUser is Offline
    wading in the water
    wading in the water
    Posts:21
    Avatar

    --
    04-11-2013 06:04 AM
    Hi Ryan,

    I have that tried but dont work, because 2 different user credentials for 2 db.
    I have now data in the combobox but have the problem (see my previous comment), how can i fix it?

    Thanks,
    Hicham.
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    04-11-2013 06:15 AM
    Hello Hicham,

    Then you'll need to use the SQL Data Provider an configure the External Connection string to your other database under Module Configuration -> SQL Data Provider in Dynamic Forms.

    Please let me know if you have any questions.

    Thanks,

    Ryan
    hichamUser is Offline
    wading in the water
    wading in the water
    Posts:21
    Avatar

    --
    04-11-2013 11:24 PM
    Hi Ryan,
    when I select an item from the combobox, by postback, the value of combobox goes back to the first value 'select a value'.
    Is this a configuration issue of the combobox? or the module?

    Thanks,
    Hicham.
    hichamUser is Offline
    wading in the water
    wading in the water
    Posts:21
    Avatar

    --
    04-12-2013 12:19 AM

    Hi Ryan,
    I have no Module Configuration -> SQL Data Provider, I've Initial SQL Rendering / Bind, can I set the external connection setting there? And how to fill combobox?

    Thanks,
    Hicham


     


     

    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    04-12-2013 05:00 AM
    Hello Hicham,

    If you're not on Dynamic Forms 4.1.4(latest version) then this option won't be available to you. Unfortunately, you won't be able to use an Initial SQL bind to populate your combo box.

    You may look into using a Question Event - Set Default value: this section allows you to set a value and possibly use an External Connection string.

    Let me know if this option is available for you.

    Thanks,

    Ryan
    hichamUser is Offline
    wading in the water
    wading in the water
    Posts:21
    Avatar

    --
    04-12-2013 05:51 AM
    Hi Ryan,
    my current version is 3.40.50.
    The set question default option gives the posibility to enable sql as a default value (Select count(*) As DefaultValue from users).

    Is there still a possibility to allow the combo box to change items, which is not the case now.
    I have now filled combobox with data, but that would not change the index.
    I choose another item -> postback -> go back to the initial value (- select a value -).
    Plz Help!
    Thanks,
    Hicham.
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    04-12-2013 05:57 AM
    Hello Hicham,

    There are several features in Dynamic Forms 4.1.4 that will assist you with completing this task. However these features aren't available in Dynamic Forms 3.4. I would recommend upgrading to Dynamic Forms 4.1.4 so you can have the stablest version of DF and have access to the latest available features.

    In your case, you'll need to use the SQL Data Provider option under Module Configuration in Dynamic Forms 4.1.4 to configure your External Connection String for your entire form.

    You can purchase Dynamic Forms from here: http://www.datasprings.com/DynamicForms

    Please let me know if you have any questions.

    Thanks,

    Ryan


    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi