?This is a desktop application I am building so unless I am smoking something there is no host name involved. The strange thing is that the Visual studio designer tools created for sqlite and entity framework let me browse my database and modify it all I want. For some reason however, the first time I try to access data via my code (C#) it says the provider failed to open.
Thanks for responding. Danny -----Original Message----- From: Stephen Chrzanowski Sent: Thursday, January 06, 2011 4:16 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] The underlying provider failed to open? Did your hostname change? There are some things with VB-anything that will try and open the file on the hostname, regardless if you specifically told it "c:\DatabaseStuff\Databasefile.db3". IIRC, at least with MS-SQL, it may try to open it as "\\hostname\.\c$\DatabaseStuff\Databasefile.db3" or something to that effect. On Mon, Jan 3, 2011 at 10:59 AM, Danny Staten <[email protected]>wrote: > ?Yeah I have posted in MSDNs forums, and a forum specific to entity > framework and sqlite. So far nobody has responded. I know that this > mailing list hits a very wide spectrum of technologies that use sqlite, > but > I was hoping that some of them would be using entity framework being that > in > the world of microsoft development it is pretty common. Thanks. > > Danny > > -----Original Message----- > From: Simon Slavin > Sent: Monday, January 03, 2011 7:07 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] The underlying provider failed to open? > > > On 3 Jan 2011, at 1:58am, Danny Staten wrote: > > > I am using sqlite with .net and entity framework 4. I am building an > > application in WPF that uses the sqlite for my data, and it has gone > > very > > well... up until I formatted my machine and set up my development > > environment again. I had everything backed up including my sqlite file, > > but I can’t get my database to open via my C# code in entity framework > any > > more. > > > > I can still browse the database using visual studio’s server explorer so > I > > know that it can be connected to, and that the data is accurate. I can > > delete and recreate my edmx based on my sqlite file so I am confident > that > > the connection string references the right file. However any time I run > > my application I get an exception that my provider failed to open. > > Your problem is not with SQLite, it's either with '.net and entity > framework > 4' or with your own application. You are more likely to get help asking > in > a forum familiar with those things. I would suggest you post the exact > text > of your exception in a forum about 'entity framework 4', whatever that is. > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
