I am running SQL Server 2000 Enterprise on my local machine (Windows 2000
Advanced Server) and attempting to run a query using ADO.

I can run simple queries, but when I try to execute this one....

Insert Into dbo.Subs_ActiveSessions
(sas_subscriberID, sas_session, sas_database,
 sas_databasename, sas_datetime, sas_ProdUsedValuesTrade,
 sas_ProdUsedValuesConsumer, sas_ProdUsedValuesLive,
 sas_ProdFutureResidual, sas_ProdIDData, sas_ProdNVPO,
 sas_ProdStandardEquipment, sas_ProdSMR, sas_ProdOptionLinks,
 sas_ProdGenericLink, sas_ProdFleetnet, sas_ProdTechnicalData)
Values
(90410, '{BB3C4F89-437E-45A5-A1AE-623BE4E263A0}',
'DSN=MQIS;Description=SQL
Server;APP=Enterprise;WSID=AETHYRS;DATABASE=PUB_CAR;Trusted_Connection=Yes',
'CAR', '2000-01-01 10:45:03.000', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1)

The query fails with the error : "[Microsoft][ODBC SQL Server Driver]Optional
feature not implemented."

I am using the connection string 'DSN=MQIS;Description=SQL
Server;APP=Enterprise;WSID=NEPTUNE;DATABASE=PUB_SUBS;Trusted_Connection=Yes'
with NEPTUNE begin my local machinename.

I can see absolutely no reason why this error message should appear, but its a
new installation, and I think a config needs to be changed, but I dont know
what.
The query works fine in Query Analyser. Can anyone please help me ?

Thanks !

Paul Champan