sql server connect: Connecting to SQL dbfs with existing code -- sql server connect

Connecting to SQL dbfs with existing code

Renee Sanders
12/29/2003 9:47:12 AM

sql server connect: 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!

Connecting to SQL dbfs with existing code

Linchi Shea
12/29/2003 11:39:30 AM

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

[quoted text, click to view]

Re: Connecting to SQL dbfs with existing code

Renee Sanders
12/29/2003 12:03:14 PM

The test was completed successfully. That's what is perplexing.

*** Sent via Developersdex http://www.developersdex.com ***

RE: Connecting to SQL dbfs with existing code

kevmc NO[at]SPAM online.microsoft.com
12/29/2003 8:08:50 PM

Does the System DSN connect if you Test it from the IIS server?
If not what is the OS error returned?

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Re: Connecting to SQL dbfs with existing code

kevmc NO[at]SPAM online.microsoft.com
12/29/2003 8:41:39 PM

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.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.