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
