Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODBC Driver for Oracle Database 10g

AfiaMar 25 2014

Hi All,

How would I connect to MS SQL Server databases from Oracle 10g Database?

I have few databases on MS SQL Server and I would like to make a connection between Oracle 10g db to MS SQL server.

My Database is Oracle 10g on HP-UX OS 11.11

Thanks,

Comments

509983
Thanks Muhammad Waseem Haroon,

I Appreciate your Post. I have studied the material / links provided by you and follwed the steps and successfully implemented it using Nokia 3120.
Using Nokia 3120 its taking only 8 to 10 seconds per SMS.

I think, It will be beneficial for all of us to share the experience regarding this Post.

Thanks.
Ali Samad Khan
507897
This is a nice post and I will definitely try this out. Very nice topic I must say.
530699
Hi,

good stuff

anything for MS Windows?
575142
plz
i floww all steps but give
error
(
SQL> /
Process err :'gnokii' is not recognized as an internal or external command,
Process err :operable program or batch file.

PL/SQL procedure successfully completed.)

what is solution???????????
Satyaki_De
Good post. But, will it work in Windows?

Regards.

Satyaki De.
554938
gr8 work man!!! keep it up
398653
Gnokii can only run for Linux OS as it is defined on Gnokii's website.

You can suppose that Gnokii is an Example and Just Install a software which must be executed by the script for Mobile SMS on any windows or any OS but make sure that the software which you have installed on server side, must be able to be executed by the script then you can implement my above mentioned steps by removing Gnokii commands.

The Java Class & PL/SQL-API which I have recomended named "host" & "host_command" is not only for Linux based Oracle Database Servers, it can be used for Wondows Based Oracle Database Server which I thing is doing a main role.

As you Know, that once the Procedure will be executed successfully on any OS based oracle database server with any SMS Utility, you can execute it on any client as well. It does not matter that whatever the OS is installed there.

Thanks & Regards,
Muhammad Waseem Haroon
m.waseem@emirates.com

Message was edited by:
Waseem Haroon
398653
One of my friend told me about

OZEKI - http://www.ozeki.hu

But I hav'nt tried to send SMS using OZEKI.

Regards,
Muhammad Waseem Haroon
m.waseem@emirates.com
57043
Hi,

I had tried to send SMS message from database to hutch india phone, using demo_mail, but it is not working.

BEGIN
demo_mail.mail( sender => 'emailer@mailing.com',
recipients => '+0982044XXXX@hutch.co.in' ,
subject => 'SMS From Oracle Database Server',
message => 'Hi! This is a test Message.');
END;
/
Kindly tell me where I am going wrong.

thanks & regards
paragjp
Satyaki_De
Thanks for your reply. I've tried the first script provided by you. So far it is showing some transient SMTP error. I'm looking into this. And, thanks for sharing further knowledge with us.

Regards.

Satyaki De.
Satyaki_De
I've a following error message - how to resolve this? Any idea?
ERROR at line 1:
ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 17
ORA-06512: at "SYS.UTL_SMTP", line 96
ORA-06512: at "SYS.UTL_SMTP", line 138
ORA-06512: at "ODSUSER1.DEMO_MAIL", line 205
ORA-06512: at "ODSUSER1.DEMO_MAIL", line 99
ORA-06512: at "ODSUSER1.DEMO_MAIL", line 86
ORA-06512: at line 2
Regards.

Satyaki De.
398653
Hi,

............
.....
00000
BEGIN
demo_mail.mail( sender =>
'emailer@mailing.com',
recipients =>
'+0982044XXXX@hutch.co.in' ,
subject => 'SMS From
Oracle Database Server',
message => 'Hi! This is
a test Message.');
END;
/
....
....
..
If you are trying to send SMS using my 1st option (Using Oracle SMTP Package) then..... first try to send SMS from "hotmail / yahoo / Gmail / Free Account / Any Email account" to your mobile '+0982044XXXX@hutch.co.in', if it is working from there then I am 100% sure that your procedure will run perfectly.

Normaly, Mobile Service Provider does not allow users to send email to mobile phone. I don't Know "hutch" is allowing or not. you have to check it with them.
398653

SMTP Server is required to use UTL_SMTP or Demo_Mail Package. If it is available to you then CUSTOMIZE your Demo_Mail Package Specification.

CREATE OR REPLACE PACKAGE demo_mail IS
   
  ----------------------- Customizable Section -----------------------
   
  -- Customize the SMTP host, port and your domain name below.
  smtp_host   VARCHAR2(256) := 'smtp-server.some-company.com';
  smtp_port   PLS_INTEGER   := 25;
  smtp_domain VARCHAR2(256) := 'some-company.com';
 .. .....
..   .. 
... ....
...  ....

You can use Microsoft Exchange Server, MDaemon and many more SMTP Software Packages for that......... also there are free SMTP Software Packages are available on "Free Downlolad Websites" which you can download.

NicloeiW
Hi,

I also receive the same error message as Satya
ERROR at line 1:
ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 17
ORA-06512: at "SYS.UTL_SMTP", line 96
ORA-06512: at "SYS.UTL_SMTP", line 138
ORA-06512: at "ODSUSER1.DEMO_MAIL", line 205
ORA-06512: at "ODSUSER1.DEMO_MAIL", line 99
ORA-06512: at "ODSUSER1.DEMO_MAIL", line 86
ORA-06512: at line 2
 
could you give us one actual example i really cant understand this,

if i send mail from hotmail then what should be host name, doman name, port etc
Satyaki_De
We are using Lotus notes in our office. So, we can't check what is the microsoft exchange server. Is there any other way - that i can check that one. Or if Lotus notes use any different mail sever - can you say how to view that information? Or, can you give me any link from where i can download those exchange server? Any idea? Thanks in advance for sharing your thought with us.

Regards.

Satyaki De.
57043
Hi,

Regarding my thread , I can send an email to hotmail, yahoo ...etc. But can not send SMS

thanks & regards
paragjp
NicloeiW
did u custmise your package, i cant even send that mails
Satyaki_De
Check your smtp connection.

Regards.

Satyaki De.

N.B: If you have outlook configure you can easily get that one....
NicloeiW
i have outlook configured..but i still cant get,,,could be explain me how ??
Satyaki_De
Right click on the outlook properties and you will get the properties tab and in that you will get the account information and there you will get the incoming mail server and out going server.

Regards.

Satyaki De.
NicloeiW
Thanks, now email is working, but sms NOT may be OP can throw some light
Satyaki_De
Welcome... If you get any solution regarding the sms - pls post that here.

Regards.

Satyaki De.
NicloeiW
sure,,
user517698
hi ,

tk you for sharing the info , will try it ouy


tks & rgds
398653
Please review the checklist (if you have missed any step)

1) Try to Send Email From Oracle (SMTP Package) to Hotmail.
2) Try to Send SMS From Hotmail or Oracle (SMTP Package) or from any Client e.g Outlook or Lotus Notes to Your <Mobile_Number@Service_Prvider_Domain.XXX> to confirm that your mobile service provider is giving you that facility of Emailing 2 SMS or not.

if you are able to send email from oracle to hotmail and you are not able to send send email to your mobile phone then I can not help :) as it is not allowed from your service provider.
398653

We are using Lotus notes in our office. So, we can't
check what is the microsoft exchange server. Is there
any other way - that i can check that one. Or if
Lotus notes use any different mail sever - can you
say how to view that information?

It does'nt matter that which SMTP Server you are using, what you need to ask with your system administrator is about IP Address or Domain Name of your Email Server(of any brand).

You can Ask with your Network or System Adminstrator OR you can Check your Incoming/Outgoing Mail Server IP or Dmain Name.

Also...You must know about....

Global Email Account ID (Which must be able to email to the world) from which you will send email to your mobile phone and then Customize your Package.

You can also define server IP Address in DEMO_MAIL instead of defining domain name in it.

--Customize the SMTP host, port and your domain name below.  
smtp_host   VARCHAR2(256) := '192.168.0.1';
smtp_port   PLS_INTEGER   := 25;
smtp_domain VARCHAR2(256) := 'some-company.com';

Or, can you give me
any link from where i can download those exchange
server? Any idea? Thanks in advance for sharing your
thought with us.

Regards.

Satyaki De.

you can check it on http://www.download.com

Best Regards,
Muhammad Waseem Haroon
m.waseem@emirates.com
Emirates Group I.T - Mercator

Message was edited by:
Waseem Haroon

398653
You are Welcome Dear.

Waseem
Satyaki_De
Thanks for your brief explanation. I'm checking it. I don't think i'll get the port ip address as aresult of security reason.

Regards.

Satyaki De.
579749
how to know my SMTP server name and port number
659031
sir,
i had seen your article
Send Message From Oracle To Mobile Device
u had posted on oracle disscusion forum

sir this mail is reagring a help from ur end
....sir i m an pl/sql developer
working for a coperative banks
sir
now the bank pepoles want to send sms to their customer when they do some transaction
whether it is credited or debited

sir.. bank is using a oracle database to store the information
about all transaction
after every transaction it insert a row in a dotr010 (transaction table)

sir i had developed a standalone software to send sms usning AT commands in VB 6.0
but sir it is not automatically trigger a sms to customer this utility not send sms untill it is not run by bank pepoles

sir i need your help
my nakning software is completely
window based

i need ur help to get know
1. how to communicate GSM modem through oracle (procedure,pl/sql)
2. how the sms is triggered when one row is inserted in a transaction tabel
3. and how to maintain log file

this all only by using oracle no interface

thanks for kind time
i hope you pepole reply soon
i need it

regard
atul
663320
Hi i need help
im using the Oracle Collaboration Suite, but i want create a new drive for send sms, i know that the OCS using class like oracle.panama, but i want create a new one with information of my sms server, someone know about it?, where i can find the code of the oracle.panama or how i can create the drive that i need
please help me...
its very important
702040
Hi,
i have group of applicants who applied for some posts. so, now i want to send sms to all applicants by mobile phone to attend written test. but i have to send sms to mobile phones. how can i send sms to different mobile network providers. please help me out.

Thanks & Regards,
amar
653361
Hello Waseem.
Thanks for your post. Please, I am to implement job schedule which will send an SMS to the DBA upon a trigger from a DML on particular tables.
Please, do I still need the Java stored procedure or I just have to implement the PL/SQL for the jobs and the utl_smtp or utl_mail?
Regards,
726762
Hi,


You can find information about creating this solution on these webpages:

http://www.sms-integration.com/p-42-sms.html (How to send SMS from SQL - including Oracle)
http://www.ozekisms.com/index.php?owpn=392 (SMS Autoreply from database)


Regards,
Altair
qamarsyed
Hi guys,

Here it is :D, I have created my own sms gateway for Oracle Application.

I have created a java bean, which loads any USB connected GSM device in your oracle forms application, it also loads GSM operator automatically you do not need mention it manually.

You only have to insert a message that you want to send in an oracle table with the number to whom you want send sms.

This java bean auto fetch unsend sms from that table every 5 seconds and send it to supplied number.

No additional configuration required.

You can set JDBC url with username and password at run time, and all you need to just press SEND SMS button :) .

And last but not the least, if incoming call coming during sending sms, this java bean auto reject these calls ;)

From Details and order this product please visit my blog: http://qamarsyed.blogspot.com/

cheers

Qamar Abbas
798771
qamarsyed
Well here me again ,

I have developed another stand alone java application to Send SMS from Oracle and SQL Server Databases.


Check it out: http://qamarsyed.blogspot.com/2010/10/java-sms-gateway-for-oracle-sql-server.html



cheers :)



Qamar Syed

Edited by: qamarsyed on Oct 28, 2010 11:37 AM
Adeel Aslam
Hi


Actually i am using windows OS and Working on Oracle Database 10g and i want to send text messages on prepaid as well as postpaid number of any network.
I have created the java class which you recommended for this task on yyour post.But tell me which SMS utility should i install on window to send sms on mobile devices.Because gnokii is for Linux not for window.
So please tell me solution Because i am working on this task for many days but nothing found except you post


Ragards


Adeel Aslam
958726
hi waseem

please explain how to install gnokii in windows xp.


plzzzzzzzzzz!!!!!!!!
1 - 39
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 22 2014
Added on Mar 25 2014
0 comments
1,484 views