Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

AppTheory specializes in solutions based on the DotNetNuke platform and has 2 employees on the DotNetNuke Core Team.
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Biz Modules provides professional business modules and solutions for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
MadCap Software, Inc.
AspDotNetStoreFront - E-Commerce by Design - The Leading ASP.NET shopping cart platform for developers!
Click here to go to dev.live.com for Windows Live developer resources
SteadyRain
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Extend It! ( Pr...  Syntax error when installing module but SQL is fine
Previous Previous
 
Next Next
New Post 5/6/2008 10:10 AM
User is offline Snoek8
41 posts
www.mexmax-internet.com
10th Ranked


Syntax error when installing module but SQL is fine 

I am having a strange problem with one of my modules. When I install it I get a syntax error in one of the sql provider files. When I copy the complete content of this sql file and execute it from Host>SQL with "run as script" the SQL executes without any problem. This leads me to think that there is no actual syntax error in the script but rather that the sql is interpreted in two diferent ways.

I hope somebody can shed some light on this.

Thanks.
 
New Post 5/6/2008 3:30 PM
User is offline William Severance
576 posts
www.wesnetdesigns.com
8th Ranked




Re: Syntax error when installing module but SQL is fine 

Make sure that you are saving your SqlProvider files with encoding UTF-8 not ANSI. Otherwise, some characters (most notibly the '+') will get stripped out when the script is run in the installer.

Bill, WESNet Designs
 
New Post 5/7/2008 2:24 PM
User is offline Snoek8
41 posts
www.mexmax-internet.com
10th Ranked


Re: Syntax error when installing module but SQL is fine 

At a risk of sounding stupid but how can I check this? And how can I save it as UTF-8 from Visual studio?
 
New Post 5/7/2008 3:12 PM
User is offline Rhys
51 posts
10th Ranked


Re: Syntax error when installing module but SQL is fine 

Believe it or not, humble Notepad can do the job. Use File | Save As, then choose your Encoding from the dropdown at the bottom of the dialog.

If this doesn't do the trick can you post details of the error and the offending SQL?

Regards, Rhys

www.rmjcs.com - Mostly SQL Server Stuff
 
New Post 5/8/2008 7:44 AM
User is offline Snoek8
41 posts
www.mexmax-internet.com
10th Ranked


Re: Syntax error when installing module but SQL is fine 

Thanks a lot guys this was the problem. Is there a way to check the encoding used for textfiles so you can easily spot a file that has the wrong encoding?

Stephan
http://www.mexmax-internet.com
 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  General DotNetN...  Extend It! ( Pr...  Syntax error when installing module but SQL is fine
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


TMA Resources
TMA Resources is a software company providing eBusiness solutions for the Association market.
www.tmaresources.com 		DotNetNuke Hosting Provider UK
UK leading DotNetNuke Hosting provider. Owned and operated by a Microsoft Gold Certified Partner.
www.DNN-Portals.co.uk 		Alliance Systems & Programming Inc
Alliance is not just our name... it's how we do business. We partner with our clients, learning their business processes and standards and then applying our expertise to help them improve their workflow and profitability.
www.Alliancesys.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP