access og server 2003

Jeg tilgå db med følgende kode:


set rs = Server.CreateObject("ADODB.Recordset")
set Conn = Server.CreateObject("ADODB.Connection")

sDir = Server.MapPath(".") & "\database\"
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & sDir & ("data.mdb")

  Conn.Open DSN

are you trying to connect to an Access dB from an ASP application?
What version of Access do you have?

yes
i juse ASP.
I maybe dont have Acces installed.
What file do I need to installe

You dont need to install Access if you use ASP to open the Access database, but you need MDAC.

Do you know what version of Access the dB is created in? How have you created the dB?

Actually I would think MDAC is alreday installed on the PC.

http://msdn.microsoft.com/en-us/data/aa937703.aspx


Maybe upgrading to the newest version might help

according to this link http://support.microsoft.com/kb/231943 you should have the newest version but without SP1

If you have an Access 2007 db then you will very likley need something else

i hvae MDAC 2.8
but it still dont work

try re-installing it
http://www.dbforums.com/archive/index.php/t-555421.html

i have re-installed but it didnt help.
Do i did to reg a speciel .dll

jb2000, you can write in Danish, I understabnd very well. Just too lazy to write :o)

"Do i did to reg a speciel .dll" ?

what special.dll?

If you have installed mdac then it should register the components.

What version of Access is teh dB made with?

Hey
Jeg ved ikke hvilken version af Access det er, men det er gammelt. Det er bare noget jeg har overtaget.
Jeg læste et sted at det kunne hjælpe at reistrere følgende dll.er


regsvr32 C:\WINDOWS\System32\Msjetoledb40.dll
regsvr32 C:\WINDOWS\System32\Msjet40.dll
regsvr32 C:\WINDOWS\System32\Mswstr10.dll
regsvr32 C:\WINDOWS\System32\Msjter40.dll
regsvr32 C:\WINDOWS\System32\Msjint40.dll

regsvr32 C:\WINDOWS\System32\jscript.dll
regsvr32 C:\WINDOWS\System32\vbscript.dll

jeg har lige geninstalleret mdac 2.8 uden servicepack 1.

Min server kører iis 6.0 med servicepack 2.0
Jeg har haft afinstalleret min servicepack 2.0 og geninstalleret den. Det kan ikke anbefaldes. Heldigvis er det stadig en testserver...
Jeg har også uploaded en ny kopi af db i tilfælde at den skulle være beskadet.

OK, so we can assume that it isnt an Access 2007 dB you have. I would have thought that installing mdac would also register the required DLL's but you could also try registering them manually.
If you still cant get it working then you might have a better chance of getting help in to ASP catgeory.

Jeg geninstalleret win 2003 og nu virker det fint.