Re: creating a database through odbc?

From: wayne <no_at_email.please.com>
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

Original text of this message