Problem creating connection to SQL server database from RSA

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Problem creating connection to SQL server database from RSA

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-09-14 : 09:56:17

KESHAVi PATEL writes "In Data perspective view of RSA, while creating new SQL server database connection with Open Source jtds type-4 driver, the testing of connection with database was successful but it did not create data structure on the workspace and was complaining of : One or more problems were reported while accessing the database. Commit() should not be called in auto-commit mode.

But on the other hand while testing for cloudscape database connection in RSA, the connection was created successfully.

But with squirrel it allows to connect and see the database without any difficulty.

I tried doing the same things, in WSAD, without any complain the database connection was created on the workspace which shows data structure and guest user

Any one of yours comment regarding solution to the problem in RSA to create database connection shall be highly appreciated."

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2006-09-14 : 12:06:17

Are you using MSSQL server???
What are "RSA" "Open Source jtds type-4 driver" "cloudscape" WSAD"???????