|
|
Choosing A Webhost: |
Error at Line : syntax error near exec: msg#00025db.mdb-tools.devel
Dear All! I use unixODBC with mdbtools unixODBC works good, mdbtools works good BUT together... So what can I do? ---unixODBC& MDBTOOLS--- isql -v Cats myuser mypassword [...] SQL> help Error at Line : syntax error near exec [08001][unixODBC]Couldn't parse SQL [ISQL]ERROR: Could not SQLTables ---mdb-tables--- $ mdb-tables /home/user/Acc.mdb Account Types Accounts Reports Transactions ----with MySQL--- isql -v MySQL1 myuser mypassword works great* with MySQL [...] *works great mean SQL>help gives the table names back ################################# INI: /etc/odbc.ini --->8---- [Cats] Description = Microsoft Access Database of Dogs Driver = MDBToolsODBC Trace = No TraceFile = Database = /home/user/Acc.mdb Servername = 192.168.2.234 UserName = myuser Password = mypassword Port = 5432 [MySQL1] Description = MySQL test database Driver = MySQL Trace = No TraceFile = Servername = 192.168.2.234 UserName = myuser Password = mypassword PORT = 3306 Database = test --->8--- /etc/odbcinst.ini --->8--- [MySQL] Description = Myodbc driver for MySQL Driver = /usr/local/lib/libmyodbc3.so Setup = /usr/local/lib/libmyodbc3S.so [Default] Driver = /usr/local/lib/libmdbodbc.so.0 FileUsage = 1 UsageCount = 2 [MDBToolsODBC] Description = MDB Tools ODBC drivers Driver = /usr/local/lib/libmdbodbc.so.0 Setup = FileUsage = 1 CPTimeout = CPReuse = Driver = /usr/lib/libmyodbc3.so UsageCount = 1 --->8--- CONFIGURED: ===================================================== /mdbtools-0.6pre1$ ./configure --with-unixodbc=/usr/local make; su -c "make install" [...] Libraries have been installed in: /usr/local/lib ==================================================== /unixODBC-2.2.11$ ./configure --sysconfdir=/etc --enable-gui=no --enable-shared --with-odbc --with-msql-lib make; su -c "make install" [...] Libraries have been installed in: /usr/local/lib ==================================================== TABLE SOURCE kexi-project.org/download/tests/msa_templates.tar.gz ~5MB there is 'Accounts ledger.mdb' in it ------------------------------------------------------- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | mdb-sql and Whitespace in Column Names, Nathan Olberding |
|---|---|
| Next by Date: | Re: Error at Line : syntax error near exec, Jeff Smith |
| Previous by Thread: | mdb-sql and Whitespace in Column Names, Nathan Olberding |
| Next by Thread: | Re: Error at Line : syntax error near exec, Jeff Smith |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |