F
Frank Bruhn
read somewhere that to get a data access page to work over the internet u
need to create the data access page on the web server, (is that accurate?).
With that in mind i created in my network places an ftp connection to the web
server and am able to ftp via IE the web server
problem comes when i go into access 2003 and attempt to create a Blank Data
Access Page, i get the dialog box "Select a Data Source", everything is ok up
to this point, Next I choose My Network Places on the right pane, double
click on the ftp connection to my web server, i get the following error
message
cannot connect to ftp server on my the computer named ftp.mydomain.com, the
extended help then goes on to say the firewall or proxy settings are not
correct. As stated previous i am able to ftp to the same server thru IE
without any hickups,
1) so is there a special port in the firewall that has to be opened in order
for MS access to gain access to the my web site,
2) or is there a better way to get DAP pages working over the internet while
connected to an sql express db on the web server.
other things tried include the following
tried to edit the source of the dap page here locally in VS05 and change the
connection string to reflect the following connection string.
<a:ConnectionString>Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist
Security Info=False;Initial Catalog=ENEWSLETTER;Data
Source=(local)\sqlexpress;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;Use Encryption for Data=False;Tag with column
collation when possible=False</a:ConnectionString>
also i change the Initial Catalog portion of the above connection string to
reflect the full path to the mdf on the web server,
nothing seems to work, and i usually get an error message like "Data
Provider could not be Initialized"
any clue would be appreciated. TIA
need to create the data access page on the web server, (is that accurate?).
With that in mind i created in my network places an ftp connection to the web
server and am able to ftp via IE the web server
problem comes when i go into access 2003 and attempt to create a Blank Data
Access Page, i get the dialog box "Select a Data Source", everything is ok up
to this point, Next I choose My Network Places on the right pane, double
click on the ftp connection to my web server, i get the following error
message
cannot connect to ftp server on my the computer named ftp.mydomain.com, the
extended help then goes on to say the firewall or proxy settings are not
correct. As stated previous i am able to ftp to the same server thru IE
without any hickups,
1) so is there a special port in the firewall that has to be opened in order
for MS access to gain access to the my web site,
2) or is there a better way to get DAP pages working over the internet while
connected to an sql express db on the web server.
other things tried include the following
tried to edit the source of the dap page here locally in VS05 and change the
connection string to reflect the following connection string.
<a:ConnectionString>Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist
Security Info=False;Initial Catalog=ENEWSLETTER;Data
Source=(local)\sqlexpress;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;Use Encryption for Data=False;Tag with column
collation when possible=False</a:ConnectionString>
also i change the Initial Catalog portion of the above connection string to
reflect the full path to the mdf on the web server,
nothing seems to work, and i usually get an error message like "Data
Provider could not be Initialized"
any clue would be appreciated. TIA