I have an old application that I manage that runs on top of a progress database. I'm trying to gather some information, for various reasons. At a minimum, I need to know when Progress 9.1 and 9.1D were released. I mention these two versions because we are using 9.1D and, I assume, the "D" revision is probably just the fourth iteration in miner updates since the initial release of 9.1.
I am trying to add an external data source so that our Epicor 10.2 can run queries against our legacy Vantage 5.2 on Progress 9.1D. I am able to install the Merant 32 bit ODBC driver for Progress on our Epicor 10.2 server. I am able to launch ODBC (32 bit) and successfully connect to and authenticate with this DSN. But when I go to my external data source in Epicor 10.2 and enter this DSN and all its settings, I get this error:
Progress 9.1D full version
I found this article on the progress database, but by the sounds of it you may need upgrade your progress version to get the functionality, but as I mentioned earlier someone has probably run into this issue before and could provide some real life experience.
Hi Selvam,\\n\\nMany Thanks and sorry for responding back so late. It took a long time to get messages.jar file. We added all the files you suggested and also checked the URL and driver. \\n\\nBut we still get the same problem. We are able to connect to the progress database using a standalone java system. but not through PI.\\n\\nHave you ever connected to progress database through PI? I am not sure if PI supports progress database.\\n\\nKind Regards,\\nCharu\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"gabrielsagayaselvam.panneerselvam\",\"displayName\":\"Gabriel Sagaya Selvam Panneer Selvam\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":3970529,\"creationDate\":1209020637000,\"activeRevisionId\":5888865,\"lastActivity\":1209020637000,\"parentId\":3807990,\"originalParentId\":3807889,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false}]},\"3970760\":\"rootParentId\":3970760,\"commentsCount\":1,\"comments\":[\"body\":\"Hi Satya,\\n\\nMy requirement is to connect to Progress Database and not SQL server.\\n\\nKind Regards,\\nCharu\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"maruthivsatyakumar.akkaraboyana\",\"displayName\":\"Maruthi V Satya Kumar Akkaraboyana\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":3971420,\"creationDate\":1209027433000,\"activeRevisionId\":5889580,\"lastActivity\":1209027433000,\"parentId\":3970760,\"originalParentId\":3807889,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false]}"); const simplifiedQuestionView = JSON.parse("true"); (function() window.pageContext = mergeDeep(pageContext, question: id: 3807889, plug: "jdbc-driver-for-progress-database", votes: 0, questionTitle: "JDBC Driver for Progress Database", isClosed: false, isLocked: false, isRedirected: false, redirectedFromTitle: "", redirectedFromId: "", closedStatusData: JSON.parse(""), userVoted: false, relations: JSON.parse("\"canClose\":false,\"canUnredirect\":false,\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"canReopen\":false,\"type\":\"question\",\"canVoteUpOrCancel\":false,\"canViewRevisions\":true,\"canUnlock\":false,\"reported\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canCancelReport\":false,\"canComment\":true,\"isCurrentUserAuthor\":false,\"canViewReports\":false"), isQuestionAccepted: false , childToViewInfo: id: "" , comments: JSON.parse("\"3807990\":\"rootParentId\":3807990,\"commentsCount\":1,\"comments\":[\"body\":\"Hi Selvam,\\n\\nMany Thanks and sorry for responding back so late. It took a long time to get messages.jar file. We added all the files you suggested and also checked the URL and driver. \\n\\nBut we still get the same problem. We are able to connect to the progress database using a standalone java system. but not through PI.\\n\\nHave you ever connected to progress database through PI? I am not sure if PI supports progress database.\\n\\nKind Regards,\\nCharu\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"gabrielsagayaselvam.panneerselvam\",\"displayName\":\"Gabriel Sagaya Selvam Panneer Selvam\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":3970529,\"creationDate\":1209020637000,\"activeRevisionId\":5888865,\"lastActivity\":1209020637000,\"parentId\":3807990,\"originalParentId\":3807889,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false],\"3970760\":\"rootParentId\":3970760,\"commentsCount\":1,\"comments\":[\"body\":\"Hi Satya,\\n\\nMy requirement is to connect to Progress Database and not SQL server.\\n\\nKind Regards,\\nCharu\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"maruthivsatyakumar.akkaraboyana\",\"displayName\":\"Maruthi V Satya Kumar Akkaraboyana\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":3971420,\"creationDate\":1209027433000,\"activeRevisionId\":5889580,\"lastActivity\":1209027433000,\"parentId\":3970760,\"originalParentId\":3807889,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false]"), answerPager: answersCount: 3, page: 1, pageSize: 10, pageCount: 1, sort: "votes" , answers: JSON.parse("[\"body\":\"Hi,\\n\\nThis may help you\\n\\nTo install JDBC driver follow the how to guide.\\n\\n -how-to-guides/how%20to%20install%20and%20configure%20external%20drivers%20for%20jdbc%20and%20jms%20adapters.pdf\\n\\nConfiguration of JDBC Adapter for SQL Server\\n\\nJDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver\\nConnection = jdbc:microsoft:sqlserver://hostname:;DatabaseName=\\nUserID and Password.\\n\\nIf the connection is not working find the correct port number.\\n\\n -db81-2a10-8e91-f747188d8033\\n\\n\\n\\nRegards\\nSeshagiri\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":3807930,\"posted\":1206345461000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"The URL for 9.1D or E is\\njdbc:jdbcprogress:T:156.5.31.65:2501:inodbc2\\n\\ndriver class is com.progress.sql.jdbc.JdbcProgressDriver\\nbe sure to add these to your class path jdbc.jar, messages.jar, progress.jar in your Visual Admin\\n\\n\\nplease add the port no in url\\n\\n/thread/5254890 [original link is broken]\\n -73684.html\",\"author\":\"username\":\"gabrielsagayaselvam.panneerselvam\",\"displayName\":\"Gabriel Sagaya Selvam Panneer Selvam\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":3807990,\"posted\":1206346466000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Hi, \\n \\nTo install JDBC driver follow the how to guide. \\n \\n -how-to-guides/how%20to%20install%20and%20configure%20external%20drivers%20for%20jdbc%20and%20jms%20adapters.pdf \\n \\nConfiguration of JDBC Adapter for SQL Server \\n \\nJDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver \\nConnection = jdbc:microsoft:sqlserver://hostname:;DatabaseName= \\nUserID and Password. \\n \\nIf the connection is not working find the correct port number. \\n \\n -db81-2a10-8e91-f747188d8033 \\n \\nJDBC- X I - R/3 Scenario \\n/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step \\n/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 \\n \\nPlease check the driver path as mentioned below. \\nJDBC Driver : sun.jdbc.odbc.JdbcOdbcDriver \\nConnection:jdbc:odbc:Driver=Microsoft Access Driver (*.mdb);DBQ=//location of DB table.mdb; \\n \\nNo JDBC driver required. \\n \\nReceiver JDBC scenario MS access - /people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn \\nfollow this thread \\nproblem-when-connecting-to-ms-access-through-jdbc- \\nSAP Note 850116 has details \\n \\n \\nThanks, \\nSatya Kumar \\n \\nReward Points If it is Useful..\",\"author\":\"username\":\"maruthivsatyakumar.akkaraboyana\",\"displayName\":\"Maruthi V Satya Kumar Akkaraboyana\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":3970760,\"posted\":1209021913000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[]]"), answerForm: formAction: "/answers/3807889/post.json", textareaName: "body", textareaErrors: "", isAttachmentsEnabled: true, answerEditorialGuideline: title: "Before answering", content: "You should only submit an answer when you are proposing a solution to the poster\'s problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that your answer complies with our Rules of Engagement.", links: [ title: "Rules of Engagement", href: " -of-engagement.html", ] , answerMinBodyLength: '10', answerMaxBodyLength: '20000' , currentUser: sapInternalId: '', permissions: canVoteUpOrCancel: false, canVoteDownOrCancel: false, canModerate: false, , isVotedUp: false, isVotedDown: false , alerts: alertModeratorMinLength : "It should be given a proper explanation about why the content is inappropriate.", alertModeratorMinLengthValue : "10", alreadyReportedMessage : "You already have an active moderator alert for this content." , url: profileApiBaseUrl: ' -api.services.sap.com', followUnfollowQuestion: '/sap/nodeSubscription.json', isFollowingQuestion: '/sap/isFollowingNode.json', vote: voteUp: '/commands/0/voteup.json', voteDown: '/commands/0/votedown.json', cancelVote: '/commands/0/cancelvote.json' , rss: answers: '/feed/3807889/answers.rss', answersAndComments: '/feed/3807889/comments-and-answers.rss' , authorizeUploadContext: type: 'answer' , atMention: userSearchServiceUrl: ' ', currentUserName: '', useNewUSSCORS: true, atMentionDelayMs: 100, showMentionInRedactor: true , attachmentSettings: commentMaxAttachments: '2', answerMaxAttachments: '10', commentMaxAttachmentSizeBytes: '1048576', answerMaxAttachmentSizeBytes: '1048576', commentAttachmentsSizeBytesTotal: '2097152', answerAttachmentsSizeBytesTotal: '10485760' , editor: editorClipboardUploadEnabled: true ) )(); Home
Community
Ask a Question
Write a Blog Post
Login / Sign-up Search Questions and Answers 0 Former Member Mar 24, 2008 at 07:45 AM JDBC Driver for Progress Database 562 Views Follow RSS Feed Hi experts, 2ff7e9595c
Comments