You can't use a DB from one server on a different server
If your DB is named sample.mdb and is on the same server what happen when you use that code
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
| 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?
|
|
|
| | > See inline below
| >
| > --
| > ==============================================
| > Thomas A. Rowe
| > Microsoft MVP - FrontPage
| >
| >
http://www.Ecom-Data.com
| > ==============================================
| >
| >
| > | >> 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.
| >
| >>
| >>
| >>
| >> | >>> 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
| >>> ==============================================
| >>>
| >>>
| >>> | >>>> 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
| >>>>
| >>>>
| >>>>
| >>>>
| >>>>
| >>>> | >>>>> Open the file in notepad and edit...
| >>>>>
| >>>>> --
| >>>>> ==============================================
| >>>>> Thomas A. Rowe
| >>>>> Microsoft MVP - FrontPage
| >>>>>
| >>>>>
http://www.Ecom-Data.com
| >>>>> ==============================================
| >>>>>
| >>>>>
| >>>>> | >>>>>> How would you modify the global.asa to see the root/databases folder
| >>>>>> if FP cannot?
| >>>>>>
| >>>>>>
| >>>>>>
| >>>>>> | >>>>>>> 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
| >>>>>>> ==============================================
| >>>>>>>
| >>>>>>>
| >>>>>>> | >>>>>>>>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?
| >>>>>>>>
| >>>>>>>
| >>>>>>>
| >>>>>>
| >>>>>>
| >>>>>
| >>>>>
| >>>>
| >>>>
| >>>
| >>>
| >>
| >>
| >
| >
|
|
