Search:

Type: Posts; User: VBExplorer12

Search: Search took 0.04 seconds.

  1. Re: How to validate an INSERT, after Executing

    https://www.ch-werner.de/sqliteodbc/
  2. Re: How to validate an INSERT, after Executing

    Thanks digital,

    That's what I needed.

    Regards,
  3. How to validate an INSERT, after Executing

    Hi,

    I have



    Set cn = CreateObject( "ADODB.Connection" )
    cn.Open "Driver={SQLite3 ODBC Driver};Database=c:\XXXXXXXX\XXXXXX\XXL_XX\MYPRODDB.db;"
  4. Re: What's wrong with this connection string?

    SVC IS the first 3 letters of the service login account. Ddddd2 is my local account.

    At any rate, I got an answer. It woudn't have been possible to do this locally.


    "I did talk to XXXX...
  5. Re: What's wrong with this connection string?

    Yep, I understand techgnome. I thought that maybe the service account credentials were exceptional somehow, especially since the .net version has trusted_connection=true.

    This obviously has to be...
  6. Re: What's wrong with this connection string?

    I also tried RunAs with the script, and it says that the user has not been granted the requested logon type at this computer.

    I also tried the same thing on a remote PC, and got the same result.
  7. Re: What's wrong with this connection string?

    Yep, I know techgnome. I had accidentally copied the double-slash from the .net string.
  8. Re: What's wrong with this connection string?

    No, I'm wrong. It didn't go any further. I put in a double '=' sign in there, and it just took longer to process.

    This one at least tells me the service credentials don't belong there, I guess...
  9. Re: What's wrong with this connection string?

    I'm not sure I have permissions to check the logins directly on the server.

    Anyway, a .net login seems to indicate this is Windows Authentation


    "ConnectionStrings": {
    ...
  10. Re: What's wrong with this connection string?

    Thanks sapator, I tried this approach but it says that "Data source name not found and no default driver specified."


    OptionBase1, you're correct about separating the port with a comma, rather...
  11. Re: What's wrong with this connection string?

    Thanks everyone,

    I think one of my problems is that I don't understand the concept of a Service Account. I tried to look it up on Google, but many of the definitions are circular. I'll try a...
  12. What's wrong with this connection string?

    Hi,

    I'm using a service account, non-windows authentication.




    Set Connection_o = CreateObject("ADODB.Connection")

    ' ConnectionString_s = "Provider=SQLOLEDB;Data ...
  13. Replies
    3
    Views
    1,389

    Re: How to parse this huge html?

    First thought,

    Can you save the html first, then try opening with Excel, and observe?

    You can also search around for 'Convert Html to..." tools, like this one:
    ...
  14. Re: Is Karl Peterson's MConsole Console COM component still available?

    Huh. The mediafire link samples.zip file has everything.

    The tip for transforming the url only works for the Tools software on the site, but not the Samples.
    And the OneDrive link is no longer...
  15. Re: Is Karl Peterson's MConsole Console COM component still available?

    Thanks Carlos,

    But I was already there, as well as some other site. But if you drill down to any of the downloads, they don't lead anywhere.

    Even the Donate button isn't active. I was able...
  16. Is Karl Peterson's MConsole Console COM component still available?

    Hi,

    It looks like Karl is no longer maintaining his site. None of the software links are active.

    I know he's officially retired.

    Does anyone have his MConsole component?
  17. Re: JScript to search for specific outlook emails, and download attachments

    JScript.net version, also based on the original VBScript version:

    Compile:


    @Echo Off

    @Echo Compiling Get_Attachment_from_Email_Dotnet.js

    Rem Release
  18. JScript to search for specific outlook emails, and download attachments

    Hi,

    I just ported this from our VBScript version to Jscript. More for fun, than anything else.



    ' /*
    ' Search for and Download daily email attachment
    ' Get_Attachment_from_Email.wsf...
  19. Re: How to copy a file from a share folder with credentials, WITHOUT mapping a drive?

    Thanks jdc, but none of these posts are using credentials.

    Anyway, I found out that WScript.Network.MapNetWorkDrive( Drive_s, Folder_s, False, User_s, PW_s ) doesn't require an explicit drive. ...
  20. How to copy a file from a share folder with credentials, WITHOUT mapping a drive?

    Hi,

    I'm currently mapping the share folder to a J: drive in a batch file which calls then VBScript. Then FileSystemObject.CopyFile from a subfolder on that J: drive.

    But I'd like to skip the...
  21. Re: Appending to an existing Excel spreadsheet, without Office or Excel installed

    Thanks wqweto, I didn't know Excel had a format with this extension.
  22. Re: Appending to an existing Excel spreadsheet, without Office or Excel installed

    Thanks, Option. I just searched through the Harbour MiniGui distribution, and there's a library there c:\minigui\SAMPLES\Advanced\HbXlsxWriter\libxlsxwriter.dll that seems to have the needed...
  23. Appending to an existing Excel spreadsheet, without Office or Excel installed

    Hi,

    I'm using the Excel.Applications object in VBS, and everything is working perfectly. But I discovered that the server we will put the script on doesn't have Excel, and we're not allowed to...
  24. Re: JScript vs Javascript - error in wsf compilation of Tau-Prolog

    Of course modern Javascript is better in an absolute sense, than the older JScript. But it depends on your development context.

    Modern Javascrsipt isn't an option in the Windows WSH environment,...
  25. Re: JScript vs Javascript - error in wsf compilation of Tau-Prolog

    Yeah, but it works in the context of Javascript applications. It's only JScript that's reporting a problem.

    Anyway, I think I'll scrap Tau-Prolog and try some other Javascript implementations.
    ...
  26. Re: JScript vs Javascript - error in wsf compilation of Tau-Prolog

    Hi Dday9,


    // Threads
    function Thread( session ) {
    this.epoch = Date.now();
    this.session = session;
    this.session.total_threads++;
    this.format_success = session.format_success;...
  27. JScript vs Javascript - error in wsf compilation of Tau-Prolog

    Hi,

    I'm trying to test the compilation - without actually running any of it - of the tau-prolog module, inside of a wsf container.

    The code so far is



    <package>
    <job id="test">
  28. Replies
    2
    Views
    2,302

    Re: What does BTT mean?

    Hi Peter,

    It happens with several Kix components. Unfortunately, I'm not able to get any assistance from the Kix forum. I tried registering, and received the email about waiting for approval, but...
  29. Re: Can the address of a VB Function be used to execute the function in some way?

    Thanks wq,

    I had a problem using the GetRef, when applied to a function. It returned the value of the function, rather than an address.

    At any rate, Eval() is working perfectly.

    Thanks for...
  30. Replies
    2
    Views
    2,302

    What does BTT mean?

    Hi,

    When creating an object from a third party library, CreateObject returns a popup


    VBScript RunTime Error
    This operation is not supported with BTT enabled.


    What does 'BTT...
  31. Re: Can the address of a VB Function be used to execute the function in some way?

    It looks like the answer might be Eval(). Or get the address with GetRef, then Call the variable with parentheses.

    I'll play with those.
  32. Can the address of a VB Function be used to execute the function in some way?

    Hi,

    Outside of an Events context, can the address of a function obtained with GetRef(), be used in a variable which will later be used to execute the function?

    What I'm trying to accomplish is...
  33. Re: WinHttpRequest - errors like 'method cannot be called until open/send has been ca

    Got it. The problem is that the tool that I'm using - VBSedit - requires the temporary command line parameters to be separated by spaces. I had them separated by commas and spaces.

    So the Url_s...
  34. Re: WinHttpRequest - errors like 'method cannot be called until open/send has been ca

    Thanks, wq. I tried enclosing the variable with CVar, but the properties are still empty.

    This has to be the way in which the credentials are being delivered. The Credentials_s parameter with...
  35. WinHttpRequest - errors like 'method cannot be called until open/send has been called

    Hi,

    After both Opening and Sending a request, some of the propertes of a WinHttpRequest are displaying errors.



    On Error Resume Next
    ...
  36. Re: VBScript to get most recent subject headings from specific (not inbox) folder

    Solution:




    Dim objOutlook
    Dim TargetFolder_s
    Dim objNamespace
    Dim colFolders
  37. VBScript to get most recent subject headings from specific (not inbox) folder

    Hi,

    I'm confused about how to get emails from a specific folder. Almost all of the examples on the web, are assuming that you're getting data from either inbox, or a subfolder of inbox.

    The...
  38. Re: VBScript runtime error: ActiveX component can't create object: 'Excel.Application

    krcruz,

    Are you still around? How did you resolve the ActiveX component error? I have Office 2013, Windows 8.1, and receive the same error, when running a VBScript.

    The same VBScript will run...
Results 1 to 38 of 38



Click Here to Expand Forum to Full Width