untuk buat FileDSN pake ODBC biasa pak (udah tau kan) nah nanti kalo FileDSN
nya udah jadi tinggal buka aja pake notepad. nah tinggal bikin dech pake coding
vb untuk, yang isi nya sama dengan fileDSN tadi (maksudnya nanti saat di
jalanin di client program akan generate bikin File DSN tadi) ini contoh coding
nya (saya buat untuk Crystal Report)
Private Sub CreateDSN()
If Dir(App.Path & "\cnReport.dsn") = "" Then
Open App.Path & "\cnReport.dsn" For Output As #1
Print #1, "[ODBC]"
Print #1, "DRIVER=SQL Server"
Print #1, "UID=sa"
Print #1, "Network=DBMSSOCN"
Print #1, "LANGUAGE=us_english"
Print #1, "DATABASE=TGSSIGA"
Print #1, "WSID=JEMY"
Print #1, "APP=Seagate Crystal Reports"
Print #1, "SERVER=SERVER-TGSSI"
Close #1
End If
End Sub
----- Original Message -----
From: rahmat
To: [email protected]
Sent: Thursday, February 21, 2008 9:39 AM
Subject: [indoprog-vb] Re: Mengakses Database Access tanpa setting ODBC di
Control Panel
--- In [email protected], "jontampubolon"
<[EMAIL PROTECTED]> wrote:
>
> Kalau tidak keberatan kira kira bagaimana coding-nya. Misalnya saya
> punya file database MyDB terletak di C:\MyProgram\.
> Mohon bantuannya. Terima kasih.
>
> --- In [email protected], "Kudo, Shinichi"
> <shinichijemy@> wrote:
> >
> > pakenya jgn system DSN pak tapi FileDSN (yg notabenenya sebenernya
> cuma TEXT file) jd bisa di create by Coding VB
[Non-text portions of this message have been removed]
