Click here to Skip to main content
13,044,428 members (121,378 online)
Rate this:
Please Sign up or sign in to vote.
See more:
I need to do something where I create a blank database, and then run commands to generate my schema. I have everything worked out as far as I can tell, but for some reason every time I try to connect I get an error saying "Invalid format for parameter C:\Test\test.db"

Here's the code where I get the problem.
<br />
<pre lang="cs">SQLiteConnection.CreateFile(filePath);<br />
               String connectionString = "Data Source=" + filePath+";";<br />
               using (var connection = new SQLiteConnection(filePath))<br />
               {<br />
                   connection.Open();</pre><br />
<br />
<br />

I have tried it with DataSource or Data Source in the connection string property. I also tried with and without that appended semicolon at the end. The CreateFile works, but then I can't get my connection to open. It throws an exception every time.

Can anyone please help me?
Posted 16-Apr-11 4:46am
Updated 16-Apr-11 4:49am
strogg 16-Apr-11 13:21pm
you're using 'filepath' to open the connection. I guess u forgot to use connectionString you've created :)
DannyStaten 16-Apr-11 14:51pm
Wow thanks for the fresh pair of eyes there.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You must pass connectionString to the constructor, not the path

using (var connection = new SQLiteConnection(connectionString))

DannyStaten 16-Apr-11 14:45pm
LOL thanks. Count that one up as a brain fart that I just needed a fresh pair of eyes on. Thanks

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 16 Apr 2011
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100