The setLogonInfo method takes in the DSN name, the database name, userid and password. For instance,
crtable.SetLogonInfo "Pubs Sample Database", "pubs", cstr(userid), cstr(password)
When I develop a report based on the titles table of the pubs database, I choose the ODBC pointing to the Pubs Sample Database and Pubs database. I then strip off the pubs.dbo
Now when I mention a different value in the setlongoninfo method - say
crtable.SetLogonInfo "Pub Test", "Pubs_Duplicate", cstr(userid), cstr(password)
I cannot view any information in the report because it originally points to the ODBC - "Pubs Sample Database".
So how can strip off the ODBC name from the report as well other than the pubs.dbo ? Though the databases are different, the tables, its fields and the views are the same.
Hope to hear a solution for this.