General information
Category:
Internet applications
Yongseung-
If you are using ODBC drivers, perhaps your code for making the ODBC connecition is incorrect. Look in your Developer's Guide under ODBC connectors for the proper way to declare connections. It seems that the error message you received is telling you that an ODBC error occurred. Also, if you're making an ODBC conneciton, I'm fairly certain that you have to use a 'create sql view' command to incorporate your select statement. Good luck on finding the solution.
-Charlie Davies
>I got the errer message when using ODBC and SQL stuffs.
>
>the error message is like the followings,
>
>[State=S1000][Error=300][Microsoft][ODBC Visual FoxPro Driver]
>Function name is missing ).
>
>
>My *.idc file's code is like the followings,
>
>datasource:rex
>username:sa
>template:register.htx
>SQLStatement:
>+IF exists (
>+SELECT * FROM members.dbf
>+WHERE id='%id%'
>+ )
>+SELECT result='already'
>+ELSE
>+INSERT INTO members.dbf
>+(hname,ename,id,passwd,zipcode,hadd1,hadd2,eadd1,eadd2,
>tel,fax,email,cash,bank,catagory,detail,idnumber,today)
>+Values('%hname%','%ename%','%id%','%passwd%','%zipcode%'
>,'%hadd1%','%hadd2%','%eadd1%','%eadd2%','%tel%','%fax%',
>'%email%',10000,'%bank%','%catagory%','%extra%','',today());
>
>If there is anybody knows well about
>IDC(internet database connector) of IIS?
>
>Pls. Help me.
>thank you.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only