Support forum

Home Support forum Using Diafaan SMS Server Visual Basic.Net and MySql in Scrip…

Visual Basic.Net and MySql in Scripting Connector

Add Reply

Add Topic

April 16, 2019
2:56 pm

Henk Helmantel

Admin

Forum Posts: 1488

Member Since:
May 28, 2013

Offline

Quote

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

Quote

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?

Add Reply

Add Topic

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
4 Guest(s)

Currently Browsing this Page:
1 Guest(s)