|
|
You're in the
iis ftp
group:modify database of FTP Server through VB.Net
iis ftp:
I have developed an web-site , I use Access-2000 database with ASP, I want to access my data through VB .Net , and want to modify selected data. So procedure may be as below : Application connect to FTP Server with username and password, access database and change required correction. How can I , Any hints will be sincerly appreciated. Harsha Shah
From what you are saying to me is that you are sitting at your client
computer and you want to update records in your Access Database that could presumably be at an ISP's site that you can connect to via FTP? Normally people upload new versions of their access database in this case. Have you thought about writing some ASP web pages to update the database, or maybe a create web service in vb.net? It really depends on what you are updating as to your options. Have a look at this code project which is a database Viewer and Editor for ASP http://www.codeproject.com/asp/ute.asp For an online demo see http://www.wellige.com/tom/ute/ Let me know if any of this helps. -- Cheers Chris Chris Crowe [IIS MVP] http://blog.crowe.co.nz [quoted text, click to view] "Harsha Shah" <har_sha_99@hotmail.com> wrote in message news:uuBW7wonFHA.3300@TK2MSFTNGP15.phx.gbl... > Hi, > > I have developed an web-site , I use Access-2000 database with ASP, > > I want to access my data through VB .Net , and want to modify selected > data. > So procedure may be as below : > > Application connect to FTP Server with username and password, access > database and change required correction. > > How can I , > > Any hints will be sincerly appreciated. > > > Harsha Shah > > > > > > > > >
[quoted text, click to view] > "Chris Crowe [MVP]" Wrote : My website use Access database . I want to call server's database by> From what you are saying to me is that you are sitting at your client > computer and you want to update records in your Access Database that could > presumably be at an ISP's site that you can connect to via FTP? something like following procedure (VB.Net) conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; DATA SOURCE= "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") [quoted text, click to view] >Normally people upload new versions of their access database in this case. Some columns of the table (like password ) can be change by web user (viewer) . So it is not possible to replace whole database. Thanks for reply Hardik Shah ======================== [quoted text, click to view] > Have you thought about writing some ASP web pages to update the database, or > maybe a create web service in vb.net? > > It really depends on what you are updating as to your options. > > Have a look at this code project which is a database Viewer and Editor for > ASP > > http://www.codeproject.com/asp/ute.asp > > For an online demo see http://www.wellige.com/tom/ute/ > > Let me know if any of this helps. > -- > > Cheers > > Chris > > Chris Crowe [IIS MVP] > http://blog.crowe.co.nz > > "Harsha Shah" <har_sha_99@hotmail.com> wrote in message > news:uuBW7wonFHA.3300@TK2MSFTNGP15.phx.gbl... > > Hi, > > > > I have developed an web-site , I use Access-2000 database with ASP, > > > > I want to access my data through VB .Net , and want to modify selected > > data. > > So procedure may be as below : > > > > Application connect to FTP Server with username and password, access > > database and change required correction. > > > > How can I , > > > > Any hints will be sincerly appreciated. > > > > > > Harsha Shah > > > > > > > > > > > > > > > > > > > >
wow. can this be done?
DATA SOURCE= "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") ftp is a file transfer protocol not file system that handle file open, locking, etc. -- Regards, Bernard Cheah http://www.microsoft.com/iis/ http://www.iiswebcastseries.com/ http://www.msmvps.com/bernard/ [quoted text, click to view] "Harsha Shah" <har_sha_99@hotmail.com> wrote in message news:uPGk6BYpFHA.1416@TK2MSFTNGP09.phx.gbl... > >> "Chris Crowe [MVP]" Wrote : >> From what you are saying to me is that you are sitting at your client >> computer and you want to update records in your Access Database that >> could >> presumably be at an ISP's site that you can connect to via FTP? > My website use Access database . I want to call server's database by > something like following procedure (VB.Net) > > conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; > DATA SOURCE= "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") > > >>Normally people upload new versions of their access database in this >>case. > > Some columns of the table (like password ) can be change by web user > (viewer) . So it is not possible to replace whole database. > > Thanks for reply > > Hardik Shah > > > ======================== >> Have you thought about writing some ASP web pages to update the database, > or >> maybe a create web service in vb.net? >> >> It really depends on what you are updating as to your options. >> >> Have a look at this code project which is a database Viewer and Editor >> for >> ASP >> >> http://www.codeproject.com/asp/ute.asp >> >> For an online demo see http://www.wellige.com/tom/ute/ >> >> Let me know if any of this helps. >> -- >> >> Cheers >> >> Chris >> >> Chris Crowe [IIS MVP] >> http://blog.crowe.co.nz >> >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message >> news:uuBW7wonFHA.3300@TK2MSFTNGP15.phx.gbl... >> > Hi, >> > >> > I have developed an web-site , I use Access-2000 database with ASP, >> > >> > I want to access my data through VB .Net , and want to modify selected >> > data. >> > So procedure may be as below : >> > >> > Application connect to FTP Server with username and password, access >> > database and change required correction. >> > >> > How can I , >> > >> > Any hints will be sincerly appreciated. >> > >> > >> > Harsha Shah >> > >> > >> > >> > >> > >> > >> > >> > >> > >> >> > >
Hi,
I just take chance, then what is its alternate. Hardik [quoted text, click to view] "Bernard Cheah [MVP]" <qbernard@hotmail.com.discuss> wrote in message news:eWtsbAupFHA.2916@TK2MSFTNGP14.phx.gbl... > wow. can this be done? > DATA SOURCE= "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") > > ftp is a file transfer protocol not file system that handle file open, > locking, etc. > > -- > Regards, > Bernard Cheah > http://www.microsoft.com/iis/ > http://www.iiswebcastseries.com/ > http://www.msmvps.com/bernard/ > > > "Harsha Shah" <har_sha_99@hotmail.com> wrote in message > news:uPGk6BYpFHA.1416@TK2MSFTNGP09.phx.gbl... > > > >> "Chris Crowe [MVP]" Wrote : > >> From what you are saying to me is that you are sitting at your client > >> computer and you want to update records in your Access Database that > >> could > >> presumably be at an ISP's site that you can connect to via FTP? > > My website use Access database . I want to call server's database by > > something like following procedure (VB.Net) > > > > conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; > > DATA SOURCE= "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") > > > > > >>Normally people upload new versions of their access database in this > >>case. > > > > Some columns of the table (like password ) can be change by web user > > (viewer) . So it is not possible to replace whole database. > > > > Thanks for reply > > > > Hardik Shah > > > > > > ======================== > >> Have you thought about writing some ASP web pages to update the database, > > or > >> maybe a create web service in vb.net? > >> > >> It really depends on what you are updating as to your options. > >> > >> Have a look at this code project which is a database Viewer and Editor > >> for > >> ASP > >> > >> http://www.codeproject.com/asp/ute.asp > >> > >> For an online demo see http://www.wellige.com/tom/ute/ > >> > >> Let me know if any of this helps. > >> -- > >> > >> Cheers > >> > >> Chris > >> > >> Chris Crowe [IIS MVP] > >> http://blog.crowe.co.nz > >> > >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message > >> news:uuBW7wonFHA.3300@TK2MSFTNGP15.phx.gbl... > >> > Hi, > >> > > >> > I have developed an web-site , I use Access-2000 database with ASP, > >> > > >> > I want to access my data through VB .Net , and want to modify selected > >> > data. > >> > So procedure may be as below : > >> > > >> > Application connect to FTP Server with username and password, access > >> > database and change required correction. > >> > > >> > How can I , > >> > > >> > Any hints will be sincerly appreciated. > >> > > >> > > >> > Harsha Shah > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > >> > > > > > >
You can host the db in your local network, then access via UNC path
\\remoteserver\share why so troublesome ? can you host it in the IIS server itself ? -- Regards, Bernard Cheah http://www.microsoft.com/iis/ http://www.iiswebcastseries.com/ http://www.msmvps.com/bernard/ [quoted text, click to view] "Harsha Shah" <har_sha_99@hotmail.com> wrote in message news:O4xbVyupFHA.2580@TK2MSFTNGP09.phx.gbl... > Hi, > > I just take chance, then what is its alternate. > > Hardik > > > > "Bernard Cheah [MVP]" <qbernard@hotmail.com.discuss> wrote in message > news:eWtsbAupFHA.2916@TK2MSFTNGP14.phx.gbl... >> wow. can this be done? >> DATA SOURCE= "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") >> >> ftp is a file transfer protocol not file system that handle file open, >> locking, etc. >> >> -- >> Regards, >> Bernard Cheah >> http://www.microsoft.com/iis/ >> http://www.iiswebcastseries.com/ >> http://www.msmvps.com/bernard/ >> >> >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message >> news:uPGk6BYpFHA.1416@TK2MSFTNGP09.phx.gbl... >> > >> >> "Chris Crowe [MVP]" Wrote : >> >> From what you are saying to me is that you are sitting at your client >> >> computer and you want to update records in your Access Database that >> >> could >> >> presumably be at an ISP's site that you can connect to via FTP? >> > My website use Access database . I want to call server's database by >> > something like following procedure (VB.Net) >> > >> > conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; >> > DATA SOURCE= "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") >> > >> > >> >>Normally people upload new versions of their access database in this >> >>case. >> > >> > Some columns of the table (like password ) can be change by web user >> > (viewer) . So it is not possible to replace whole database. >> > >> > Thanks for reply >> > >> > Hardik Shah >> > >> > >> > ======================== >> >> Have you thought about writing some ASP web pages to update the > database, >> > or >> >> maybe a create web service in vb.net? >> >> >> >> It really depends on what you are updating as to your options. >> >> >> >> Have a look at this code project which is a database Viewer and Editor >> >> for >> >> ASP >> >> >> >> http://www.codeproject.com/asp/ute.asp >> >> >> >> For an online demo see http://www.wellige.com/tom/ute/ >> >> >> >> Let me know if any of this helps. >> >> -- >> >> >> >> Cheers >> >> >> >> Chris >> >> >> >> Chris Crowe [IIS MVP] >> >> http://blog.crowe.co.nz >> >> >> >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message >> >> news:uuBW7wonFHA.3300@TK2MSFTNGP15.phx.gbl... >> >> > Hi, >> >> > >> >> > I have developed an web-site , I use Access-2000 database with ASP, >> >> > >> >> > I want to access my data through VB .Net , and want to modify > selected >> >> > data. >> >> > So procedure may be as below : >> >> > >> >> > Application connect to FTP Server with username and password, access >> >> > database and change required correction. >> >> > >> >> > How can I , >> >> > >> >> > Any hints will be sincerly appreciated. >> >> > >> >> > >> >> > Harsha Shah >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> >> >> >> > >> > >> >> > >
Hi,
Thanks for your previous replies. I think I can't explain my problem effectively. So I am trying again. Please help me. I have web database name ftpdata.mdb, on this path ftp://216.157.154.143/sbgb.org/hardasp/ftpdata.mdb It is accessed by public and some of data is updated by them through web page. Now I also have to update this database at out side. it is not possible to replace whole database through ftp connection. So I have to write some code in vb. net , it might be as follow : 1) Connect to my web database ftp://216.157.154.143/sbgb.org/hardasp/ftpdata.mdb 2) Connect to my local database (C:\local.mdb) 3) Check (Record by Record) local.mdb with ftpdata.mdb and if required update ftpdata.mdb I just miss connectionstring , what should be connectionstring or is there any alternate to do this type of task Any hints will be sincerly appreciated. Hardik............. [quoted text, click to view] "Bernard Cheah [MVP]" <qbernard@hotmail.com.discuss> wrote in message news:#itjMAvpFHA.708@TK2MSFTNGP09.phx.gbl... > You can host the db in your local network, then access via UNC path > \\remoteserver\share > why so troublesome ? can you host it in the IIS server itself ? > > -- > Regards, > Bernard Cheah > http://www.microsoft.com/iis/ > http://www.iiswebcastseries.com/ > http://www.msmvps.com/bernard/ > > > "Harsha Shah" <har_sha_99@hotmail.com> wrote in message > news:O4xbVyupFHA.2580@TK2MSFTNGP09.phx.gbl... > > Hi, > > > > I just take chance, then what is its alternate. > > > > Hardik > > > > > > > > "Bernard Cheah [MVP]" <qbernard@hotmail.com.discuss> wrote in message > > news:eWtsbAupFHA.2916@TK2MSFTNGP14.phx.gbl... > >> wow. can this be done? > >> DATA SOURCE= "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") > >> > >> ftp is a file transfer protocol not file system that handle file open, > >> locking, etc. > >> > >> -- > >> Regards, > >> Bernard Cheah > >> http://www.microsoft.com/iis/ > >> http://www.iiswebcastseries.com/ > >> http://www.msmvps.com/bernard/ > >> > >> > >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message > >> news:uPGk6BYpFHA.1416@TK2MSFTNGP09.phx.gbl... > >> > > >> >> "Chris Crowe [MVP]" Wrote : > >> >> From what you are saying to me is that you are sitting at your client > >> >> computer and you want to update records in your Access Database that > >> >> could > >> >> presumably be at an ISP's site that you can connect to via FTP? > >> > My website use Access database . I want to call server's database by > >> > something like following procedure (VB.Net) > >> > > >> > conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; > >> > DATA SOURCE= "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") > >> > > >> > > >> >>Normally people upload new versions of their access database in this > >> >>case. > >> > > >> > Some columns of the table (like password ) can be change by web user > >> > (viewer) . So it is not possible to replace whole database. > >> > > >> > Thanks for reply > >> > > >> > Hardik Shah > >> > > >> > > >> > ======================== > >> >> Have you thought about writing some ASP web pages to update the > > database, > >> > or > >> >> maybe a create web service in vb.net? > >> >> > >> >> It really depends on what you are updating as to your options. > >> >> > >> >> Have a look at this code project which is a database Viewer and Editor > >> >> for > >> >> ASP > >> >> > >> >> http://www.codeproject.com/asp/ute.asp > >> >> > >> >> For an online demo see http://www.wellige.com/tom/ute/ > >> >> > >> >> Let me know if any of this helps. > >> >> -- > >> >> > >> >> Cheers > >> >> > >> >> Chris > >> >> > >> >> Chris Crowe [IIS MVP] > >> >> http://blog.crowe.co.nz > >> >> > >> >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message > >> >> news:uuBW7wonFHA.3300@TK2MSFTNGP15.phx.gbl... > >> >> > Hi, > >> >> > > >> >> > I have developed an web-site , I use Access-2000 database with ASP, > >> >> > > >> >> > I want to access my data through VB .Net , and want to modify > > selected > >> >> > data. > >> >> > So procedure may be as below : > >> >> > > >> >> > Application connect to FTP Server with username and password, access > >> >> > database and change required correction. > >> >> > > >> >> > How can I , > >> >> > > >> >> > Any hints will be sincerly appreciated. > >> >> > > >> >> > > >> >> > Harsha Shah > >> >> > > >> >> > > >> >> > > >> >> > > >> >> > > >> >> > > >> >> > > >> >> > > >> >> > > >> >> > >> >> > >> > > >> > > >> > >> > > > > > >
You won't be able open your database using that path.
You will need to maybe write a WebService (or a simple web page) that will allow you to check the changes and do updates. Your application will then post data to the WebService and get a response and then decide what to do such as update the record. Not really an IIS problem more of a development issue. -- Cheers Chris Chris Crowe [IIS MVP] http://blog.crowe.co.nz [quoted text, click to view] "Harsha Shah" <har_sha_99@hotmail.com> wrote in message news:uaVteEypFHA.3180@TK2MSFTNGP15.phx.gbl... > Hi, > > Thanks for your previous replies. I think I can't explain my problem > effectively. So I am trying again. Please help me. > > I have web database name ftpdata.mdb, on this path > ftp://216.157.154.143/sbgb.org/hardasp/ftpdata.mdb > It is accessed by public and some of data is updated by them through web > page. > > Now I also have to update this database at out side. it is not possible to > replace whole database through ftp connection. > So I have to write some code in vb. net , it might be as follow : > > 1) Connect to my web database > ftp://216.157.154.143/sbgb.org/hardasp/ftpdata.mdb > 2) Connect to my local database (C:\local.mdb) > 3) Check (Record by Record) local.mdb with ftpdata.mdb and if required > update ftpdata.mdb > > I just miss connectionstring , what should be connectionstring > or is there any alternate to do this type of task > > Any hints will be sincerly appreciated. > > > Hardik............. > > > > > > "Bernard Cheah [MVP]" <qbernard@hotmail.com.discuss> wrote in message > news:#itjMAvpFHA.708@TK2MSFTNGP09.phx.gbl... >> You can host the db in your local network, then access via UNC path >> \\remoteserver\share >> why so troublesome ? can you host it in the IIS server itself ? >> >> -- >> Regards, >> Bernard Cheah >> http://www.microsoft.com/iis/ >> http://www.iiswebcastseries.com/ >> http://www.msmvps.com/bernard/ >> >> >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message >> news:O4xbVyupFHA.2580@TK2MSFTNGP09.phx.gbl... >> > Hi, >> > >> > I just take chance, then what is its alternate. >> > >> > Hardik >> > >> > >> > >> > "Bernard Cheah [MVP]" <qbernard@hotmail.com.discuss> wrote in message >> > news:eWtsbAupFHA.2916@TK2MSFTNGP14.phx.gbl... >> >> wow. can this be done? >> >> DATA SOURCE= "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") >> >> >> >> ftp is a file transfer protocol not file system that handle file open, >> >> locking, etc. >> >> >> >> -- >> >> Regards, >> >> Bernard Cheah >> >> http://www.microsoft.com/iis/ >> >> http://www.iiswebcastseries.com/ >> >> http://www.msmvps.com/bernard/ >> >> >> >> >> >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message >> >> news:uPGk6BYpFHA.1416@TK2MSFTNGP09.phx.gbl... >> >> > >> >> >> "Chris Crowe [MVP]" Wrote : >> >> >> From what you are saying to me is that you are sitting at your > client >> >> >> computer and you want to update records in your Access Database >> >> >> that >> >> >> could >> >> >> presumably be at an ISP's site that you can connect to via FTP? >> >> > My website use Access database . I want to call server's database by >> >> > something like following procedure (VB.Net) >> >> > >> >> > conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; >> >> > DATA SOURCE= "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") >> >> > >> >> > >> >> >>Normally people upload new versions of their access database in >> >> >>this >> >> >>case. >> >> > >> >> > Some columns of the table (like password ) can be change by web user >> >> > (viewer) . So it is not possible to replace whole database. >> >> > >> >> > Thanks for reply >> >> > >> >> > Hardik Shah >> >> > >> >> > >> >> > ======================== >> >> >> Have you thought about writing some ASP web pages to update the >> > database, >> >> > or >> >> >> maybe a create web service in vb.net? >> >> >> >> >> >> It really depends on what you are updating as to your options. >> >> >> >> >> >> Have a look at this code project which is a database Viewer and > Editor >> >> >> for >> >> >> ASP >> >> >> >> >> >> http://www.codeproject.com/asp/ute.asp >> >> >> >> >> >> For an online demo see http://www.wellige.com/tom/ute/ >> >> >> >> >> >> Let me know if any of this helps. >> >> >> -- >> >> >> >> >> >> Cheers >> >> >> >> >> >> Chris >> >> >> >> >> >> Chris Crowe [IIS MVP] >> >> >> http://blog.crowe.co.nz >> >> >> >> >> >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message >> >> >> news:uuBW7wonFHA.3300@TK2MSFTNGP15.phx.gbl... >> >> >> > Hi, >> >> >> > >> >> >> > I have developed an web-site , I use Access-2000 database with > ASP, >> >> >> > >> >> >> > I want to access my data through VB .Net , and want to modify >> > selected >> >> >> > data. >> >> >> > So procedure may be as below : >> >> >> > >> >> >> > Application connect to FTP Server with username and password, > access >> >> >> > database and change required correction. >> >> >> > >> >> >> > How can I , >> >> >> > >> >> >> > Any hints will be sincerly appreciated. >> >> >> > >> >> >> > >> >> >> > Harsha Shah >> >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> >> >> >> >> >> > >> >> > >> >> >> >> >> > >> > >> >> > >
Sorry, been traveling. Now, as mentioned earlier - you can put a ftp:// in
the connectionstring and expect this to work. Also Chris has pointed out that this is development issue not IIS ftp. PS: you are posting real url in your msgs. thought is protected by password. it is still a risk by posting such info in a public forums. -- Regards, Bernard Cheah http://www.microsoft.com/iis/ http://www.iiswebcastseries.com/ http://www.msmvps.com/bernard/ [quoted text, click to view] "Harsha Shah" <har_sha_99@hotmail.com> wrote in message news:uaVteEypFHA.3180@TK2MSFTNGP15.phx.gbl... > Hi, > > Thanks for your previous replies. I think I can't explain my problem > effectively. So I am trying again. Please help me. > > I have web database name ftpdata.mdb, on this path > ftp://216.157.154.143/sbgb.org/hardasp/ftpdata.mdb > It is accessed by public and some of data is updated by them through web > page. > > Now I also have to update this database at out side. it is not possible to > replace whole database through ftp connection. > So I have to write some code in vb. net , it might be as follow : > > 1) Connect to my web database > ftp://216.157.154.143/sbgb.org/hardasp/ftpdata.mdb > 2) Connect to my local database (C:\local.mdb) > 3) Check (Record by Record) local.mdb with ftpdata.mdb and if required > update ftpdata.mdb > > I just miss connectionstring , what should be connectionstring > or is there any alternate to do this type of task > > Any hints will be sincerly appreciated. > > > Hardik............. > > > > > > "Bernard Cheah [MVP]" <qbernard@hotmail.com.discuss> wrote in message > news:#itjMAvpFHA.708@TK2MSFTNGP09.phx.gbl... >> You can host the db in your local network, then access via UNC path >> \\remoteserver\share >> why so troublesome ? can you host it in the IIS server itself ? >> >> -- >> Regards, >> Bernard Cheah >> http://www.microsoft.com/iis/ >> http://www.iiswebcastseries.com/ >> http://www.msmvps.com/bernard/ >> >> >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message >> news:O4xbVyupFHA.2580@TK2MSFTNGP09.phx.gbl... >> > Hi, >> > >> > I just take chance, then what is its alternate. >> > >> > Hardik >> > >> > >> > >> > "Bernard Cheah [MVP]" <qbernard@hotmail.com.discuss> wrote in message >> > news:eWtsbAupFHA.2916@TK2MSFTNGP14.phx.gbl... >> >> wow. can this be done? >> >> DATA SOURCE= "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") >> >> >> >> ftp is a file transfer protocol not file system that handle file open, >> >> locking, etc. >> >> >> >> -- >> >> Regards, >> >> Bernard Cheah >> >> http://www.microsoft.com/iis/ >> >> http://www.iiswebcastseries.com/ >> >> http://www.msmvps.com/bernard/ >> >> >> >> >> >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message >> >> news:uPGk6BYpFHA.1416@TK2MSFTNGP09.phx.gbl... >> >> > >> >> >> "Chris Crowe [MVP]" Wrote : >> >> >> From what you are saying to me is that you are sitting at your > client >> >> >> computer and you want to update records in your Access Database >> >> >> that >> >> >> could >> >> >> presumably be at an ISP's site that you can connect to via FTP? >> >> > My website use Access database . I want to call server's database by >> >> > something like following procedure (VB.Net) >> >> > >> >> > conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; >> >> > DATA SOURCE= "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") >> >> > >> >> > >> >> >>Normally people upload new versions of their access database in >> >> >>this >> >> >>case. >> >> > >> >> > Some columns of the table (like password ) can be change by web user >> >> > (viewer) . So it is not possible to replace whole database. >> >> > >> >> > Thanks for reply >> >> > >> >> > Hardik Shah >> >> > >> >> > >> >> > ======================== >> >> >> Have you thought about writing some ASP web pages to update the >> > database, >> >> > or >> >> >> maybe a create web service in vb.net? >> >> >> >> >> >> It really depends on what you are updating as to your options. >> >> >> >> >> >> Have a look at this code project which is a database Viewer and > Editor >> >> >> for >> >> >> ASP >> >> >> >> >> >> http://www.codeproject.com/asp/ute.asp >> >> >> >> >> >> For an online demo see http://www.wellige.com/tom/ute/ >> >> >> >> >> >> Let me know if any of this helps. >> >> >> -- >> >> >> >> >> >> Cheers >> >> >> >> >> >> Chris >> >> >> >> >> >> Chris Crowe [IIS MVP] >> >> >> http://blog.crowe.co.nz >> >> >> >> >> >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message >> >> >> news:uuBW7wonFHA.3300@TK2MSFTNGP15.phx.gbl... >> >> >> > Hi, >> >> >> > >> >> >> > I have developed an web-site , I use Access-2000 database with > ASP, >> >> >> > >> >> >> > I want to access my data through VB .Net , and want to modify >> > selected >> >> >> > data. >> >> >> > So procedure may be as below : >> >> >> > >> >> >> > Application connect to FTP Server with username and password, > access >> >> >> > database and change required correction. >> >> >> > >> >> >> > How can I , >> >> >> > >> >> >> > Any hints will be sincerly appreciated. >> >> >> > >> >> >> > >> >> >> > Harsha Shah >> >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> >> >> >> >> >> > >> >> > >> >> >> >> >> > >> > >> >> > >
Bernard Cheah Writes :
Sorry, been traveling. Now, as mentioned earlier - you can put a ftp:// in the connectionstring and expect this to work. Also Chris has pointed out that this is development issue not IIS ftp. ============= Did you mean that I can give following command ? conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; DATA SOURCE= "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") Is there any sample code. Hardik. [quoted text, click to view] "Bernard Cheah [MVP]" <qbernard@hotmail.com.discuss> wrote in message news:eIcVXgTrFHA.248@TK2MSFTNGP14.phx.gbl... > Sorry, been traveling. Now, as mentioned earlier - you can put a ftp:// in > the connectionstring and expect this to work. Also Chris has pointed out > that this is development issue not IIS ftp. > > PS: you are posting real url in your msgs. thought is protected by password. > it is still a risk by posting such info in a public forums. > > -- > Regards, > Bernard Cheah > http://www.microsoft.com/iis/ > http://www.iiswebcastseries.com/ > http://www.msmvps.com/bernard/ > > > "Harsha Shah" <har_sha_99@hotmail.com> wrote in message > news:uaVteEypFHA.3180@TK2MSFTNGP15.phx.gbl... > > Hi, > > > > Thanks for your previous replies. I think I can't explain my problem > > effectively. So I am trying again. Please help me. > > > > I have web database name ftpdata.mdb, on this path > > ftp://216.157.154.143/sbgb.org/hardasp/ftpdata.mdb > > It is accessed by public and some of data is updated by them through web > > page. > > > > Now I also have to update this database at out side. it is not possible to > > replace whole database through ftp connection. > > So I have to write some code in vb. net , it might be as follow : > > > > 1) Connect to my web database > > ftp://216.157.154.143/sbgb.org/hardasp/ftpdata.mdb > > 2) Connect to my local database (C:\local.mdb) > > 3) Check (Record by Record) local.mdb with ftpdata.mdb and if required > > update ftpdata.mdb > > > > I just miss connectionstring , what should be connectionstring > > or is there any alternate to do this type of task > > > > Any hints will be sincerly appreciated. > > > > > > Hardik............. > > > > > > > > > > > > "Bernard Cheah [MVP]" <qbernard@hotmail.com.discuss> wrote in message > > news:#itjMAvpFHA.708@TK2MSFTNGP09.phx.gbl... > >> You can host the db in your local network, then access via UNC path > >> \\remoteserver\share > >> why so troublesome ? can you host it in the IIS server itself ? > >> > >> -- > >> Regards, > >> Bernard Cheah > >> http://www.microsoft.com/iis/ > >> http://www.iiswebcastseries.com/ > >> http://www.msmvps.com/bernard/ > >> > >> > >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message > >> news:O4xbVyupFHA.2580@TK2MSFTNGP09.phx.gbl... > >> > Hi, > >> > > >> > I just take chance, then what is its alternate. > >> > > >> > Hardik > >> > > >> > > >> > > >> > "Bernard Cheah [MVP]" <qbernard@hotmail.com.discuss> wrote in message > >> > news:eWtsbAupFHA.2916@TK2MSFTNGP14.phx.gbl... > >> >> wow. can this be done? > >> >> DATA SOURCE= "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") > >> >> > >> >> ftp is a file transfer protocol not file system that handle file open, > >> >> locking, etc. > >> >> > >> >> -- > >> >> Regards, > >> >> Bernard Cheah > >> >> http://www.microsoft.com/iis/ > >> >> http://www.iiswebcastseries.com/ > >> >> http://www.msmvps.com/bernard/ > >> >> > >> >> > >> >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message > >> >> news:uPGk6BYpFHA.1416@TK2MSFTNGP09.phx.gbl... > >> >> > > >> >> >> "Chris Crowe [MVP]" Wrote : > >> >> >> From what you are saying to me is that you are sitting at your > > client > >> >> >> computer and you want to update records in your Access Database > >> >> >> that > >> >> >> could > >> >> >> presumably be at an ISP's site that you can connect to via FTP? > >> >> > My website use Access database . I want to call server's database by > >> >> > something like following procedure (VB.Net) > >> >> > > >> >> > conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; > >> >> > DATA SOURCE= "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") > >> >> > > >> >> > > >> >> >>Normally people upload new versions of their access database in > >> >> >>this > >> >> >>case. > >> >> > > >> >> > Some columns of the table (like password ) can be change by web user > >> >> > (viewer) . So it is not possible to replace whole database. > >> >> > > >> >> > Thanks for reply > >> >> > > >> >> > Hardik Shah > >> >> > > >> >> > > >> >> > ======================== > >> >> >> Have you thought about writing some ASP web pages to update the > >> > database, > >> >> > or > >> >> >> maybe a create web service in vb.net? > >> >> >> > >> >> >> It really depends on what you are updating as to your options. > >> >> >> > >> >> >> Have a look at this code project which is a database Viewer and > > Editor > >> >> >> for > >> >> >> ASP > >> >> >> > >> >> >> http://www.codeproject.com/asp/ute.asp > >> >> >> > >> >> >> For an online demo see http://www.wellige.com/tom/ute/ > >> >> >> > >> >> >> Let me know if any of this helps. > >> >> >> -- > >> >> >> > >> >> >> Cheers > >> >> >> > >> >> >> Chris > >> >> >> > >> >> >> Chris Crowe [IIS MVP] > >> >> >> http://blog.crowe.co.nz > >> >> >> > >> >> >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message > >> >> >> news:uuBW7wonFHA.3300@TK2MSFTNGP15.phx.gbl... > >> >> >> > Hi, > >> >> >> > > >> >> >> > I have developed an web-site , I use Access-2000 database with > > ASP, > >> >> >> > > >> >> >> > I want to access my data through VB .Net , and want to modify > >> > selected > >> >> >> > data. > >> >> >> > So procedure may be as below : > >> >> >> > > >> >> >> > Application connect to FTP Server with username and password, > > access > >> >> >> > database and change required correction. > >> >> >> > > >> >> >> > How can I , > >> >> >> > > >> >> >> > Any hints will be sincerly appreciated. > >> >> >> > > >> >> >> > > >> >> >> > Harsha Shah > >> >> >> > > >> >> >> > > >> >> >> > > >> >> >> > > >> >> >> > > >> >> >> > > >> >> >> > > >> >> >> > > >> >> >> > > >> >> >> > >> >> >> > >> >> > > >> >> > > >> >> > >> >> > >> > > >> > > >> > >> > > > > > >
I meant you can't do this.. ftp:\\x.x.x.x\your.mdb\
FTP is a file transfer protocol... not a file system for you to access. -- Regards, Bernard Cheah http://www.iis-resources.com/ http://www.iiswebcastseries.com/ http://www.msmvps.com/bernard/ [quoted text, click to view] "Harsha Shah" <har_sha_99@hotmail.com> wrote in message news:ep5NQBTuFHA.3548@tk2msftngp13.phx.gbl... > Bernard Cheah Writes : > Sorry, been traveling. Now, as mentioned earlier - you can put a ftp:// in > the connectionstring and expect this to work. Also Chris has pointed out > that this is development issue not IIS ftp. > ============= > Did you mean that I can give following command ? > > conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; DATA SOURCE= > "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") > > Is there any sample code. > > Hardik. > > > > "Bernard Cheah [MVP]" <qbernard@hotmail.com.discuss> wrote in message > news:eIcVXgTrFHA.248@TK2MSFTNGP14.phx.gbl... >> Sorry, been traveling. Now, as mentioned earlier - you can put a ftp:// >> in >> the connectionstring and expect this to work. Also Chris has pointed out >> that this is development issue not IIS ftp. >> >> PS: you are posting real url in your msgs. thought is protected by > password. >> it is still a risk by posting such info in a public forums. >> >> -- >> Regards, >> Bernard Cheah >> http://www.microsoft.com/iis/ >> http://www.iiswebcastseries.com/ >> http://www.msmvps.com/bernard/ >> >> >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message >> news:uaVteEypFHA.3180@TK2MSFTNGP15.phx.gbl... >> > Hi, >> > >> > Thanks for your previous replies. I think I can't explain my problem >> > effectively. So I am trying again. Please help me. >> > >> > I have web database name ftpdata.mdb, on this path >> > ftp://216.157.154.143/sbgb.org/hardasp/ftpdata.mdb >> > It is accessed by public and some of data is updated by them through >> > web >> > page. >> > >> > Now I also have to update this database at out side. it is not possible > to >> > replace whole database through ftp connection. >> > So I have to write some code in vb. net , it might be as follow : >> > >> > 1) Connect to my web database >> > ftp://216.157.154.143/sbgb.org/hardasp/ftpdata.mdb >> > 2) Connect to my local database (C:\local.mdb) >> > 3) Check (Record by Record) local.mdb with ftpdata.mdb and if > required >> > update ftpdata.mdb >> > >> > I just miss connectionstring , what should be connectionstring >> > or is there any alternate to do this type of task >> > >> > Any hints will be sincerly appreciated. >> > >> > >> > Hardik............. >> > >> > >> > >> > >> > >> > "Bernard Cheah [MVP]" <qbernard@hotmail.com.discuss> wrote in message >> > news:#itjMAvpFHA.708@TK2MSFTNGP09.phx.gbl... >> >> You can host the db in your local network, then access via UNC path >> >> \\remoteserver\share >> >> why so troublesome ? can you host it in the IIS server itself ? >> >> >> >> -- >> >> Regards, >> >> Bernard Cheah >> >> http://www.microsoft.com/iis/ >> >> http://www.iiswebcastseries.com/ >> >> http://www.msmvps.com/bernard/ >> >> >> >> >> >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message >> >> news:O4xbVyupFHA.2580@TK2MSFTNGP09.phx.gbl... >> >> > Hi, >> >> > >> >> > I just take chance, then what is its alternate. >> >> > >> >> > Hardik >> >> > >> >> > >> >> > >> >> > "Bernard Cheah [MVP]" <qbernard@hotmail.com.discuss> wrote in >> >> > message >> >> > news:eWtsbAupFHA.2916@TK2MSFTNGP14.phx.gbl... >> >> >> wow. can this be done? >> >> >> DATA SOURCE= "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") >> >> >> >> >> >> ftp is a file transfer protocol not file system that handle file > open, >> >> >> locking, etc. >> >> >> >> >> >> -- >> >> >> Regards, >> >> >> Bernard Cheah >> >> >> http://www.microsoft.com/iis/ >> >> >> http://www.iiswebcastseries.com/ >> >> >> http://www.msmvps.com/bernard/ >> >> >> >> >> >> >> >> >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message >> >> >> news:uPGk6BYpFHA.1416@TK2MSFTNGP09.phx.gbl... >> >> >> > >> >> >> >> "Chris Crowe [MVP]" Wrote : >> >> >> >> From what you are saying to me is that you are sitting at your >> > client >> >> >> >> computer and you want to update records in your Access Database >> >> >> >> that >> >> >> >> could >> >> >> >> presumably be at an ISP's site that you can connect to via FTP? >> >> >> > My website use Access database . I want to call server's database > by >> >> >> > something like following procedure (VB.Net) >> >> >> > >> >> >> > conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; >> >> >> > DATA SOURCE= > "ftp:\\180.20.15.40\sbgb.org\Database\inspection.mdb") >> >> >> > >> >> >> > >> >> >> >>Normally people upload new versions of their access database in >> >> >> >>this >> >> >> >>case. >> >> >> > >> >> >> > Some columns of the table (like password ) can be change by web > user >> >> >> > (viewer) . So it is not possible to replace whole database. >> >> >> > >> >> >> > Thanks for reply >> >> >> > >> >> >> > Hardik Shah >> >> >> > >> >> >> > >> >> >> > ======================== >> >> >> >> Have you thought about writing some ASP web pages to update the >> >> > database, >> >> >> > or >> >> >> >> maybe a create web service in vb.net? >> >> >> >> >> >> >> >> It really depends on what you are updating as to your options. >> >> >> >> >> >> >> >> Have a look at this code project which is a database Viewer and >> > Editor >> >> >> >> for >> >> >> >> ASP >> >> >> >> >> >> >> >> http://www.codeproject.com/asp/ute.asp >> >> >> >> >> >> >> >> For an online demo see http://www.wellige.com/tom/ute/ >> >> >> >> >> >> >> >> Let me know if any of this helps. >> >> >> >> -- >> >> >> >> >> >> >> >> Cheers >> >> >> >> >> >> >> >> Chris >> >> >> >> >> >> >> >> Chris Crowe [IIS MVP] >> >> >> >> http://blog.crowe.co.nz >> >> >> >> >> >> >> >> "Harsha Shah" <har_sha_99@hotmail.com> wrote in message >> >> >> >> news:uuBW7wonFHA.3300@TK2MSFTNGP15.phx.gbl... >> >> >> >> > Hi, >> >> >> >> > >> >> >> >> > I have developed an web-site , I use Access-2000 database with >> > ASP, >> >> >> >> > >> >> >> >> > I want to access my data through VB .Net , and want to modify >> >> > selected >> >> >> >> > data. >> >> >> >> > So procedure may be as below : >> >> >> >> > >> >> >> >> > Application connect to FTP Server with username and password, >> > access >> >> >> >> > database and change required correction. >> >> >> >> > >> >> >> >> > How can I , >> >> >> >> > >> >> >> >> > Any hints will be sincerly appreciated. >> >> >> >> > >> >> >> >> > >> >> >> >> > Harsha Shah >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> >> >> >> >> >> >> >> >> > >> >> >> > >> >> >> >> >> >> >> >> > >> >> > >> >> >> >> >> > >> > >> >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
| home · blog · groups | Questions? Comments? Contact the dn |