Forum Discussion

CTouu's avatar
CTouu
Frequent Visitor
3 years ago
Solved

ODBC Url connection How to put a parameter

Hi !    I've got a simple (I think) issue.  I have a simple connection to a Postgre DB Connection by ODBC (i don't use the postgre connector, don't need to propose).  I have several DBs and I wan...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago
    = Odbc.DataSource("Driver={PostgreSQL Unicode(x64)};Server=localhost;Port=5432;Database=" & databasename & ";", [HierarchicalNavigation=true])
CTouu's avatar
CTouu
Frequent Visitor
3 years ago

I think you didn't understood my issue. 

I just want to know how to variabilize an ODBC Source in the Query Editor 

For example : 

I need to import 23 tables

if I have a DEVELOPMENT database with a dbname A

and a PROD database with a dbname B

I want to know how to switch the dbname without having to change the dbname manually in each of the 23 tables 

lbendlin's avatar
lbendlin
Super User
3 years ago
= Odbc.DataSource("Driver={PostgreSQL Unicode(x64)};Server=localhost;Port=5432;Database=" & databasename & ";", [HierarchicalNavigation=true])
  • CTouu's avatar
    CTouu
    Frequent Visitor
    3 years ago

    yes it works !! Thank you very much for your help ! I missed the & & characters !