Search results

if you make an Access Project out the app, then by default , all "queries" you create are stored procedures. You don't have a choice.

this might help..might not...take a look. http://weblogs.asp.net/pwilson/archive/2003/10/10/31456.aspx

you can get the sql 2005 express edition for free and you can use the CTP to manage it. http://www.microsoft.com/downloads/details.aspx?FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&DisplayLang=en

I hear ya man, I actually dev 80-90% in classic ASP at work.. *BLECH*.. infact, I just built a pagable, sortable gridview class and stored proc to go with it over the past few days so I can plop a grid in where I need it and not have to screw around with copy paste. It acts similar to a GridView...

My recommendation is that if you don't know ASP that you skip it and move right to ASP.NET. There's a bit of a learning curve to it but once you can a handle on the basics, you can make sites with those features you want rather quickly. VS.NET Express is free...

Try making another user in sql server that can login to that database. Then use those credentials for the project connection and see if that works.

how did you set up the connection on the clients? did you use windows authentication or SQL authentication?

got it..my text was being padded with whitespace and the convert was cutting the text at 50 characters. I removed the convert for the @SQLText and @SQLFor and used a regex to replace 2 or more whitespaces with just one whitespace and passed that to the procedure.. bicketty bam! :)

I'm trying to setup a paging query in SQL server 2000 and I'm having a real pain in the butt time with it. What I want to do is pass in the text of the query and execute it. So @SQLFrom would contain " From [tablename] " but I keep getting [Microsoft][ODBC SQL Server Driver][SQL...

ok, got that one sorted by using exec sp_helptext 'sprocname'

Getting stored procedure source text? Hello, I was wondering if anyone knew how to obtain the source text (i.e Select x from table) of a stored procedure using any SQL server commands or functions.. Thanks.

you should be using sql server 2000. SQL 7 is nearing EOL and has moved to special support in MS. In any case, Your client ony needs MS-Access installed. SQL server can communicate with your project over a network, so when you set up your MS Access Project, it will ask you for the server...

did you check the record in the database to make sure the whole content is actually there?

http://www.mssqlcity.com/FAQ/Devel/first_month_day.htm http://www.sqljunkies.com/Article/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk

then why not use the second suggestion which is to UPPERCASE them in the front end code ?

varArray=split(variable,"string to split on") now it's in an array..

not necessary. use the split function instead.

do something like this at the top of your page if request.form<>"" then txtAreaText=request.form("txtAreaText") 'request.form("txtAreaText") references the name of the html text area. end if <textarea rows="5" columns="30"><%=txtAreaText%></textarea> infact, do this for all your form fields...

Classic ASP or .NET?

.NET is vastly superior to DAP in every way. Whatever you can do with DAP, you can do it better with .NET. I posted a link to MS VS.NET Express which you can download for free until Nov of 06 and ONLY during that time frame will the downloads come with a free life-time license. Here's the...