Join our DNN Community    (Newsletter, Tips, Tricks and Forums for DNN Skins & Modules)

 


 
Microsoft Gold Certified Partner - DNN Benefactor

DotNetNuke Powered! 
Friday, January 09, 2009 Register · Login · Contact · Search:  
Company Solutions Portfolio Contact
Forums
GoMap (free module)
Review and discuss the new FREE GoMaps module, Google Maps and DotNetNuke Integration.
Forums > Bi4ce.Modules > GoMap (free module)
Subject: Unable to find data table
You are not authorized to post a reply.
 
Author Messages
boilermanc
Flyweight
Posts:3
12/22/2006 1:26 PM Alert 
I have watched the videos (very helpful) and been able to work through the wizard. In that process I selected to create a new table. Where is the table? I cannot find and I did not recieve and error. Sorry if this is simple but I have tried everything i know. Thanks!
boilermanc
Flyweight
Posts:3
12/22/2006 1:52 PM Alert 
Did a little more digging and part of the problem is my inexperience with DNN and SQL Express. I opened Visual Studio and can connect to the database and find the module tables including the GoMap tables. However, in SQL Express Manager it only shows me the sys tables. How do you get the data tables to display in SQL Express? Additional question, has anyone had success importing data from an access file or cvs to SQL Express? I have not find a good resource that would explain it. Sorry if this is not the right place for this post. I appreciate the help none the less. Thanks!
boilermanc
Flyweight
Posts:3
12/22/2006 3:06 PM Alert 
Well, by trial and error I have made more progress today than in many previous hours. I have found how to display the data tables in sql express.

This article is a starting point...
http://www.dotnetnuke.com/Community/BlogsDotNetNuke/tabid/825/EntryID/1202/Default.aspx

But then I accidently found another way to do it.

1. Go into your app_data folder for you dnn install.
2. Make a copy of your database just in case.
3. Go to SQL Express Manager and select the database.
4. Right click and delete the database (it just deletes it from SQL Express).
5. Right click on Databases in SQL Express and select Attach.
6. Select Add.
7. Surf to the app_data folder and select the database for your install.
8. It will add the database with the full path.
9. Rename the database taking out the full path.
10. Voila! The data tables now show up in SQL Express!

I opened the site and it works like a champ so it didnt break anything in my case.

Hope that helps someone!

Now, gotta figure out how to get data into the tables...

Thanks!
You are not authorized to post a reply.
Forums > Bi4ce.Modules > GoMap (free module) > Unable to find data table


ActiveForums 3.6
Latest Post
 
At R2integrated (formerly Bi4ce), we take support seriously.  That's why we support our customers and DNN community with daily monitoring from our experienced engineering team.  We ask that the first step taken is to read the relevant documentation and support forums prior to submitting any questions that may already be available or have been answered.  We ask that you review the documentation that we provide for our products before posting a question.

The Forums are for our customers to chat, exchange ideas and strategies, and submit feedback.  Please be sure to perform keyword searches for previous related forum responses.

To be helpful when submitting a new item, please include the following: 
  1. DNN Version
  2. Module Version
  3. Admin Log Viewer Information
  4. Environment detail: Operating system, .NET framework version, database and version, IIS version, Browser version (if appropriate)
We always try to respond quickly and monitor the forums daily during business hours (EST).  Occasionally, requests for a specific project requirement may not apply for the free support offered. For project specific support please submit via our Information Request form.

Thank you for using our Forums.

Click here to register for the Forums
 
© 2008 by R2integrated (formerly Bi4ce) | DNN® is a registered trademark of DotNetNuke Corporation