Skip to Content
avatar image
Former Member

Trouble connecting to postgress sql BODS 4.2

Nov 18, 2016 at 07:33 AM | 47 Views

Hello I am trying to connect to postgressql 4.2 and I am constantly getting the below error:

ODBC call <SQLDriverConnect> for data source <test_postgress> failed: <[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified>. Notify Customer Support.

Can someone please help me what should i do

SAP Data Services
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 18, 2016 at 08:07 AM

    On the Job server machine, go to ODBC Administration to make sure the data source 'test_progress' is there.

    (It's in standard Windows control panel administrative tools)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Shane Patel
    Jan 30 at 10:46 PM

    Don't forget that there is a customer influence page out there requesting official support for Postgres so that it is QA'd and added to the supported databases list: https://influence.sap.com/sap/ino/#/idea/201753/?section=sectionDetails

    Add comment
    10|10000 characters needed characters exceeded