Re: ODBC probelms when connecting to MSSQL

From: "Robert Boardman" <robb@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
I'm trying to connect to MSSQL 2000 to execute a number of stored
procedures to return values to my IVR system,

I have two stored procedures that work, and one that works from the ms
query analyser, but when I run the perl script

Please send the stored procedure, red herring or not we need to see
it to help.

Jenda
===== Jenda@xxxxxxxxxxx === http://Jenda.Krynicky.cz =====
When it comes to wine, women and song, wizards are allowed
to get drunk and croon as much as they like.
-- Terry Pratchett in Sourcery

.

Relevant Pages

  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server and VSS
    ... You can do this directly from the Query Analyser. ... Guru's guide (the one on t-sql stored procedures, ... > Microsoft plan to have SQL server integrated with VSS in the next version? ...
    (microsoft.public.sqlserver.programming)
  • Re: how to use Store Procedure in VC# 2005 and SQL 2005 ?
    ... you have to create the stored procedures on your sql-server with help of query analyser: ...
    (microsoft.public.dotnet.languages.csharp)