6 Replies Latest reply on Feb 5, 2015 10:26 AM by Jeff Strauss

    ODBC driver problem with 32-bit driver

    Jeff Strauss

      I am running into a situation where there are a bunch of workbooks published to server using a 32-bit Postgres driver.  Both this driver and the 64-bit version are installed along with a host of other drivers.

       

      The problem: When extracts refresh, it takes a little bit longer than it should and I want it to be better performing.  The problem is that the 64-bit drivers are looked at first and then when it's not found, it seems to use the last one (SQL Server) as the default and then when this fails it fails over to the 32-bit driver.  This takes time.

       

      I've been looking at ODBCadmin and ini files as a possible way of fixing this and am seeking out any ideas for this forum.  I could go and correct all the workbooks, but this may be disruptive to the analyst community that owns these and probably do not have the 64-bit driver yet on their machine.  and there may be a more elegant windows solution.

       

      -Attempt to connect to PostgresSQL Unicode.  Seeks out 64-bit drivers

      {"ts":"2015-01-13T10:46:07.135","pid":6360,"tid":"22a0","sev":"info","req":"-","sess":"232631ED20EF4EB4B08521BD13EE3412-3:0","site":"","user":"","k":"ds-connect","v":{"name":"Acquisition Performance","attr":{"password":"********",":locale":"1033","caption":"","server-oauth":"","name":"Acquisition Performance","odbc-native-protocol":"no","workgroup-auth-mode":"prompt","server":"dtord01gpv01p.int","expected-driver-version":"PostgreSQL Unicode",":id":"AcquisitionPerformance","class":"greenplum","port":"5432","username":"generic_sql_report_utility","dbname":"vds_prd"}}}

       

      - Does not find the Postgres driver in the 64-bit list.  I think it defaults to the last one in the 64-bit list (SQL Server), which takes about a minute to fail, and then the process is killed

      {"ts":"2015-01-13T10:46:07.291","pid":6360,"tid":"22a0","sev":"info","req":"-","sess":"232631ED20EF4EB4B08521BD13EE3412-3:0","site":"","user":"","k":"msg","v":"ExternalProtocol::LocalProtocolServer::CreateServerProcess: pid=7636"}

      {"ts":"2015-01-13T10:47:09.462","pid":6360,"tid":"20f8","sev":"warn","req":"-","sess":"232631ED20EF4EB4B08521BD13EE3412-3:0","site":"","user":"","k":"msg","v":"Server error (pid=7636): Database error 0x80004005: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.\nDatabase error 0x80004005: Invalid connection string attribute\n"}

      {"ts":"2015-01-13T10:47:09.462","pid":6360,"tid":"20f8","sev":"warn","req":"-","sess":"232631ED20EF4EB4B08521BD13EE3412-3:0","site":"","user":"","k":"msg","v":"See G:\\Tableau\\Tableau Server\\data\\tabsvc\\vizqlserver\\Logs\\tabprotosrv.txt for details"}

      {"ts":"2015-01-13T10:47:09.462","pid":6360,"tid":"20f8","sev":"warn","req":"-","sess":"232631ED20EF4EB4B08521BD13EE3412-3:0","site":"","user":"","k":"msg","v":"throw DataSourceException (type=UnableToConnect): Database error 0x80004005: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.\nDatabase error 0x80004005: Invalid connection string attribute\n"}

      {"ts":"2015-01-13T10:47:09.462","pid":6360,"tid":"22a0","sev":"warn","req":"-","sess":"232631ED20EF4EB4B08521BD13EE3412-3:0","site":"","user":"","k":"msg","v":"throw DataSourceException (type=UnableToConnect): Database error 0x80004005: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.\nDatabase error 0x80004005: Invalid connection string attribute\n"}

      {"ts":"2015-01-13T10:47:09.525","pid":6360,"tid":"22a0","sev":"info","req":"-","sess":"232631ED20EF4EB4B08521BD13EE3412-3:0","site":"","user":"","k":"msg","v":"Server process exited with code 0"}

      {"ts":"2015-01-13T10:47:09.525","pid":6360,"tid":"22a0","sev":"info","req":"-","sess":"232631ED20EF4EB4B08521BD13EE3412-3:0","site":"","user":"","k":"destruct-protocol","v":{"protocol":"bc8ac70","attr":{"password":"********",":locale":"1033","caption":"","server-oauth":"","name":"Acquisition Performance","odbc-native-protocol":"no","workgroup-auth-mode":"prompt","server":"dtord01gpv01p.int","expected-driver-version":"PostgreSQL Unicode",":id":"AcquisitionPerformance","port":"5432","class":"greenplum","username":"generic_sql_report_utility","dbname":"vds_prd",":driver-bitness":"64"}}}

       

      - Fails over to 32-bit drivers.  And the extract most of the time continues on its way

      {"ts":"2015-01-13T10:47:09.525","pid":6360,"tid":"22a0","sev":"info","req":"-","sess":"232631ED20EF4EB4B08521BD13EE3412-3:0","site":"","user":"","k":"msg","v":"Failing over to 32-bit for greenplum"}

      {"ts":"2015-01-13T10:47:09.603","pid":6360,"tid":"22a0","sev":"info","req":"-","sess":"232631ED20EF4EB4B08521BD13EE3412-3:0","site":"","user":"","k":"msg","v":"ExternalProtocol::LocalProtocolServer::CreateServerProcess: pid=8496"}