Re: creating a database through odbc?

It would be even easier to use ODBC to export the data from Access to an Oracle instance..I assume from the second part of the original question ( "else, I need a way of importing a simle file into oracle") that there is at least one existing Oracle instance he could use..
( Caveat : Keep Table names and Column names in UPPER CASE and avoid MEMO fields in Access..)

"Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote:

>wayne wrote:
>
>> > 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.
>>
>> 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.
>
>No reason I know why you couldn't do what you wrote above. But perhaps you have
>forgotten the original post. Let me quote it again here.
>
>"not knowing that much about oracle, is it possible to create a file in excel or
>access and put it into oracle through odbc?"
>
>The person posting made specific reference to Excell and Access ... not VB. He
>also said:
>
>"I need a quick oracle database to test an app..."
>
>I would hardly call your solution quick. Would you?
>
>Then he concluded: "else, I need a way of importing a simle file into oracle"
>
>Seems to me it would be substantially easier to run SQL*Loader than to start
>banging out VB in Excell.
>
>Daniel A. Morgan

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Sat Jul 21 2001 - 23:56:34 CEST