Subject Re: Connection string in ADODatabase
From Akshat Kapoor <akshat.kapoor@kapoorsons.in>
Date Tue, 27 Oct 2020 13:43:50 +0530
Newsgroups dbase.getting-started

Good Afternoon Gaetano,

Yes with minor changes this worked.

> msgbox(_app.inifile)
> d = new adodatabase()
> d.databasename="ADOinINI"
> d.active = true
> q = new adoquery()
> q.databasename = d

q.database = d

> q.sql = "select * from sales20"
> q.active = true
> msgbox("number of records: "+q.rowset.count())
> q.active = false
> d.active=false

>>> PORT=3307"

port = 3306

But apart from these 2 minor your code works flawlessly.

But I would say damn difficult to implement.
Because usually we do not know the server name and expecting the end
user to change it and make no other changes is expecting too much.

Regards
Akshat