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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-25 : 13:11:31
|
Todd writes "My company uses the standard edition of Goldmine 4 which uses dBase IV (GM4 Enterprise can use SQL7 as the backend). I'm trying to set up the .dbf files as a linked server in MSSQL7 SP2.
I set up a System DSN called Goldmine which seems OK. I went into MMC and added a linked server named GOLDMINE, with "Goldmine" in the boxes labelled Product Name and Data Source; RPC and RPC Out both checked. All the appropriate tables show up under the Goldmine linked server in MMC. The MSSQL service runs under a domain acct that has change permissions to the folder with the .dbf files.
However, this:
SELECT * FROM OPENQUERY(Goldmine,'SELECT * FROM Contact1')
fails when called in QA, even under the sa account. The error is:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC dBase Driver] '' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.]
I had this set up before on NT4 SP5 or SP6, but the server was rebuilt (clean install) with Win2k SP1. I have DTS packages that will import, but prefer to use the linked servers so I can write the stored procs and get my hands on the actual T-SQL (DTS hides too much I think).
Any ideas? Thanks!" |
|
|
|
|
|
dBase IV as a Linked Server in SQL 7