Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
Problems with CAPI.AllocConnect() connecting to SQL 2000
Van_Duong_(tridentadmin_-_(deleted))
Has anyone had any problems connecting to a SQL 2000 database using AllocConnect(). We are running Livelink 9.1 Sp3 on Windows 2003 on one of our test machines. It worked fine connecting to SQL 7 but when I switched it over to connect to a copy of the database on SQL 2000 it has intermittent problems making the connection. Seems like it works the first time and then won't work the next. I have to restart Livelink to get it to work.Could it have something to do with the DSN I defined or possibly the way I created the database in SQL 2000.Any help would be appreciated.Thanks,Jeff RadkeGeneral Dynamics
Find more posts tagged with
Comments
volvostephen
Every once in a while I used to run into that problem. We have since upgraded to Livelink 9.1 SP4 and it hasn't happened again. It would seem that at times, the SQL Connections do not release properly and are unable to make subsequent connections. Not sure why. It does seem very odd that it happens all the time for you though..Is the SQL 2000 DB working properly? If you are using a local SQL user in the DB, then it can become troublesome to migrate objects. The easiest way around that would be to make dbo owner of all SQL objects in that db.That's all I can offer...might not help.
