Re: [sqlite] Help with SQLite and VB2010 Express
Hi, Simon I am a SQLite user. And before I can get to ask questions about SQLite Database, I must be able to use it with Visual Studio 2010. The tools from SQLite are not up to par. So I think all questions about SQLite and the environment it can be used are SQLite User Question. I will always answer them, if I can help. And if I know of another Forum that answers the better will provide it. So do not be so sanctimonious. Guy -Original Message- From: Simon Slavin Sent: Monday, January 10, 2011 5:49 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Help with SQLite and VB2010 Express On 10 Jan 2011, at 9:34pm, Bob Keeland wrote: > Obviously I don't know what I'm doing with SQLite so I'll ask the question > that shows my ignorance. > What is the difference between what can or should be asked on this list > and what should be directed to the System.Data.SQLite forum? The easiest way is to pretend that the people on this list (the sqlite-users one) have never used your operating system or programming language, and the people on the System.Data.SQLite forum have never used the advanced features of SQLite. The question you asked refers in detail to .NET, particular setup procedures, and OleDB. None of those things are part of SQLite, and none of them can be downloaded from the SQLite home site. From our point of view, they're not really part of the subject matter of this list. It's possible that you'll find someone on this list who can answer your question. But it's more likely that you'll get better help from the other list because those are the people who understand all the technical terms you used. Had your question been about the syntax of a SQLite command, this list would be better. > They seem to have duplicate purposes - helping people who are having > problems. I read quite a few technical fora like that but they don't have much overlap. People who read one of the lists won't help me with the subject-matter of another list because they just don't know about it, and the question would be off-charter anyway. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help with SQLite and VB2010 Express
Hi, Simon I am a SQLite user. And before I can get to ask questions about SQLite Database, I must be able to use it with Visual Studio 2010. The tools from SQLite are not up to par. So I think all questions about SQLite and the environment it can be used are SQLite User Question. I will always answer them, if I can help. And if I know of another Forum that answers the better will provide it. So do not be so sanctimonious. Guy -Original Message- From: Simon Slavin Sent: Monday, January 10, 2011 5:49 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Help with SQLite and VB2010 Express On 10 Jan 2011, at 9:34pm, Bob Keeland wrote: > Obviously I don't know what I'm doing with SQLite so I'll ask the question > that shows my ignorance. > What is the difference between what can or should be asked on this list > and what should be directed to the System.Data.SQLite forum? The easiest way is to pretend that the people on this list (the sqlite-users one) have never used your operating system or programming language, and the people on the System.Data.SQLite forum have never used the advanced features of SQLite. The question you asked refers in detail to .NET, particular setup procedures, and OleDB. None of those things are part of SQLite, and none of them can be downloaded from the SQLite home site. From our point of view, they're not really part of the subject matter of this list. It's possible that you'll find someone on this list who can answer your question. But it's more likely that you'll get better help from the other list because those are the people who understand all the technical terms you used. Had your question been about the syntax of a SQLite command, this list would be better. > They seem to have duplicate purposes - helping people who are having > problems. I read quite a few technical fora like that but they don't have much overlap. People who read one of the lists won't help me with the subject-matter of another list because they just don't know about it, and the question would be off-charter anyway. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help with SQLite and VB2010 Express
Thank you for the reply, it makes more sense now. I'll go to the forum on System.Data.SQLite. BobK --- On Mon, 1/10/11, Simon Slavin wrote: From: Simon Slavin Subject: Re: [sqlite] Help with SQLite and VB2010 Express To: "General Discussion of SQLite Database" Date: Monday, January 10, 2011, 4:49 PM On 10 Jan 2011, at 9:34pm, Bob Keeland wrote: > Obviously I don't know what I'm doing with SQLite so I'll ask the question > that shows my ignorance. > What is the difference between what can or should be asked on this list and > what should be directed to the System.Data.SQLite forum? The easiest way is to pretend that the people on this list (the sqlite-users one) have never used your operating system or programming language, and the people on the System.Data.SQLite forum have never used the advanced features of SQLite. The question you asked refers in detail to .NET, particular setup procedures, and OleDB. None of those things are part of SQLite, and none of them can be downloaded from the SQLite home site. From our point of view, they're not really part of the subject matter of this list. It's possible that you'll find someone on this list who can answer your question. But it's more likely that you'll get better help from the other list because those are the people who understand all the technical terms you used. Had your question been about the syntax of a SQLite command, this list would be better. > They seem to have duplicate purposes - helping people who are having >problems. I read quite a few technical fora like that but they don't have much overlap. People who read one of the lists won't help me with the subject-matter of another list because they just don't know about it, and the question would be off-charter anyway. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help with SQLite and VB2010 Express
On 10 Jan 2011, at 9:34pm, Bob Keeland wrote: > Obviously I don't know what I'm doing with SQLite so I'll ask the question > that shows my ignorance. > What is the difference between what can or should be asked on this list and > what should be directed to the System.Data.SQLite forum? The easiest way is to pretend that the people on this list (the sqlite-users one) have never used your operating system or programming language, and the people on the System.Data.SQLite forum have never used the advanced features of SQLite. The question you asked refers in detail to .NET, particular setup procedures, and OleDB. None of those things are part of SQLite, and none of them can be downloaded from the SQLite home site. From our point of view, they're not really part of the subject matter of this list. It's possible that you'll find someone on this list who can answer your question. But it's more likely that you'll get better help from the other list because those are the people who understand all the technical terms you used. Had your question been about the syntax of a SQLite command, this list would be better. > They seem to have duplicate purposes - helping people who are having > problems. I read quite a few technical fora like that but they don't have much overlap. People who read one of the lists won't help me with the subject-matter of another list because they just don't know about it, and the question would be off-charter anyway. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help with SQLite and VB2010 Express
Hi, Bob I had problems to when i installed SQLite-1.0.66.0-setup specially with apps that I had created with SQLite-1.0.65.0-setup and also because of the framework 4.0, for that there is a work around to modify in the config file of the app. I will try to find the details and report back to you cause now every thing works fine now Be patient, Guy -Original Message- From: Bob Keeland Sent: Monday, January 10, 2011 4:34 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Help with SQLite and VB2010 Express Obviously I don't know what I'm doing with SQLite so I'll ask the question that shows my ignorance. What is the difference between what can or should be asked on this list and what should be directed to the System.Data.SQLite forum? They seem to have duplicate purposes - helping people who are having problems. BobK > You really don't need to run the msi. You can download the binary > package and added the dlls as references and start using the > dataprovider. In the future, this sort of question should be asked in > the System.Data.SQLite forum. On Mon, Jan 10, 2011 at 12:10 PM, Bob Keeland wrote: > I've been struggling with how to use SQLite with Visual Basic2010 Express. > VB2010 Express does not work with Microsoft Access (which I've used in the > past) and so I have to use SQL. I don't feel that I need the capabilities > of Microsoft SQL Server and so I've been looking at SQLite and MySQL. I've > got System.Data.SQLite (VB.NET - ADO.NET provider on how to connect to > SQLite within Visual Basic) from the forum and I've got > "SQLite-1.0.66.0-setup" but when I run it I get a message that says that > it will switch the OleDB connection in VB2010 to run SQLite instead of > Access. Then, it gives me an error message that it cannot read; > "c:\ . . . . \AppData\Local\Temp\tmpB3B6.tmp.msi" > > Does anyone know why I get this message? Do I need to buy Visual Studio > 2010 Professional in order to do database work? Is the VB2010 Express just > too limited??? > > BobK > > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help with SQLite and VB2010 Express
Obviously I don't know what I'm doing with SQLite so I'll ask the question that shows my ignorance. What is the difference between what can or should be asked on this list and what should be directed to the System.Data.SQLite forum? They seem to have duplicate purposes - helping people who are having problems. BobK > You really don't need to run the msi. You can download the binary > package and added the dlls as references and start using the > dataprovider. In the future, this sort of question should be asked in > the System.Data.SQLite forum. On Mon, Jan 10, 2011 at 12:10 PM, Bob Keeland wrote: > I've been struggling with how to use SQLite with Visual Basic2010 Express. > VB2010 Express does not work with Microsoft Access (which I've used in the > past) and so I have to use SQL. I don't feel that I need the capabilities of > Microsoft SQL Server and so I've been looking at SQLite and MySQL. I've got > System.Data.SQLite (VB.NET - ADO.NET provider on how to connect to SQLite > within Visual Basic) from the forum and I've got "SQLite-1.0.66.0-setup" but > when I run it I get a message that says that it will switch the OleDB > connection in VB2010 to run SQLite instead of Access. Then, it gives me an > error message that it cannot read; > "c:\ . . . . \AppData\Local\Temp\tmpB3B6.tmp.msi" > > Does anyone know why I get this message? Do I need to buy Visual Studio 2010 > Professional in order to do database work? Is the VB2010 Express just too > limited??? > > BobK > > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help with SQLite and VB2010 Express
You really don't need to run the msi. You can download the binary package and added the dlls as references and start using the dataprovider. In the future, this sort of question should be asked in the System.Data.SQLite forum. On Mon, Jan 10, 2011 at 12:10 PM, Bob Keeland wrote: > I've been struggling with how to use SQLite with Visual Basic2010 Express. > VB2010 Express does not work with Microsoft Access (which I've used in the > past) and so I have to use SQL. I don't feel that I need the capabilities of > Microsoft SQL Server and so I've been looking at SQLite and MySQL. I've got > System.Data.SQLite (VB.NET - ADO.NET provider on how to connect to SQLite > within Visual Basic) from the forum and I've got "SQLite-1.0.66.0-setup" but > when I run it I get a message that says that it will switch the OleDB > connection in VB2010 to run SQLite instead of Access. Then, it gives me an > error message that it cannot read; > "c:\ . . . . \AppData\Local\Temp\tmpB3B6.tmp.msi" > > Does anyone know why I get this message? Do I need to buy Visual Studio 2010 > Professional in order to do database work? Is the VB2010 Express just too > limited??? > > BobK > > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Help with SQLite and VB2010 Express
I've been struggling with how to use SQLite with Visual Basic2010 Express. VB2010 Express does not work with Microsoft Access (which I've used in the past) and so I have to use SQL. I don't feel that I need the capabilities of Microsoft SQL Server and so I've been looking at SQLite and MySQL. I've got System.Data.SQLite (VB.NET - ADO.NET provider on how to connect to SQLite within Visual Basic) from the forum and I've got "SQLite-1.0.66.0-setup" but when I run it I get a message that says that it will switch the OleDB connection in VB2010 to run SQLite instead of Access. Then, it gives me an error message that it cannot read; "c:\ . . . . \AppData\Local\Temp\tmpB3B6.tmp.msi" Does anyone know why I get this message? Do I need to buy Visual Studio 2010 Professional in order to do database work? Is the VB2010 Express just too limited??? BobK ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users