General information
Category:
Internet applications
I'm sorry to say, but I don't have any experience with connecting databases to the internet, but I would assume that's it much the same as having one on a network. I would think that as long as you have an ODBC driver that allows you to connect, the rest of it will be like working on any network. And as long as you have the ODBC driver, shouldn't you be able to establish the remote view programatically within a 'create remote view' command? Sorry I'm not much help, but this is virgin territory for me.
>Cause I'm not so familar with connecting web and database,
>I'd like to ask you a question(might be silly one).
>You mean that I can access remote views via internet's http protocol?
>If so, How can I do that?
>
>
>> 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