Open Forum

Expand all | Collapse all

Excel Refreshable Error - HELP - Initialization of Data source failed.

  • 1.  Excel Refreshable Error - HELP - Initialization of Data source failed.

    Posted 19 days ago
    Added a column to an existing refreshable report and now certain users/devices are not able to connect.  This would be the first time a refreshable Excel has been updated since installing year PR update.  I have checked everything and must be missing something simple.  Checked permissions on SQL server, file is saved to network share.

    GP 18.3.1200 (2020)
    Excel 2013 and 2019

    Error:

    Initialization of the data source failed.

    Checked the database server or contact your database administrator.  Mare sure the external database is available, and then try the operation again.  If you see this message again, created a new data source to connect to the database.

    Thanks
    Dedra

    #Technical
    #BIandReporting
    #GP2018and2018R2

    ​​​​​​

    ------------------------------
    Dedra Wagoner
    PC/Software Specialist
    Siemer Milling Company
    Teutopolis IL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Excel Refreshable Error - HELP - Initialization of Data source failed.

    GPUG ALL STAR
    Posted 19 days ago

    @Dedra Wagoner

     

    This is likely an issue with the ODBC address.  Did the server or instance name change?

     

    It would be looking for a 32-bit ODBC (you'll find what it is looking for in the Data Definition in Excel).  If that exactly-named ODBC does not exist on a machine then it can't connect and you'll have to create the ODBC source.

     

    Are you seeing where two users using the SAME machine get different results or is the issue really a difference in the machine?

     

    Please Remember to email support.desk@aislingdynamics.com
    for any support issues or questions not related to a particular project

    Thanks!!

    Kindest Regards,

    Jo deRuiter

    Business Applications Practice Manager

     at 

    Aisling Dynamics

    Phone: (770) 728-8083 Ext 1

    Mobile: (770) 906-4504

    Email: jo.deruiter@aislingdynamics.com

    HTTPS://WWW.AISLINGDYNAMICS.COM/

    FOR IMMEDIATE ASSISTANCE WITH SUPPORT ISSUES
    PLEASE EMAIL:
    SUPPORT.DESK@AISLINGDYNAMICS.COM

    OR CLICK THE LINK TO THE RIGHT

    Schedule a Meeting with Me

    Review Aisling Dynamics on Google

    This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. This message contains confidential information and is intended only for the individuals named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

     




    Academy - Online Interactive Learning from Experts


  • 3.  RE: Excel Refreshable Error - HELP - Initialization of Data source failed.

    Posted 19 days ago
    Same server / instance.
    On my PC the file opened without issue - Win 10, Excel 2019
    On my Laptop received the error message -.Win 10, Excel 2019

    With file open, went to connection properties, definition and browsed to the ODC file.
    Then was able to get data/connect.

    Hadn't ever ran into this issue after updating a report besides forgetting permissions in SQL on the view.

    Dedra

    ------------------------------
    Dedra Wagoner
    PC/Software Specialist
    Siemer Milling Company
    Teutopolis IL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Excel Refreshable Error - HELP - Initialization of Data source failed.

    Posted 14 days ago

    Updated another refreshable excel report and have the same issue again.    User with GP installed locally can open the file without errors, users who login to  GP via RDS or do not have GP login get the Initialization of the data source failed.message.  Below are the connection strings from the files based on GP versions that is the only thing that it showing as being different between excel reports .....

    GP2018 (only works with GP installed locally)

    Provider=SQLNCLI11.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=XXC;Data Source=SVR-XXXXX;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=PC-XXXXX;Use Encryption for Data=False;Tag with column collation when possible=False;MARS Connection=False;DataTypeCompatibility=0;Trust Server Certificate=False;Application Intent=READWRITE

     

    GP2016 (works with or without GP installed locally) 

    Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=SXX;Data Source=SVR-XXX;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=PC-XXXX;Use Encryption for Data=False;Tag with column collation when possible=False



    ------------------------------
    Dedra Wagoner
    PC/Software Specialist
    Siemer Milling Company
    Teutopolis IL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Excel Refreshable Error - HELP - Initialization of Data source failed.

    Posted 14 days ago
    Was able to correct by installing SQL Native client.

    Thanks
    Dedra

    ------------------------------
    Dedra Wagoner
    PC/Software Specialist
    Siemer Milling Company
    Teutopolis IL
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role