Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

Visual Basic.Net and MySql in Scripting Connector
sp_NewPost Add Reply sp_NewTopic Add Topic
April 16, 2019
2:56 pm
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Vic,

You can find an example script for the Scripting Connector in the Scripting Pack on the download page of this website. The script to access a MySQL database is called 'ODBCKeywordLookup' and can be found in the folder 'ConnectorScripts\DatabaseQuery'.

The example script uses ODBC library and not the native MySqlClient library to access the MySQL database.

The scripts in the Scripting pack are only available for C# but the Visual Basic.NET version would be almost the same, only the syntax is slightly different.

Regards, Henk

April 16, 2019
10:56 am
Vic Martin

Hi, everyone.

I don't have much experience using VB.Net, but I have been using VB 6.0 for database programming since time immemorial.

I can't find any good samples of code for accessing Mysql using the scripting connector in Diafaan.

My purpose is this: I need to search the mysql database for an account that uses the mobile number in each received SMS.

sample SQL query:


as A inner join
as B on (A.mobilenum=B.mobilenum) WHERE A.mobilenum=

The Compilation process immediately stumbled upon the following line:

Imports MySql.Data.MySqlClient


Any insights?

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
4 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3928

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502