| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Terry
Guest
Posts: n/a
|
I am using FP2002 and want to host a db online to capture sensitive
information. I have a SSL and since FP doesn't work well with secured folders I used dreamweaver to create the form to post to the database. My webhost (or the software) mandates that the databases folder exist from the root folder. FP extensions do not allow access to this folder since FP only goes down from the public folder. My asp form can find the db using the dsn if I put the database in the root/databases folder but I can't use my FP database results form to query it. I have tried creating a query form in dreamweaver but can't get the ftp remote connection to see the database either. I have also tried changing the asp in the secured folder to us dsn-less and use the /public/databases/ path and while the form says it processes successfully it also says it can't write to the database. any thoughts? |
|
||
|
||||
|
|
|
| |
|
Thomas A. Rowe
Guest
Posts: n/a
|
If the database is stored outside of the web, you can use a System DSN which is supported by FP,
however depending on your web host, you may have to manually write the connection in the global.asa file. FP work just fine with SSL, as long as the SSL certificate is applied to the entire web and the extensions are configure to work on port 443. You would still access/publish your site via FP using http, not https. You web host must manually set the necessary permissions on the folder (and database) holding the database, since the database is not stored in a folder accessibility by the FP extensions. -- ============================================== Thomas A. Rowe Microsoft MVP - FrontPage http://www.Ecom-Data.com ============================================== "Terry" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)... >I am using FP2002 and want to host a db online to capture sensitive information. I have a SSL and >since FP doesn't work well with secured folders I used dreamweaver to create the form to post to >the database. My webhost (or the software) mandates that the databases folder exist from the root >folder. FP extensions do not allow access to this folder since FP only goes down from the public >folder. My asp form can find the db using the dsn if I put the database in the root/databases >folder but I can't use my FP database results form to query it. I have tried creating a query form >in dreamweaver but can't get the ftp remote connection to see the database either. I have also >tried changing the asp in the secured folder to us dsn-less and use the /public/databases/ path and >while the form says it processes successfully it also says it can't write to the database. any >thoughts? > |
|
||
|
|
||||
|
Terry
Guest
Posts: n/a
|
How would you modify the global.asa to see the root/databases folder if FP
cannot? "Thomas A. Rowe" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > If the database is stored outside of the web, you can use a System DSN > which is supported by FP, however depending on your web host, you may have > to manually write the connection in the global.asa file. FP work just fine > with SSL, as long as the SSL certificate is applied to the entire web and > the extensions are configure to work on port 443. You would still > access/publish your site via FP using http, not https. > > You web host must manually set the necessary permissions on the folder > (and database) holding the database, since the database is not stored in a > folder accessibility by the FP extensions. > > -- > ============================================== > Thomas A. Rowe > Microsoft MVP - FrontPage > > http://www.Ecom-Data.com > ============================================== > > > "Terry" <(E-Mail Removed)> wrote in message > news:%(E-Mail Removed)... >>I am using FP2002 and want to host a db online to capture sensitive >>information. I have a SSL and since FP doesn't work well with secured >>folders I used dreamweaver to create the form to post to the database. My >>webhost (or the software) mandates that the databases folder exist from >>the root folder. FP extensions do not allow access to this folder since >>FP only goes down from the public folder. My asp form can find the db >>using the dsn if I put the database in the root/databases folder but I >>can't use my FP database results form to query it. I have tried creating >>a query form in dreamweaver but can't get the ftp remote connection to see >>the database either. I have also tried changing the asp in the secured >>folder to us dsn-less and use the /public/databases/ path and while the >>form says it processes successfully it also says it can't write to the >>database. any thoughts? >> > > |
|
||
|
|
||||
|
Thomas A. Rowe
Guest
Posts: n/a
|
Open the file in notepad and edit...
-- ============================================== Thomas A. Rowe Microsoft MVP - FrontPage http://www.Ecom-Data.com ============================================== "Terry" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > How would you modify the global.asa to see the root/databases folder if FP cannot? > > > > "Thomas A. Rowe" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... >> If the database is stored outside of the web, you can use a System DSN which is supported by FP, >> however depending on your web host, you may have to manually write the connection in the >> global.asa file. FP work just fine with SSL, as long as the SSL certificate is applied to the >> entire web and the extensions are configure to work on port 443. You would still access/publish >> your site via FP using http, not https. >> >> You web host must manually set the necessary permissions on the folder (and database) holding the >> database, since the database is not stored in a folder accessibility by the FP extensions. >> >> -- >> ============================================== >> Thomas A. Rowe >> Microsoft MVP - FrontPage >> >> http://www.Ecom-Data.com >> ============================================== >> >> >> "Terry" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)... >>>I am using FP2002 and want to host a db online to capture sensitive information. I have a SSL and >>>since FP doesn't work well with secured folders I used dreamweaver to create the form to post to >>>the database. My webhost (or the software) mandates that the databases folder exist from the >>>root folder. FP extensions do not allow access to this folder since FP only goes down from the >>>public folder. My asp form can find the db using the dsn if I put the database in the >>>root/databases folder but I can't use my FP database results form to query it. I have tried >>>creating a query form in dreamweaver but can't get the ftp remote connection to see the database >>>either. I have also tried changing the asp in the secured folder to us dsn-less and use the >>>/public/databases/ path and while the form says it processes successfully it also says it can't >>>write to the database. any thoughts? >>> >> >> > > |
|
||
|
|
||||
|
Terry
Guest
Posts: n/a
|
That is not what I meant. I mean the global.asa file shows the file path
like this: "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=databases/t2s.mdb" This folder is off the public folder as in, root/public/databases I need to have one root/databases "Thomas A. Rowe" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > Open the file in notepad and edit... > > -- > ============================================== > Thomas A. Rowe > Microsoft MVP - FrontPage > > http://www.Ecom-Data.com > ============================================== > > > "Terry" <(E-Mail Removed)> wrote in message > news:(E-Mail Removed)... >> How would you modify the global.asa to see the root/databases folder if >> FP cannot? >> >> >> >> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message >> news:(E-Mail Removed)... >>> If the database is stored outside of the web, you can use a System DSN >>> which is supported by FP, however depending on your web host, you may >>> have to manually write the connection in the global.asa file. FP work >>> just fine with SSL, as long as the SSL certificate is applied to the >>> entire web and the extensions are configure to work on port 443. You >>> would still access/publish your site via FP using http, not https. >>> >>> You web host must manually set the necessary permissions on the folder >>> (and database) holding the database, since the database is not stored in >>> a folder accessibility by the FP extensions. >>> >>> -- >>> ============================================== >>> Thomas A. Rowe >>> Microsoft MVP - FrontPage >>> >>> http://www.Ecom-Data.com >>> ============================================== >>> >>> >>> "Terry" <(E-Mail Removed)> wrote in message >>> news:%(E-Mail Removed)... >>>>I am using FP2002 and want to host a db online to capture sensitive >>>>information. I have a SSL and since FP doesn't work well with secured >>>>folders I used dreamweaver to create the form to post to the database. >>>>My webhost (or the software) mandates that the databases folder exist >>>>from the root folder. FP extensions do not allow access to this folder >>>>since FP only goes down from the public folder. My asp form can find >>>>the db using the dsn if I put the database in the root/databases folder >>>>but I can't use my FP database results form to query it. I have tried >>>>creating a query form in dreamweaver but can't get the ftp remote >>>>connection to see the database either. I have also tried changing the >>>>asp in the secured folder to us dsn-less and use the /public/databases/ >>>>path and while the form says it processes successfully it also says it >>>>can't write to the database. any thoughts? >>>> >>> >>> >> >> > > |
|
||
|
|
||||
|
Thomas A. Rowe
Guest
Posts: n/a
|
Ask your web host to set up a System DSN which would solve the problem or they need to provide you
with a sample FileSystem DSN on how to create the connection. -- ============================================== Thomas A. Rowe Microsoft MVP - FrontPage http://www.Ecom-Data.com ============================================== "Terry" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > That is not what I meant. I mean the global.asa file shows the file path like this: > "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=databases/t2s.mdb" > > This folder is off the public folder as in, root/public/databases > > I need to have one root/databases > > > > > > "Thomas A. Rowe" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... >> Open the file in notepad and edit... >> >> -- >> ============================================== >> Thomas A. Rowe >> Microsoft MVP - FrontPage >> >> http://www.Ecom-Data.com >> ============================================== >> >> >> "Terry" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... >>> How would you modify the global.asa to see the root/databases folder if FP cannot? >>> >>> >>> >>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message >>> news:(E-Mail Removed)... >>>> If the database is stored outside of the web, you can use a System DSN which is supported by >>>> FP, however depending on your web host, you may have to manually write the connection in the >>>> global.asa file. FP work just fine with SSL, as long as the SSL certificate is applied to the >>>> entire web and the extensions are configure to work on port 443. You would still access/publish >>>> your site via FP using http, not https. >>>> >>>> You web host must manually set the necessary permissions on the folder (and database) holding >>>> the database, since the database is not stored in a folder accessibility by the FP extensions. >>>> >>>> -- >>>> ============================================== >>>> Thomas A. Rowe >>>> Microsoft MVP - FrontPage >>>> >>>> http://www.Ecom-Data.com >>>> ============================================== >>>> >>>> >>>> "Terry" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)... >>>>>I am using FP2002 and want to host a db online to capture sensitive information. I have a SSL >>>>>and since FP doesn't work well with secured folders I used dreamweaver to create the form to >>>>>post to the database. My webhost (or the software) mandates that the databases folder exist >>>>>from the root folder. FP extensions do not allow access to this folder since FP only goes down >>>>>from the public folder. My asp form can find the db using the dsn if I put the database in the >>>>>root/databases folder but I can't use my FP database results form to query it. I have tried >>>>>creating a query form in dreamweaver but can't get the ftp remote connection to see the >>>>>database either. I have also tried changing the asp in the secured folder to us dsn-less and >>>>>use the /public/databases/ path and while the form says it processes successfully it also says >>>>>it can't write to the database. any thoughts? >>>>> >>>> >>>> >>> >>> >> >> > > |
|
||
|
|
||||
|
Terry
Guest
Posts: n/a
|
So you are saying they should be able to configure the dsn to what ever path
I need? I have been on the phone with them several times and they have told me that the database folder has to be off the root. 2nd question. Does the FP database results wizard use dsn-less connections normally? It seems it does. "Thomas A. Rowe" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > Ask your web host to set up a System DSN which would solve the problem or > they need to provide you with a sample FileSystem DSN on how to create the > connection. > > -- > ============================================== > Thomas A. Rowe > Microsoft MVP - FrontPage > > http://www.Ecom-Data.com > ============================================== > > > "Terry" <(E-Mail Removed)> wrote in message > news:(E-Mail Removed)... >> That is not what I meant. I mean the global.asa file shows the file path >> like this: >> "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=databases/t2s.mdb" >> >> This folder is off the public folder as in, root/public/databases >> >> I need to have one root/databases >> >> >> >> >> >> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message >> news:(E-Mail Removed)... >>> Open the file in notepad and edit... >>> >>> -- >>> ============================================== >>> Thomas A. Rowe >>> Microsoft MVP - FrontPage >>> >>> http://www.Ecom-Data.com >>> ============================================== >>> >>> >>> "Terry" <(E-Mail Removed)> wrote in message >>> news:(E-Mail Removed)... >>>> How would you modify the global.asa to see the root/databases folder if >>>> FP cannot? >>>> >>>> >>>> >>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message >>>> news:(E-Mail Removed)... >>>>> If the database is stored outside of the web, you can use a System DSN >>>>> which is supported by FP, however depending on your web host, you may >>>>> have to manually write the connection in the global.asa file. FP work >>>>> just fine with SSL, as long as the SSL certificate is applied to the >>>>> entire web and the extensions are configure to work on port 443. You >>>>> would still access/publish your site via FP using http, not https. >>>>> >>>>> You web host must manually set the necessary permissions on the folder >>>>> (and database) holding the database, since the database is not stored >>>>> in a folder accessibility by the FP extensions. >>>>> >>>>> -- >>>>> ============================================== >>>>> Thomas A. Rowe >>>>> Microsoft MVP - FrontPage >>>>> >>>>> http://www.Ecom-Data.com >>>>> ============================================== >>>>> >>>>> >>>>> "Terry" <(E-Mail Removed)> wrote in message >>>>> news:%(E-Mail Removed)... >>>>>>I am using FP2002 and want to host a db online to capture sensitive >>>>>>information. I have a SSL and since FP doesn't work well with secured >>>>>>folders I used dreamweaver to create the form to post to the database. >>>>>>My webhost (or the software) mandates that the databases folder exist >>>>>>from the root folder. FP extensions do not allow access to this >>>>>>folder since FP only goes down from the public folder. My asp form >>>>>>can find the db using the dsn if I put the database in the >>>>>>root/databases folder but I can't use my FP database results form to >>>>>>query it. I have tried creating a query form in dreamweaver but can't >>>>>>get the ftp remote connection to see the database either. I have also >>>>>>tried changing the asp in the secured folder to us dsn-less and use >>>>>>the /public/databases/ path and while the form says it processes >>>>>>successfully it also says it can't write to the database. any >>>>>>thoughts? >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > |
|
||
|
|
||||
|
Thomas A. Rowe
Guest
Posts: n/a
|
See inline below
-- ============================================== Thomas A. Rowe Microsoft MVP - FrontPage http://www.Ecom-Data.com ============================================== "Terry" <(E-Mail Removed)> wrote in message news:enr0%(E-Mail Removed)... > So you are saying they should be able to configure the dsn to what ever path I need? I have been > on the phone with them several times and they have told me that the database folder has to be off > the root. They have to give you the exact path to use unless they create a System DSN. > > 2nd question. Does the FP database results wizard use dsn-less connections normally? It seems it > does. No, FP normal create a file system based connection using a global.asa file. > > > > "Thomas A. Rowe" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... >> Ask your web host to set up a System DSN which would solve the problem or they need to provide >> you with a sample FileSystem DSN on how to create the connection. >> >> -- >> ============================================== >> Thomas A. Rowe >> Microsoft MVP - FrontPage >> >> http://www.Ecom-Data.com >> ============================================== >> >> >> "Terry" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... >>> That is not what I meant. I mean the global.asa file shows the file path like this: >>> "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=databases/t2s.mdb" >>> >>> This folder is off the public folder as in, root/public/databases >>> >>> I need to have one root/databases >>> >>> >>> >>> >>> >>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message >>> news:(E-Mail Removed)... >>>> Open the file in notepad and edit... >>>> >>>> -- >>>> ============================================== >>>> Thomas A. Rowe >>>> Microsoft MVP - FrontPage >>>> >>>> http://www.Ecom-Data.com >>>> ============================================== >>>> >>>> >>>> "Terry" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... >>>>> How would you modify the global.asa to see the root/databases folder if FP cannot? >>>>> >>>>> >>>>> >>>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message >>>>> news:(E-Mail Removed)... >>>>>> If the database is stored outside of the web, you can use a System DSN which is supported by >>>>>> FP, however depending on your web host, you may have to manually write the connection in the >>>>>> global.asa file. FP work just fine with SSL, as long as the SSL certificate is applied to the >>>>>> entire web and the extensions are configure to work on port 443. You would still >>>>>> access/publish your site via FP using http, not https. >>>>>> >>>>>> You web host must manually set the necessary permissions on the folder (and database) holding >>>>>> the database, since the database is not stored in a folder accessibility by the FP >>>>>> extensions. >>>>>> >>>>>> -- >>>>>> ============================================== >>>>>> Thomas A. Rowe >>>>>> Microsoft MVP - FrontPage >>>>>> >>>>>> http://www.Ecom-Data.com >>>>>> ============================================== >>>>>> >>>>>> >>>>>> "Terry" <(E-Mail Removed)> wrote in message >>>>>> news:%(E-Mail Removed)... >>>>>>>I am using FP2002 and want to host a db online to capture sensitive information. I have a SSL >>>>>>>and since FP doesn't work well with secured folders I used dreamweaver to create the form to >>>>>>>post to the database. My webhost (or the software) mandates that the databases folder exist >>>>>>>from the root folder. FP extensions do not allow access to this folder since FP only goes >>>>>>>down from the public folder. My asp form can find the db using the dsn if I put the database >>>>>>>in the root/databases folder but I can't use my FP database results form to query it. I have >>>>>>>tried creating a query form in dreamweaver but can't get the ftp remote connection to see the >>>>>>>database either. I have also tried changing the asp in the secured folder to us dsn-less and >>>>>>>use the /public/databases/ path and while the form says it processes successfully it also >>>>>>>says it can't write to the database. any thoughts? >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > |
|
||
|
|
||||
|
Terry
Guest
Posts: n/a
|
My isp gave me instructions on how to use dsn-less connection for my
database with this code: Set MyConn = Server.CreateObject("ADODB.Connection") MdbFilePath = Server.MapPath("sample.mdb") MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";" I assume I need to change the Server.MapPath("sample.mdb") and DBQ=" & MdbFilePath & ";" but not sure exactly what to put in it as the asp file will reside on a secure server and my home page on another. Any ideas? What exactly do I need to ask my isp on this? "Thomas A. Rowe" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)... > See inline below > > -- > ============================================== > Thomas A. Rowe > Microsoft MVP - FrontPage > > http://www.Ecom-Data.com > ============================================== > > > "Terry" <(E-Mail Removed)> wrote in message > news:enr0%(E-Mail Removed)... >> So you are saying they should be able to configure the dsn to what ever >> path I need? I have been on the phone with them several times and they >> have told me that the database folder has to be off the root. > > They have to give you the exact path to use unless they create a System > DSN. > >> >> 2nd question. Does the FP database results wizard use dsn-less >> connections normally? It seems it does. > > No, FP normal create a file system based connection using a global.asa > file. > >> >> >> >> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message >> news:(E-Mail Removed)... >>> Ask your web host to set up a System DSN which would solve the problem >>> or they need to provide you with a sample FileSystem DSN on how to >>> create the connection. >>> >>> -- >>> ============================================== >>> Thomas A. Rowe >>> Microsoft MVP - FrontPage >>> >>> http://www.Ecom-Data.com >>> ============================================== >>> >>> >>> "Terry" <(E-Mail Removed)> wrote in message >>> news:(E-Mail Removed)... >>>> That is not what I meant. I mean the global.asa file shows the file >>>> path like this: >>>> "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=databases/t2s.mdb" >>>> >>>> This folder is off the public folder as in, root/public/databases >>>> >>>> I need to have one root/databases >>>> >>>> >>>> >>>> >>>> >>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message >>>> news:(E-Mail Removed)... >>>>> Open the file in notepad and edit... >>>>> >>>>> -- >>>>> ============================================== >>>>> Thomas A. Rowe >>>>> Microsoft MVP - FrontPage >>>>> >>>>> http://www.Ecom-Data.com >>>>> ============================================== >>>>> >>>>> >>>>> "Terry" <(E-Mail Removed)> wrote in message >>>>> news:(E-Mail Removed)... >>>>>> How would you modify the global.asa to see the root/databases folder >>>>>> if FP cannot? >>>>>> >>>>>> >>>>>> >>>>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message >>>>>> news:(E-Mail Removed)... >>>>>>> If the database is stored outside of the web, you can use a System >>>>>>> DSN which is supported by FP, however depending on your web host, >>>>>>> you may have to manually write the connection in the global.asa >>>>>>> file. FP work just fine with SSL, as long as the SSL certificate is >>>>>>> applied to the entire web and the extensions are configure to work >>>>>>> on port 443. You would still access/publish your site via FP using >>>>>>> http, not https. >>>>>>> >>>>>>> You web host must manually set the necessary permissions on the >>>>>>> folder (and database) holding the database, since the database is >>>>>>> not stored in a folder accessibility by the FP extensions. >>>>>>> >>>>>>> -- >>>>>>> ============================================== >>>>>>> Thomas A. Rowe >>>>>>> Microsoft MVP - FrontPage >>>>>>> >>>>>>> http://www.Ecom-Data.com >>>>>>> ============================================== >>>>>>> >>>>>>> >>>>>>> "Terry" <(E-Mail Removed)> wrote in message >>>>>>> news:%(E-Mail Removed)... >>>>>>>>I am using FP2002 and want to host a db online to capture sensitive >>>>>>>>information. I have a SSL and since FP doesn't work well with >>>>>>>>secured folders I used dreamweaver to create the form to post to the >>>>>>>>database. My webhost (or the software) mandates that the databases >>>>>>>>folder exist from the root folder. FP extensions do not allow >>>>>>>>access to this folder since FP only goes down from the public >>>>>>>>folder. My asp form can find the db using the dsn if I put the >>>>>>>>database in the root/databases folder but I can't use my FP database >>>>>>>>results form to query it. I have tried creating a query form in >>>>>>>>dreamweaver but can't get the ftp remote connection to see the >>>>>>>>database either. I have also tried changing the asp in the secured >>>>>>>>folder to us dsn-less and use the /public/databases/ path and while >>>>>>>>the form says it processes successfully it also says it can't write >>>>>>>>to the database. any thoughts? >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > |
|
||
|
|
||||
|
Thomas A. Rowe
Guest
Posts: n/a
|
Sorry, I do not work with dsn-less connection, you will need to wait for someone else to reply.
-- ============================================== Thomas A. Rowe Microsoft MVP - FrontPage http://www.Ecom-Data.com ============================================== "Terry" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > My isp gave me instructions on how to use dsn-less connection for my database with this code: > > Set MyConn = Server.CreateObject("ADODB.Connection") > MdbFilePath = Server.MapPath("sample.mdb") > MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";" > > I assume I need to change the Server.MapPath("sample.mdb") and DBQ=" & MdbFilePath & ";" but not > sure exactly what to put in it as the asp file will reside on a secure server and my home page on > another. > Any ideas? What exactly do I need to ask my isp on this? > > > > "Thomas A. Rowe" <(E-Mail Removed)> wrote in message > news:%(E-Mail Removed)... >> See inline below >> >> -- >> ============================================== >> Thomas A. Rowe >> Microsoft MVP - FrontPage >> >> http://www.Ecom-Data.com >> ============================================== >> >> >> "Terry" <(E-Mail Removed)> wrote in message news:enr0%(E-Mail Removed)... >>> So you are saying they should be able to configure the dsn to what ever path I need? I have >>> been on the phone with them several times and they have told me that the database folder has to >>> be off the root. >> >> They have to give you the exact path to use unless they create a System DSN. >> >>> >>> 2nd question. Does the FP database results wizard use dsn-less connections normally? It seems >>> it does. >> >> No, FP normal create a file system based connection using a global.asa file. >> >>> >>> >>> >>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message >>> news:(E-Mail Removed)... >>>> Ask your web host to set up a System DSN which would solve the problem or they need to provide >>>> you with a sample FileSystem DSN on how to create the connection. >>>> >>>> -- >>>> ============================================== >>>> Thomas A. Rowe >>>> Microsoft MVP - FrontPage >>>> >>>> http://www.Ecom-Data.com >>>> ============================================== >>>> >>>> >>>> "Terry" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... >>>>> That is not what I meant. I mean the global.asa file shows the file path like this: >>>>> "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=databases/t2s.mdb" >>>>> >>>>> This folder is off the public folder as in, root/public/databases >>>>> >>>>> I need to have one root/databases >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message >>>>> news:(E-Mail Removed)... >>>>>> Open the file in notepad and edit... >>>>>> >>>>>> -- >>>>>> ============================================== >>>>>> Thomas A. Rowe >>>>>> Microsoft MVP - FrontPage >>>>>> >>>>>> http://www.Ecom-Data.com >>>>>> ============================================== >>>>>> >>>>>> >>>>>> "Terry" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... >>>>>>> How would you modify the global.asa to see the root/databases folder if FP cannot? >>>>>>> >>>>>>> >>>>>>> >>>>>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message >>>>>>> news:(E-Mail Removed)... >>>>>>>> If the database is stored outside of the web, you can use a System DSN which is supported >>>>>>>> by FP, however depending on your web host, you may have to manually write the connection in >>>>>>>> the global.asa file. FP work just fine with SSL, as long as the SSL certificate is applied >>>>>>>> to the entire web and the extensions are configure to work on port 443. You would still >>>>>>>> access/publish your site via FP using http, not https. >>>>>>>> >>>>>>>> You web host must manually set the necessary permissions on the folder (and database) >>>>>>>> holding the database, since the database is not stored in a folder accessibility by the FP >>>>>>>> extensions. >>>>>>>> >>>>>>>> -- >>>>>>>> ============================================== >>>>>>>> Thomas A. Rowe >>>>>>>> Microsoft MVP - FrontPage >>>>>>>> >>>>>>>> http://www.Ecom-Data.com >>>>>>>> ============================================== >>>>>>>> >>>>>>>> >>>>>>>> "Terry" <(E-Mail Removed)> wrote in message >>>>>>>> news:%(E-Mail Removed)... >>>>>>>>>I am using FP2002 and want to host a db online to capture sensitive information. I have a >>>>>>>>>SSL and since FP doesn't work well with secured folders I used dreamweaver to create the >>>>>>>>>form to post to the database. My webhost (or the software) mandates that the databases >>>>>>>>>folder exist from the root folder. FP extensions do not allow access to this folder since >>>>>>>>>FP only goes down from the public folder. My asp form can find the db using the dsn if I >>>>>>>>>put the database in the root/databases folder but I can't use my FP database results form >>>>>>>>>to query it. I have tried creating a query form in dreamweaver but can't get the ftp >>>>>>>>>remote connection to see the database either. I have also tried changing the asp in the >>>>>>>>>secured folder to us dsn-less and use the /public/databases/ path and while the form says >>>>>>>>>it processes successfully it also says it can't write to the database. any thoughts? >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > |
|
||
|
|
||||
|
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to catch exceptions from Firebird database? | Jarkki | Microsoft ADO .NET | 1 | 19th Oct 2005 10:24 AM |
| Database connections and try catch finally? | Kenneth Myhra | Microsoft ADO .NET | 12 | 12th Oct 2005 10:46 PM |
| Howto catch changes in the database | =?Utf-8?B?RGVyY2tpZQ==?= | Microsoft ADO .NET | 8 | 15th Jun 2005 09:12 PM |
| I am in a catch 22 with the database results tool | Mark Sandfox | Microsoft Frontpage | 1 | 18th Dec 2003 08:20 PM |
| How to catch database messages | XMan | Microsoft Access Form Coding | 9 | 24th Oct 2003 04:09 PM |
Powered by vBulletin®. Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2010, Crawlability, Inc. |
