Visual Basic Code , VB.NET Code, VB Code
  Home   :  Code   :  Forums   :  Submit   :  Mailing List   :  About   :  Contact
A1VBCode Forums
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      

Home » Classic Visual Basic (VB 6 or earlier) » Database Programming » problem in the connection of Oracle DataBase


problem in the connection of Oracle DataBaseExpand / Collapse
Author
Message
Posted 4/27/2011 4:07:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 4/28/2011 4:42:40 AM
Posts: 2, Visits: 12
Hi ,
i have visual basic6 application, and i instaled it as setup on the client

this application should connect remotely via a network with oracle database
put on another device
i used this connection string :

If oconn.State = 1 Then oconn.Close
oconn.Open "Provider=msdaora;Data Source=orcl;User Id=FIN;Password=FIN;"

i have this error in the image attached

so ...please help me to solve this problem
or
what i need to download (tools,provider)
to let vb application to connect to oracle database remotely

thankx 4 all



With My Best Wishes For All
Online MSN : Hassanoracle@hotmail.com
Hassan

  Post Attachments 
error.jpg (235 views, 20.24 KB)
Post #30338
Posted 4/27/2011 1:39:35 PM


Forum God

Forum God

Group: Moderators
Last Login: 5/16/2012 8:37:42 AM
Posts: 1,891, Visits: 5,293
Welcome to A1vbcode hassaco. 

I don't know the language in that error.log but you've written here in English can you translate?

Are you trying to install on a 64bit system? 

Keith

I've been programming with VB for 17 years. Started with VB4 16bit Pro, VB5 Pro, VB6 Pro/Enterprise and now VB3 Pro. But I'm no expert, I'm still learning.
Post #30339
Posted 4/28/2011 2:56:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 4/28/2011 4:42:40 AM
Posts: 2, Visits: 12
Hi Keithuk,

Thank you for u r reply
i am sorry for latting ,and sorry because the message of error not in English unintentionally.
i attached you new file with English language

What i need : what i should install (provider or tools or files) in the client device
which has vb6 application to connect with oracle remotely.

thank you very much...



With My Best Wishes For All
Online MSN : Hassanoracle@hotmail.com
Hassan

  Post Attachments 
error1.JPG (251 views, 23.23 KB)
Post #30340
Posted 4/28/2011 4:02:42 PM


Forum God

Forum God

Group: Moderators
Last Login: 5/16/2012 8:37:42 AM
Posts: 1,891, Visits: 5,293
Well it looks like your installer didn't install the necessary files to use the Oracle database.

Which installer did you use not P & D Wizard? You would be better of using Inno Setup its free.


Keith

I've been programming with VB for 17 years. Started with VB4 16bit Pro, VB5 Pro, VB6 Pro/Enterprise and now VB3 Pro. But I'm no expert, I'm still learning.
Post #30341
Posted 10/14/2011 3:05:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 10/14/2011 2:53:28 PM
Posts: 3, Visits: 3
I don't know the language in that error.log but you've written here in English can you translate?

Are you trying to install on a 64bit system?
Post #30786
Posted 10/31/2011 7:37:58 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 10/31/2011 8:47:18 AM
Posts: 7, Visits: 5
Are you connecting your database connection through GUI basis or through typing query. If typing query I suggest to check for GUI basis and test the connection it will help you connect database.

Android Application Development | Android Application Developer | Web Development Firm
Post #30844
Posted 4/18/2012 10:34:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 4/18/2012 10:31:16 PM
Posts: 2, Visits: 2
I do not know the language in the error.log, but written in English, where you can translate?

wholesale oil painting
Post #31379
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 1 (1 guest, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Admin, Mod, Mark, Keithuk

PermissionsExpand / Collapse

All times are GMT -5:00, Time now is 2:10am