Search results for query: *

...{ String sqlConnection = "Data Source=xx;Initial Catalog=xx;User ID=xx;Password=xx"; String sqlString = "Select * from tblTelephoneList"; System.Data.SqlClient.SqlConnection mySQLConnect = new...

Hi, This is all fixed now. It was just to do with IP address assignments to virtual sites. Thanks for your reply :)

Hi, I seem to be having a few issues. Here at work we have a Windows 2003 domain controller that is also hosting some internal web stuff. If I remote desktop into the server, and use "localhost" in IE, the web pages are served. If I try using either the IP address, or the domain name either on...

Thanks man... I cut n paste the fn_split thing from a link in the first FAQ and ended up with: select * from Table join fn_split('1,4', ',') on Table.ID = fn_split.value And it works... Nice... I really need to study this sh*t more... ;-) Thanks again.

...a Web List. So, I'll potentially end up with xxx.asp?userIDs=131,132,134.... ad infinitum. I COULD get the asp to loop through a series of SELECT * from TABLE where ID = x things and store them in an array, but was wondering how to do it all in one hit. While not knowing how many IDs are...

Er.... Problem solved.... SET NOCOUNT ON at the top of the query... It appears that SQL was returning a recordset to ASP everytime it added a row to the table... Which was causing ASP to have a fit... Thank you for replying to my post! Much appreciated! :-)

1) I have done the CREATE PROCEDURE thing in the actual stored procedure on the server. I have write access to the server and haven't had any issues creating sp's before. Just didn't cut n' paste it. 2) It's executing fine from QA. No problems - returns the correct 2 column table. The sp is...

...into @issuecounter, @date END -- End CLOSE issue -- close cursor deallocate issue select * from @issues GO When I run this query in Query Analyser, it seems to work fine. IE. I get a table returned with the correct values. However, when I...

Works like a charm! Thanks George! :-)

Good afternoon, I was wondering if anyone could help me with a problem before I stick my fist through my monitor? Table: HEADING | URL | ACCOUNT_TYPE Blah http://1 Type 1 Blah2 http://2 Type 1 Blah3 http://3 Type 2 Blah4 http://4 Type 3 Blah5...

Thanks man, Had a look through the IIS settings and lo and behold... someone had reset permissions on the file I was editing... Problem solved. Thanks for replying :-)

Of course there IS an error with .SetPassword - General Access Denied... Which is weird...

Good afternoon, I'm trying to figure out a way of changing an object in Active Directory's password through a webpage. Basically, we have around 3000+ accounts on our domain (workin in a school), and our Tech Support spends a lot of time resetting students passwords when they forget them. I'm...

Hi there Satish could have a point - that's one thing that I never really checked to be honest. We did a domain upgrade over the Summer and so I ditched the SQL Database for login information and decided to do it through Windows authentication and ADSI. Much cleaner :-)

I've just been having a flick through that link you left. Wow. Lots of stuff :-) Thanks guys, you've both been a huge help. Think I'm finally getting my head round the subject. Nice one :-)

Thanks damber... It's all starting to make some kinda of sense now... Obviously a mental block. I've got the thing authenticating and dumping various bits of info back at me... Just looking into the various properties that the different objects have... Thanks again for your help! :-)

Hi The logon_user serverVariable isn't set... It's just blank. I've tried your code by replacing strUserName with a valid user name (in this case, mine)... And nothing happens... When I try and response.write out the GrpList variable, there's nothing in it. Sorry if I'm being slow, but this...

Hi there, I'm looking for a primer/tutorial/any help with communicating with Active Directory from ASP 3.0. I'll be totally honest, I get using ASP with SQL databases but now (apparently) have to move over to ADSI/LDAP. I'm trying to write a typical form input login: 1)User types in...

Thanks for that... I managed to come up with a solution in the end. Used CSS to format the text / table so it was nice and small and then used ScriptX (available from http://www.meadroid.com/ScriptX) to force the page to print on landscape. Not exactly what I wanted to do - but close enough for...

Hi. I'm having trouble formatting a generated excel page. I'm using <code> <% Response.ContentType = "application/vnd.ms-excel" %> <HTML xmlns:x="urn:schemas-microsoft-com:office:excel"> <HEAD> <style> <!--table @page { mso-page-orientation: landscape...