Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TRACS
Starting Member
5 Posts |
 Posted - 2009-02-17 : 16:04:20
|
I need to pass a query from Microsoft Access 2003 to a SQL Server 2005 Server which will then access an ORACLE Server. There are limitations on accessing the ORACLE Serve so that precludes accessing it directly by the user. I am using ODBC Connections to connect all the servers together. I have found info on passing a query from Access to SQL Server, but I get lost when I need to then pass the query on to the ORACLE server. The end user will pass an number value as the variable. I am pretty sure that I need to have a stored procedure in the SQL Server but am new to SQL Server and could use a little guidance. Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Pass through query from Access