ok...
I've set up a SQL 2000 server and had to figure out a way to access a remote
SQL 2000 server and run queries against it.
solved
Problem now is that I need to set up an alias for the 4 level qualified path.
------
example...
select *
from openquery(server_name,'server_name.catalog.schema.table_name')
-----
server_name, and server_name.catalog.schema need to be aliased in SQL server
just as a datasource is aliased in the application.cfm file.
any help is appreciated.
Steve
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
