Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

VBScript update Oracle XE

481060Jan 12 2006 — edited Jan 13 2006
VERY new here. I am working on cenverting a VBScript/MySQL script to oracle. I plan to use the vbscript to place data into an oracle express 10g database.

I used migration workbench to migrate the schema from MySQL to Oracle Express. This went well. I can see all the tables, triggers and sequences. I guess because the the MySQL database ran in a root context, the Oracle schema is called 'ROOT'. I dont care, its fine.

I created a DSN on my XP/SP2 machine:
Data Source Name: Winventory_Ora
Description: Winventory_Ora
TNS Service Name: XE_FC3_ORA
User ID: root
Test of the connection is successfull after providing password.
tnsnames.ora contains service name indicated.

Here is my connection string in the script:
conn = "Driver={Oracle in XE};Dsn=Winventory_Ora;Uid=system;Pwd=xxxxxx;"
database.open conn

Note above that I can't connect with a username of 'ROOT' in the connect string. That produces:
C:\dloads\winvent8\winventory\scripts\audit.vbs(337, 4) Microsoft OLE DB Provide
r for ODBC Drivers: [Oracle][ODBC][Ora]ORA-01017: invalid username/password; log
on denied

Does this seem to be correct so far? I cant write data using the string below:
sql = "INSERT INTO root.network_card (NET_ID, NET_MAC_ADDRESS) VALUES ('35', '00:0B:CD:5A:47:A2')"
database.execute sql

Am I on the right track here? Data never ends up in the oracle database!

Thanks in advance

-mwm
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2006
Added on Jan 12 2006
1 comment
872 views