Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming connect is required, the following 39 results were found.

  1. Connect to Joomla database in standalone scripthttps://joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

    Joomla versions 1.6.x to 2.5.x. Because I use dynamic scripts running in the background (mootools), some of these need to connect to the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  2. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    been looking into this for a friend and going through forums to investigate this error. After you've checked your database connection details, I find what FisherC said below is the most probable cause for the error. FisherC says: I have the same...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  3. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

    problem of backing up your MySQL database when attempting to "Data Export" using MySQL Workbench. This is not regarding the connection issue as I can connect to my database using MySQL Workbench (I have enabled the old authentication protocol). The...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  4. ZohoCreator: Basic Widget with Zoho Datahttps://joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

    via API. No need for the Zoho Widget SDK. Why? At time of print, I felt the documentation was a little sparse on how to connect a JS widget to the data held in Zoho Creator. Having this example for future use might save me some time. The following is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Connection Strings for SQL Serverhttps://joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

    Connectors from dev.MySQL.com MySQL Connector/Net Type: .NET Framework Class Library Usage: MySql.Data.MySqlClient.MySqlConnection Manufacturer: MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default port is...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  6. ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

    So this is an article expanding on my article Zoho Deluge - Connect to Xero API and explores how instead of a schedule, we can get Xero to tell ZohoCRM whenever an invoice or contact gets updated in Xero. Why? I used to use ZohoCRM schedules to pull...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    I tried the SQL Server Management Studio solution to connect to a MySQL database then lost my way wondering what was I trying to achieve? I've written this article because this is how I connected to a MySQL database from within the Business Intelligence...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  8. Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

    event: Code: ; AutoHotkey_L: pwb := ComObjCreate( "InternetExplorer.Application" ) pwb.Visible := True ComObjConnect( pwb, "IE_" ), loading = 1 ; Connect IE object & set var "loading" as TRUE pwb.Navigate( "www.AutoHotkey.com" ) While, loading Sleep, 10...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  9. Display Feeds to major Social Networkshttps://joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

    fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) {return;} js = d.createElement(s); js.id = id; js.src = "//connect.facebook.net/en_US/sdk.js"; fjs.parentNode.insertBefore(js, fjs); }(document, 'script', 'facebook-jssdk')); (function(d, s,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  10. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

    purposes you should leave this next variable as an empty string. If you leave this blank, the script will run through and connect to Google Drive using the Service Account. The script will work without being authorized, it just won't see any files other...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  11. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

    field called "Email" Return to the Context Handler Function IDE (page where you enter the deluge code): Click on "Manage Connections" Click on Create Connection Select Service "Zoho OAuth" Give it a name, I'm calling mine "ChatGPT CRM" Untick "Use...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Create Read-Only Database User in SQL Serverhttps://joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

    how to setup a database user with read-only access to the AdventureWorks database. Using SQL Server Management Studio 2008: Connect to your database server. Expand Security > Logins. Right-click on the user who will be set as having read-only access (in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  13. Passwords: Did-you-knowhttps://joellipman.com/hardware/passwords-did-you-know.html

    the majority of webmail and email programs; passwords in remote desktop sessions; and any wifi keys used in your wireless connections. All the software can run off a USB key needing only a few seconds to connect to your computer and to automatically...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  14. Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    the SQL against your new database Open your favorite database management tool (phpMyAdmin, workBench, navicat, sqlyog?) and connect to the new database. This script will use both databases, reading from the old Joomla database and writing to the new...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  15. Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

    generally change their website design everyday... It's 100% FREE Open Source, (well as long as you have your own internet connection) mainly because it's not just my code. I simply combined three technologies into one: Basic Website browser (in its own...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  16. SSRS Redirect after a report is runhttps://joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

    decision. Time spent on trying to find a solution was not considered to be warranted. My reports use a parameter for the connection string to specify which server and database to connect to and the follow on link was enough as a solution. My seniors...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  17. MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    > Data Sources (ODBC) > System DSN (get technical help if you don't know how to do this)... Open Excel 2007 > New > "Blank" Connect to data source: > Data tab > From Other Sources > From Microsoft Query > select Data Source Specify SQL Query: > Add...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  18. Joes DNS Correction (JDC)https://joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

    had this? Your colleagues are connecting fine and your IT service desk say everything is functioning normally and it's just YOU! Script Function If you are on a network that frequently loses connection or simply forgets what intranet site you were...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  19. How to change local folder for TFShttps://joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

    I installed Business Intelligence Development Studio 2008 (BIDS) and connected it to a Team Foundation Server 2010 (TFS) instance and set my working local folder to my home directory. When the rest of my colleagues installed it however, they decided to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Team Foundation Server
    • Language: *
  20. Sync Outlook 2007 Shared Calendar with SharePoint 2007https://joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

    2007 Using MS Internet Explorer (demo below is version 8), bring up your SharePoint Calendar Click on Actions Select Connect to Outlook Allow the website to open a program on your computer (opens Outlook). Confirm the prompt your Outlook instance...

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *
Results 1 - 20 of 39

Please publish modules in offcanvas position.