First off, I hope this is in the right section. I am sorry if it is not. I have been searching and reading for a few days now, but to no avail.
I have found a tutorial, and cannot get it to work. It is close to what I want to learn to do. Basically I want to search a microsoft data base for parts and their location. But this is the closest thing I have found to learn with and I keep getting this error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
/DaEngine.asp, line 14
I am trying to run this from my computer, as I am with some of my web pages. I am thinking that the problem may lie with the driver situation being that I am very unfamiliar with this aspect. I am including the zip file if anyone is interested in looking at it, or if someone knows a better code geared more towards what I am looking for. Any help would be greatly appreciated.
I failed to mention this. Went into Data Sources (ODBC), Clicked on System DSN, Added Microsoft Access Driver (*.mdb), pointed it to the db file, and named it "Employees". Hopefully this is all that I needed to do to create this DSN.
In theory yes, that is all you need to do. I would check what driver you used as you may have selected the wrong one and I would open the database in access just to make sure it is not corrupt or anything.
GOT IT,GOT IT,GOT IT.......
Updated with the latest service pack, but my version stayed the same (4.200.00). But it works, It works!!!
Now I can continue on with my learning after 3 days of 5 to 6 hours each of pulling my hair out. Thank you so much for hanging in there with me.
One more thing about this mess..... I have it working but, After I do a search, if I try to go back or re-open the window, and try to search again, I get an error. I have to wait about 30 seconds to a minute or so before I can search again. It's like its waiting on the connection to close or something.
What do you think this may be a result of?