Guest User

Untitled

a guest
Jun 5th, 2018
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.61 KB | None | 0 0
  1. //var conn = Jdbc.getConnection('jdbc:sqlserver:MyDBName.database.windows.net:1433/MyDBName', 'MyDBUserName', 'MyDBPassword');
  2.  
  3. // SECOND ITERATION OF CONNECTION STRING
  4. //var conn = Jdbc.getConnection('jdbc:sqlserver://MyDBName.database.windows.net:1433;'+ 'databaseName=MyDBName;user=MyDBUserName;password=MyDBPassword;');
  5.  
  6. // THIRD ITERATION OF CONNECTION STRING
  7. //var conn = Jdbc.getConnection('jdbc:sqlserver://MyDBName.database.windows.net/MyDBName:1433', 'MyDBUserName', 'MyDBPassword');
  8.  
  9. // FOURTH ITERATION OF CONNECTION STRING
  10. //var conn = Jdbc.getConnection('MyDBName.database.windows.net','MyDBUserName', 'MyDBPassword');
  11.  
  12. // FIFTH ITERATION OF CONNECTION STRING
  13. //var conn = Jdbc.getConnection('jdbc:sqlserver://MyDBName.database.windows.net', {user:'MyDBUserName', password:'MyDBPassword'});
  14.  
  15. // SIXTH ITERATION OF CONNECTION STRING
  16. //var conn = Jdbc.getConnection('MyDBName.database.windows.net', {user:'MyDBUserName', password:'MyDBPassword'});
  17.  
  18. // SEVENTH ITERATION OF CONNECTION STRING
  19. //var conn = Jdbc.getConnection('jdbc:sqlserver://MyDBName.database.windows.net:1433/MyDBName', {user:'MyDBUserName', password:'MyDBPassword'});
  20.  
  21. // EIGHT ITERATION OF CONNECTION STRING
  22. //https://developers.google.com/apps-script/reference/jdbc/jdbc
  23. //var conn = Jdbc.getConnection('jdbc:sqlserver://MyDBName.database.windows.net/MyDBName:1433', {user:'MyDBUserName', password:'MyDBPassword'});
  24.  
  25. // NINTH ITERATION OF CONNECTION STRING - Now I'm just throwing anything at the wall and seeing what sticks!
  26. //var conn = Jdbc.getConnection('jdbc:sqlserver://MyDBName.database.windows.net/MyDBName;user=MyDBUserName;password=MyDBPassword');
  27.  
  28. // TENTH ITERATION OF CONNECTION STRING
  29. //var conn = Jdbc.getConnection('jdbc:mysql://MyDBName.database.windows.net/MyDBName:1433', {user:'MyDBUserName', password:'MyDBPassword'});
  30.  
  31. // ELEVENTH ITERATION OF CONNECTION STRING
  32. //var conn = Jdbc.getConnection('jdbc:sqlserver://MyDBName.database.windows.net:1433;databaseName=MyDBName','MyDBUserName','MyDBPassword');
  33.  
  34. //TWELVTH
  35. //var conn = jdbc:sqlserver://MyDBName.database.windows.net;database=MyDBName;user=MyDBUserName;password=MyDBPassword;
  36.  
  37. // THIRTEENTH
  38. //var conn = Jdbc.getConnection('jdbc:sqlserver://MyDBName.database.windows.net;user=MyDBUserName;password=MyDBPassword;databaseName=MyDBName;');
  39.  
  40. // FOURTEENTH
  41. //var conn = Jdbc.getConnection("jdbc:sqlserver//MyDBName.database.windows.net:1433;databaseName=MyDBName;user=MyDBUserName;password=MyDBPassword");
  42.  
  43. // FIFTEENTH
  44. //var conn = Jdbc.getConnection("jdbc:sqlserver://MyDBName.database.windows.net:1433;databaseName=MyDBName","MyDBUserName","MyDBPassword");
  45.  
  46. // SIXTEENTH
  47. // http://stackoverflow.com/questions/18978380/error-when-connecting-to-mssql-server-with-google-apps-script-via-jdbc?rq=1
  48. //var conn = Jdbc.getConnection("jdbc:sqlserver://NumericalIPAddress:1433;" + "databaseName=MyDBName;user=MyDBUserName;password=MyDBPassword;");
  49.  
  50. // SEVENTEENTH
  51. // same as above with one less semicolon
  52. //var conn = Jdbc.getConnection("jdbc:sqlserver://NumericalIPAddress:1433;" + "databaseName=MyDBName;user=MyDBUserName;password=MyDBPassword");
  53.  
  54. //EIGHTEENTH
  55. // http://stackoverflow.com/questions/15440939/querying-sql-server-with-google-apps-script-via-jdbc
  56. var conn = Jdbc.getConnection("jdbc:sqlserver://MyDBName.database.windows.net:1433;databaseName=MyDBName","MyDBUserName","MyDBPassword");
  57.  
  58. var user = 'USER@SERVER';
  59. var userPwd = 'PASSWORD';
  60. var database = 'DB_NAME'
  61. var connectionString = 'jdbc:sqlserver://SERVER.database.windows.net:1433;databaseName=' + database;
  62.  
  63. var conn = Jdbc.getConnection(connectionString , user, userPwd);
Add Comment
Please, Sign In to add comment