Trying to setup an external table to use in metadata. They do not have SQL on their Laserfiche server and since dynamic fields require local SQL I downloaded SQL express. I got in, created a database called LF_AUX. Then created a table with two columns and named in Police. Then when registering it I get "Unable to locate the specified external database table. Checking the event log gives me the following:
Invalid object name 'LF_AUX.dbo.Police'."; Statement="select * from LF_AUX.dbo.Police where 1=0"; SQL Variable=""; SQL State="42S02".
Anyone have any idea as to why its not finding it? Done this quite a bit before with no issues. The only thing odd on this is the client is running SQL 2008 for their Laserfiche database. The sqlexpress on the Laserfiche server is 2016. Didn't know if that mattered.
Thanks,
Chris