RDS

[seshadrivk]

Dim madoDataSpace As New RDS.DataSpace
Dim madoDataFactory

Dim rs As New ADODB.Recordset
mstrConnect = "DSN=local;uid=fgic;pwd=fgic"
mstrServer = "http://dev.fgic.capital.ge.com/"
strsql = "select loginid from sys_userinfo"
Set madoDataFactory = madoDataSpace.CreateObject("RDSServer.DataFactory", mstrServer)
Set rs = madoDataFactory.Query(mstrConnect, strsql)

[berta]

I think the server is

mstrServer = "dev.fgic.capital.ge.com" 'not "http://dev.fgic.capital.ge.com/"

but are U sure that U have the permission to createobject by DCOM on dev.fgic.capital.ge.com?

and I try PING dev.fgic.capital.ge.com but
"Bad IP address dev.fgic.capital.ge.com"

hi,brt

<center>
<HR width=80%>
<img src='http://web.tiscali.it/bertaplanet/im...ertaplanet.gif'>
</center>

[Cakkie]

First of all, as Betra said, loose the http://, in stead, use \\
mstrServer = "\\dev.fgic.capital.ge.com"

Secondly, if you are connecting over the internet, i got some really bad news. ISP don't allow DCOM over the internet. If it is on a LAN, ignore this remark.

Finally, check to see if you have sufficient rights on the server, both on server level as on database level.

If that doesn't do the trick, fill us in with some more information, like the statement it goes wrong, and what error you get.




Tom Cannaerts
[email protected]

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook