MSDE and DDL error

I have recently set up MSDE through a SharePoint services
install. I added a database, but when I go to add a table
through Visual Studio or osql I get the error "ADO error:
DDL statement is not allowed." I have tried to modify the
DDL settings in my database through >> exec sp_dboption
mydatabase, "ddl in tran", true <<, but "ddl in tran" is
not a recognized option any longer. Anyone know a
workaround on this? THANKS>Check your MDAC version
Try to update it.
Regards
---
All information provided above AS IS.
"Stephen Haiman" <shaiman@.ctt-inc.com> wrote in message
news:115501c3a2ea$88b9a2a0$a301280a@.phx.gbl...
> I have recently set up MSDE through a SharePoint services
> install. I added a database, but when I go to add a table
> through Visual Studio or osql I get the error "ADO error:
> DDL statement is not allowed." I have tried to modify the
> DDL settings in my database through >> exec sp_dboption
> mydatabase, "ddl in tran", true <<, but "ddl in tran" is
> not a recognized option any longer. Anyone know a
> workaround on this? THANKS>

MSDE 1 or MSDE 2K ?

I want to experiment a little bit with the MSDE. I'll be working with
it strictly from Visual Basic 6.
I have both versions of MSDE available for installation (on
Windows2K). Which one should I use?
hi Martin,
"Martin" <martinvalley@.comcast.net> ha scritto nel messaggio
news:ku03605ao6d7v7o4vt9op58f1ob6f88m52@.4ax.com...
> I want to experiment a little bit with the MSDE. I'll be working with
> it strictly from Visual Basic 6.
> I have both versions of MSDE available for installation (on
> Windows2K). Which one should I use?
as MSDE 1.0 is base on SQL Server 2000 and is currently only in maintenance,
I'd stick with the live one, MSDE 2000, which is full supported and is
plenty of new features with regards to the SQL Server 7.0 code base...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.6.0 - DbaMgr ver 0.52.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||are things mixed up?
|||minor correction in <>
as MSDE 1.0 is base on SQL <Server 7.0> and is currently only in
maintenance,
I'd stick with the live one, MSDE 2000 (<based on SQL Server 2000>), which
is full supported and is
plenty of new features with regards to the SQL Server 7.0 code base...
MSDE 2000 (latest release) is available from
http://www.microsoft.com/downloads/d...displaylang=en
Thanks
Dave.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marc" <anonymous@.discussions.microsoft.com> wrote in message
news:84CAA9BC-DE4F-4779-BE75-B6B715F4A6B4@.microsoft.com...
> are things mixed up?