Archived Thread: 'SQLite ConnectionString '

• SQLite ConnectionString

  Posted by soccer on Thursday, June 26, 2008

  Sadly, I've never heard of SubSonic, but it looks exactly what I need. I just downloaded SubSonic 2.1 RC1 and am trying to get it to work with a small test SQLite database. I tried generating the DAL in a WinForm app, but I get errors when I run sonic.exe. Since I'm using SQLite, I didn't include the server or database in the connection string. I tried several variations on the connection string, but couldn't get it to work. Unfortunately I couldn't find an example in the forums for a SQLite connection string. Thanks for your help!

  Here is my app.config

  <?xml version="1.0" encoding="utf-8" ?>
  <configuration>
    <appSettings/>
  
    <configSections>
      <section name="SubSonicService" type="SubSonic.SubSonicSection, SubSonic" allowDefinition="MachineToApplication" restartOnExternalChanges="true" requirePermission="false" />
    </configSections>
  
    <connectionStrings>
      <add name="TestDB" connectionString="Data Source=c:\temp\test.db3;" />
    </connectionStrings>
  
    <SubSonicService defaultProvider="SQLiteTestProvider">
      <providers>
        <add name="SQLiteTestProvider" type="SubSonic.SQLiteDataProvider, SubSonic" connectionStringName="TestDB" generatedNamespace="Test.SQLite"/>
      </providers>
    </SubSonicService>
  </configuration>

   

  Error:

  No server name was passed in - please specify using /s MyServerName
  No Database name was passed in - please specify using /db MyDatabaseName
  sonic.exe v2.1.0.0 - Command Line Interface to SubSonic v2.1.0.0
  Usage:   sonic command [options]
  Sample:  sonic generate /server localhost /db northwind /out GeneratedFiles
  Help:    sonic help
  TIP:    SubSonic will read your App.Config or Web.Config - just select the project
  and run your command.
  
  ERROR: Trying to execute generate
  Error Message: System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.
     at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue)
     at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
     at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
     at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
     at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
     at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
     at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value)
     at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
     at System.Data.SqlClient.SqlConnection..ctor(String connectionString)
     at SubSonic.SqlDataProvider.CreateConnection(String newConnectionString) in C:\temp\SubSonic\SubSonic_2.1_RC_1_Source\src\SubSonic\DataProviders\SqlDataProvider.cs:line 211
     at SubSonic.SqlDataProvider.CreateConnection() in C:\temp\SubSonic\SubSonic_2.1_RC_1_Source\src\SubSonic\DataProviders\SqlDataProvider.cs:line 201
     at SubSonic.AutomaticConnectionScope..ctor(DataProvider provider) in C:\temp\SubSonic\SubSonic_2.1_RC_1_Source\src\SubSonic\Sql Tools\Connection.cs:line 172
     at SubSonic.SqlDataProvider.GetReader(QueryCommand qry) in C:\temp\SubSonic\SubSonic_2.1_RC_1_Source\src\SubSonic\DataProviders\SqlDataProvider.cs:line 358
     at SubSonic.SqlDataProvider.GetTableNameList() in C:\temp\SubSonic\SubSonic_2.1_RC_1_Source\src\SubSonic\DataProviders\SqlDataProvider.cs:line 866
     at SubSonic.DataService.GetTableNames(String providerName) in C:\temp\SubSonic\SubSonic_2.1_RC_1_Source\src\SubSonic\DataProviders\DataService.cs:line 665
     at SubSonic.SubCommander.Program.GenerateTables() in C:\temp\SubSonic\SubSonic_2.1_RC_1_Source\src\SubCommander\Program.cs:line 896
     at SubSonic.SubCommander.Program.Main(String[] args) in C:\temp\SubSonic\SubSonic_2.1_RC_1_Source\src\SubCommander\Program.cs:line 76
  Execution Time: 153ms
  

• Re: SQLite ConnectionString

  Posted by penyaskito on Thursday, June 26, 2008

  Take a look at http://connectionstrings.com/?carrier=sqlite

   

• Re: SQLite ConnectionString

  Posted by spookytooth on Thursday, June 26, 2008

  Where is the config file that you're referencing here? Is it in a separate project? If so - sonic.exe can't see it (which seems to be the problem). Tell me more about your setup.

• Re: SQLite ConnectionString

  Posted by soccer on Thursday, June 26, 2008

  I discover after I sent the message that I failed to set the "Initial Directory" when I setup SubSonic DAL in the External Tools. So, you are exactly right. Now my new issue is that sonic.exe runs, but it doesn't generate anything.

   

  Setting ConfigPath: 'App.config'
  Building configuration from C:\Visual Studio 2005\Projects\SubSonicTester\App.config
  Adding connection to Pubs
  Generating classes for Pubs (0 total)
  Finished
  Setting ConfigPath: 'App.config'
  Building configuration from C:\Visual Studio 2005\Projects\SubSonicTester\App.config
  Adding connection to Pubs
  Generating ODS Controllers for Pubs (0 total)
  Finished
  Setting ConfigPath: 'App.config'
  Building configuration from C:\Visual Studio 2005\Projects\SubSonicTester\App.config
  Adding connection to Pubs
  Setting ConfigPath: 'App.config'
  Building configuration from C:\Visual Studio 2005\Projects\SubSonicTester\App.config
  Adding connection to Pubs
  Generating SPs to C:\Visual Studio 2005\Projects\SubSonicTester\Generated\StoredProcedures.cs
  Finished
  Setting ConfigPath: 'App.config'
  Building configuration from C:\Visual Studio 2005\Projects\SubSonicTester\App.config
  Adding connection to Pubs
  Generating Structs to C:\Visual Studio 2005\Projects\SubSonicTester\Generated\AllStructs.cs
  Finished
  Running Compiler...
  Writing Files...
  Done!
  Execution Time: 824ms
  

• Re: SQLite ConnectionString

  Posted by spookytooth on Friday, June 27, 2008

  There are no files in "C:\Visual Studio 2005\Projects\SubSonicTester\Generated\"?