Ingen beskrivning
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

SQL_連線字串.vb 2.5KB

123456789101112131415161718192021222324252627282930313233
  1. Module SQL_連線字串
  2. Friend Sub SQL_連線字串_測試()
  3. ConString = "Data Source=" & 登入人IP & ";Initial Catalog=HX-GPS-ERP-SYS;Persist Security Info=True;User ID=b70340;Password=Lee0911274990;Max pool size = 200;Connection Timeout=0"
  4. End Sub
  5. Friend Sub SQL_連線字串_正式()
  6. ConString = "Data Source=" & 登入人IP & ";Initial Catalog=HX-GPS-ERP-SYS;Persist Security Info=True;User ID=b70340;Password=Lee0911274990;Max pool size = 200;Connection Timeout=0"
  7. End Sub
  8. Friend Sub SQL_連線字串_圖片資料庫()
  9. ConString2 = "Data Source=" & 登入人IP & ";Initial Catalog=" & 圖片庫 & ";Persist Security Info=True;User ID=b70340;Password=Lee0911274990;Max pool size = 200;Connection Timeout=0"
  10. End Sub
  11. Friend Sub SQL_連線字串_本機()
  12. Dim Str As String = Application.StartupPath
  13. AccessConString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Str & "/HabitData.mdb;Jet OLEDB:Database Password=Qaz!@#123;Persist Security Info=False;User ID=Admin"
  14. End Sub
  15. Friend Sub SQL_連線字串_正式_工程SQL()
  16. ConString1 = "Data Source=" & 登入人IP & ";Initial Catalog=PROJECT-SYS;Persist Security Info=True;User ID=b70340;Password=Lee0911274990;Max pool size = 200; Connection Timeout=0"
  17. End Sub
  18. Friend Sub SQL_連線字串_測試_工程SQL()
  19. ConString1 = "Data Source=" & 登入人IP & ";Initial Catalog=PROJECT-SYS;Persist Security Info=True;User ID=b70340;Password=Lee0911274990;Max pool size = 200; Connection Timeout=0"
  20. End Sub
  21. Friend Sub SQL_連線字串_正式_管理SQL()
  22. ConString3 = "Data Source=" & 登入人IP & ";Initial Catalog=HX-PGS-MSN;Persist Security Info=True;User ID=b70340;Password=Lee0911274990;Max pool size = 200; Connection Timeout=0"
  23. End Sub
  24. Friend Sub SQL_連線字串_測試_管理SQL()
  25. ConString3 = "Data Source=" & 登入人IP & ";Initial Catalog=HX-PGS-MSN;Persist Security Info=True;User ID=b70340;Password=Lee0911274990;Max pool size = 200; Connection Timeout=0"
  26. End Sub
  27. Friend Sub SQL_連線字串_測試_LINE_SQL()
  28. ConString4 = "Data Source=" & 登入人IP & ";Initial Catalog=HX-LINE-AUTO;Persist Security Info=True;User ID=b70340;Password=Lee0911274990;Max pool size = 200; Connection Timeout=0"
  29. End Sub
  30. Friend Sub SQL_連線字串_正式_LINE_SQL()
  31. ConString4 = "Data Source=" & 登入人IP & ";Initial Catalog=HX-LINE-AUTO;Persist Security Info=True;User ID=b70340;Password=Lee0911274990;Max pool size = 200;Connection Timeout=0"
  32. End Sub
  33. End Module