ADODB error connecting to SQL

[Gicu]

Under user mapping can you check the box beside the chronos database in the top box and check the db_datareader and db_datawriter (or the db_owner) in the bottom one, reboot and see what happens?



Cheers,
Vlad

[JamesSF]

made that change - rebooted server

still getting this error

5 [Microsoft][SQL Server Native Client 11.0][SQL Server]Changed database context to 'chronos'.

         Dim CN As ADODB.Connection
         Set CN = CreateObject("ADODB.Connection")

        CN.Open "Driver={SQL Server Native Client 11.0};server=sql.transcom-solutions.com;Database=chronos;User ID=chronos_system;Password=[QWpK:$z3}7l@6x;Trusted_Connection=yes"

or any of the other connection strings referenced above

[Gicu]

Are you logged on in Windows as chronos_system? If when using Trusted Connection= Yes you do not specify the user and password. Can you try to link a table from chronos using the built in Access external data wizard and after you have it linked open the msysObjects (you might need to turn visible the system objects in File/Options/Current Database/Navigation Options) and have a look at its connect(ion) string and try to replicate that in your code.

Cheers,
Vlad