Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

sp_TopicIcon
Visual Basic.Net and MySql in Scripting Connector
sp_NewPost Add Reply sp_NewTopic Add Topic
April 16, 2019
2:56 pm
Henk Helmantel
Admin
Forum Posts: 1008
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
Guest
Guests

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 VB.net 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:

SELECT A.ACCOUNTNO from

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: 494

Currently Online:
4 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 519

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 815

Posts: 2818

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1008