Verify the connection to the replicate Microsoft SQL Server database.
isql –Uvaliduser –Ppassword –Smy_mssql_access_service
where validuser and password are any valid user and password, and my_mssql_access_service is the DirectConnect service name.
select @@sqldbmsname
go
SQLDbmsName
---------------------
Microsoft SQL Server
select @@sqldbmsver
SQLDbmsVer
09.00.1399