It works well. But we got another ms-user and I created new database link:
create database link old_link connect to old_user identified by 123 using 'my_sid';
Everything is the same, except user name. New link works. It does not generate any errors. But instead datetime columns it shows something like '? ; 9/D8@'. Other columns are correct.
create database link new_link connect to new_user identified by 123 using 'my_sid';
Are you saying that old_user can select the datetime column successfully but the new_user gets the wrong result ?Yes, this is correct.
Are they bot selecting fromthe same table ? What is the SSQL*Server create statement for the table in the select ?They bouth select from the same table.
create table ##R_temp (dttm_column datetime)
I got two *.trc files and compared them by content. There is only one difference between the files. In the trace file for new_user there is a line:
select * from "##R_temp"@old_link; select * from "##R_temp"@new_link;
Does it make sense?
hgoulcp, line 1107: calling SQLGetTypeInfo got sqlstate 23000