Can somebody give me a good working example of a SQLConnection string if
my server's name is SQL1, my database is DB1, my password is 12345 and
my username is USERNAME?

Thanks



 
Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com
 

-----Original Message-----
From: David L. Penton [mailto:[EMAIL PROTECTED]] 
Sent: Friday, October 04, 2002 10:17 AM
To: dotnet
Subject: RE: Getting results of SQL stored procedure 'Print' statements

Check the errors collection.  IIRC, PRINT statements will be there.

David L. Penton, Microsoft MVP
JCPenney Application Specialist / Lead
"Mathematics is music for the mind, and Music is Mathematics for the
Soul. - J.S. Bach"
[EMAIL PROTECTED]

Do you have the VBScript Docs or SQL BOL installed?  If not, why not?
VBScript Docs: http://www.davidpenton.com/vbscript
SQL BOL: http://www.davidpenton.com/sqlbol


-----Original Message-----
From: T. Bradley Dean [mailto:[EMAIL PROTECTED]]

I've created a SQL stored procedure that, instead of return a recordset,
"Print"s out it's results. The problem is, I can't see these results
anywhere but in the SQL Query Analyzer!

I'm using ASP.net with VB.net code, I've tried doing a Scalar Command
and
also just a regular SQLDataReader, both return nothing.

Any tips would be appreciated.

Thanks,

~Brad


---
You are currently subscribed to dotnet as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
%%email.unsub%%

---------
Administrated by 15 Seconds : http://www.15Seconds.com
List Archives/Search : http://local.15Seconds.com/search
Subscription Information : http://www.15seconds.com/listserv.htm
Advertising Information: http://www.internet.com/mediakit/






---
You are currently subscribed to dotnet as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]

---------
Administrated by 15 Seconds : http://www.15Seconds.com
List Archives/Search : http://local.15Seconds.com/search
Subscription Information : http://www.15seconds.com/listserv.htm
Advertising Information: http://www.internet.com/mediakit/


Reply via email to