Your question, your audience. Choose who sees your identity—and your question—with question security.
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 %>
Join the community of 500,000 technology professionals and ask your questions.