• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Mysql JDBC and Database links

 
Robert Spero
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am having a real hard time understand this! I have an oracle db and a mssql db that i am using stored proc to get the data i need. I want to create a web interface and access the stored proc. Here is where i have spent an entire day, i want to migrate my mSsql to mYsql. In ms it is straight forward to do an openquery method but with mysql i can not even link the database. In a situation like this how can i link my oracle db to mysql as a simple view or to pass parameters. I do not have rights to create these proc on the oracle db but i can query all day long. thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic