Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Appok

  1. Appok

    Looping

    create table Software ( [Name] varchar (255) not null, [Version] varchar (255) not null, [F_ID] int not null, ) Created a table then i altered the table ALTER TABLE Software ADD FOREIGN KEY (F_ID) REFERENCES Inventory(P_ID); nothing gets inputted when i run the script, but when i allow nulls...
  2. Appok

    Looping

    Yes my inventory table does have a primary key auto increment field. Ok i'll make one also now for software list
  3. Appok

    Looping

    what do you mean by key field?
  4. Appok

    Looping

    ' 'Found most parts of this script available at http://www.tek-tips.com/viewthread.cfm?qid=798632 strComputer = "." Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") Set colItems = objWMIService.ExecQuery("Select * from Win32_BIOS",,48) 'SQL Database Connection Dim...
  5. Appok

    Looping

    How can i loop this instruction sSoftware = "Insert into Software_List ([Name], [Version]) values ('" & objSoftware.Name & "','" & objSoftware.Version & "')" mConnection.Execute (sSoftware) Because at the moment it executes only once and it lists only 1 program in my table, i have been told...
  6. Appok

    SQL Remote Connection and upload

    i have figured out my problem as it was not the SQL is was my script, i had too many insert statements and that was the issue.
  7. Appok

    VBS Newbie

    HI all i just wanna give an update on my script. I have done pretty much what i wanted to accomplish! aside from the script spamming new lines each time it has run and also i'd like it to just update its values that have change on the users information in the database. The script all started...
  8. Appok

    SQL Remote Connection and upload

    Sorry hit the post button instead of preview, and i dunno how to edit my posts lol
  9. Appok

    SQL Remote Connection and upload

    I also have another question that has been bothering me. Each time the script has run, it fills its gaps with null cells. If i disable allow nulls my script will not run, this is what i mean. <a href="http://imgur.com/NzHjl"><img src="http://i.imgur.com/NzHjl.jpg" alt="" title="Hosted by...
  10. Appok

    SQL Remote Connection and upload

    Alright thanks for your help! i'll play around with it, i did see my TCP/IP and i set a port to 1433 im pretty sure i can set a static IP from my home router.
  11. Appok

    SQL Remote Connection and upload

    I figured it out! im able to go to each of my PC's at home and run the script and i can see all the data they have! this is awesome! But will this work on an outside line? im currently running it inside my own home network.
  12. Appok

    SQL Remote Connection and upload

    mConnection.Open = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=Inventory;Data Source=ADAM-SERVER\SQLEXPRESS; UID=Adam; PWD=qazw" this is my connection string, i dont know if its the right way for settingup a SQL Login Connection
  13. Appok

    SQL Remote Connection and upload

    Hi all I have been creating a VB script that does a computer inventory and uploads it to a SQL Database called Inventory and the Table is called inventory. I;m using a free version of SQL 2012 and i setup a account which i can use to log into the database and pull data off the server and...
  14. Appok

    VBS Newbie

    The thing with UPDATE is that i need to reconfig the script each time right? i forgot to mention that this script will be a login script for multiple PC's. But i do have alot of progress and i'll keep messing around with it. I just need a way to get rid of the null values or somehow combine all...
  15. Appok

    VBS Newbie

    this is what i have now, i figured out what was wrong with my tables. and now i run the script and it inputs the values in 1 big table, but how do i make it only for 1 line for each computer is my next problem. hah ' 'Found most parts of this script available at...
See more

Part and Inventory Search

Back
Top