Forum Discussion

magnify-bi-com's avatar
5 years ago

FireBird ODBC connector intermittent refresh

Hey,

 

I am getting the following error in the query editor and when i try to refresh my FIreBird ODBC connector;

 

DataSource.Error: ODBC: ERROR [08004] [ODBC Firebird Driver]Failed to establish a connection.
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=SiteWatch
OdbcErrors=[Table]

 

I know the connection works as I have connected to the data initially, and then again at irregular intervals it will fetch the data again.

 

To me it seems as though the datasource is "is use" or something like that, because it will connect sometimes, but not others, I am not trying to do anything to the data table except retrieve it, any help would be great;

 

let
Source = Odbc.DataSource("dsn=SiteWatch", [HierarchicalNavigation=true]),
V_CUSTOMERCODE_View = Source{[Name="V_CUSTOMERCODE",Kind="View"]}[Data]
in
V_CUSTOMERCODE_View

 

Thanks,

 

J

1 Reply