>Hi
>I want to connect with this line of code
>handle=SQLSTRINGCONNECT('dsn=rbhoo;uid=rbhoo;pwd=rbhoo')
>it works great when i exam it in prg but when i compile it to exe and hit the adress it retyrn a 0< value
>why?
If using ODBC you first have to create a system DSN and give SQL access to IUSR_Computername. The reason it works for you in the prg is that you are logged in as yourself, but the web user is logged in under a different id with different access - usually IUSR_Computername.
The solution is to create a
System DSN and give IUSR_ access.
The other solution is to use SQLSTRINGCONNECT as you have done and pass in a userid and password. Since this Uid has access it works.