VBScript: Syntax Error in FROM clause

Question

This is my first visit here. I need help with connection to access db from vbscript, I will appreciate any clues! This is my code:

connStr = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\Users\Gregory\Documents\db1.accdb"
set conn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.Recordset") 
conn.Open connStr
rs.CursorType = adOpenStatic
rs.Open "SELECT username FROM User", conn

I should also add that there is just one table in the database, called "User" and it's got three fields: username, password and realName.

@user3786747 -- You have to have patience -- it's Saturday night (depending on where you are, of course). — rory.ap
– rory.ap, Commented Jun 28, 2014 at 22:13
This is what I am getting: Script error detected at line 19. Source line: rs.Open "SELECT username FROM User", conn Description: Syntax error in FROM clause. — user3786747
– user3786747, Commented Jun 28, 2014 at 22:29
I believe User is a reserved word in SQL. Try using [] around the table name: select username from [User] — Bond
– Bond, Commented Jun 29, 2014 at 0:43

Bond · Accepted Answer · 2014-06-29 02:17:51Z

2

I believe User is a reserved word in SQL. Try using [ ] around the table name:

select username from [User]

answered Jun 29, 2014 at 2:17

Bond

16.3k6 gold badges34 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBScript: Syntax Error in FROM clause

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related