title: H2: Supplying an init script via full path (Windows 7)
body: <p>Our C# application is accessing H2 Database (1.3.164) through H2Sharp. OS is Windows 7, 64bit.</p>
  
  <p>The connection string</p>
  
  <pre><code>jdbc:h2:C:\Users\TestUser\Desktop\TestAppStorage\TestDB;INIT=RUNSCRIPT FROM 'C:\Users\TestUser\Desktop\TestAppStorage\init.sql'
  </code></pre>
  
  <p>causes the following exception:</p>
  
  <p>An error occurred while connecting to database:</p>
  
  <pre><code>IO Exception: "java.io.FileNotFoundException: Could not find file 'C:\Users\TestUser\Desktop\VS Projects\TestManagerApp\bin\Debug\UsersTestUserDesktopTestAppStorageinit.sql'."; "C:UsersTestUserDesktopTestAppStorageinit.sql"; SQL statement:
  RUNSCRIPT FROM 'C:UsersTestUserDesktopTestAppStorageinit.sql' [90031-164]
  </code></pre>
  
  <p>The path value comes from user selections in the UI. How should one supply the init script with a full path under Windows? The examples I saw always use <code>~</code> as the beginning of the path but in our cases it may not be the case.</p>
  
  <p>BTW, as far as I can see, the string is correct until the point it is handed to H2 from H2Sharp (i.e. H2Sharp is not causing a problem until the <code>java.sql.DriverManager.getConnection(connectionString, userName, password);</code> call.</p>