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  |  

telerik -- supercharge your DNN websites
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Engage Software - Training Partner for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

Merak Mail Server
WebSecureStores -- ASP.NET & DotNetNuke Hosting Solutions
FCKeditor Project
Salaro -- Skins and more
OnyakTech
The best choice for your web site host, email hosting, and domain registration.
 


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
50 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
787 posts
www.wesnetdesigns.com
7th 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
50 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
50 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.
 


DM Analytics, LLC
DM Analytics, LLC provides software solutions that facilitate rapid development of independent or dependent datamarts and their associated web-based reporting.
www.dmanalytics.com 		Integral Hosting | DNN only $14.95/month
Experienced .NET hosting on Windows 2003, ASP.NET 1.1 & 2.0, MSSQL with real technical support.
www.integralhosting.com 		Aricie
Aricie is one of the French pioneers and experts in DotNetNuke technology.
www.aricie.com

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