What's wrong with this statement? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

What's wrong with this statement?

Author

Topic

JasonASA
Starting Member

1 Post

Posted - 2007-06-25 : 13:51:22

[code]
<%@ Language="VBSCRIPT" %>

<%
connect.open connectString

Dim testSQL
testSQL = "INSERT INTO development (address) VALUES 'some address'"

connect.execute(testSQL)

%>

<% connect.close() %>
[/code]

Any idea what could be wrong with this statement? It's causing the following error:

[code]
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

/asa_dev/gm/dbTest.asp, line 10
[/code]

Thanks,
Jason

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-06-25 : 13:52:25

Have you tried running the insert statement in Query Analyzer/Management Studio to see if the statement is correct in SQL Server? You should always start there first rather than figuring it out via your application.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-06-25 : 13:52:56

[code]INSERT INTO development (address) VALUES ('some address')[/code]

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources