Stored procedure to Source Control

[kim1]

I have create a Database Project in InterDev.

When I right-click on the connection to Add to Source Control, I enter the database location. I have this error:

Error: ---------------------------
Microsoft Development Environment
---------------------------
ADO error: [Microsoft][ODBC SQL Server Driver][SQL Server]ODSOLE Extended Procedure: Bad variable type.

[Microsoft][ODBC SQL Server Driver][SQL Server]A cursor with the name 'cursorProcNames' does not exist.

Anyone has an idea?

Thank you for your help.

Kim

 

[MerlinB]

Does your server have Visual SourceSafe installed (it must be on the server)? If you do not want to use SourceSafe, then leave the Source Control stuff blank.

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)

 

[kim1]

Hi MerlinB,

Yes, I have the SourceSafe on the Server, I want the source safe database on this server because it is backup on tape every day.

I want to use SourceSafe to control the stored procedure directly throught InterDev and not from Enterprise Manager.

Do you have any idea?

Thank your for your help. Kim

 

[MerlinB]

try:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/sql7storprocvers.asp

or:

http://support.microsoft.com/support/kb/articles/Q199/2/04.ASP

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)