以下兩種方式都可以達成:
MS SQL Server DSNless connection
Driver={SQL Server};Server=servername;Database=dbname;Uid=username;Pwd=password;
MS SQL Server OLE DB connection
Provider=SQLOLEDB;Data Source=machineName;Initial Catalog=dbname;User ID=username;Password=password;
例如:資料庫伺服器的IP是192.168.1.68,資料庫是testdb,帳號是test,密碼是noOneKnows
MS SQL Server DSNless connection
Driver={SQL Server};Server=192.168.1.68;Database=testdb;Uid=test;Pwd=noOneKnows;
MS SQL Server OLE DB connection
Provider=SQLOLEDB;Data Source=192.168.1.68;Initial Catalog=testdb;User ID=test;Password=noOneKnows;
參考資料:
http://class2u.idv.tw/book/ultradev4/connection.htm