[AccessD] DSNLess remote tables return 'dbo' for user_name()

Ryan W wrwehler at gmail.com
Sat Apr 10 09:02:07 CDT 2021


According to connectionstrings site the 17 version works on 2008. It seemed to work on my workstation just fine but I do have the driver loaded (something must have installed it). 

That said a more bare bones machine without all the dev stuff I have on doesn’t have anything but the plain Jane “sql server” driver. No version 11 or 13. 

As I said that would become a dependency I’d have to remember to install once we roll out workstation updates again. May not be worth it. 

Sent from my iPhone

> On Apr 10, 2021, at 8:50 AM, Stuart McLachlan <stuart at lexacorp.com.pg> wrote:
> 
> 
>> 
>> still on SQL Server 2008.
> 
> Ouch!  ver 17:   "works with all currently suppported versions of SQL Server."
> 2008 is no longer supported.
> 2012 Extended support ends Dex 2022.
> 
> Best to stay with Ver11 or 13 for now. 
> 
> 
>> On 10 Apr 2021 at 8:37, Ryan W wrote:
>> 
>> I just checked the big cheeses machine (he barely does anything on it)
>> and does NOT have the ODBC Driver 17 loaded... so apparently even
>> Windows 10 just comes with the base driver.  Which is probably the
>> reason I've kept using DRIVER=SQL Server for so long, because it's the
>> least common denominator and does not add dependencies when rolling
>> out the app when we upgrade workstations.
>> 
>> I'll have to consider whether the move is worth it, if it's just for
>> compatibility with new datatypes, at this time it's not a problem
>> since we're still on SQL Server 2008... but have plans to move to SQL
>> Server 2019 within the year.
>> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


More information about the AccessD mailing list