obj.Open does not work in Teradata
Do you happen to know why can I open a MS Access table by using obj.Open but cannot do the same for Teradata?
Below, the command used:
obj.ActiveConnection = <conn string>
obj.CursorType = adOpenKeyset
obj.CursorType = adOpenDynamic
obj.LockType = adLockOptimistic
obj.Source = <tablename>
Are something different between them?
Please, let me know your thoughts.
Thanks in advance, Fernando.
Re: obj.Open does not work in Teradata
May be your connection string is wrong.
Look at www.connectionstrings.com