Forum Discussion

Razorbx13's avatar
Razorbx13
Icon for Post Patron rankPost Patron
3 years ago

ODBC Error - Unable to connect to the datasource undefined.

We have setup an ODBC datasource on the gateway server, connected a desktop model, imported data and published the model.  No problems.  We have setup the Gateway and the gateway and the data source ...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
3 years ago

Hi Razorbx13 

 

For the authentication method you will need to put in a username and password to successfully log into your ODBC data source?

Razorbx13's avatar
Razorbx13
Icon for Post Patron rankPost Patron
3 years ago

Yeah, but there is no requirement for that on the desktop.  It basically is a direct connect in with no login required.  The one on the gateway server in which we installed the desktop just to check connections worked fine.  

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    3 years ago

    Hi Razorbx13 

     

    All databases need a log in to authenticate. You probably have got single sign on, which is signing in for you in the background. I would suggest chatting to the database administrator to confirm how to connect from the Gateway server which sits outside of your domain.

    • Razorbx13's avatar
      Razorbx13
      Icon for Post Patron rankPost Patron
      3 years ago

      Well I still have a question.  I load the ODBC driver on my laptop.  Copy all the DBF files to my laptop for the server location, setup the 64 bit ODBC connection, open up PowerBI Desktop and I see all the tables.   Are you saying there is a userid and password embedded in one of those DBF files?  Or somewhere else I am missing?