Has anyone ever used NotesSQL 3.02g with SQL Server 7.0 DTS?
Subject: NotesSQL with SQL Server DTS
I have, but then again, I was the developer. NotesSQL 3.02f had specific fixes in it for DTS. Are you having problems or are you just curious if it should work?
Ron
Subject: RE: NotesSQL with SQL Server DTS
Having some trouble with a dts package created on a SQL 7.0 server. NotesSQL 3.02g has been loaded on that server, as well as a Notes 6.02 client. However, when I try to run the dts package from the server, I’m getting this message: “Unspecified error” “[Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_DBC failed”.
I can run this dts package successfully from my local enterprise manager (v7.0). But when I try to schedule the job to run, the job fails.
Subject: RE: NotesSQL with SQL Server DTS
Go into the Windows Event Viewer and go to the Software section (on the left hand side), see if you see any events named NotesSQL and open them up to view. If there are any errors (and I suspect there will be), follow the directions, they should be very descriptive!
Ron