pcsoft.us.windevCopyright 2026, PC SOFT6 Aug 2015 10:12:00 Z5 Aug 2015 15:35:00 ZPoll: SQL Server Native Access provides real added value Hi, For one of our customers we are requested to move one of our WebDev solutions from HFCS to SQLServer 2012. Is there any specific reason to use the SQL Server Native Access solutions? We are not using any direct bound tables, controls or anything from our web pages as all is OO class based and goes via a business layer first before being submit/fetched from the database. On the other hand we use blob fields (XML, HTML, Binary) intensively for this solution. At first sight (as we dot use any RAD, SQL Server views, etc...) we have the impression that using oleDB should be sufficient to migrate our solution to SQL Server. Apart of that there is also the cost impact: Making a simple calculation would immediately account for 2400€ (One Dev/Test SQL Server, One Pre-Production SQL Server, One Production SQL Server) to have the migration done using SQL Server Native Access since we need a native access for all SQL servers although only one of them is the final end-user production environment. So here's my question: - Is there a real need to use the SQL Server native access? - What are the advantages based on your experience over oleDB? - We use hCommands in our OO db access layer but this seems to work fine using oleDB with SQL Server as well. Or are we missing some constraints here? - Any other experience you guys would like to share? ... Thanks in Advance, Peter H.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53426-wxxx-sqlserver-native-access/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53426-wxxx-sqlserver-native-access-53441/read.awp6 Aug 2015 10:12:00 ZHi, in which concern is programming easier with native Access? I use oledb (mainly because native Access is too expensive,…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53426-wxxx-sqlserver-native-access-53441/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53426-wxxx-sqlserver-native-access-53441/read.awp[WXxx] SQLServer Native Accessguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53426-wxxx-sqlserver-native-access-53439/read.awp6 Aug 2015 08:49:00 ZHi Peter, if you have 30Gb database and speed is your concern then put all your insert, update, delete in stored procedure an…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53426-wxxx-sqlserver-native-access-53439/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53426-wxxx-sqlserver-native-access-53439/read.awp[WXxx] SQLServer Native Accessguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53426-wxxx-sqlserver-native-access-53438/read.awp5 Aug 2015 23:36:00 ZHi Peter, I use both native access and OLEDB with my WD 19 application and there are 2 main reasons why I'm pushing my newer …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53426-wxxx-sqlserver-native-access-53438/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53426-wxxx-sqlserver-native-access-53438/read.awp[WXxx] SQLServer Native Accessguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53426-wxxx-sqlserver-native-access-53430/read.awp5 Aug 2015 17:22:00 ZHi I try... - Is there a real need to use the SQL Server native access? Yes, it's fast and simple to use HCommands, and I…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53426-wxxx-sqlserver-native-access-53430/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53426-wxxx-sqlserver-native-access-53430/read.awp[WXxx] SQLServer Native Access