I'd to transfer data form RSView32 via RSSQL to the other computer which installed MS SQL 2000. I setup these two commputers
by WORKGROUP (Windows XP SP2 for both). Currently, I cannot set
RSSQL to meet database in MSSQL in the other computer. From the
"Configuration check list" in RSSQL, I cannot pass step4
(Define data objects) Anyone has experience please help or recommend the website with good sample.

 

Have you set up DNS files for MS SQL 2000 on both the PC running RSView32 and the PC running the database?

Rick

 

Have you set up DNS files for MS SQL 2000 on both the PC running RSView32 and the PC running the database?

Rick

I've set the DSN only the RSSQL side (RSSQL and RSView32 are in the same PC, MSSQL is in the other PC), RSSQL still cannot see the
database in the MSSQL. I'm sure that the PCs are in the same
workgroup.

 

Does the "Test Data Source" button succeed at the end of the ODBC definition/configuration routine on the RSSql PC?

 

Does the "Test Data Source" button succeed at the end of the ODBC definition/configuration routine on the RSSql PC?

Yes, it show "Succeeded" at Test Data Source.

 

bundhit.

Might be some kind of "security" or "user permission" problem on the RSSQL side. MSSQL will usually not allow annonomus access to the database server. User login permissions are a big pain in the rear but necessary to keep out unwanted traffic. Of course I'm not an expert in these matters, just something to consider.
BD

 

Thanks for all responses
Currently, I can solve the problem!
I changed the OS from WindowsXP SP2 to SP1,
I set "allow" for the "Access Permission" of Administrator
and I used SQL server and Windows Authentication Mode
Finally, the data can be transfered from RSView to MSSQL

Anyhow, I still doubt in the meaning of bi-directional transaction
of RSSQL. I am not sure that the data in MSSQL can be transfered
back to the RSview or not (without VB script). Anyone, has experience, please shares.