# I am new In clarion and I am not sure how to connect clarion IDE to a database which I made in sql server management studio **URL:** \ **Category:** questions\ **Created:** [May 26, 2017, 6:44am UTC](https://clarionhub.com/t/i-am-new-in-clarion-and-i-am-not-sure-how-to-connect-clarion-ide-to-a-database-which-i-made-in-sql-server-management-studio/1194 "2017-05-26T06:44:44Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![jerin8326](https://clarionhub.com/letter_avatar_proxy/v4/letter/j/ac8455/32.png) [@jerin8326](https://clarionhub.com/u/jerin8326)\ **Post date:** [May 26, 2017, 6:44am UTC](https://clarionhub.com/t/i-am-new-in-clarion-and-i-am-not-sure-how-to-connect-clarion-ide-to-a-database-which-i-made-in-sql-server-management-studio/1194/1 "2017-05-26T06:44:44Z")
Can some one please help !!1! ---
**Author:** ![Mike\_Duglas](https://clarionhub.com/user_avatar/clarionhub.com/mike_duglas/32/1061_2.png) [@Mike\_Duglas](https://clarionhub.com/u/Mike_Duglas)\ **Post date:** [May 26, 2017, 11:22am UTC](https://clarionhub.com/t/i-am-new-in-clarion-and-i-am-not-sure-how-to-connect-clarion-ide-to-a-database-which-i-made-in-sql-server-management-studio/1194/2 "2017-05-26T11:22:34Z")
You have to have a dictionary, in which you call “Import Table” wizard. ---
**Author:** ![seanh](https://clarionhub.com/letter_avatar_proxy/v4/letter/s/4af34b/32.png) [@seanh](https://clarionhub.com/u/seanh)\ **Post date:** [May 27, 2017, 12:14am UTC](https://clarionhub.com/t/i-am-new-in-clarion-and-i-am-not-sure-how-to-connect-clarion-ide-to-a-database-which-i-made-in-sql-server-management-studio/1194/3 "2017-05-27T00:14:17Z")
Like Mike says. Clarion uses it’s own data dictionary which you need to sync with the MSSQL database. You can do this via import tables or if you have the EE version of clarion then there a dictionary sync option in the dictionary. ---
**Author:** ![jerin8326](https://clarionhub.com/letter_avatar_proxy/v4/letter/j/ac8455/32.png) [@jerin8326](https://clarionhub.com/u/jerin8326)\ **Post date:** [May 27, 2017, 10:58am UTC](https://clarionhub.com/t/i-am-new-in-clarion-and-i-am-not-sure-how-to-connect-clarion-ide-to-a-database-which-i-made-in-sql-server-management-studio/1194/4 "2017-05-27T10:58:02Z")
Can u provide all the steps and the code in Clarion ? ---
**Author:** ![seanh](https://clarionhub.com/letter_avatar_proxy/v4/letter/s/4af34b/32.png) [@seanh](https://clarionhub.com/u/seanh)\ **Post date:** [May 28, 2017, 2:29am UTC](https://clarionhub.com/t/i-am-new-in-clarion-and-i-am-not-sure-how-to-connect-clarion-ide-to-a-database-which-i-made-in-sql-server-management-studio/1194/5 "2017-05-28T02:29:57Z")
Create a new dictionary, where you click to add a table, pull down for the option to import tables, follow the prompts. You choose an odbc source and navigate to your database In code the table owner is the connection string. ---
**Author:** ![jerin8326](https://clarionhub.com/letter_avatar_proxy/v4/letter/j/ac8455/32.png) [@jerin8326](https://clarionhub.com/u/jerin8326)\ **Post date:** [May 29, 2017, 12:34pm UTC](https://clarionhub.com/t/i-am-new-in-clarion-and-i-am-not-sure-how-to-connect-clarion-ide-to-a-database-which-i-made-in-sql-server-management-studio/1194/6 "2017-05-29T12:34:59Z")
Thnks a lot seaanh ! ---
**Author:** ![jerin8326](https://clarionhub.com/letter_avatar_proxy/v4/letter/j/ac8455/32.png) [@jerin8326](https://clarionhub.com/u/jerin8326)\ **Post date:** [May 29, 2017, 12:36pm UTC](https://clarionhub.com/t/i-am-new-in-clarion-and-i-am-not-sure-how-to-connect-clarion-ide-to-a-database-which-i-made-in-sql-server-management-studio/1194/7 "2017-05-29T12:36:28Z")
Error(5): cif$fileopen hell2.exe Access is denied. - Is der any fix for this error ? everytime I run a application I will recive this error the next time I run it . .. I will hav to wait for 5-10 mins and den run again !! is der any fix for this isssue ?? ---
**Author:** ![Rudik](https://clarionhub.com/letter_avatar_proxy/v4/letter/r/439d5e/32.png) [@Rudik](https://clarionhub.com/u/Rudik)\ **Post date:** [May 31, 2017, 11:08am UTC](https://clarionhub.com/t/i-am-new-in-clarion-and-i-am-not-sure-how-to-connect-clarion-ide-to-a-database-which-i-made-in-sql-server-management-studio/1194/8 "2017-05-31T11:08:21Z")
I think you get this error when clarion try to build a new exe/dll, and that mean only that this file is still in use. Obviously your exe hang instead of close itselfe. Check in the Windows TaskManager if your exe is still running and quit it there.