Hi,

I wish to use a FileDSN for MS SQL Server 7, with a trusted connection. This job will be executed on a remote instance.

Thanks in advance

Nick

: Hi,

: I wish to use a FileDSN for MS SQL Server 7, with a trusted connection. This
: job will be executed on a remote instance.

: Thanks in advance

: Nick

sorry for the lack of detail... I need to know the specifics because I tried configuring the job but do not seem to have any success

Please see "File DSN's connecting to Access DB's" message thread below. There you will find answer for your question.

By the way, if you have dblib installed you don't need to use ODBC at all. Just create MS SQL Server database profile in 24x7 and use native database connection bypassing ODBC.

: Hi,

: I wish to use a FileDSN for MS SQL Server 7, with a trusted connection. This
: job will be executed on a remote instance.

: Thanks in advance

: Nick