Need Help ASAP!

Question

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

ChrisMoix-87856 SSCertifiable Points: 7288 More actions · Answer 1

SSCertifiable

Points: 7288

September 6, 2005 at 2:20 pm

Are you using MSDE?

Gary Tharaldson SSC Rookie Points: 29 More actions · Answer 2

I don't think so. Like I said, I've only used MS Access. My server all of a sudden is giving me this error.

I have a hosting account through Interland and generally use a Plesk interface....but I do have the ability to log on via terminal services.

Any ideas here?

ChrisMoix-87856 SSCertifiable Points: 7288 More actions · Answer 3

I don't see Access in your original post. It sounds like an MSDE error. Sorry I can't help any more. Sounds like you need to contact Interland.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

SSC Guru

Points: 294069

September 6, 2005 at 2:35 pm

Is it possible that some tables are linked to msde??

Gary Tharaldson SSC Rookie Points: 29 More actions · Answer 5

Nope, I do a call to the MS Access database only....one table lives there:

var oConn = Server.CreateObject("ADODB.Connection")

MdbFilePath = Server.MapPath("database/pornstar.mdb");

oConn.Open("Driver={Microsoft Access Driver (*.mdb)}; DBQ=" + MdbFilePath + ";");

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

Now it became interesting. Are you sure it's not possible that the access db has LINKED TABLES?

Phil Parkin SSC Guru Points: 246982 More actions · Answer 7

I reckon people would be more keen to help if you posted a copy of pornstar.mdb

Under what circumstances does the error message appear? Are you accessing table data, running queries etc?

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Gary Tharaldson SSC Rookie Points: 29 More actions · Answer 8

Haha! No doubt! It happens when I'm trying to do an insert into the database....using asp (jscript).

Nothing fancy going on here...it's a brand new site I'm working on...same server as all my other sites, same code pulled off an existing site.

Query works, connection strings are correct...out of the blue...this lousy error message....it's BS I tell you!

ziller SSC Eights! Points: 897 More actions · Answer 9

Sounds like Access is using the SQL Server Desktop Engine instead of JET, which limits the number or running queries to 8. See this article:

and this