Bug 478226

Summary:	Penrose Server fails to connect to ODBC data sources on Ubuntu using unixodbc
Product:	[Retired] penrose	Reporter:	Chandrasekar Kannan <ckannan>
Component:	Connectors	Assignee:	Endi Sukma Dewata <edewata>
Status:	CLOSED EOL	QA Contact:	Ben Levenson <benl>
Severity:	low	Docs Contact:
Priority:	low
Version:	unspecified	CC:	benl, nmalki, ykaul
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2020-03-27 19:34:05 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Chandrasekar Kannan 2008-12-27 08:10:09 UTC

To reproduce:
Create a working connection to an ODBC data source  using JdbcOdbcDriver for Penrose Server on Windows.
Export to Penrose Server on Ubuntu Linux and create the corresponding configuration in unixodbc and mdbtools. Start Penrose Server on Ubuntu and it will fail: "[unixODBC][Driver Manager]Data source name not found, and no default driver specified"

This issue may be related to PENROSE-255: Penrose Studio uses local ODBC instead of server side and fails



=========================================================
Issue dump from jira
$VAR1 = {
          'priority' => '3',
          'customFieldValues' => [],
          'project' => 'PENROSE',
          'status' => '1',
          'components' => [
                            {
                              'name' => 'Connectors',
                              'id' => '10059'
                            }
                          ],
          'reporter' => 'webdb22',
          'key' => 'PENROSE-256',
          'assignee' => 'jimyang',
          'summary' => 'Penrose Server fails to connect to ODBC data sources on Ubuntu using unixodbc',
          'id' => '10835',
          'updated' => '2007-09-02 17:21:08.0',
          'votes' => '0',
          'fixVersions' => [],
          'affectsVersions' => [
                               {
                                 'releaseDate' => '2007-07-17 00:00:00.0',
                                 'sequence' => '26',
                                 'name' => 'Penrose-1.2.4',
                                 'released' => 'true',
                                 'id' => '10123',
                                 'archived' => 'false'
                               }
                             ],
          'description' => 'To reproduce:
Create a working connection to an ODBC data source  using JdbcOdbcDriver for Penrose Server on Windows.
Export to Penrose Server on Ubuntu Linux and create the corresponding configuration in unixodbc and mdbtools. Start Penrose Server on Ubuntu and it will fail: "[unixODBC][Driver Manager]Data source name not found, and no default driver specified"

This issue may be related to PENROSE-255: Penrose Studio uses local ODBC instead of server side and fails

',
          'created' => '2007-09-02 17:21:08.0',
          'environment' => 'Penrose Server 1.2.4 on Ubuntu 6.06.1 using unixodbc 2.2.11 and mdbtools 0.5.99',
          'type' => '1'
        };


=========================================================