DotConnect & Visual Studio Express 2010 Toolbox problem

shaharw18 · Post by **shaharw18** » Sun 27 Nov 2011 13:04

Hi,

I've installed dotConnect. and using it with no problem inside the code itlself.
in my Visual Studio Express 2010 I've added a new tab to the toolbox,
and added to it all the Devart components on the .NET components list.

the result was pointer + dblinqdatasource components only.
there were supposed to be around 10 components.

my project is a web project.
does anyone has a clue what should I do, inorder to solve the situation?

thanks
Shahar.

Pinturiccio · Post by **Pinturiccio** » Mon 28 Nov 2011 13:47

You can register only 3 components in toolbox for dotConnect for SQLite in Microsoft Visual Web Developer 2010 Express:
-SQLiteDataSource
-DbLinqDataSource
-DbSqlDataSource

SQLiteDataSource allows setting up the corresponding SQLiteConnection, SQLiteCommands, etc. via its design time interface.

shaharw18 · Post by **shaharw18** » Tue 29 Nov 2011 07:51

thats a good answer, just that there was no sqliteDatasource on the list.

that is the problem I have. the components are not there.

: )

Pinturiccio · Post by **Pinturiccio** » Tue 29 Nov 2011 11:42

Please make sure that you add all components the Namespace column of which starts with "Devart". You can do it easily by sorting the component by the 'Assembly Name' column.
If you add all components the Namespace column of which starts with "Devart" and SQLiteDataSource is not in the toolbox, then please specify your dotConnect for SQLite version and edition.

shaharw18 · Post by **shaharw18** » Tue 29 Nov 2011 11:51

hi,

My dotConnect version is the one I've downloaded from Devart website
2 days ago.

I'm using visual studio express 2010.

thanks
Shahar

Pinturiccio · Post by **Pinturiccio** » Wed 30 Nov 2011 10:21

Try to reinstall the dotConnect for SQLite. Perform the following steps:
1. uninstall dotConnect for SQLite;
2. remove all Devart.* and policy.*.Devart.* files from the GAC;
3. clear the Program Files\Devart\dotConnect and Program Files\Common Files\Devart\dotConnect folders;
4. re-install dotConnect for SQLite.
5. Select the "Install menu item and toolbox components into Visual Studio" check box.

If SQLiteDataSource is not in the toolbox, you have to add it manually:
1. Open Visual Studio and go to Toolbox window;
2. Select 'Add Tab' from the Toolbox window popup menu, type SQLite for its name, and press the ENTER key;
3. Select Choose Items... from the popup menu;
4. In the Choose Toolbox Items dialog box switch to the .NET Framework tab;
5. Select the components with the Namespace starting from 'Devart'. You can sort components by their namespace for more convenience (to sort them, click the header of the Namespace column);
6. Click OK.

overtime wrote:please specify your dotConnect for SQLite version and edition.

You can find dotConnect for SQLite version and edition in the Programs and Features window (Windows Vista and 7) or Add or Remove Programs window (Windows XP and earlier).
Windows 7:
1. Run Control Panel->Uninstall a Program.
2. Find Devart dotConnect for SQLite.
3. dotConnect for SQLite version is displayed in the Version column.
4. dotConnect for SQLite edition is displayed in the Name column. For example: dotConnect for SQLite Trial (Trial Edition), dotConnect for SQLite Express (Express edition), etc.

Windows XP:
1. Run Control Panel->Add or Remove Programs.
2. Find Devart dotConnect for SQLite.
3. Click the reference "Click hear for support information". The Support Info window will be opened.
4. dotConnect for SQLite version is displayed in this window.
5. dotConnect for SQLite edition is displayed in the Name column. For example: dotConnect for SQLite Trial (Trial Edition), dotConnect for SQLite Express (Express edition), etc.

Please tell us dotConnect for SQLite version and edition. Looking forward to your reply.

shaharw18 · Post by **shaharw18** » Wed 30 Nov 2011 11:32

hi

I've done exactly what you've wrote.
I've installed the latest dotConnect version.
the components were not in the toolbox.
I went to add them manualy.
the entire .NET components list of Devart where selected already on the list.
despite all of that, what I see in the toolbox is:
pointer, dblinqdatasource.

my dotconnect version is: Standart 3.50.250.0

thanks
Shahar.

Pinturiccio · Post by **Pinturiccio** » Wed 30 Nov 2011 12:56

dotConnect for SQLite Standard edition does not provide the SQLiteDataSource component for web applications.
For more details please refer to http://www.devart.com/dotconnect/sqlite/editions.html

shaharw18 · Post by **shaharw18** » Wed 30 Nov 2011 13:30

thats explains the situation thank you.