General

I managed to pass by the SAS Support Forum stand in Vegas and Renee Harper was generous enough to show me through the ne/upgraded SAS Support forum software they currently have in beta.

I gotta save it looks great!

Lots of new features and importantly new features that will save time when creating, browsing, reading or replying to forum posts.

Some of my fav’s:

• Editor when creating posts that will speel check your content, deffo required for me.
• Ability to flag articles as liked and lots of way’s to increase your standing in the forum (even a scorecard style widget of posters and repliers)
• Ability to save a list of forums you use regularly and hide the ones you don’t.
• And my all time fav the ability to create a forum thread as an online document that can be used via collaboration with multiple people.  So we can all work on those best practice guides we keep asking for.

And Barry (as I know you are going to ask when im back there will be a SAS Admin Forum created, Tim Stearn (the DI Product Manager) has agreed to sponsor it, so wahoo!  Dates were a little vague Tim wanted to peg it to the 9.3 release, Renee would like to peg it to the forum upgrade, but I did ask nicely if we could have it as early as possible.

So start posting now people, as they are even going to migrate all the old posts to the new forum version (wonder if they will do that for customers moving from SAS 9.2 to 9.3 for free as well

 

Just noticed over on sascommunity,org (http://www.sascommunity.org/wiki/SAS_Global_Forum_Proceedings) that they have posted scanned copies of all the papers from SAS Forum (SUGI) all the way back to 1976!

Wonder how many people who presented in 1976 are presenting at SAS Forum 2011 in Vegas?

If you are let me know.

Well got my paper in on time for my preso, excitedly titled:

“Paper 313-2011 – Migrating SAS® Enterprise Guide® Projects from SAS® 9.1 to SAS® 9.2″

And the presentaton itsself is almost finished.

Yah me!

Different JDBC drivers requires different connection URL formats. A quick summary of various connection URL formats is provided here as a comparison and a reference:

Driver Name: Apache Derby Network Client JDBC Driver

---

Driver JAR File: derbyclient.jar

Connection URL Formats:

jdbc:derby://host/database

Connection URL Examples:

jdbc:derby://localhost/TestDB

Driver Name: JDBC-ODBC Bridge

---

Driver JAR File: None (included in Java SE 1.6)

Connection URL Formats:

jdbc:odbc:DSN

Connection URL Examples:

jdbc:odbc:MY_FLAT

jdbc:odbc:MY_ACCESS

jdbc:odbc:SQL_SERVER;user=sa;password=myPws

Driver Name: MySQL Connctor/J

---

Driver JAR File: mysql-connector-java-5.0.7-bin.jar

Connection URL Formats:

jdbc:mysql://…

Connection URL Examples:

jdbc:mysql://localhost:3306/myDB?user=myUser&password=myPwd

jdbc:mysql://:3306/myDB?user=myUser&password=myPwd

jdbc:mysql://localhost/myDB?user=myUser&password=myPwd

jdbc:mysql://localhost:3306/?user=myUser&password=myPwd

jdbc:mysql://localhost/?user=myUser&password=myPwd

jdbc:mysql://:3306/?user=myUser&password=myPwd

jdbc:mysql:///HerongDB?user=myUser&password=myPwd

jdbc:mysql:///?user=myUser&password=myPwd

Driver Name: Oracle JDBC Thin client-side driver

---

Driver JAR File: ojdbc14.jar

Connection URL Formats:

jdbc:oracle:thin::SID

jdbc:oracle:thin:/SID

Connection URL Examples:

jdbc:oracle:thin:myUser/myPwd@localhost:1521:mySID

jdbc:oracle:thin:myUser/myPwd@:1521:mySID

jdbc:oracle:thin:myUser/myPwd@//localhost:1521/mySid

jdbc:oracle:thin:myUser/myPwd@//:1521/mySID

jdbc:oracle:thin:myUser/myPwd@//localhost/mySID

jdbc:oracle:thin:myUser/myPwd@///mySID

Driver Name: Miscrosoft JDBC Driver

---

Driver JAR File: sqljdbc.jar

Connection URL Formats:

jdbc:sqlserver://host

Connection URL Examples:

jdbc:sqlserver://localhost;user=sa;password=mypwd

jdbc:sqlserver://localhost:1269;user=sa;password=mypwd

jdbc:sqlserver://localhost;user=sa;password=mypwd;database=myDB