Untuk di registry, kebetulan password tidak saya save di odbc saya,
sehingga tidak terlihat.
Saya coba utak-atik saat istirahat tadi, untuk di accdb dan accde (saya
pake 0ff2007), saya gunakan fungsi berikut:
Public Sub ListQuery(DBFullPath As String)
Dim db As DAO.Database
Set db = Workspaces(0).OpenDatabase(DBFullPath)
Dim qd As DAO.QueryDef
For Each qd In db.QueryDefs
Debug.Print qd.Name
Debug.Print qd.Connect
Next qd
End Sub
hasilnya terlihat dengan pemanggilan listquery
"d:\projects\odbchack.accde", kira2 seperti ini:
listquery "d:\projects\odbchack.accde"
Query1
ODBC;DSN=DataBase;Description=Database on
Server1;UID=sa;PWD=password;DATABASE=DBDEMO
aksan kurdin
Muntahar wrote:
maksudnya ODBC yang dibuat dengan ODBC Data Source Administrator itu
khan pak ?
saya iseng2 cari lewat regedit,
ketik "regedit" pada run
coba explorasi pada ke berikut,
user DSN :
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI
system DSN :
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
aku pake os win7
On Tue, Jan 19, 2010 at 11:40 AM, aksankurdin <[email protected]
<mailto:[email protected]>> wrote:
monggo dibagi cara nge-haknya, mas muntahar .....
biar kita bisa cari solusi alternatif, seperti buat koneksi lewat
vba. beberapa dari kita sudah mengandalkan penggunaan odbc ini
dalam aplikasi access.
aksan kurdin
--- In [email protected]
<mailto:belajar-access%40yahoogroups.com>, Muntahar <eyoun...@...>
wrote:
>
> bisa di hack mas, cuman tergantung orang yang nge hack ...
> :)
> bagaimana kalo bikin koneksi nya melalui VBA? ajah ?
>
> On Tue, Jan 19, 2010 at 11:06 AM, Ivan Leonardo <i...@...> wrote:
>
> >
> >
> > Saya lagi coba buat pass through query ke BE Mysql, waktu create
> > connection di propertiesnya kan ditanya apakah psw mau di
save. Kalau
> > pilih yes apakah nantinya password dsn ini bisa dengan mudah
di hack ?
> >
> > Thanks
> >
> > ----------------------------------------------------------
> > This message contains confidential information and is intended
only for the
> > individual named. If you are not the named addressee you
should not
> > disseminate, distribute or copy this e-mail. Please notify the
sender
> > immediately by e-mail if you have received this e-mail by
mistake and delete
> > this e-mail from your system. E-mail transmission cannot be
guaranteed to be
> > secure or error-free as information could be intercepted,
corrupted, lost,
> > destroyed, arrive late or incomplete, or contain viruses. The
sender
> > therefore does not accept liability for any errors or
omissions in the
> > contents of this message, which arise as a result of e-mail
transmission. If
> > verification is required please request a hard-copy version.
> >
> >
> >
>
>
>
> --
> ---------------------------------------------
> grapyak-semanak-cluthak
> http://djmumun.wordpress.com <http://djmumun.wordpress.com>
> http://facebook.com/djmumun <http://facebook.com/djmumun>
> ---------------------------------------------
>
--
---------------------------------------------
grapyak-semanak-cluthak
http://djmumun.wordpress.com <http://djmumun.wordpress.com>
http://facebook.com/djmumun <http://facebook.com/djmumun>
---------------------------------------------
