Connection String Accross Domains

[THDotNet]

I am using Access as a reporting front end and SQL Server 2000 as its back
end. The connection string I have been using has been working fine up until
now.

What has changed is that the front end now resides on a different domain
than the SQL DTBS.

Can anyone provide me an example of a connection string that will work
across domains?

Help is much appreciated

 

[SusanV]

If you simply wish to connect to a server not available in your network
browse list, you can use the IP address in the ODBC properties connection
tab, along with the credentials.

To prompt the user for credentials:
http://msdn2.microsoft.com/en-us/library/ms160330.aspx

More info on ODBC settings:
http://www.drdev.net/article10.htm