Very Computer

1. Error in Wizard generated code

80040e14

If fNeedRecordset Then
    Set Company = Server.CreateObject("ADODB.Connection")
    Company.ConnectionTimeout = Session("Company_ConnectionTimeout")
    Company.CommandTimeout = Session("Company_CommandTimeout")
    Company.Open Session("Company_ConnectionString"),
Session("Company_RuntimeUserName"), Session("Company_RuntimePassword")
    Set cmdTemp = Server.CreateObject("ADODB.Command")
    Set rsPCompanyContact = Server.CreateObject("ADODB.Recordset")
    cmdTemp.CommandText = "SELECT ""ContactID"", ""Title"",
""Forename"", ""MiddleName"", ""Surname"", ""Salutation"",
""Position"", ""Telephone"", ""Alternate"", ""Home"", ""Mobile"",
""Pager"", ""Fax"", ""Minicom"", ""EMailWork"", ""EMailPersonal"",
""Homepage"", ""LastUsed"", ""LastContact"" FROM dbo.""Contact"""
    cmdTemp.CommandType = 1
    Set cmdTemp.ActiveConnection = Company
    rsPCompanyContact.Open cmdTemp, , 1, 3
End If

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect
syntax near 'Contact'.

/Money/PCompanyList.asp, line 299

The line is second from bottom i.e.

    rsPCompanyContact.Open cmdTemp, , 1, 3

This is the list view from the generated code - the form view gives
exactly the same error.  In the list view however I see all of the
field names in the database table (SQL Server 6.5)

Any help will be appreciated

Terry Murphy

2. Oracle nextval returned to Access97 through ODBC

3. Accessing wizard generated code

4. Approach Users Mailing List FAQ

5. Where to find information on Wizard-generated code

6. NT RAS problem

7. Form Wizard generated Code VFP3 ?

8. test

9. help--need to understand VFP3 Form Wizard generated code

10. New data form wizard source code for VB5

11. Source code for VB's Data Form Wizard

12. WWW Internet Search Wizard source code?

13. Visual Basic source-code to C++ source-code