by 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