July 7, 2005 at 1:42 pm
i just got back from a class where i learnt that openvms system can be a linked server to sql, via odbc connection.
here is the problem, i have the odbc connection, called the dharma gateway, the problem is when i set it up i see the tables but i cannot see the columns, and i have been unable to query the linked server. any ideas?
[font="Comic Sans MS"][/font]It is what it is.
July 11, 2005 at 8:00 am
This was removed by the editor as SPAM
July 11, 2005 at 8:09 am
I came across a similar problem 3 or 4 years ago, where some tables were visible and others weren't, and a similar situation with columns.
It turned out to be a setting in the ODBC driver. Unfortunately, I no longer have access to a machine with the driver, and I can't remember the exact setting. I think it was on an 'Advanced' tab or button. The word 'pre-fetch' seems to ring a bell.
Sorry I can't be more helpful.
July 11, 2005 at 3:33 pm
Is your ODBC data source for an Rdb database?
If so:
(1) Have you tried the 2.X (preferable) and 3.X versions of the Rdb/ODBC driver?
(2) Do you have columns of type BIGINT? You'll need to CAST them to another type. Easy to do that using a view in the Rdb db.
(3) Does any table have over 500 columns? That's the limitation of the Rdb driver. You'll need to divide tables like that into several views.
(4) Does the account used for the ODBC data source have SELECT and SHOW priv on each table?
Jeff
July 11, 2005 at 3:38 pm
Rdb linked servers here have "data access" and "remote collation" properties checked in the linked server def. In the ODBC properties, "cursor=nohold" is used.
Jeff
July 12, 2005 at 7:05 am
actually, none of the above apply . but i guess i will just go back to the old method of using dts to get the data out daily . i just thought it would be nice to have it linked and ready for the developers that i am trying to woo off the vms system.
any way thanks all for the contribution
[font="Comic Sans MS"][/font]It is what it is.
July 12, 2005 at 7:38 am
Contact the vendor of the ODBC driver you are using for tech support. That was a big help for me with the Oracle/Rdb driver and I had a similar problem with column names.
Good luck with your porting off VMS. We have been porting Rdb/Oracle/SAS/RMS/Focus to SQL Server for several years. In a federal agency like mine, nobody approaching retirement wants the VMS server to go.
Jeff
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply