title: How to access a UniqueIdentifer column from Java's JDBC-ODBC bridge
body: <p>I'm currently working on a java program that will access an Microsoft SQL Server using the JDBC-ODBC bridge driver provided in the Java distribution.</p>
  
  <p>Everything seems to be setup correctly and I can query basic data from the database, but when I try to run a query that gets a UniqueIdentifer field in it, when I do the subsequent <code>ResultSet.getString()</code> it fails with:</p>
  
  <pre><code>java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Numeric value out of range
  </code></pre>
  
  <p>Has anyone experienced anything like this before?  This works using the JDBC driver provided by Microsoft, but the customer wants to use the DSN they created.</p>
  
  <p>If this is helpful when I run a <code>Connection.getMetaData();</code> the <code>UniqueIdentifer</code> field returns a <code>DATA_TYPE</code> of 1111</p>