|
Home > Archive > IQ Server > March 2005 > create remote server with ConnectionString, not DNS
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
create remote server with ConnectionString, not DNS
|
|
| Alexander Sinitsin 2005-03-30, 7:08 pm |
| Hello, All!
CREATE SERVER server-name CLASS 'server-class' USING 'connection-info'
Can I issue CREATE SERVER use valid ODBC connection string as
'connection-info'?
There is non a big difference between DSN name and connection string,
because DSN name is a 'shortcut' for connection string. But documentation
describe only DSN usage.
With best regards, Alexander Sinitsin. E-mail: a.sinitsin[hot
dog]alvion.com.ua
| |
| Alexander Sinitsin 2005-03-30, 7:08 pm |
| Yes, I can :)
I just add MS SQL Server 200 with this statement:
CREATE SERVER ServerName
CLASS 'mssodbc'
USING 'Driver=SQL Server; SERVER=ServerName;In
itial Catalog=DBName;
USR=UserName; PWD=UserPassword'
Thanks
|
|
|
|
|