March 16, 2002 at 1:17 am
Hi All,
I am facing a few problems for debugging a stored procedure from VB using T-SQL Debugger. I am debugging against a default instance of sql server 2000, not named instance. I am able to debug with sql server 7.0 but not with sql 2000. On doing a 'execute' for ADOCOMMAND, I am getting the following error
"The following sql server error has occured. ODBC Driver does not support the requested properties". Is it something to dowith ADO drivers I have. I am using MDAC 2.5. Please help
Thanks
Rajdeep
March 16, 2002 at 12:38 pm
Try MDAC 2.6. MDAC 2.5 doesn't support named instances directly, you have to configure an alias to get it to work. I've had no problems with 2.6.
Andy
March 16, 2002 at 1:43 pm
Also there were revisions made in MDAC 2.6 for 2000, which it was the version shipped with 2000.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply