<![CDATA[Latest posts for the topic "不需設定ODBC的MS SQL Sever Connection String"]]> https://forum.andowson.com/posts/list/12.page JForum - http://www.jforum.net 不需設定ODBC的MS SQL Sever Connection String [b]MS SQL Server DSNless connection[/b]
[code]Driver={SQL Server};Server=servername;Database=dbname;Uid=username;Pwd=password;[/code]
[b]MS SQL Server OLE DB connection[/b]
[code]Provider=SQLOLEDB;Data Source=machineName;Initial Catalog=dbname;User ID=username;Password=password;[/code]
例如：資料庫伺服器的IP是192.168.1.68，資料庫是testdb，帳號是test，密碼是noOneKnows
[b]MS SQL Server DSNless connection[/b]
[code]Driver={SQL Server};Server=192.168.1.68;Database=testdb;Uid=test;Pwd=noOneKnows;[/code]
[b]MS SQL Server OLE DB connection[/b]
[code]Provider=SQLOLEDB;Data Source=192.168.1.68;Initial Catalog=testdb;User ID=test;Password=noOneKnows;[/code]

參考資料：
http://class2u.idv.tw/book/ultradev4/connection.htm]]> https://forum.andowson.com/posts/preList/167/257.page https://forum.andowson.com/posts/preList/167/257.page GMT