Hello all,
I have been using the following DO script successfully since you helped me.
clear
odbc load, table("client_data") dsn(DBonServer1) noquote
save "client_data", replace
There is now a new server: Server2. There are two databases on it: database_a and database_b
Unlike DBonServer1 driver, AllDBsonServer2, my new ODBC driver, just refers to the server, not to database_a or database_b.
In my DO script, how do I specify the database for a table?
I tried:
Thanks!
I have been using the following DO script successfully since you helped me.
clear
odbc load, table("client_data") dsn(DBonServer1) noquote
save "client_data", replace
There is now a new server: Server2. There are two databases on it: database_a and database_b
Unlike DBonServer1 driver, AllDBsonServer2, my new ODBC driver, just refers to the server, not to database_a or database_b.
In my DO script, how do I specify the database for a table?
I tried:
odbc load, table("database_a/table1") dsn(AllDBsonServer2) noquoteIt did not work...
and
odbc load, table("database_a\table1") dsn(AllDBsonServer2) noquote
Thanks!
Comment