#158058 - 2006-03-03 07:15 AM
Re: SQL Connection
|
Shaun
Fresh Scripter
Registered: 2006-03-01
Posts: 9
|
Thanks guys for the input.
Further testing by adjusting the script to insert to a database specificly made on the server, confirms that the DBConn Open and Close are fine. Also confirms that the DBExecuteSQL is working when doing an INSERT.
Looking more like an issue with getting the Stored Proceedure in MSSQL to work properly, or an issue of corectly calling it.
If I use the 'SQL Query Analyser' and run the stored proceedure from the same PC with the same credintials it works, one would assume (never a good thing) that it then should work with the kix script.
Either that or my SP is screwed and i need to look at that side (most likely since its my first attempt at this)
|
|
Top
|
|
|
|
Moderator: Glenn Barnas, NTDOC, Arend_, Jochen, Radimus, Allen, ShaneEP, Ruud van Velsen, Mart
|
0 registered
and 697 anonymous users online.
|
|
|