Re: DAPīs on the internet

From: Sylvain Lafontaine ("Sylvain)
Date: 10/07/04 

Date: Thu, 7 Oct 2004 10:52:28 -0400

No, UseRemoteProvider = True is for using the RDS provider. It must be set
to false if you want a direct connection with the SQL-Server. Many of the
other parameters in the Data tab must also be set to their default values.

What is the connections tring that you are trying to use?

S. L.

"JB" <javier_berlanga@hotmail.com> wrote in message
news:145801c4ac3e$54442b40$a401280a@phx.gbl...
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
>>
>>
>>.
>>
>
>
>.
>

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: 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: web form getting data to SQL Backend
    ... Set Connection = Server.CreateObject ... timezone = rs ... source, name, phone, email, debt amount and city/state or zip.") ... As you are using OLEDB and SQL-Server ...
    (microsoft.public.access.adp.sqlserver)