Sharepoint DDL error

Question

Sharepoint DDL error

chisholmd

SSCrazy

Points: 2490
More actions
September 29, 2004 at 3:01 pm

#85605

HI, A client of mine has sharepoint installed and working. They want me to display some of their sharepoint data on their public web page. I have connected to the sharepoints MSDE database with enterprise manager but I am unable to create any views, stored procedures etc.
I created a SQL account and gave it the neccessary permissions for creating procs etc and access to the underlying tables.
When I try to save my view or proc I get an ODBC error "DDL statement is not allowed"
Whats up with that?

Dave
Trainmark.com IT Training B2B Marketplace
(Jobs for IT Instructors)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jim Erickson Grasshopper Points: 12 More actions · Answer 1

If you are using FrontPage use webparts. This where you connect to the database and create queries with SharePoint services.

Jim

chisholmd SSCrazy Points: 2490 More actions · Answer 2

Thanks. I needed specifically to connect to the database from a remote server and I foudn the answer. Sharepoint services installs a version of MSDE called WMSDE which specifically forbids connections from remote servers.

Fortunetly for me their was other reasons to upgrade that server to full sql 2000 so once sharepoint is migrated to sql there won't be a problem.

This was one of those annoying problems were you double check the connection string, firewall and account permissions over and over and over until you finally realize that something else is going on. I cast my vote for bigger budgets for the guys that write error messages. An error message like;

"This version of SQL (WMSDE) doesn't not allow remote connections"

Dave

Trainmark.com IT Training B2B Marketplace
(Jobs for IT Instructors)

Ryan Thompson Grasshopper Points: 10 More actions · Answer 3

A client has asked me to do some data manipulation on a Sharepoint Services database.

I am trying to add a trigger to the Userdata table to capture updated or inserted events and record them against a master event record. Try as I might by adding permissions, roles, logging in as "sa" etc etc I get the ODBC error "DDL statement is not allowed".

It seems that any manipulation of the data structure, triggers, stored procedures etc in the Sharepoint services database running on WMSDE is just not allowed.

Can someone confirm that there is no option to allow DDL statements, as it seems the only solution to either upgrade the database to SQL Server 2000 or have a third party tool to manipulate the data.

Thanks

chisholmd SSCrazy Points: 2490 More actions · Answer 4

Sounds like your having the same problem I was but from a different source. Fortunetly we had other reasons to install sql2000 on the same box so the natural solution for us was to simply port sharepoint to sql. How did you make out?

Dave

Trainmark.com IT Training B2B Marketplace
(Jobs for IT Instructors)

Ryan Thompson Grasshopper Points: 10 More actions · Answer 5

We ended up developing a .NET service running on the sharepoint server which ran checks on the data at regular intervals and emailed a user if there were event conflicts.