FesterJester

I don't think what I am trying to do is doable. I have not yet found a way of creating a virtual serial port (I.E. COM10) without paying for some old piece of software or a bloated newer piece of software. I will keep searching, but my hopes are falling. If anyone knows up something to help with this, I welcome suggestions. Thanks,

I did see those UDF's, but I am not sure if they allow me to create a virtual COM/serial port or only open an existing COM/serial port. I will read the threads closer and see if I can figure that out.

I know serial ports / COM ports are a very old technology and are disappearing, but I have some legacy equipment that I need to keep operating for a while. Here is my question. Can I create virtual COM/serial ports using AutoIT? I would like to read one COM/serial port and output that to multiple COM/serial ports. I know there are software solutions out there to do this, but I am curious if I can make my own solution without all of the unnecessary features that are in the software I have seen so far. It seems like a simple thing to do, but as I discovered already, a simple task can turn into hundreds of lines of code and hours of time spent. Thanks in advance to anyone that helps. FJ

Thanks Jos. I figured that was the answer for the reason you stated, but I could not find a definitive answer anywhere.

Like the title suggests. Is there a way to use variables in the #pragma compile() statements? Thanks in advance.

@mLipok Not a problem. I understand that situation. I average 60+ hours Monday - Friday in my IT job plus the 20+ hours I freelance on the weekends plus my own projects in between all of that. (I think sleep is in there somewhere also. lol) I appreciate the work you have put into this so far and I thank you for having responded to my messages so far. I will keep my eye on this thread for an update. 😉

I found a solution! Looks like I need to add Integrated Security=SSPI to the connection string in order to authenticate to the SQL server properly. I have cheated and added ;Integrated Security=SSPI to the end of the server name I enter for variable $sServer. I.E. Local $sServer = 'ServerName;Integrated Security=SSPI' ; change this string to YourServerLocation Probably not the most elegant solution, but it is working now. Now I just need to build a username and password prompt. 🙂 Also, has anyone noticed that ADO_EXAMPLE_MS_SQL_Giovanov.au3 is incomplete?

I have made a little progress. I enabled the internal COMError handler and discovered a much more descriptive error. I figured out that I needed to change $bSQLAuth to True in the _Example_5_MSSQL_WinAuth() function. Now I can see that I am getting an authentication error. How do I use Windows/Active Directory credentials to authenticate? I know my credentials are valid because I can use my credentials in Microsoft SQL Server Management Studio.

I am going to make a guess and assume that @error=4 @extended=-2147352567 means authentication error. I managed to get _Example_MSSQL_SQLServerAuthorization() working. It looks like I had the wrong format for the server location string. I changed the server string in both example functions, but the _Example_MSSQL_WindowsAuthorization() function still has the error listed in the post above.

@mLipok I never noticed that the function was missing the "If @error" statement. Now I get the same error when I execute both functions. This is the entire output in the bottom panel of the SciTE Script Editor window >"C:\Program Files (x86)\AutoIt3\SciTE\..\autoit3.exe" /ErrorStdOut "C:\Users\user\Desktop\AutoIT-SQL\ADO_EXAMPLE.au3" ! ---> @error=4 @extended=-2147352567 : _Example_MSSQL_SQLServerAuthorization() ! ---> @error=4 @extended=-2147352567 : _Example_MSSQL_WindowsAuthorization() >Exit code: 0 Time: 21.36

Hello everyone. Looking to use AutoIT to return the results of a transact-sql (MSSQL) query. I will be connecting to SQL Server 15.0.2080.9 and would like to use Windows Authentication if possible. I downloaded this library and the examples, however I have been unsuccessful in connecting to the SQL server. I made a copy of ADO_EXAMPLE.au3 and edited the examples. In the _Example_MSSQL_SQLServerAuthorization() function, I changed: Database, Server, User, and Password I also changed the select statements to pull from tables that actually exist. In the _Example_MSSQL_WindowsAuthorization() function, I changed: Database and Server I also changed the select statements to pull from tables that actually exist. When I call the _Example_MSSQL_WindowsAuthorization() function, I get no output and no error that I can determine. When I call the _Example_MSSQL_SQLServerAuthorization() function, I get >"C:\Program Files (x86)\AutoIt3\SciTE\..\autoit3.exe" /ErrorStdOut "C:\Users\user\Desktop\AutoIT-SQL\ADO_EXAMPLE.au3" ! ---> @error=4 @extended=-2147352567 : _Example_MSSQL_SQLServerAuthorization() >Exit code: 0 Time: 20.86 I have not yet read through all 28 pages of this post to see if someone has listed the error codes or had a similar issue. Anyone out there able to help explain to me what I am doing wrong or missing? Any help is appreciated. Thanks, FJ

@argumentum Thank you. I did reference credit above that line, but have also added as you suggested. I have updated the file and the first post. @iamtheky I did not run across your attempt during my development. At a quick glance, I see yours requires PowerShell for some functionality and has more features reported than mine. Do I have some code that was written by you by chance? I do not want to take credit for something I did not write.

For some reason, I am unable to post this into the script examples, so this looked like the next best place to post it. Using some scripts made by others, much help from the AutoIT help resources, and Google searching, I have created a somewhat basic audit tool for Windows computers. Much credit goes to Ian Maxwell (@llewxam) and @engine Thank you both and please let me know if I have code from someone else that needs credit. Anyway, on to the cool part. This script will collect the following info and place it into a CSV file. Each item is selectable using check boxes and output and execute buttons have visual feedback. Computer name Hardware Manufacturer Hardware Model Possible Hardware Serial Number CPU Type, Speed, and Core Count RAM and Swap Local Hard Drives with Size and Free Space Remote Network Drives with Size and Free Space Network Connections with Hardware Device Name MAC Address DHCP or Static Domain IP Address Default Gateway Local User Accounts (Minus Guest, Default, and HomeGroupUsers) Operating System Version, Service Pack, Architecture, and Product Key Microsoft Office Version and Product Key (Having trouble with 2010 and 2013 keys) Installed Software with Description, Install Date, and Version Suggestions, criticism, and improvements are welcome. Thank you, FesterJester PC_Audit_Tool.au3