Re: [tanya-jawab] membuat ODBC MDB di linux

2004-07-14 Terurut Topik Andri Sudarmawijaya 
sorry bukan bikin dns
tapi bikin dsn

On Wednesday 14 July 2004 19:55, Andri Sudarmawijaya wrote:
> kayaknya masalahnya di mdbtool nya
> mdbtools-0.5-115
> mdbtools-odbc-0.5-1
>
> ketahuannya waktu pake
> unixODBC-gui-qt-2.2.9-1
> kalo bikin dns dengan driver selain mdb gak masalah
> tapi kalo bikin dns dengan driver mdb
> ada pesan eror
>
> could not construct a property list for (MDBToolODBC)
>
> ada saran ?
> trims
> andri
>
> On Tuesday 13 July 2004 08:56, Kalpin Erlangga Silaen wrote:
> > Dear Andri,
> > sayang sekali Anda tidak menyebutkan pesan errornya
> > apa saja ? tetapi anda bisa lihat contoh konfigurasi
> > ODBC yang ada di mesin linux yang berjalan dengan baik
> >
> >
> > odbc.ini :
> >
> > [PostgreSQL]
> > Driver  = PostgreSQL
> > Name= PostGre
> > Description =
> > Trace   = No
> > TraceFile   =
> > Database= tes
> > Servername  = 127.0.0.1
> > UserName= postgres
> > Password=
> > Port=
> > Protocol=
> > ReadOnly= Yes
> > RowVersioning   = Yes
> > ShowSystemTables= Yes
> > ShowOidColumn   = Yes
> > FakeOidIndex= Yes
> > ConnSettings=
> >
> > [test]
> > Driver  = MySQL
> > Name= test
> > Description = blah
> > Decription  = blah
> > Server  = 10.1.1.1
> > Port=
> > Socket  =
> > Database= kalpin
> > User= root
> > Password=
> >
> > [karyawan]
> > Driver  = Microsoft SQL Server
> > Name= karyawan
> > Description = mssql
> > Servername  = 10.1.1.55
> > Database= Northwind
> > UID = sa
> > PWD =
> > Port=
> >
> > [MYSQL]
> > Driver  = MySQL
> >
> >
> > odbcinst.ini :
> >
> > # Included in the unixODBC package
> > [PostgreSQL]
> > Description = ODBC for PostgreSQL
> > Driver  = /usr/lib/kalpin/libodbcpsql.so
> > Setup   = /usr/lib/kalpin/libodbcpsqlS.so
> > FileUsage   = 1
> >
> >
> > # From the MyODBC package
> > [MySQL]
> > Description = ODBC for MySQL
> > Driver  = /usr/lib/kalpin/libmyodbc3.so
> > Setup   = /usr/lib/kalpin/libodbcmyS.so
> > FileUsage   = 1
> >
> > [Microsoft SQL Server]
> > Description = ODBC for Microsoft SQL Server
> > Driver  = /usr/lib/kalpin/libtdsodbc.so
> > Setup   = /usr/lib/kalpin/libtdsS.so
> > FileUsage   = 1
> >
> > Semoga membantu
> >
> >
> >
> > Kalpin Erlangga S
> >
> > --- Andri Sudarmawijaya <[EMAIL PROTECTED]> wrote:
> > > saya membuat odbc untuk mengakses file .mdb yang
> > > akan di konfersi ke mysql
> > > tapi selalu ada pesan kesalahan, dulu nya lancar
> > > sebelum ganti server ganti
> > > windows ke fedora 1.
> > >
> > > configurasi apa yang kurang
> > >
> > > ---file odbc.ini---
> > > [absensi]
> > > Description = Microsoft Access
> > > Driver = MDBToolsODBC
> > > Database = /home/files/output.mdb
> > > Servername = localhost
> > > UserName =
> > > Password =
> > > Port = 5432
> > > ---file odbc.ini---
> > >
> > > ---file odbcinst.ini---
> > > [MDBToolsODBC]
> > > Description = MDB Tools ODBC drivers
> > > Driver =  /usr/lib/libmdbodbc.so.0
> > > setup =
> > > FileUsage = 1
> > > CPTimeout =
> > > CPReuse =
> > > ---file odbcinst.ini---
> > >
> > > [EMAIL PROTECTED] andri]$ rpm -qa|grep odbc
> > > postgresql-odbc-7.3-4
> > > mdbtools-odbc-0.5-1
> > > php-odbc-4.3.3-6
> > >
> > > [EMAIL PROTECTED] andri]$ rpm -qa|grep mdb
> > > mdbtools-odbc-0.5-1
> > > mdbtools-gui-0.5-1
> > > mdbtools-0.5-1
> > >
> > > mohon bantuannya, trims
> > > andri
> >
> > __
> > Do you Yahoo!?
> > Yahoo! Mail Address AutoComplete - You start. We finish.
> > http://promotions.yahoo.com/new_mail

-- 
Unsubscribe: kirim email kosong ke [EMAIL PROTECTED]
Arsip dan info di http://linux.or.id/milis.php
FAQ milis http://linux.or.id/faq.php

Re: [tanya-jawab] membuat ODBC MDB di linux

2004-07-14 Terurut Topik Andri Sudarmawijaya 
kayaknya masalahnya di mdbtool nya
mdbtools-0.5-115
mdbtools-odbc-0.5-1

ketahuannya waktu pake 
unixODBC-gui-qt-2.2.9-1
kalo bikin dns dengan driver selain mdb gak masalah
tapi kalo bikin dns dengan driver mdb
ada pesan eror

could not construct a property list for (MDBToolODBC)

ada saran ?
trims
andri

On Tuesday 13 July 2004 08:56, Kalpin Erlangga Silaen wrote:
> Dear Andri,
> sayang sekali Anda tidak menyebutkan pesan errornya
> apa saja ? tetapi anda bisa lihat contoh konfigurasi
> ODBC yang ada di mesin linux yang berjalan dengan baik
>
>
> odbc.ini :
>
> [PostgreSQL]
> Driver  = PostgreSQL
> Name= PostGre
> Description =
> Trace   = No
> TraceFile   =
> Database= tes
> Servername  = 127.0.0.1
> UserName= postgres
> Password=
> Port=
> Protocol=
> ReadOnly= Yes
> RowVersioning   = Yes
> ShowSystemTables= Yes
> ShowOidColumn   = Yes
> FakeOidIndex= Yes
> ConnSettings=
>
> [test]
> Driver  = MySQL
> Name= test
> Description = blah
> Decription  = blah
> Server  = 10.1.1.1
> Port=
> Socket  =
> Database= kalpin
> User= root
> Password=
>
> [karyawan]
> Driver  = Microsoft SQL Server
> Name= karyawan
> Description = mssql
> Servername  = 10.1.1.55
> Database= Northwind
> UID = sa
> PWD =
> Port=
>
> [MYSQL]
> Driver  = MySQL
>
>
> odbcinst.ini :
>
> # Included in the unixODBC package
> [PostgreSQL]
> Description = ODBC for PostgreSQL
> Driver  = /usr/lib/kalpin/libodbcpsql.so
> Setup   = /usr/lib/kalpin/libodbcpsqlS.so
> FileUsage   = 1
>
>
> # From the MyODBC package
> [MySQL]
> Description = ODBC for MySQL
> Driver  = /usr/lib/kalpin/libmyodbc3.so
> Setup   = /usr/lib/kalpin/libodbcmyS.so
> FileUsage   = 1
>
> [Microsoft SQL Server]
> Description = ODBC for Microsoft SQL Server
> Driver  = /usr/lib/kalpin/libtdsodbc.so
> Setup   = /usr/lib/kalpin/libtdsS.so
> FileUsage   = 1
>
> Semoga membantu
>
>
>
> Kalpin Erlangga S
>
> --- Andri Sudarmawijaya <[EMAIL PROTECTED]> wrote:
> > saya membuat odbc untuk mengakses file .mdb yang
> > akan di konfersi ke mysql
> > tapi selalu ada pesan kesalahan, dulu nya lancar
> > sebelum ganti server ganti
> > windows ke fedora 1.
> >
> > configurasi apa yang kurang
> >
> > ---file odbc.ini---
> > [absensi]
> > Description = Microsoft Access
> > Driver = MDBToolsODBC
> > Database = /home/files/output.mdb
> > Servername = localhost
> > UserName =
> > Password =
> > Port = 5432
> > ---file odbc.ini---
> >
> > ---file odbcinst.ini---
> > [MDBToolsODBC]
> > Description = MDB Tools ODBC drivers
> > Driver =  /usr/lib/libmdbodbc.so.0
> > setup =
> > FileUsage = 1
> > CPTimeout =
> > CPReuse =
> > ---file odbcinst.ini---
> >
> > [EMAIL PROTECTED] andri]$ rpm -qa|grep odbc
> > postgresql-odbc-7.3-4
> > mdbtools-odbc-0.5-1
> > php-odbc-4.3.3-6
> >
> > [EMAIL PROTECTED] andri]$ rpm -qa|grep mdb
> > mdbtools-odbc-0.5-1
> > mdbtools-gui-0.5-1
> > mdbtools-0.5-1
> >
> > mohon bantuannya, trims
> > andri
>
> __
> Do you Yahoo!?
> Yahoo! Mail Address AutoComplete - You start. We finish.
> http://promotions.yahoo.com/new_mail

-- 
Unsubscribe: kirim email kosong ke [EMAIL PROTECTED]
Arsip dan info di http://linux.or.id/milis.php
FAQ milis http://linux.or.id/faq.php

Re: [tanya-jawab] membuat ODBC MDB di linux

2004-07-13 Terurut Topik Andri Sudarmawijaya 
sorry
ini pesan erornya
Warning: odbc_do(): SQL error: [unixODBC]Couldn't parse SQL , SQL state 08001 



On Tuesday 13 July 2004 08:56, Kalpin Erlangga Silaen wrote:
> Dear Andri,
> sayang sekali Anda tidak menyebutkan pesan errornya
> apa saja ? tetapi anda bisa lihat contoh konfigurasi
> ODBC yang ada di mesin linux yang berjalan dengan baik
>
>
> odbc.ini :
>
> [PostgreSQL]
> Driver  = PostgreSQL
> Name= PostGre
> Description =
> Trace   = No
> TraceFile   =
> Database= tes
> Servername  = 127.0.0.1
> UserName= postgres
> Password=
> Port=
> Protocol=
> ReadOnly= Yes
> RowVersioning   = Yes
> ShowSystemTables= Yes
> ShowOidColumn   = Yes
> FakeOidIndex= Yes
> ConnSettings=
>
> [test]
> Driver  = MySQL
> Name= test
> Description = blah
> Decription  = blah
> Server  = 10.1.1.1
> Port=
> Socket  =
> Database= kalpin
> User= root
> Password=
>
> [karyawan]
> Driver  = Microsoft SQL Server
> Name= karyawan
> Description = mssql
> Servername  = 10.1.1.55
> Database= Northwind
> UID = sa
> PWD =
> Port=
>
> [MYSQL]
> Driver  = MySQL
>
>
> odbcinst.ini :
>
> # Included in the unixODBC package
> [PostgreSQL]
> Description = ODBC for PostgreSQL
> Driver  = /usr/lib/kalpin/libodbcpsql.so
> Setup   = /usr/lib/kalpin/libodbcpsqlS.so
> FileUsage   = 1
>
>
> # From the MyODBC package
> [MySQL]
> Description = ODBC for MySQL
> Driver  = /usr/lib/kalpin/libmyodbc3.so
> Setup   = /usr/lib/kalpin/libodbcmyS.so
> FileUsage   = 1
>
> [Microsoft SQL Server]
> Description = ODBC for Microsoft SQL Server
> Driver  = /usr/lib/kalpin/libtdsodbc.so
> Setup   = /usr/lib/kalpin/libtdsS.so
> FileUsage   = 1
>
> Semoga membantu
>
>
>
> Kalpin Erlangga S
>
> --- Andri Sudarmawijaya <[EMAIL PROTECTED]> wrote:
> > saya membuat odbc untuk mengakses file .mdb yang
> > akan di konfersi ke mysql
> > tapi selalu ada pesan kesalahan, dulu nya lancar
> > sebelum ganti server ganti
> > windows ke fedora 1.
> >
> > configurasi apa yang kurang
> >
> > ---file odbc.ini---
> > [absensi]
> > Description = Microsoft Access
> > Driver = MDBToolsODBC
> > Database = /home/files/output.mdb
> > Servername = localhost
> > UserName =
> > Password =
> > Port = 5432
> > ---file odbc.ini---
> >
> > ---file odbcinst.ini---
> > [MDBToolsODBC]
> > Description = MDB Tools ODBC drivers
> > Driver =  /usr/lib/libmdbodbc.so.0
> > setup =
> > FileUsage = 1
> > CPTimeout =
> > CPReuse =
> > ---file odbcinst.ini---
> >
> > [EMAIL PROTECTED] andri]$ rpm -qa|grep odbc
> > postgresql-odbc-7.3-4
> > mdbtools-odbc-0.5-1
> > php-odbc-4.3.3-6
> >
> > [EMAIL PROTECTED] andri]$ rpm -qa|grep mdb
> > mdbtools-odbc-0.5-1
> > mdbtools-gui-0.5-1
> > mdbtools-0.5-1
> >
> > mohon bantuannya, trims
> > andri
>
> __
> Do you Yahoo!?
> Yahoo! Mail Address AutoComplete - You start. We finish.
> http://promotions.yahoo.com/new_mail

-- 
Unsubscribe: kirim email kosong ke [EMAIL PROTECTED]
Arsip dan info di http://linux.or.id/milis.php
FAQ milis http://linux.or.id/faq.php

Re: [tanya-jawab] membuat ODBC MDB di linux

2004-07-13 Terurut Topik Moh Dzulkarnaen 
Mungkin user akses di mysql nya belom di register untuk odbc
Rgds
Dzulkarnaen
--
Unsubscribe: kirim email kosong ke [EMAIL PROTECTED]
Arsip dan info di http://linux.or.id/milis.php
FAQ milis http://linux.or.id/faq.php

Re: [tanya-jawab] membuat ODBC MDB di linux

2004-07-13 Terurut Topik Kalpin Erlangga Silaen 
Dear Andri,
sayang sekali Anda tidak menyebutkan pesan errornya
apa saja ? tetapi anda bisa lihat contoh konfigurasi
ODBC yang ada di mesin linux yang berjalan dengan baik
:

odbc.ini :

[PostgreSQL]
Driver  = PostgreSQL
Name= PostGre
Description =
Trace   = No
TraceFile   =
Database= tes
Servername  = 127.0.0.1
UserName= postgres
Password=
Port=
Protocol=
ReadOnly= Yes
RowVersioning   = Yes
ShowSystemTables= Yes
ShowOidColumn   = Yes
FakeOidIndex= Yes
ConnSettings=

[test]
Driver  = MySQL
Name= test
Description = blah
Decription  = blah
Server  = 10.1.1.1
Port=
Socket  =
Database= kalpin
User= root
Password=

[karyawan]
Driver  = Microsoft SQL Server
Name= karyawan
Description = mssql
Servername  = 10.1.1.55
Database= Northwind
UID = sa
PWD =
Port=

[MYSQL]
Driver  = MySQL


odbcinst.ini :

# Included in the unixODBC package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver  = /usr/lib/kalpin/libodbcpsql.so
Setup   = /usr/lib/kalpin/libodbcpsqlS.so
FileUsage   = 1


# From the MyODBC package
[MySQL]
Description = ODBC for MySQL
Driver  = /usr/lib/kalpin/libmyodbc3.so
Setup   = /usr/lib/kalpin/libodbcmyS.so
FileUsage   = 1

[Microsoft SQL Server]
Description = ODBC for Microsoft SQL Server
Driver  = /usr/lib/kalpin/libtdsodbc.so
Setup   = /usr/lib/kalpin/libtdsS.so
FileUsage   = 1

Semoga membantu



Kalpin Erlangga S
--- Andri Sudarmawijaya <[EMAIL PROTECTED]> wrote:
> saya membuat odbc untuk mengakses file .mdb yang
> akan di konfersi ke mysql
> tapi selalu ada pesan kesalahan, dulu nya lancar
> sebelum ganti server ganti 
> windows ke fedora 1.
> 
> configurasi apa yang kurang
> 
> ---file odbc.ini---
> [absensi]
> Description = Microsoft Access
> Driver = MDBToolsODBC
> Database = /home/files/output.mdb
> Servername = localhost
> UserName =
> Password =
> Port = 5432
> ---file odbc.ini---
> 
> ---file odbcinst.ini---
> [MDBToolsODBC]
> Description = MDB Tools ODBC drivers
> Driver =  /usr/lib/libmdbodbc.so.0
> setup =
> FileUsage = 1
> CPTimeout =
> CPReuse =
> ---file odbcinst.ini---
> 
> [EMAIL PROTECTED] andri]$ rpm -qa|grep odbc
> postgresql-odbc-7.3-4
> mdbtools-odbc-0.5-1
> php-odbc-4.3.3-6
> 
> [EMAIL PROTECTED] andri]$ rpm -qa|grep mdb
> mdbtools-odbc-0.5-1
> mdbtools-gui-0.5-1
> mdbtools-0.5-1
> 
> mohon bantuannya, trims
> andri
> 




__
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail 

-- 
Unsubscribe: kirim email kosong ke [EMAIL PROTECTED]
Arsip dan info di http://linux.or.id/milis.php
FAQ milis http://linux.or.id/faq.php

[tanya-jawab] membuat ODBC MDB di linux

2004-07-12 Terurut Topik Andri Sudarmawijaya 
saya membuat odbc untuk mengakses file .mdb yang akan di konfersi ke mysql
tapi selalu ada pesan kesalahan, dulu nya lancar sebelum ganti server ganti 
windows ke fedora 1.

configurasi apa yang kurang

---file odbc.ini---
[absensi]
Description = Microsoft Access
Driver = MDBToolsODBC
Database = /home/files/output.mdb
Servername = localhost
UserName =
Password =
Port = 5432
---file odbc.ini---

---file odbcinst.ini---
[MDBToolsODBC]
Description = MDB Tools ODBC drivers
Driver =  /usr/lib/libmdbodbc.so.0
setup =
FileUsage = 1
CPTimeout =
CPReuse =
---file odbcinst.ini---

[EMAIL PROTECTED] andri]$ rpm -qa|grep odbc
postgresql-odbc-7.3-4
mdbtools-odbc-0.5-1
php-odbc-4.3.3-6

[EMAIL PROTECTED] andri]$ rpm -qa|grep mdb
mdbtools-odbc-0.5-1
mdbtools-gui-0.5-1
mdbtools-0.5-1

mohon bantuannya, trims
andri

-- 
Unsubscribe: kirim email kosong ke [EMAIL PROTECTED]
Arsip dan info di http://linux.or.id/milis.php
FAQ milis http://linux.or.id/faq.php