Search results for query: *

Edit: Now if the login is correct is should return the url: http://access.mysite.com/downloadnow/program.exe Now if the login is incorrect is should return the url: http://mysite.com/noaccess.html

Hi, I would like to send a http command: hxxp://username:password@mysite.com/downloadnow/program.exe Now if the login is correct is should return the url: http://mysite.com/downloadnow/program.exe Now if the login is incorrect is should return the url: http://mysite.com/noaccess.html Thats...

I've even tried: Set objParam = objCommand.CreateParameter("test",3,2,5) objCommand.Parameters.Append objParam msgbox objParam intSprocValue = objCommand.Parameters("test").value msgbox intSprocValue Still no return value. Please someone help me out :)

Sorry I edited the wrong line. I removed the @ signs and it does the same as it did before. It executes the stored proc and runs but it does not return the number 0, 101 or 201.

I removed them and I got the following error on the same line of code I just edited: "Arguments are of the wrong type, are out of acceptable range, or in conflict with one another" Thanks :)

Hi Guys, I'm busy with a script and have decided to call a sproc and return the result to VB. Here is the sproc: CREATE PROCEDURE pr_Cleanup BEGIN TRAN TRUNCATE TABLE tb_Users IF @@ERROR <> 0 BEGIN ROLLBACK TRAN RETURN 101 END TRUNCATE TABLE tb_Excluded IF @@ERROR <> 0...

Thanks sorted :)

Buya its works great! Thanks PHV :) Star for you! Any help with the windows authentication question? How would I go about changing the login from trusted sql to windows authentication? Thanks alot :)

Also is it possible to use windows authentication if the script is run locally on the server? Because I was having issues since the default under security is set to "Windows Authentication Mode" and not "SQL Server and Windows Authentication Mode". Thanks :D

Hi, I have the following connection string: Set objConn = CreateObject("ADODB.Connection") objConn.Open "Driver={SQL Server};" & _ "Server=127.0.0.1;" & _ "Database=Master;" & _ "user id=test;" & _ "password=test;" Set...

Sorry typo: SQLQuery = "CREATE TABLE [dbo].[tb_Excluded](" & _ should be: SQLQuery = "CREATE TABLE [dbo].[tb_DomainUsers](" & _ So I end up with a db and name domainusers and a table named domain users! Thanks :)

Ok its working great! I also just realized I'll be making 700 mssql queries weather I add them to a temps files and read them back of if I do the query in the "if...then" check. One last issues i'm having is checking if the database/table i will be writing to exists or not! At the moment I can...

OK thanks since I am the n00b I will take your advice :) Will update you when I try this later today! Cheerz for being so helpful :D

Thanks :) Thats also a good idea! I was thinking of doing something along the lines of: If NumCommas = 4 Then WScript.Echo "Good String" WScript.Echo "Line added to Good.txt" Else WScript.Echo "Bad String" WScript.Echo "Line added to Bad.txt" End If ----...

Sorry I just tried to make it brief as possible! From the beginning: I have a text file with 650 lines of info. Each should contain all of the following fields: Username, Name, Surname, Password, Email Yet some lines only contain 3 fields: Username, Surname, Email. I need to add all 650...

Hi guys, After sorting through a text file with my VBS scripts I end up with 2 collections of entries. 1 with collection will have 650 lines and the other 1 will have 50 lines. Question now is do I create 2 lists in memory perform my SQL queries on them? or Do I create 2 temp text files and...