Re: Impersonation and SQL access (again)

From: Al Blake (al_at_blakes.net)
Date: 05/27/04 

Date: Thu, 27 May 2004 19:29:10 +1000

Update:
I've fixed it!

Here's the connect string that works:

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;User ID=;Initial Catalog=Media;Data Source=MIDAS

I now have the browser user passing through the ASP and being used to
connect to SQL.
neat.
Al.

Relevant Pages

  • Re: ASP recordset as SQL table
    ... You can continue to do the same thing in ASP that you do in Access. ... The alternative would be to use the Filter method of the ADO recordset. ... > and then I want to open another recordset that performs a SQL operation on ... not a string. ...
    (microsoft.public.access.conversion)
  • Empty Recordset
    ... I have a ASP page accessing a Oracle database and a SQL ... string that should return 1 line. ...
    (microsoft.public.inetserver.asp.db)
  • Re: How to search for Keywords? Thank You.
    ... I have a page with a search form where keywords are submitted. ... Consider I write the keywords 'asp' and 'book'. ... Then I use this script in results.aspx to put the keywords in a string: ... This SQL looks only for 'ASP' and 'BOOK' words. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Problems with Delete Command
    ... The SQL could get fairly messy if you need to construct it in code, ... ContactID, and WebComID, and create your on-the-fly SQL on that saved query, ... to find the list of ContactIDs from the junction table, ... This is a style/readability thing: if you are going to use string ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Need help with Code Please!!!
    ... posted in response to my last post was some SQL, but this is not the SQL that ... the actual string that gets built at the end of the SQ1 build process. ... The message says Syntax error in query expression ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ...
    (microsoft.public.access.formscoding)