DbNetSuiteVS 1.0 Now Available  

Tips / FAQ

Converting the default dictionary to Sql Server
I have installed the US English version of DbNetSpell so I'm currently using Access. I would like to host the dictionary tables in Sql Server. How do I go about that?
Show Answer
1) Download the US English dictionary file (engus.csv) and place it in the 'imports' subfolder of the DbNetSpell installation folder. This is a CSV file supplied within a zip archive, so make sure you extract it. The dictionary file may be downloaded from this URL

http://www.dbnetspell.com/dbnetspell/download.aspx

2) Identify the Sql Server database which will serve as the location for the new dictionary table. You can use an existing database or create a new one. You should then take the OLEDB connection string which accesses the database and copy this into the value property of the 'default' connection alias within the web.config file in the DbNetSpell installation folder. For example;

<add key="default" value="Provider=SQLOLEDB;Server=server1;Database=northwind;UID=sa;PWD=;"/>

(note - you can check the connection string first by pasting it into the conection string test utility which is accessible from the DbNetSpell menu page.)

3) You can then run the Dictionary Management utility from the DbNetSpell menu page. Select the 'engus.csv' option from the list of Dictionary Source Files (it should be the only one) and select 'default' from the connection alias drop-down (again, it should be the only option) and then click on the button to 'Create Dictionary'. Progress should be reported after every 1000 words.

This completes the conversion process. All your existing DbNetSpell pages will now extract information from the SQl Server tables.

Hide Answer


Accents & Capitalisation in French
Does DbNetSpell allow me to omit accents from capitals in French?
Show Answer
No. DbNetSpell will require you to accent capitals wherever they would be required in the lower case equivalent.

Hide Answer