I noticed some strange behaviour today. Whilst using Feeds SQL Parser on an external SQLExpress database, it was completely ignoring the name of the database in settings.php and tried to run all queries on whichever database it found first (i.e. the first one in alphabetical order).

I tried exactly the same setup on a Windows environment (using sqlsrv drivers to connect to the database) and it worked fine, so I think it may be an issue with the dblib drivers.

Comments

LGLC’s picture

LGLC commented

This seems to happen specifically when two databases both have a table with the same name - in which case, whichever database comes first alphabetically is chosen.