| ron.g.hippen@wellsfargo.com 2006-01-18, 9:23 am |
| I have created a System DSN called REDBRICKDB using the ODBC Data
Source Administrator on a Windows XP machine. The driver I am using is
the Red Brick [32] Driver. The Red Brick Client 32 software is
installed on this machine. I can successfully connect to the database
when running RBPing32.exe.
I successfully created a DTS package in SQL Server 2000 that uses the
Red Brick [32] Driver and a Transform Data Task to move data from a
table in the Red Brick database to a SQL Server table.
Now I am trying to create a linked server to the Red Brick database.
The linked server has a Product name of MSDSQL and the Data source name
is the ODBC DSN called REDBRICKDB. I continue to get a "** FATAL
**(145) Login user name and password is invalid" error when connecting
to this linked server.
I am thinking there is a specific Provider string that is necessary to
access the Red Brick database but I have been unable to determine what
the connection string should be.
I tried to create a File DSN using the ODBC Administrator to see the
connection string but that was unsuccessful. I have also saved the DTS
package to VB to see if I could see the connection properties but this
also did not help.
Does anyone have any suggestions for setting up this linked server to a
Red Brick database?
|