General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hi all,
>Doing a conversion of database from Oracle to Sql Server. We normally connect via remote views to the Oracle database. In the DBC, we use a connection string to connect to the database.
>When changing the backend to Sql server, we just changed the connection string and thought that the remote views would work straightaway.
>However, this was not the case and we found that the only way thru is to recreate the remote views.
>Is there something I'm missing here?
>Thanks in advance
>Yau
Yau - cycle through your dbc as a table , find the remote view, and start looking at the 'stuff' in there. you'll find code that takes your connection string and 'does stuff' with it there.
My apologies for being vague.
hth - mondo regards [Bill]
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only