Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!
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.