Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
leahsmart
Posting Yak Master
133 Posts |
 Posted - 2004-05-25 : 04:41:33
|
| Hi Reader!I was wondering if it was possible to create a view in my sql database from an asp page.I have had a go at doing it and I get this error message:Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver]Syntax error or access violationThanksLeah |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2004-05-25 : 06:16:09
|
| Theoretically, should work, but definitely not recommended. How did you try to create the view - pass the CREATE VIEW statement to Connection.Execute()? Post the code and the statement.OS |
 |
|
|
leahsmart
Posting Yak Master
133 Posts |
Posted - 2004-05-25 : 06:26:44
|
| Thanks for your reply but I have got it working now as I posted the question on another forum.Thanks |
|
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-05-25 : 07:03:04
|
| Which forum?Could you paste the link please?Duane. |
|
|
|
leahsmart
Posting Yak Master
133 Posts |
Posted - 2004-05-25 : 07:05:54
|
| Sure:The reason it did not work is because I was begin a pleb:http://www.aspmessageboard.com/forum/databases.asp?M=700704&T=700704&F=21&P=1 |
|
|
|
|
|
|
Creating a view from an asp page