Re: DAPīs on the internet

anonymous_at_discussions.microsoft.com
Date: 10/07/04

  • Next message: JB: "Re: DAPīs on the internet" 
    Date: Thu, 7 Oct 2004 00:07:01 -0700

    iīm still having an error message "invalid parameter in
    the connectionstring", does it necessary to set de
    remoteuserprovider =true?
    >-----Original Message-----
    >Yes, with the little exception that maybe the number
    port 1433 is not
    >mandatory but I'm not sure. This number can also be
    changed inside the
    >SQL-Server configuration.
    >
    >S. L.
    >
    ><javier_berlanga@hotmail.com> wrote in message
    >news:136b01c4ac30$6e5c58d0$a401280a@phx.gbl...
    >So i suppose that Data Source=arscim.no-ip.info,1433 can
    >be changed to a private IP or a valid domain..and that
    >would look like this:
    >
    >Provider=SQLOLEDB.1;Password=rapport_dap;Persist Security
    >Info=True;User
    >ID=rapport_dap;Initial Catalog=arscim;Data
    >Source=200.78.81.88,1433;Use
    >Procedure for Prepare=1;Auto Translate=True;Packet
    >Size=4096;Workstation
    >ID=SYLVAIN2;Use Encryption for Data=False;Tag with column
    >collation when
    >possible=False
    >
    >OR
    >
    >Provider=SQLOLEDB.1;Password=rapport_dap;Persist Security
    >Info=True;User
    >ID=rapport_dap;Initial Catalog=arscim;Data
    >Source=www.myserver.com,1433;Use
    >Procedure for Prepare=1;Auto Translate=True;Packet
    >Size=4096;Workstation
    >ID=SYLVAIN2;Use Encryption for Data=False;Tag with column
    >collation when
    >possible=False
    >
    >Once again, thanks for the reply
    >
    >
    >>-----Original Message-----
    >>You are right, ASP is a very different thing from DAP.
    >With ASP, all datas
    >>are written to the HTML page before it is sent to the
    >user; with DAP, no
    >>data at all are written before the page is sent to the
    >user. Only when the
    >>page is opened in the browser that a direct connection
    >with the SQL-Server
    >>is etablished and datas are sent over the wire.
    >>
    >>Here the last connection string that I have used:
    >>
    >>Provider=SQLOLEDB.1;Password=rapport_dap;Persist
    >Security Info=True;User
    >>ID=rapport_dap;Initial Catalog=arscim;Data
    >Source=arscim.no-ip.info,1433;Use
    >>Procedure for Prepare=1;Auto Translate=True;Packet
    >Size=4096;Workstation
    >>ID=SYLVAIN2;Use Encryption for Data=False;Tag with
    >column collation when
    >>possible=False
    >>
    >>Notice that the user name and the password are written
    >in plain text, this
    >>is not something that I overlooked and it is mandatory
    >when using DAPs; so
    >>it is probably highly desirable that you use stored
    >procedures/views/tables
    >>with Execute or Read only permissions for this account;
    >otherwise anyone
    >>will be able to modify data on your MSDE or SQL-Server.
    >>
    >>You can also try to use Application Roles instead; but I
    >doubt that this
    >>would be a simpler solution.
    >>
    >>The above connection string is taken from a live example
    >using a MSDE Server
    >>and a dynamic IP address for its data source (the pages
    >themselves are
    >>presently on a static IP address but that change
    >absolutely nothing); you
    >>can see it at:
    >>
    >>http://www.arscim.qc.ca/LigueXpertCS7/RapportsDap_index.
    h
    >tm
    >>
    >>S. L.
    >>
    >>"JB" <javier_berlanga@hotmail.com> wrote in message
    >>news:1a7301c4ac0a$a4414d50$a601280a@phx.gbl...
    >>
    >>Thank you very much,i see now that i was lost with this
    >>issue, all i knew about deploying DAP on the internet
    was
    >>what i read in the article.
    >>
    >>Iīve worked with ASP connected to a DSN, so i thought it
    >>was similar with the DAP, because using a DSN all i
    >>needed to do was to set up the IIS and i was able to
    >>accees the the SQL database from any pc.
    >>
    >>Thank you again , and as a last favor, perhaps you could
    >>send me an example of a connection string with an IP as
    >>you describe, because honestly i have no idea how to do
    >>that. About the router, no problem, i can deal with
    that.
    >>
    >>Thank you VERY MUCH again, youīve been a great help
    >>
    >>
    >>.
    >>
    >
    >
    >.
    >

  • Next message: JB: "Re: DAPīs on the internet"

    Relevant Pages

    • Re: DAPīs on the internet
      ... ASP is a very different thing from DAP. ... >>is etablished and datas are sent over the wire. ... >>The above connection string is taken from a live example ...
      (microsoft.public.access.dataaccess.pages)
    • Re: Firewall issues with DAP?? - correction
      ... If anyone has an ideas of how the connection is being blocked (DAP creating other connections to db that are blocked at firewall? ... Maybe a level security problem from IE. ...
      (microsoft.public.access.dataaccess.pages)
    • Re: DAPīs on the internet
      ... You have a misconception about DAP pages here: ... your local server; this even in the case if they are located or served from ... This is the connection string of one of the DAP iīm ... Ihave also tried with an odc file connection: ...
      (microsoft.public.access.dataaccess.pages)
    • Re: DAPīs on the internet
      ... to false if you want a direct connection with the SQL-Server. ... ASP is a very different thing from DAP. ...
      (microsoft.public.access.dataaccess.pages)
    • RE: passwords in asp pages
      ... about the specifics of the connection other than the type (ie. by type I ... about your asp, ... passwords for credentials to an sql database on another machine. ... to facilitate one-on-one interaction with one of our expert instructors. ...
      (Security-Basics)