Hi,
I have an error in my code which says:
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ':'.
At line 69.
Here's the code:
strInsertSQL = "INSERT INTO Navigation (UserName, SystemTime, InitialProcess, OpportunityGUID, ActivityGUID) "
strInsertSQL = strInsertSQL & "VALUES (" & userID & ", " & time() & ", " & "TEST" & ", " & "Blank" & ", " & strActivityID & ")"
objRS= objConn.Execute(strInsertSQL)
line 69 of my code is the last line above where it executes the sql. The connection I have used is:
Const ODBCConnection = "Driver={SQL Server};Server=AGGTEX;Database=Rental;Uid=xxx;Pwd=xxx;"
I know the connection works as I have successfully managed to do a select statement using the same database.
Please could somebody help as I have been working on this for a while.
Thanks in advance
I have an error in my code which says:
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ':'.
At line 69.
Here's the code:
strInsertSQL = "INSERT INTO Navigation (UserName, SystemTime, InitialProcess, OpportunityGUID, ActivityGUID) "
strInsertSQL = strInsertSQL & "VALUES (" & userID & ", " & time() & ", " & "TEST" & ", " & "Blank" & ", " & strActivityID & ")"
objRS= objConn.Execute(strInsertSQL)
line 69 of my code is the last line above where it executes the sql. The connection I have used is:
Const ODBCConnection = "Driver={SQL Server};Server=AGGTEX;Database=Rental;Uid=xxx;Pwd=xxx;"
I know the connection works as I have successfully managed to do a select statement using the same database.
Please could somebody help as I have been working on this for a while.
Thanks in advance