Microsoft OLE DB Provider for SQL Server error '80040e14'
There is already an object named 'MyTable' in the database.
/Populate.asp, line 25
<% set conn = CreateObject("ADODB.Connection") conn.open "Provider=SQLOLEDB;Data Source=server-name;User ID=myUN;Password=********;" sql = "CREATE DATABASE MyDatabase" conn.execute sql, , 129 if not tableExists then tableCreate = "CREATE TABLE Mytable(" & _ "IDColumn INT not null," & _ "IntegerColumn INT," & _ "VarcharColumn VARCHAR(50)," & _ "MemoColumn VarChar(MAX))" conn.execute tableCreate, , 129 end if conn.close set conn = nothing %>
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.