#Thin sql client odbc how to

Open Control Panel вЂ“ Administrative Tools вЂ“ ODBC Data Sources (32-bit)

Where IвЂ™ve put SERVER HOSTNAME, OR HOSTNAME вЂ“ You need to use the FQDN on your WDM server (YouвЂ™ll need an admin rights for the below вЂ“ just a one off to create the connection)

#Thin sql client odbc how to

Has anyone any information/ instruction on how to do this on WMS?ДЄdded Bonus for WDM users, this is how I set up the WDM ODBC connection вЂ“ However you will have to work out the tables you need once youвЂ™ve connected вЂ“ but the naming is fairly obvious so shouldnвЂ™t be too hard to work out) Unsure what username to use with my DB password. I have downloaded a MongoDB driver, and I have the database PW set up on install, however cannot for the life of me get the ODBC connection to work. HoweverвЂ¦ WMS doesnвЂ™t seem to play the same ball game, has anyone been able to (or know how) to set up the ODBC connection system/user DSN from a Windows PC to the WMS box to query the database? In WDM I was able to use the SQL driver in Windows to create an ODBC connection to the rapport database so could export details of the fleet, for usage reporting, asset management and the like вЂ“ it was pretty handy (ps, if anyone still uses WDM and would likeВ instruction on this. I have finally just made the move to WMS from WDM, and I like the new setup, much more friendly, however I would like to know if anyone has managed to set up an ODBC link to the DB used by WMS.