RDS Problem 1

[fruityBoy]

Hi all, I have a problem using RDS.

I setup the control to look at an ODBC data connection that I have defined (it does not matter if it is SQL, Fox, Access, etc), but upon issueing the 'refresh' method, I get the following errors:

OLE ID DISPATCH EXCEPTION CODE 0 FROM RDSSERVER.DATAFACTORY:
THE SPECIFIED HANDLER HAS DENIED ACCESS.

I am following the exact instructions for programming that Microsoft provides, I have even downloaded Microsoft Foxpro Samples and these return the error, which leads me to think that it is not the code, but rather the way the controls have been setup.

Has anybody else come across this problem, and if so, how did you resolve this issue?

I can get it working if I work directly with the ADO objects instead of using the RDO wrappers, but I would prefer to use the higher level methods.

Thanks in advance.

[sig][/sig]

 

[emcveigh]

fruitBoy,

I'm having this same problem using RDS with SQL 2000 and W2K SP1. Were you ever able to figure it out?

Emma

 

[Walid]

Hi
fruitBoy,Emma
Can you please post a sample of your code you use with the RDS object.
Thanks
Walid Magd
Engwam@Hotmail.com

 

[fruityBoy]

This takes me back a few months!!

Basically, what I did was - give up and use ADO, I reported the problem to Microsoft, but never got any response.

I think that if you use ADO instead, you will find it a lot more satisfying and user-friendly.

It's easy to create connections to data sources (local and remote) and pass resultsets back between foxpro objects (dcom on mutiple machines included - which is REALLY useful).

I've written 3 tier applications with it and foxpro DCOM programs, and found it to be a fast, simple and easy approach to handling data.

Sorry I can't help you anymore with the RDS problem tho..

fruityBoy