I work with FoxPro 2.6 Files and SQL Server 2000 - I use the Import Data Wizard (which uses DTS) and select dBase III as the file format.  I have...

In Query Analyzer, type:

I use the following:

ALTER PROCEDURE sp_WhoAmI

AS

/* set nocount on */

--DECLARE @sys_usr char(30)

SELECT System_user as SQLUserName

RETURN

I use an Access program and run this command against the SQL Server:

strSQL = "sp_password NULL, '" & Me!txtPassword.Value & "', '"...

I have specific experience on this kind of a setup. I have an SQL database and an 8 port IVR setup. Our volume is lower than what you...

The problem with the timeout issue on the connection for an Access ADP is that the Project is the connection and I have not found a way to set the...

No problem - glad I could help.

I am the dba for my company and we run our business on a SQL database with an ADP front end. I have...

before you execute, add the following:

cmd1.CommandTimeout = 0

This will cause the command to not timeout. The default timeout period in Access is 30 seconds.

I would also suggest verifying that...