March presentation followup

Slides from the March presentation UsingSQLStoredProceduresFromAccess. 

A good reference for which Active X reference to use when https://support.microsoft.com/en-us/kb/231943 remember in general use the oldest common needed reference for your application.

A good reference for field type differences SQL to Access https://www.brentozar.com/sql-server-access-data-types/

Our questions from today:

from Ben (privately):

How do you know what verison of ADO your clients are using?  Is there an association with each version of Office?

from Yossi Dukes (privately):

FYI – here’s a wiki on MDAC and ADO versions : https://en.wikipedia.org/wiki/Microsoft_Data_Access_Components#History

from Yossi Dukes (privately):

what about error trapping if the SP fails?

from Giorgio Rovelli (privately):

This implies you have to know T-SQL to produce sprocs

from Yossi Dukes (privately):

How large a varchar can ADO support from the SQL db (ie: if theres a 10k memo stored in the SQL db, can ADO return the whole contents or is there a physical limit that ADO can return; and if so, what’s the max size it can return)

from Yossi Dukes (privately):

char(n)    Fixed width character string. Maximum 8,000 characters    Defined width

varchar(n)    Variable width character string. Maximum 8,000 characters    2 bytes + number of chars

varchar(max)    Variable width character string. Maximum 1,073,741,824 characters    2 bytes + number of chars

text    Variable width character string. Maximum 2GB of text data    4 bytes + number of chars

from Yossi Dukes (privately):

have to go, but thanks for your talk – much appreciated 🙂

from Giorgio Rovelli to Everyone:

Thanks Maria, that was great, I think we should post questions selecting Everyone so everyone can see them