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
