Information générale
Catégorie:
Applications Internet
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement