Connection String Accross Domains

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11396-connection-string-accross-domains.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11396
across domains?

Help is much appreciated
--
Tim Heffernan
..NET Developer

*

Do you agree or disagree with the writer above? Why not share your immediate thoughts with us! Login Now! or Sign Up Today! to share your views... Gurfateh!

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

--
hth,
SusanV



"THDotNet" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11396
news:EB5511BE-7FCE-4767-BE48-09E27DE19539@microsoft.com...
>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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11396
> across domains?
>
> Help is much appreciated
> --
> Tim Heffernan
> .NET Developer