TROUBLESHOOTING - Creating a DNS For Pastel

Post Reply
Posts: 15
Joined: Mon Dec 30, 2013 8:00 am

TROUBLESHOOTING - Creating a DNS For Pastel

Post by Andre » Tue Nov 27, 2018 7:26 am

When getting DSN errors in the extractor, its possible that the DNS was created incorrectly
Bellow are the steps to creating a DNS:

(1) Go to C:\Windows\SysWOW64 select odbcad32
(2) Select System DSN then click on Add
(3) Click on the down arrow and Select Pervasive ODBC Engine Interface then FINISH
(4) In Data Source Name type in the Company Name in this case (SPUR12) then click on Create
(5(a) In Database Name, type in the same Company Name (ROCO18)
(b) Click on Browse in the directory location and point it to C:\Pastel14\ROCO18\V14.0.2
(C) Click on Add and point the location to C: Pastel14\ROCO18
(6)- Once completed click on Test to check the connection

Post Reply