Leaderboard

I want to present BETA Version of my ADO.au3 UDF. This is modifed version of _sql.au3 UDF. For that I want to thanks : ; Chris Lambert, eltorro, Elias Assad Neto, CarlH This is first public release , and still is as BETA DOWNLOAD LINK (in download section): Have fun, mLipok EDIT: 2016-06-03 Below some interesting topics about databases: EDIT 2016/07/04: For more info about ADO look here: https://www.autoitscript.com/wiki/ADO FOR EXAMPLE DATABASE use AdventureWorksDW2016_EXT.bak from: https://github.com/microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksDW2016_EXT.bak I will relay on this database in my examples. Here is link to post which shows how "ODBC Data Source Administrator" looks like.

You said that the response after your upload request was: The documentation says that you should upload the file to the upload_url from the response. Correct me if I'm wrong, but that should be https://upload.pushbullet.com/upload-legacy/CvQ0yPe8pgxxxxxxxxsm5ZJ What am I reading wrong?

Thank you again for all the feedback. mikell, You are welcome. kcvinu, I'm working on a UDF with listviews and custom draw notifications where I'm trying to use subclassing as a replacement of a message handler created with GUIRegisterMsg. I could help you a little bit with an alternative solution, but your question also gave me an opportunity to launch this idea. So far I'll recommend you to use GUIRegisterMsg. One thing is small pieces of test code with ConsoleWrite statements. They usually work. A complete UDF is another thing. I probably need 2 - 3 weeks to finish first version. Then we'll see if it works. Regards Lars.

Hi ElChaca, You have added a trailing backslash to both FileInstall destination path and $sfldr1 variable.

This will install it and save it to the registry so it won't be removed on startup. Honestly though I've used _WinAPI_AddFontResourceEX in a program I made that I used frequently (close and restart) and there was never any problem or delay to install the three custom fonts I used. Don't know if you're worried about the overhead or the processing speed but when you're just working with small files (my .ttf files were 12kb, 22kb, and 324kb) and checking checking (not accessing) a lot of files, almost all, modern, machines can do the processing without any any noticeable delay. #include <WinAPIGdi.au3> #include <Array.au3> Local $timer_init = TimerInit() Local $font_families = _WinAPI_EnumFontFamilies() Local $time_enum_font_families = TimerDiff($timer_init) / 1000 & "s" $timer_init = TimerInit() Local $font_installed = _ArraySearch($font_families, "Futura", 0, 0, 0, 1) Local $time_array_search = TimerDiff($timer_init) / 1000 & "s" Local $time_font_install = 0 If ($font_installed = -1) Then $timer_init = TimerInit() _WinAPI_AddFontResourceEx("Futura Extra Bold.ttf", $FR_PRIVATE) $time_font_install = TimerDiff($timer_init) / 1000 & "s" EndIf MsgBox("", "Time", "Time to enum font families: " & $time_enum_font_families & @CRLF & _ "Time to search through (" & $font_families[0][0] & ") font families: " & $time_array_search & @CRLF & _ "Time to add font resource: " & $time_font_install) Time to enum font families: 0.210863995560568s Time to search through (1672) font families: 0.0302487330923837s Time to add font resource: 0.00023872755105527s It would probably be more efficient to just always install your font on startup, save yourself roughly 1/4 - 1/5 of a second.

here is next example: #include <MsgBoxConstants.au3> #include <AutoItConstants.au3> #include <array.au3> #include <ie.au3> #include <WinAPIProc.au3> _IEErrorHandlerRegister(_ErrFunc) _Example() Func _Example() Local $iPID = Run(@ProgramFilesDir & "\Internet Explorer\iexplore.exe about:blank1-2 -noframemerging -private") Local $hwnd = 0 Local $oIE ConsoleWrite('$iPID = ' & $iPID & @CRLF) While 1 $hwnd = _WinAPI_EnumProcessWindows($iPID, False) If @error = 0 Then $hwnd = $hwnd[1][0] ConsoleWrite('$hwnd = ' & $hwnd & @CRLF) $oIE = _IEAttach($hwnd, 'hwnd') _IENavigate($oIE, "google.com") If Not @error Then ExitLoop EndIf Sleep(100) WEnd EndFunc ;==>_Example But something sill is not working fine. I'm tired, going sleep (02:00 AM)

Which MySQL provider you want to use ?

Hmmm... Strange. This follownig snippet should work: RegWrite('HKEY_CURRENT_USER\SOFTWARE\Microsoft\Internet Explorer\Main','SessionMerging','REG_DWORD','00000001') Run('"C:\Program Files (x86)\Internet Explorer\iexplore.exe" -nosessionmerging -private https://www.autoitscript.com/forum') https://msdn.microsoft.com/library/hh826025(v=vs.85).aspx ‑nosessionmerging Internet Explorer 8 and later versions. Internet Explorer 8 and later versions. Prevents Internet Explorer from merging tab processes and thus sharing session cookies across tabs. Even if you have the –framemerging feature turned on (which it is by default; see above), specifying this option will isolate your tabs into separate processes and prevent session sharing, even if those tabs are associated with the same frame process. You can also set this option via registry key: HKEY_CURRENT_USER SOFTWARE Microsoft Internet Explorer Main SessionMerging (DWORD) 00000000 The feature is enabled when the value is set to (DWORD) 00000001 and disabled when the value is (DWORD) 00000000. By default, it is enabled. For more info, see Session management within Internet Explorer 8.0, Session Cookies, sessionStorage, and IE8, and Understanding Session Lifetime. but ...... here: https://blogs.msdn.microsoft.com/ie/2009/05/06/session-cookies-sessionstorage-and-ie8-or-how-can-i-log-into-two-webmail-accounts-at-the-same-time/ IELaunchURL function: https://msdn.microsoft.com/en-us/library/aa767962(VS.85).aspx

But first you should check for provider name. use _ADO_OLEDBProvidersList() from here: https://www.autoitscript.com/wiki/ADO_Tools

You can try here:

Or in the registry : HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Fonts

Just check for c:\Windows\Fonts\

IE Command-Line Options https://msdn.microsoft.com/en-us/library/hh826025(v=vs.85).aspx

This script will send an Outlook email but will ask for a confirmation: CreateMailItem() Func CreateMailItem() Local $olMailItem = 0 Local $olFormatRichText = 3 Local $olImportanceLow = 0 Local $olImportanceNormal= 1 Local $olImportanceHigh = 2 $oOApp = ObjCreate("Outlook.Application") $oOMail = $oOApp.CreateItem($olMailItem) With $oOMail .To = ("to@domain.com") .Subject = "email subject" .BodyFormat = $olFormatRichText .Importance = $olImportanceHigh .Body = "email message" .Display .Send EndWith EndFunc I vaguely remember that only outlookexpress has an option to suppress this warning thanks to the "i love you virus" that broke out on May 4 2000. (Still remember that one like it was yesterday )