Hi Mike
There are actually five parameters inside my stored procedure (and they can all be null if necessary).
I don't have any problems calling it when the driver is p2sql.dll, but when i convert the driver to sqloledb.dll then it doesn't recognise the name of the stored procedure cos it has...
Hi there
I have a report which is coming off a stored procedure using SQL server connection which has a field longer than 255 chars. The report field cuts out after 255 chars. Crystal website told me to convert the driver to SQL OLEDB which I did and it runs fine......but i have to keep logging...
Hi Mike
Have you checked out the below site:
www.coveryourasp.com
The author gives you all the code you need, as he does the exact samething on his site. I haven't actually looked at it, but give it a go.
HTH
Tim
Hey db999, maybe you should consider going around every single users computer and putting the dsn on manually....................just a thought.
All the best
Hi there
What I want to do seems rather simple but then not so simple.
This is the situation:
We have 20 Access Databases (not in ASP) and we have a few access databases that have been given an ASP front end.
I have built a front end for the intranet and on this I would like to list all the...
Hi Brad
If I were you, use the form and have it submitted to either the same page or to another page (this gets the variable into the server)
By calling
intEmpNum = Request.Form("empNum")
Then run this into your sql statement as before.
Check out asp101.com for some good examples...
Hi there
I'm looking for the same answer you are, so if you don't mind I'll just listen in. Although I did read in some messages posted back earlier, that they had to play around with the security settings to get it working properly
Tim
Hi there,
I'm trying to write some SQL that will run through a table I have, adding up the values in one column, for each hour they were logged.
For example, 8-9am 3 calls logged
9-10am 6 calls logged
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.