VBScript update Oracle XE
481060Jan 12 2006 — edited Jan 13 2006VERY 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