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.
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>
tried other versions of the connection string including using the full path
jto the db on the web server in the Initial Catalog portion of the connection
string above,
nothing seems to be working and i when i try and view the DAP page in ie i
usually get error messges like "Data Provider could not be Initialized"
would really appreciate some clues, 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.
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>
tried other versions of the connection string including using the full path
jto the db on the web server in the Initial Catalog portion of the connection
string above,
nothing seems to be working and i when i try and view the DAP page in ie i
usually get error messges like "Data Provider could not be Initialized"
would really appreciate some clues, TIA