I want to pass variables from one content page to another using ["someVariable"] so I need to set the sessionstate of my app. The syntax is easy enought to follow but I do I use an ODBC connection instead of sql? So when they ask for a connection string but I have only been able to find sqlconnection strings instead of an ODBC. Any thoughts?

To my knowledge, only SQL Server is supported for database session state management. I could be totally wrong however. I suppose that it might be fine as long as the database you connect to has the correct session state schema. However, it's possible that it will still only work with SQL Server. You can change the connection string, but the underlying classes that control database session state are likely using the System.Data.SqlClient classes so they'll only work with SQL Server.

-Peter