DNN5.6.2 / form master 2.2.1

 

Trying to create table from existing form and getting invalid object name, which identifies the table name I gave but is putting dnn_ in front of it.  For example, if I create a table named "webinquiry" form master comes back with the following error message: "Invalid object name 'dnn_webinquiry'.  But if I look in the database the table is "webinquiry", not "dnn_webinquiry".  

 Help please.

 

Dana Richard

I really need help with this please....

Dana,

I took a tremendous amount of Steve's time with this problem and I think I owe him some. I have overcome some of the problems and found workarounds where I can't.

I had the same problems, but there are a crap load of parameters that determine your outcome.

1. Are your running shared hosting?

2. Are you on Sql Server 2005 or 2008 or Express?

3. Are you trying to attach an external Data Base or are having trouble accessing the Internal Data Base.

4. Who is your hosting account with?

5. What is the string Connection Connection your are trying?

6. If you are trying to access an external Data Base, Why, 'cause of the table size limitations, or, is it an off site

       Data Base that you need to read, or to Read/Write to?

I say all this, because I fought trying to isolate my Data Base on external Drives because of the amount of Data that my business is going to generate.

I was on GoDaddy, with their 500 MB Sql Server Db's and moved to Arvixe.com with 10 Gb Sql Server Tables and the  ability to link servers which solved most of my problems.

Just maybe, you need to step back and actually access what you really need, just like I did, after wasting a month of Steve's time and beating my head against the wall.

If  I can help you, I will out of respect for what Steve did for me, Dana.

Feel free to reach out, if you want.

johnh@thegardenstatemarketplace.com

John Hornak

Hi John,
Thank you for your offer to help. I don't think my problem is a huge one, but I guess we'll see. To answer your questions directly:


1. Are your running shared hosting?

No, hosted internally on dedicated server

2. Are you on Sql Server 2005 or 2008 or Express?

MSSQL 2008

3. Are you trying to attach an external Data Base or are having trouble accessing the Internal Data Base.

No

4. Who is your hosting account with?

n/a

5. What is the string Connection Connection your are trying?

This question made me think...I obtained the connection string from the web.confg but it just dawned on me that it is going to an external server. I removed the connection string because I want the table on the local dnn db. I've got to wait until next week to test this because the server is in production so I'll have to schedule some time.

6. If you are trying to access an external Data Base, Why, 'cause of the table size limitations, or, is it an off site

Data Base that you need to read, or to Read/Write to?

Because I wasn't thinking....

I will post back on here next week after I get a chance to test. Thank you for the questions, they forced me to think!

Dana

Hi John,

I was able to recreate the problem this morning. Here is what I did...

1. made sure that no connection string was set.
2. Verified that I could see the tables in the default dnn database through the drop-down window in formmaster underneath the connection string field.
3. Selected "create new table from form"
4. Created the table from the form fields and titled it "EVG_DEV_WebInquiryForm"
5. Selected "Commit Operation"
6. Received error message "Invalid object name 'dnn_EVG_DEV_WebInquiryForm'."
7. Deleted mappings
8. Selected "create new table from form"
9. Created the table from the form fields and titled it "dnn_EVG_DEV_WebInquiryForm"
10. Selected "Commit Operation"
11.This seemed to take so I went to the settings menu and selected "Data Manager"
12. Received error message "Invalid object name 'dnn_dnn_EVG_DEV_WebInquiryForm'."

So it appears to me that there is something that is appending "dnn_" to the front of the table when searching for it.

I hope this helps.

Thanks,
Dana

Dana,

 Was wondering how did you make out with this problem?

John,

Thanks for the follow up. Nothing has changed. I am using the local DNN SQL instance so no connection string is defined. This works fine. But as soon as I try to either create a form from an existing table, map an existing form to a table, or create a table from an existing form I get the aforementioned error that table dnn_XXXX does not exist. If I name the table dnn_XXXX I get an error message that table dnn_dnn_XXXX does not exist.

I have heard nothing from Code5Systems so I am going to have to look elsewhere for a solution, which is too bad. It's potentially a nice product but...

Dana

Dana,

That's a shame, since I use it for about everything from forms to file download managers.

Here is the email for Steve: c5.cust.service@code5systems.com

I would try reaching out to him first.

In the mean time.....

Did you try Uninstalling the extension its self and and reloading it from scratch?

You can save your existing forms using the export content command in the module setting so you don't lose your work.

You then reload them into the module using the import command.

Good Luck,

John

Hi,

I have a very similar issue.  I think this is probably a bug, not an install or configuration issue.  The symptoms you describe leads me to believe you have objectQualifier="dnn" in your web.config file under "SqlDataProvider".  I am going to search the forum for any mention of issues relating to the DNN objectQualifier.  If I have any time left I will report back my findings, if any.

WWSDA,

Thanks for the info. I checked and you are correct, it is set to "DNN". I agree that this is most likely a bug vs a config error. I guess the big question is how to get it addressed. Apparently not through the forum. I'll try customer service and see if it goes anywhere.

Thanks,
Danarich

Problem was resolved by upgrading to V2.2.2

Hi,

I have upgraded to v2.2.2 and the problems with ObjectQualifier persist.

• If I map a table, the table is created without the ObjectQualifier.  
• If I go out and back in (manage) I receive an error at the top of the page: "Invalid object name 'oq_myTable' ", where oq is the object qualifier.  
• If I submit test data it is written to the (improperly named) table
• I am unable to delete the mappings 
• Editing the mappings to remove a field does not appear to work (the field remains in the table, however I am not sure if this by design)

I am not opposed to tweaking the stored procedure (if any) that controls this behavior, to get a quick fix however I would like the change to come from Code5 so that I can still receive support.

I will try to reproduce. This is not a SP issue

Hi,

Thank you for looking into this.  By the way, we have scrapped our plans of using the webservice interface, which elevates this issue in priority for us.