yogiyang
Posts: 26
|
| Posted: 06/09/2009, 8:16 AM |
|
Till date I have been studying ready made samples and some samples supplied by this community members like Wasp.
Now I want to try and build out my own sample. For this I have a small MDB file which has got two tables and each table has 3 fields.
There are the steps that I am using:
- I create a folder for holding CCS project.
- I copy the MDB file to the project folder.
- I start CCS and in the start up dialogbox I select New Project -> Blank Project.
- I set the name of the project to 'YogiTest'.
- Folder to the folder that I had created before.
- I select Language to be ASP.NET C# & rest standard.
Till here everything seems to work well.
- In Project Explorer I right click on Connections & select New Connection
- Name Connection to 'cnYogiTest'
- As Database I select MS Access
From here problems seem to start for me.
- I click on build button to build a connection string and set it to use Jet 4.0 OLEDB Provider and locate the MDB file and click on Test Connection which is reported to be successful.
- Now when I click the OK Button nothing appears in the connection string of the CCS's Add New Connection DialogBox.
What is wrong here?
Have I to use some other way of doing this connection thing?
I have also tried this as per what is shown in Help file but no use.
Please guide me here.
_________________
Regards,
Yogi Yang |
 |
 |
Waspman
Posts: 948
|
| Posted: 06/09/2009, 12:44 PM |
|
Hi Yogi,
It should have a string in the connection field something like...
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Tony\Desktop\database.mdb;Persist Security Info=False
Normally I'd contact support or re-install CCS.
T
(Does the connection string work in the Blog example)
_________________
http://www.waspmedia.co.uk |
|
|
|
yogiyang
Posts: 26
|
| Posted: 06/09/2009, 11:54 PM |
|
Thanks Waspman for hint.
After reading your post I manually pasted string in the connection string and it seems to work but now I face another problem.
It does shows only one table instead of two!
I Save and Close Project.
I reopen it and the connection string is gone! 
I am really baffled as to what to do.
I think I will have to contact support for this problem.
_________________
Regards,
Yogi Yang |
|
|
|
|
