[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