DB Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

SELECT * FROM `user` the_table WHERE the_table.userid = DB Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

SELECT * FROM `user` the_table WHERE the_table.userid = IIS 7 Problem with classic ASP and MS Access Database? - iTechForums
Login
Search   Moderators Wanted: If you're interested please send your portfolio to info[at]itechforums.com
Welcome to the iTechForums.
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.
To register now click here.
Latest Threads
Advertisements
Forum Statistics
Threads:
Posts: 4
Members:
Number of Users Online:
Welcome to our newest member,
iTechForums » System Administration » MS IIS »

IIS 7 Problem with classic ASP and MS Access Database?

Reply
 
Thread Tools Display Modes
  #1  
Old 12-28-2008, 05:23 PM
ARNYMA ARNYMA is offline
Junior Member
  
Join Date: Dec 2008
Posts: 1
Default

IIS 7 Problem with classic ASP and MS Access Database?

IIS 7 Problem with classic ASP and MS Access Database?

I have windows vista home premium and IIS7 installed on it. Classic ASP pages are working fine,but when I try to connect to Access database,I get the error, I did some research on internet, and set the permission for TEMP directory,and ApplicationPool, but still get the same erro.Any Ideas?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

  #2  
Old 12-28-2008, 05:23 PM
dhvrm dhvrm is offline
Senior Member
  
Join Date: May 2008
Posts: 113
Default
There are any number of possibilities here, from that you are using relative paths in a Server.MapPath call -- relative paths aren't allowed under IIS 7's architecture, at least not in the Server.MapPath method -- to not having installed MDAC or the proper data access components on your computer to power your connections & queries.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3  
Old 01-14-2010, 12:45 PM
ijkl838 ijkl838 is offline
Junior Member
  
Join Date: Sep 2009
Posts: 9
Talking

www.ashoess.com(nike shox tl3)

www.ashoess.com(nike shox tl3)

The Day Off From Work My husband was enjoying the day off from work and watched me scurry about the house. I picked up his dirty clothes, put away his work shoes, carried out his popcorn bowl from the previous night's football viewing, washed the breakfast dishes, wiped the coffee he'd spilled and ironed his shirts. Seeing a thoughtful look on his lace, I wondered if he was beginning to realize just how much unnecessary work he created for me. Maybe he would offer to help. "A penny for your thoughts," I said. "I was thinking," he replied, "that one of the things I like best about you is how you always find ways to keep yourself busy." puma shoesnike shox r4nike shox nznike air max 2009nike air max tn
__________________
prada shoes
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4  
Old Yesterday, 07:00 AM
ximike2010 ximike2010 is offline
Senior Member
  
Join Date: Jul 2010
Posts: 149
Exclamation

17.7.27

17.7.27

Herve leger Herve leger Herve leger Herve leger
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Previous Thread | Next Thread »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP access database question. 4 million records in the database. it takes too much Destiny's Child .Net (ASP.Net, VB.Net, C#) 0 10-22-2008 02:55 AM
how Display pic from access database Vb .net ? jjjjjjjjj .Net (ASP.Net, VB.Net, C#) 0 09-07-2008 05:30 AM
Remote access to a MySQL database? nit MySQL 0 08-20-2008 02:10 PM
Java and a database(access)? David P Java, Java Servlets & JSP 0 06-13-2008 12:29 PM
Convert a SQL database .bak to MS Access? Mike M MS SQL 0 05-06-2008 09:45 AM

Your Ad Here

All times are GMT. The time now is 03:32 AM.
Contact Us - Archive - Top