Forum Discussion

nerra's avatar
nerra
Icon for Helper II rankHelper II
5 years ago
Solved

Apply parameters to existing dataset

HI All,   I have an inherited dataset with an ODBC connection to Redshift defined for the data source.  I get an error when I change the actual server name and database name to the parameters "ser...
Need Help
Show and Tell
  • lbendlin's avatar
    lbendlin
    5 years ago

    ODBC{"connectionstring":"dsn=" & DSNName }

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

For testing try using a dsn based ODBC connection. It is easier to troubleshoot.

nerra's avatar
nerra
Icon for Helper II rankHelper II
5 years ago

HI ,

 

How will this affect when we're using gateways?

I created a System DSN pointing to QA and another one pointing to PROD on my local machine.

My parameter is now the name of the System DSN. It works locally. 

 Does this System DNS need to be added to the Gateway?

 

Regards,

Nera