Connecting to SQL dbfs with existing code

No need to setup the web server as a primary domain
controller for the SQL Server connectivity to work.
After you configured the system DSN on the web server, did
you test the DSN as the very last step of setting up the
DSN? If yes, what error message did you get?
Linchi

quote:

---

>--Original Message--
>We recently moved our Access databases to SQL and are
>trying to get our pages to open the connections to the
>server. I've set the system DSNs on the server as needed.
>However, no connections are made. After reviewing several
>books, microsoft.com, etc...I'm severely frustrated. The
>only thing I can think that would possibly be an issue is
>that our webserver (Win2003) is not setup as a Primary
>Domain Server and we have to connect via http.
>Any suggestions are appreciated. THANKS!
>.
>

---

The test was completed successfully. That's what is perplexing.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Does the connection actually hit SQL Server?
Enable auditing for failed logins on SQL , then stop n start MSSQLServer
service.
Check the SQL Errorlogs after the failed connection attempt.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.sqlsql

Connect to SQL Server through VPN

Hi
I've recently configured a VPN between 2 locations, using 3Com Internet Firewall 25.
It seems to be working fine, but i can't connect to a remote sql server. I've tried to do this from the managemente console, the query analyzer and a VB Application (ODBC) and i always get the same message: "The server does not exist or access denied". I'm trying to reach the server using its ip address, wich i can succesfully ping, and SQL authentication method.

If anyone has any idea, i will be really thankfull!You need to verify that port TCP 1433 and port UDP 1434 are open.

Also check for port TCP 135, that should be open if you need to make distributed queries|||Can you help us!!!!