Avatar billede tma_oksboel Nybegynder
12. november 2002 - 21:37 Der er 11 kommentarer

Dataadgangsider, endnu engang. Data Source

Hej
Jeg kan fint oprette en dataadgangsside som virker på et intranet. Når jeg vil overføre databasen til min webserver, skal Data Source ændres til noget der er valid på internettet. På intranettet kan jeg anvende \\servername\foldername\db.mdb, men hvad er syntaksen når det er en webserver??
Jeg vil IKKE bruge noget asp i denne løsning.

Hjælp med at lukke dette problem, en gang for alle.

Torben
Avatar billede terry Ekspert
12. november 2002 - 21:57 #1
Torben, do you know where to change the information?

On a web server you normally will be allocated a drive so

d:\databases\db.mdb or what ever, should work
Avatar billede terry Ekspert
12. november 2002 - 22:02 #2
If you view the htm file in Notepad and search for ConnectionString then you  should see the path\filename after ;Data Source=
Avatar billede terry Ekspert
12. november 2002 - 22:11 #3
this link should also be of help

http://www.eksperten.dk/spm/278485
Avatar billede terry Ekspert
12. november 2002 - 22:11 #4
and here
there is also a link here
http://www.eksperten.dk/spm/87452
Avatar billede tma_oksboel Nybegynder
12. november 2002 - 22:12 #5
I know where to change it, but not what to write. It is not a logical driveletter and path. It you take a look at the source of this test:
http://www.soelbaekdata.dk/db/tkunder.htm

You vil see that the system cannot find the database, even if it is in the same directory as the html-file.
Avatar billede tma_oksboel Nybegynder
12. november 2002 - 22:13 #6
I have looked at all of these links (I even answared the first one) but the solutions only apply to intranet.
Avatar billede terry Ekspert
12. november 2002 - 22:41 #7
the first is not!
Data Source=//80.80.80.80/dbfolder/db.mdb
Your web provider should be able to tell you what your drive is
mine is d:
so I could just write ;Data Source=D:\mydb.mdb;
Avatar billede tma_oksboel Nybegynder
12. november 2002 - 22:44 #8
If it is located at the internet, i would like to see it. Can you give me the address?
Avatar billede tma_oksboel Nybegynder
13. november 2002 - 09:59 #9
En supporter der hvor jeg har mit websted har skrevet følgende til mig:
den fysiske sti på serveren kan findes ved at bruge Server.Mappath.
Stien er : d:\www2\soelbaekdata\

Server.MapPath kan jeg vel kun bruge i forbindelse med ASP. Jeg kan godt bruge f.eks. CurrentProject.FullName men det vil vist ikke rigtig løse noget.
Torben
Avatar billede terry Ekspert
13. november 2002 - 13:02 #10
Torben, can you see th text in the other commnets, I can only see your last comment! Do eksperten have a problem or is it me?

I think I wrote previously that you could use d:\ ....
but that isnt correct as HTML (I think) will be looking on the client PC. I dont know much about HTML so I cant say for sure if you can use server.mappath as it is NOT on the server like ASP would be. Unless you can put <%server.mappath%> in the connection string or maybe a call to an asp function.
Avatar billede tma_oksboel Nybegynder
13. november 2002 - 13:27 #11
I can only see the same as you mention. I have found a link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_adap.asp
But I havent had the time yet to see if it solves my problem. If you want, you could take a look. I have found the option UseRemoteProvider which is to be set True when on a IIS
Torben
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester