GitHub

Connecting to Microsoft Sql Server with PHP 7 from Linux (mssql and/or sqlsrv drivers) ms ...

I don't typically connect to MS Sql Server databases but I need to now (from Linux). So, in researching my options I've found that ADOdb recommends mssql, so i installed FreeTDS and the mssql php ...
note

【Access VBA】データベースのBLOB型カラムを実ファイルに書き込みし ...

1.準備 SQLServerテーブルの説明 Access VBAの参照設定 Cドライブにフォルダを作成 2.バイナリデータを書き込みして保存するVBA 変数定義 コネクション・レコードセット バイナリデータを書き込みして保存する FileSystemObjectでファイルを作成する ADODB.Streamで書き込みして保存する ...
GitHub

axmls date/datetime different mysql vs sql server vs oracle

adodb 5.20.7, windows 7, sql server 2012, iis 7.5, oracle 12.1.0.2, mysql 5.7 If I pick type of D, mysql gets Date, sql server gets date time, oracle gets date If i pick type of T, mysql get DateTime, ...
University of Vermont

Tips on Writing Portable SQL

If you are writing an application that is used in multiple environments and operating systems, you need to plan to support multiple databases. This article is based on my experiences with multiple ...
LinkedIn

Tips and Tricks: using VBScript to append data onto SQL with Stored Procedures

I gonna show how to use iFIX to append data into a SQL table with Stored Procedure. First of all, we got to create the Stored Procedure onto the SQL. In Object Explorer, connect to an instance of ...