| Connecting VB to a database created with SQL Developer [message #249779] |
Thu, 05 July 2007 19:18  |
gorkonyan
Messages: 3
Registered: July 2007
|
Junior Member |
|
|
Hello,
If I use Sql Developer to create a database in Oracle, is it possible to connect through Data Environment from Visual Basic to that database?
Basicly I want to connect Visual Basic to a database in Oracle. The problem is that I don't know where the database is created by the SQL Developer (I can't find any xyz.sql file) to have the path for Visual Basic. Sorry for being such a newbie and asking for such a "how to". Any help is welcomed.
[Updated on: Thu, 05 July 2007 19:18] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Connecting VB to a database created with SQL Developer [message #249833 is a reply to message #249779] |
Fri, 06 July 2007 01:50  |
gorkonyan
Messages: 3
Registered: July 2007
|
Junior Member |
|
|
I know I can use ADO, OLE DB, ODBC and so on, but the problem is that if I want to connect the forms created in VB I need the path to a .sql, I don't know where these .sql files are created by SQL Developer, if they are created. Or should I create by myself the create.sql, insert.sql and so on? And after that to connect SQL Developer to that data base?
Is it possible to export the tables as .sql ? I can see that the inserts can be exported (mytable.sql in witch is the insert into...) but can you export something like mytable.sql in witch you actually create the table (create table mytable ...)?
Thanks
[Updated on: Fri, 06 July 2007 02:14] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
