Re: creating a database through odbc?
Date: Sat, 21 Jul 2001 21:56:08 GMT
Message-ID: <9gqti7$lv_at_dispatch.concentric.net>
> As long as you are so good hurling insults perhaps you will enlighten the
rest
> of us how you go about creating a schema through an ODBC connection. No
doubt
> demonstrating how to specify tablespaces, storage parameters, create views
and
> sequences, and compile code.
[Quoted] [Quoted] You gotta be kidding, right? Ignoring the fact that the guy did not ask the question you ask of me, I do not see how it is hard to create users/schemas, compile, etc...
Here's a VB snippet:
Dim OracleConn As New Connection
Dim OracleCmd As New Command
Call OracleConn.Open("PROVIDER=MSDASQL;Driver={Oracle ODBC
Driver};UID=a;PWD=a;DBQ=myDSN")
Set OracleCmd.ActiveConnection = OracleConn
OracleCmd.CommandText = "CREATE USER TTT IDENTIFIED BY TTT"
Call OracleCmd.Execute(, , adExecuteNoRecords)
Why is the preceding snippet impossible to implement? You can pass _any_ oracle code/command through the ODBC driver.
I still think your response was extremely bad. Received on Sat Jul 21 2001 - 23:56:08 CEST