Search results for query: *

Hi wvdba Tried your way using the objConn settings and still get the unspecified error - alos, not too sure, but I think the Microsoft.Jet.OLEDB.4.0 provider is for Access 2003 databases (if www.connectionstrings.com is correct). Another way I do (NOTE: this is connecting to a 2003 db, i have...

Hi Chris, IIS USER has been granted full control over that folder and all its contents :( ALL users have in fact in order for me to try and work around this issue, to avail as of yet tho ShotoCon

Hi, just a few quick replies wvdba - in response to your reply, there is only one column in that particular table, its just for testing to be honest. ChrisHirst - I know its cross posted, I stated that in my original post, the fact is im not sure that its an ASP or IIS issue. ShotoCon

Hi There, Was developing a site on my old machine and have now transferred to my new machine which, unfortunately, has vista installed on it and so comes with IIS 7 and now my site will no longer connect to the database :( Figured it was because the new machine has Access 2007 installed...

Hi There, Was developing a site on my old machine and have now transferred to my new machine which, unfortunately, has vista installed on it and so comes with IIS 7 and now my site will no longer connect to the database :( Figured it was because the new machine has Access 2007 installed...

Umm, can ignore this - figured it out. Need to remove the enclosing ' ' from the winKey statement so the new code looks summit like this: "SELECT * FROM contestants WHERE key = "&winKey&""

Hi There, Have this bit of code here: dbQuery1 = "SELECT key FROM tempWin" Set recordSet = dbConnection.execute(dbQuery1) Dim winKey winKey=Cint(recordSet("key")) dbQuery1 = "SELECT * FROM contestants WHERE key = '"&winKey&"'" Set recordSet = dbConnection.execute(dbQuery1)...

Yip Yip Yip Here it is: <% 'Connect to you database 'simplified for illustration sql = "SELECT Id, Name, Image, url FROM tblGroup" Set RS = conn.Execute(sql) Dim arrData 'Array to Store Data Dim arrSequencer 'Array to Hold Random Suequence Dim iArrayLooper 'Integer For Looping...

Hi, Im currently writing an ASP page to select a record from a database based on the time stamp created when added. At present this has to be done manually - the user currently selects the hour they want the random record from (have randomisation sorted) and submits, system takes random record...

Hey Unfortunately the SQL Server code doesnt work - i did however manage to find code on asp101.com which did the trick Thanks for the help though ;oD

Hey Nelviticus, Thanks for the tip. Turns out it was an IIS problem, although not that one that you had pointed out. In the web site extensions console asp pages were marked as prohibited, allowed them and it works fine :-) Thanks for you tip though, it was whilst i was in there that I...

It'll just be running from an Access DB, the quiz doesn't need to do anything uber complicated, just hold the quiz questions and the contestants information.

Was wondering if anyone could give me any tips on this before i got started and got bogged down going down the wrong path! I need to be able to select 20 distinct records from a database - but the selection also needs to be random. Its basically for a quiz so I cant have the same question sets...

Can anyone help. Have set up a Virtual Server to develop some systems for myself before putting them live on an actual server - done this with several pieces of web-tech software (mainly coldFusion). Am trying to create a fairly simple ASP app but when i try to view any of the ASP (.asp) pages...