473,320 Members | 1,949 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Windows Vista Ultimate - Connecting to an Access DB in IIS 7

Hello everyone. I just recently moved to Windows Vista Ultimate from XP Pro on my desktop machine which of course means I'm running IIS 7. I'm able to view asp pages that don't connect to an access database by way of an include file I have in the wwwroot directory. But when I try to access any page that has this include file I get the error number #500 this page cannot be displayed. I took a look at whether or not the IUSR user has Adminstrative rights. Interestingly this user does not appear in the Users folder but only in the Groups folder. Could this be part of my connection problem? And if so, how do I add the user IUSR to the Users folder?
Oct 23 '07 #1
5 4419
kenobewan
4,871 Expert 4TB
So this appears to be an Access problem?
Oct 23 '07 #2
Could it be the type of connection I'm using. Here is my connection script:

dbpath = "D:\accessdb\test\billing"
CommStrStart = "Provider=Microsoft.jet.oledb.4.0;data source="
If Session("SName") = "Charlotte" Then
DataConn = DBPath & "\CharlotteBillingData.mdb"
End If

Set Conn = Server.CreateObject("ADODB.Connection")
ConStr = CommStrStart & DataConn
Conn.open(ConStr)
Set cmdDC = Server.CreateObject("ADODB.Command")
cmdDC.ActiveConnection = Conn
Oct 23 '07 #3
By the way, my database was created using Access 2003 and I've recently upgraded to Office 2007. This worked on my XP Pro setup but not having the same success in Vista.
Oct 23 '07 #4
kenobewan
4,871 Expert 4TB
Try connection string:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\accessdb\test\billing\CharlotteBillingDa ta.mdb;Persist Security Info=False;

Your code needs optimizing:)
Oct 24 '07 #5
Thank you for the response. I'm unfamiliar with this kind of connection. When you say that the code needs to be optimized what do you suggest. I'm somewhat new at coding.
Oct 30 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

37
by: Allen Browne | last post by:
If you develop for others, you probably have multiple versions of Access installed so you can edit and create MDEs for clients in different versions. This works fine under Windows XP, even with...
6
by: j2ee.singh | last post by:
Hi, I'm looking to buy a new laptop primarily to learn & practice .NET and C#. My Question is: Is there any requirement for .NET and C# in terms of the following Operating Systems: -...
2
by: =?Utf-8?B?TG9yZW56bw==?= | last post by:
hi i just got windows vista ultimate and the way my pc is set up is i have 2 hard drives 1 with xp pro and one with vista ultimate but i wanted to go make a back up of vista the entire image one...
1
cjbrx3115
by: cjbrx3115 | last post by:
Hey everyone! I had always wanted DreamScene on my computer, but found out that it can only be done on Windows Vista Ultimate (I have Home Premium.) I was wondering if any of you knew of a place that...
2
by: mindspring | last post by:
A pc that was created in MS office xp's Access 2002 has been working fine on a windows vista Ultimate pc that has MS OFfice Vista Edition. But all of the sudden it stopped working and gives this...
1
by: mushroom | last post by:
Hi Everyone, I have a problem connecting windows vista with windows XP. I have a laptop running Windows Vista 32 bit and a desktop running Windows XP with Service Pack 2. They are both...
1
by: Chris Botha | last post by:
I upgraded from Vista Home Premium to Ultimate. With Home Premium there is no Windows Authentication for IIS - I googled that it is available under Ultimate and upgraded to Ultimate. However, when...
3
by: litusahoo | last post by:
Hi i need to install oracle 9i on windows vista ultimate service pack1 .but everytime i try to install it it shows some error and stops , Please let me know how can i install oracle9i in...
2
by: =?Utf-8?B?TG9yZW4=?= | last post by:
I have a brand new Dell computer right out of the box. It was purchased with Windows Vista Basic. I have also separately purchased Windows Vista Ultimate and I want to install it on this new...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.