This is a CLR question but here's some backgound first:
I need to talk to a Sybase "Advantage" database server and join results together with some SQL Server data. I tried using Enterprise manager to link a server to Advantage using both OLE DB and ODBC. Both types of connections Ping
ok when I create then but they also both error out when, from within the linked server screen in enterprise manager, I try to open the tree control to view tables in the database.
I also tried to access the Advantage server using an opendatasource call through both OLE DB and ODBC - both calls errored out with "Invalid object name"
I read the Advantage documentation and I discovered that the drivers - at least the ODBC driver - are a combination of level 1 and level 3 compliance, so I concluded that SQL Server is bombing when it tries to retrieve catalog information
after it connects...
I coded up a C# table valued function to retrieve the data that I need using ODBC. The function works fine from within Visual Studio but now I'm getting CAS errors when I try to use it from within SQL Server. The issue is security and I'm
having trouble figuring out how to tune permissions etc. to get this to work. Specifically I am getting this error when I try to call t
View Complete Post