Post reply

.ASP Classic JScript Connection String

  • May 29, 2008 at 9:17 am

    #71606

    I know this may not be the place and I apologize. I have a connection to a SQL2000 DB in a classig ASP page. In my test environment this connection works fine. I use a connection string as well as DSN connection. When I ported the application to the client environment the connection stopped working with the "server does not exist or access denied" error. I tried the DSN route and get the same error.

    Here's the oddball. If I use the same connection string in a VBScript page the connection works.

    Has anyone seen this? Help please.

    Thank You

    ST

  • May 29, 2008 at 10:01 am

    #821838

    Sorry, I forgot to mention that in the client environment I can connect to a SQL server NOT using an instance name. The server that I am having trouble connecting to uses an instance name.

    ST

  • June 3, 2008 at 9:43 am

    #823724

    OK, here's the latest information. The issue seems to be different than I thought. The connection via DSN (ODBC) does not work at all regardless of which language. The app works correctly whe the ASP pages are running under IIS5. The client environment is requiring IIS6 and there seems to be a permissions or credentials issue between IIS and SQL.

    Any thoughts are appreciated.

    Thanks

    ST

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply