Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-19-2019, 10:18 AM   #1
sportsguy
Finance wiz, Access hack
 
sportsguy's Avatar
 
Join Date: Dec 2004
Location: Boston, MA, USA
Posts: 341
Thanks: 4
Thanked 1 Time in 1 Post
sportsguy has a little shameless behaviour in the past
Trying to Link Azure server hosted locally to Access

I used the sql server native 11 ODBC driver, but I can't open any columns with a decimal column type. Is there a different ODBC driver I can use, or any settings, or do I need to set the columns to currenty or long or something Access will recognize? I have set the columns in the security area to Other-> Public, but that doesn't change the outcome.
ODBC Sql Server 17 doesn't load, I haven't tried ODBC Sql Server 13

ERROR
ODBC--Call failed
Restricted Data type Attribute violation (#0)

Thanks in Advance

sportsguy is offline   Reply With Quote
Old 07-19-2019, 10:58 AM   #2
sportsguy
Finance wiz, Access hack
 
sportsguy's Avatar
 
Join Date: Dec 2004
Location: Boston, MA, USA
Posts: 341
Thanks: 4
Thanked 1 Time in 1 Post
sportsguy has a little shameless behaviour in the past
Re: Trying to Link Azure server hosted locally to Access

Using the CAST function solves the issue. . .
sportsguy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access VBA Import from Excel to Azure SQL Server IvanM Modules & VBA 2 08-15-2017 04:43 AM
Project Nami: WordPress for Azure SQL Database/SQL Server Rx_ Web Design and Development 0 04-06-2016 05:14 AM
Does Access 2010 cache locally from Sql Server 2008R2? madEG General 2 06-24-2014 01:00 PM
Cant get Access upsizing wizard to work to load Access2010 DB to hosted SQL server GMC7000 SQL Server 1 12-02-2013 12:29 PM
Access DB hosted on website ... is it possible to conect sjslall Modules & VBA 1 11-15-2010 06:27 PM




All times are GMT -8. The time now is 02:41 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World