Execute method (to execute sql command remotely w/ODBC)
Posted on 1999-06-22
I need to run a sql command on a remote database. I've written a program that works ok as long as the user has the sqlnet driver and sqlplus on their client. I would like to eliminate the need for sqlplus. Any ideas how I can use sqlnet/ODBC to execute an sql command on a remote database? Ex command:
'alter user testuser identified by testpw'
How can I execute this remotely on the Oracle db (using ODBC)? Any ideas welcome.
Update to question (additional info):
1) I know ODBC may be used to connect to the remote db. I have the following associated with a command button (for a test):
Dim MyDataBase As Database
Set MyDataBase = OpenDatabase(mtmj, False, False, ODBC)
Dim SQL As String
SQL = "ALTER user testid identified by testpw"
MyDataBase.Execute SQL, dbFailOnError
This code succesfully opens and closes the db. I'm able to login and establish a connection. Unfortunately the sql statement fails. VB returns an error that indicates the 'alter table' command is invalid. Is there an error in my statement? Alter user is not supported? Error with how I open the db? Any help at all is greatly appreciated.
I want to used sqlnet/odbc because they already exist on all of the client machines. I do not want to install another piece of software if at all possible.