We are using the dbexpress driver dbexpsda.dll 3.0.5
and acessing SQL Server 2005 (delphi 7).
when we call,
tsqlconnection(conn).getfieldnames(name,list);
We receive the error:
'EMSError - Invalid object name 'master.dbo.spt_provider_types'
I found in your forums 2 short discussions concerning this
error - possibly this table is no longer available in SQL2005.
This line is SQLEXPR where the exception bubbles up from,
Status := GetInternalConnection.FSQLMetaData.getColumns(
PChar(FSchemaInfo.ObjectName),
PChar(FSchemaInfo.Pattern), 0, FSQLCursor);
Urgently needing your help
Thanks
Shane