Hi,
I was able to create an MSSQL database with the ASPNETDB.MDF file. But how do I get the Login Control to point to the MSSQL rather than the \App_Data\ASPNETDB.MDF file?
Hi
you need to see This
Configuring ASP.NET 2.0 Application Services to use SQL Server 2000 or SQL Server 2005
|||
check out below solved thread..
Login control And DB - ASP.NET Forums
you might need to include the tables and stored procedure which requires for login control into your DB...
hope it helps./.
Hi
I am trying to use Association Viewer Control in
Microsoft.AnalysisServices.Viewers.DLL dll in VS 2005 but sometimes it gives an error.
"Code generatio for property 'ConnecitonManager'" failed. Error was:'Property accesor 'ConnectionManager' on object 'AssosiactionViewer1' threw the following exception:'Object referance not set to instance of an object"
Is there anyone here who use
"Microsoft SQL Server 2005 Datamining Viewer Controls" in SQLServer2005 FeaturePack ?
http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en
i am using VS2005 Version 8.0.50727.762 (SP.050727-7600)
and SQL Server 2005 SP2
thanks from now.
Cem üney
Thanks for reporting this issue. We are trying to reproduce this problem and will provide an update soon.|||Thank you very much for your reply.
i hope you can see the same problem.
|||Cem,
It would be very helpful if you could tell us a little bit more about your problem. Have you found any particular conditions when you hit the error? Are you getting the error when creating the viewer? or after? What are you doing before invoking the viewer? This will save us a lot guessing and we will be able to find the problem and work a solution earlier.
Thanks,
Fernando Godinez, SQL Server Data Mining
|||ok sir,
i am sending you the pictures that shows my problem. thanks for your interest.
viewer1.jpg
http://img517.imageshack.us/my.php?image=viewer1sz6.jpg
i just open new VBProject.
viewer2.jpg
http://img478.imageshack.us/img478/4223/viewer2jp1.jpg
i add the Microsoft.AnalysisServices.Viewers.dll controls to ToolBox
viewer3.jpg
http://img504.imageshack.us/img504/2976/viewer3qd4.jpg
i just drag and drop the AssociationViewer control to my empty form. When i click properties after 2-3 seconds, it gives me the error at the image.
viewer4.jpg
http://img504.imageshack.us/img504/7746/viewer4ho7.jpg
Connection Manager error and my referances. Maybe i have to some more references but which one?
viewer5.jpg
http://img504.imageshack.us/img504/9749/viewer5if8.jpg
When i close the project and open it again i saw this message
All pictures are here
http://rapidshare.com/files/38900865/viewer.rar.html
|||Cem,
I was able to reproduce the error and we will work on it. In the meantime here is what you need to do to get you application running:
1. Create a form with a Panel on it.
2. From the code part you will have to create a new AssociatonViewer
3. Set the ConnectionString property for you association viewer manually
4. Set the mining model name that you want to view
5. Add the viewer to the panel controls collection
6. Call the LoadViewerData method from the viewer (context parameter can be null).
* Note: You connection string must have the form "Provider=MSOLAP.3;Data Source= your server name;Initial Catalog=your catalog". Where you must provide your server name and your catalog name.
You can see an implementation on the use of the controls in http://www.sqlserverdatamining.com/dmcommunity/_downloads/1361.aspx
All the code in that sample is in C# but I'm sure you can get the grasp without much trouble.
Hope this helped,
Fernando
|||ok fernando,
i know the example before, and i adapted it to VB.
control does not give error when its created at runtime.
thanks for your interest again.
Cem üney
