Received-SPF: pass (google.com: domain of sentto-8332265-27587-1197037240-toni.rahayu=gmail.com@returns.groups.yahoo.com designates 69.147.64.217 as permitted sender) client-ip=69.147.64.217;
DomainKey-Status: good
Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=lima; d=yahoogroups.com;
	b=iKIUG8J0kcfguonr6aYyyardiQcqXb4GSD3m+hGMll0Zd4Evd5rBb7aaLnChKvyPexA8LCHCABUN7Ku21ZQCiKbHt8WgWObCnWJE0lLi/R+kYi4E81cfF49XQQPUEg52;
To: Programmer-VB@yahoogroups.com
Organization: UNI
In-Reply-To: <C72573AA.0018F952.00@omeweb.omedata.com>
References: <C72573AA.0018F952.00@omeweb.omedata.com>
Message-ID: <op.t2yxw4drstu624@sodik>
User-Agent: Opera Mail/9.02 (Win32)
From: "Sodik Ihwan" <sodik_ihwan@yahoo.com.sg>
Sender: Programmer-VB@yahoogroups.com
MIME-Version: 1.0
Mailing-List: list Programmer-VB@yahoogroups.com; contact Programmer-VB-owner@yahoogroups.com
Precedence: bulk
Date: Fri, 07 Dec 2007 21:16:06 +0700
Subject: Re: [Programmer-VB] ? Koneksi Postgresql pada Vb.6
Reply-To: Programmer-VB@yahoogroups.com
Content-Type: text/plain; charset=iso-8859-15
Content-Transfer-Encoding: 7bit

ya tau lah, selain krn deket trus taun 93 rekan saya dapet tawaran di
company itu tapi dia lebih milih company lain.
btw bukannya koneksi dibawah via ado/oledb, soale saya tdk liat ada dsn
yang biasa dipake odbc.

On Fri, 07 Dec 2007 11:32:46 +0700, Toni Rahayu <toni.rahayu@gmail.com>
wrote:

>
>
> Hallo Kang Sodik,
> Kamu udah install-in pogress odbc plus setting di data source odbc nya  
> gak, kalo
> udah cek lagi nama databasenya di settingan odbc-nya.
>
> Perbedaannya banyak, diantaranya di pogress case sensitif, terus  
> penulisan nama
> filenya harus pake "" contoh "NamaFile" dll.
>
> btw, kang sodik koq tahu abaout kantor saya ? yup... database yang saya  
> pake
> MySQL, Postgress dan oracle ora ono Ms-SQL nya kang.
>
> Rgds
>
>
>
>
>
> "Sodik Ihwan" <sodik_ihwan@yahoo.com.sg> on 12/06/2007 12:13:26 PM
>
>       Please respond to Programmer-VB@yahoogroups.com
>
> To:   Programmer-VB@yahoogroups.com
> cc:    (bcc: Toni Rahayu/IT/domino_srv)
>
> Subject:  Re: [Programmer-VB] ? Koneksi Postgresql pada Vb.6
>
>
>
> Kang saya coba sample dibawah, tapi muncul error sbb:
> Error -2147467259: [Microsoft][ODBC Driver Manager] Data source name not
> found and no default driver specified
> kenapa ya?
> btw untuk SQL Command nya sendiri, perbedaan antara Ms-SQL dan PostGreSQL
> banyak atau tidak, kebetulan saya sedang menjajaki migrasi dari Ms-SQL ke
> PostGreSQL, coz Ms-SQL License nya mahal banget, apalagi CAL nya.
> btw seinget saya dulu kantor Kang Toni juga pake Ms-SQL kan?
> salam,
> sodik
>
> On Thu, 06 Dec 2007 16:36:29 +0700, Toni Rahayu <toni.rahayu@gmail.com>
> wrote:
>
>>
>>
>> Hallo yepai,
>> Coba pake ini :
>>
>> Option Explicit
>> Public PostgresConnection As ADODB.Connection
>>
>> Public Sub Main()
>>     Dim sErrStr As String
>>     On Error GoTo ErrorHandler
>>
>>     Set PostgresConnection = New ADODB.Connection
>>     Set PostgresConnection =
>> Db_Open("DSN=PostgreSQL26;UID=postgres;PWD=YourPassword;Database=ErpDB;")
>>
>>     frmKamu.Show
>>     GoTo ExitHandler
>>     Exit Sub
>>
>> ErrorHandler:
>>     sErrStr = "Error " & Err.Number & ": " & Err.Description
>>     MsgBox sErrStr, vbInformation + vbOKOnly, "frmMDI:Main"
>>
>> ExitHandler:
>>     Exit Sub
>> End Sub
>>
>> Private Function Db_Open(ConnectionString As String) As ADODB.Connection
>>     Dim sErrStr As String
>>
>>     Set Db_Open = New ADODB.Connection
>>
>>     Db_Open.CursorLocation = adUseClient
>>     Db_Open.ConnectionString = ConnectionString
>>     Db_Open.Open
>>
>>     Exit Function
>>
>> ErrorHandler:
>>     sErrStr = "Error " & Err.Number & ": " & Err.Description
>>     MsgBox sErrStr, vbInformation + vbOKOnly, "mdMain:Db_Connect"
>>
>> ExitHandler:
>>     Exit Function
>> End Function
>>
>>
>>
>>
>>
>> "Yepai" <fachrevi78@yahoo.com> on 11/28/2007 08:25:18 AM
>>
>>       Please respond to Programmer-VB@yahoogroups.com
>>
>> To:   Programmer-VB@yahoogroups.com
>> cc:    (bcc: Toni Rahayu/IT/domino_srv)
>>
>> Subject:  [Programmer-VB] ? Koneksi Postgresql pada Vb.6
>>
>>
>>
>> Dulu waktu kursus vb.6 koneksi database yang diajarkan cuma dengan
>> ms.access dan ms.sql server. Gimana yah kalo koneksi dengan postgresql
>> ? ada yang tahu ? sharing.. dong....!!! trim's
>>
>
>
>
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
>
> Send instant messages to your online friends  
> http://asia.messenger.yahoo.com
>
>
> Wahana Programmer Groups Links
>
> Yahoo! Groups Links
>
>
>



-- 
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Send instant messages to your online friends http://asia.messenger.yahoo.com 


Wahana Programmer Groups Links

<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
    http://wahanaprogrammer.net

<*> Untuk menghubungi owner milis ini, kirim email ke:
    wahana.programmer@yahoo.co.id

<*> Konsultasi pemrogramman bisa chat disini:
    Yahoo! Messenger: wahanaprogrammer
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/Programmer-VB/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/Programmer-VB/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:Programmer-VB-digest@yahoogroups.com 
    mailto:Programmer-VB-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    Programmer-VB-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/