Centerprise Trial

Support Queries Astera Centerprise
1

Hi,
I was able to install the QuNect ODBC for QuickBase and query data but ran into some issues.

  1. Can’t insert data to QuickBase due to field size issues. QuickBase does not have fixed lengths on text fields, but the schema was identified for a large field as VARCHAR with a very large size. As a result, the insert gets blocked due to mismatch with VARCHAR properties. I was not able to find a work around.

  2. I tried simply seeing if I could download data and push to Excel but got this error.

Message : ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Product Version: 5.0.152.1
OS Info: Microsoft Windows NT 6.1.7600.0
Exception Class Name: Astera.Transfer.TransferException
Stacktrace: at Astera.Transfer.DbReaderBase.CreateAndOpenConnection()

at Astera.Transfer.DbReaderBase.Open()

at Astera.Transfer.BaseReader.Initialize()

at Astera.Transfer.DataflowChainItem.Initialize(DataflowChainItem

contextItems, JobMonitoringInfoBase monitoringInfo)

at

Astera.Transfer.Dataflow.DataflowPipeline.InitializeItem(DataflowChainItem

item)

at Astera.Transfer.Dataflow.DataflowPipeline.PerformInitializeItem(Object

state)

Message : ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Product Version: 5.0.152.1
OS Info: Microsoft Windows NT 6.1.7600.0
Exception Class Name: Astera.Core.DbProviderException
Stacktrace: at
Astera.Database.DbProviderBase.OpenConnection(IDbConnection connection)
at Astera.Database.DbProviderBase.CreateAndOpenConnection(DatabaseInfo
dbInfo)
at Astera.Transfer.DbReaderBase.CreateAndOpenConnection()
Message : ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Product Version: 5.0.152.1
OS Info: Microsoft Windows NT 6.1.7600.0
Exception Class Name: System.Data.Odbc.OdbcException
Stacktrace: at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle
hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcConnectionHandle…ctor(OdbcConnection connection,
OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at System.Data.Odbc.OdbcConnectionOpen…ctor(OdbcConnection
outerConnection, OdbcConnectionString connectionOptions)
at
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection, DbConnectionPoolGroup poolGroup)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at Astera.Database.DbProviderBase.OpenConnection(IDbConnection
connection)
We have had good luck in the past working with other integration tools and the QuickBase ODBC QuNect to resolve issue and get things working. Please let me know your thoughts.

2

Hello,

  1. We’ll have to download and test this particular ODBC driver to see what the exact cause of the issue you’re facing is.
  2. You were trying to write to an Excel file via ODBC?
    What is the OS you are using?
3

I was trying to write to Excel, but I also tried a delimited file. I think the issue is in the ODBC used to get the data from QuickBase.

4

Are you able to right-click and preview data from the source ODBC table on the diagram? Regardless, I’d like to get a closer look. Is there a time we can meet so I can view your screen?

5

A bug was filed and resolved for this issue.