How to connection oracle odbc and gammu

[Tri Cahyo Hari Kurniadi]

Dear Mr. Michal

Thank very much for attention, my name is cahyo from indonesia, i am
any Question about GAMMU Configuration, How to connection oracle odbc
and gammu, i want use odbc backend to change native mysql. i have set
connection odbc to connection with oracle odbc like in tutorial

Service = sql
driver = odbc
host = odbc_name
user = cahyo
password = cahyo

after that i check with gammu-smsd -c smsdrc and i get error
1. SQLExecDirect Failed, code = -1, HY000:1:933:[ORACLE][ODBC][ORA]
ORA-00933:SQL command not properly.
2. table outbox not found, disconecting.

Thanks very much Mr. Michal GAMMU IS VERY HELPFUL


Best Regard
Tri Cahyo H.K

[gilberto dos santos alves]

hi. first see that your odbc is working ok, make one test using bash or
python script to make sure that your environment is ok. please post more
information about your environment and oracle version that you use.

Post by Tri Cahyo Hari Kurniadi
Dear Mr. Michal
Thank very much for attention, my name is cahyo from indonesia, i am
any Question about GAMMU Configuration, How to connection oracle odbc
and gammu, i want use odbc backend to change native mysql. i have set
connection odbc to connection with oracle odbc like in tutorial
Service = sql
driver = odbc
host = odbc_name
user = cahyo
password = cahyo
after that i check with gammu-smsd -c smsdrc and i get error
1. SQLExecDirect Failed, code = -1, HY000:1:933:[ORACLE][ODBC][ORA]
ORA-00933:SQL command not properly.
2. table outbox not found, disconecting.
Thanks very much Mr. Michal GAMMU IS VERY HELPFUL
Best Regard
Tri Cahyo H.K
------------------------------------------------------------
------------------
_______________________________________________
Gammu-users mailing list - https://lists.sourceforge.net/
lists/listinfo/gammu-users

[Tri Cahyo Hari Kurniadi]

Thank very much mr alberto for attention .
my odbc is working OK. because I have testing, my environment
1. Windows 10 64 bit
2. Oracle 11g XE

Post by gilberto dos santos alves
hi. first see that your odbc is working ok, make one test using bash or
python script to make sure that your environment is ok. please post more
information about your environment and oracle version that you use.

Post by Tri Cahyo Hari Kurniadi
Dear Mr. Michal
Thank very much for attention, my name is cahyo from indonesia, i am
any Question about GAMMU Configuration, How to connection oracle odbc
and gammu, i want use odbc backend to change native mysql. i have set
connection odbc to connection with oracle odbc like in tutorial
Service = sql
driver = odbc
host = odbc_name
user = cahyo
password = cahyo
after that i check with gammu-smsd -c smsdrc and i get error
1. SQLExecDirect Failed, code = -1, HY000:1:933:[ORACLE][ODBC][ORA]
ORA-00933:SQL command not properly.
2. table outbox not found, disconecting.
Thanks very much Mr. Michal GAMMU IS VERY HELPFUL
Best Regard
Tri Cahyo H.K
------------------------------------------------------------
------------------
_______________________________________________
Gammu-users mailing list - https://lists.sourceforge.net/
lists/listinfo/gammu-users

--
gilberto dos santos alves
[phone]
sao paulo - sp - brasil

[Michal Čihař]

Hi

Post by Tri Cahyo Hari Kurniadi
Dear Mr. Michal
Thank very much for attention, my name is cahyo from indonesia, i am
any Question about GAMMU Configuration, How to connection oracle odbc
and gammu, i want use odbc backend to change native mysql. i have set
connection odbc to connection with oracle odbc like in tutorial
Service = sql
driver = odbc
host = odbc_name
user = cahyo
password = cahyo
after that i check with gammu-smsd -c smsdrc and i get error
1. SQLExecDirect Failed, code = -1, HY000:1:933:[ORACLE][ODBC][ORA]
ORA-00933:SQL command not properly.
2. table outbox not found, disconecting.

Have you created the tables in the database? This has to be done
manually, see 
https://wammu.eu/docs/manual/smsd/odbc.html#creating-tables

Also you can enable more verbose logging to see what went wrong in more
details, see https://wammu.eu/support/bugs/

[Tri Cahyo Hari Kurniadi]

I have verbose logging at https://wammu.eu/support/bugs/ , maybe that
helpul to problem analysis.
Gammu is better

Hi

I have create table like this
https://wammu.eu/docs/manual/smsd/odbc.html#creating-tables because i
import from mysql to oracle with navicat. Maybe  dependence with type
data or other something. my environment windows 10 64 bit, and oracle
11g XE. How to solution my problem

It can be many problems, enable verbose logging as described on
 https://wammu.eu/support/bugs/ and show us the log. It might be that
the SQL queries we use are not compatible with Oracle and you might
have to override them.
Also you might want to try more up to date Gammu version which can be
https://ci.appveyor.com/project/nijel/gammu/build/185/job/0cdf50urru37l
7ws/artifacts
https://ci.appveyor.com/project/nijel/gammu/build/185/job/61u1dqaj44xks
wt9/artifacts
--
Michal Čihař | https://cihar.com/ | https://weblate.org/