June 14, 2004 at 2:07 pm
I am attempting to create a Linked Server in Windows 2000 to a SQLBase 7.5 database. I've downloaded and installed the latest drives from Gupta. I can create OBDC connections and DTS packages that work with the SQLBase data, but I can't get it to work with Linked Servers. When I try to look at the tables in a Linked Server with an SQLBase OLE connection I get a 7399: OLE DB provider 'UNKNOWN' reported an error. The Linked Servers set up with 'Microsoft OLE DB Privder for ODBC' just seem to lock up the Enterprise Manager when I try to look at the tables.
Any help or advice would be appreciated.
June 14, 2004 at 5:41 pm
Your drivers may not expose the proer info for the Ole drivers to work with. Check out this link http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlole.mspx . Note also not all drivers will work with SQL Server as a linked server.
June 15, 2004 at 6:15 am
I too am curious to find out how to use a linked server with SQLBase. I also installed the Gupta 8.5 driver (not really sure what version of SQLBase we have). If I try and run a DTS -> All Tasks-> Import Data it will create all the tables, but won't copy the data into them. It is strange because I can preview the data from this wizard. I ended up creating a DTS package that does Data Transform steps to copy each tables data over nightly into the empty table structures and that worked. A linked server would be ideal!
On a related note: I was having all kinds of problems getting my nightly jobs to run using the SQL Agent. Didn't appear to be a rights issue, but something with environment variables. I actually had to log in to our server as the service account that SQL Agent runs as, and create a user environment variable (Path=C:\PROGRA~1\Gupta\SQLBAS~1) as that user. Absurd as that sounds, it allowed the SQL Agent to run. Not sure why that was working while doing the same as a system environment variable did not.
email me if you want to bang heads
Greg
greg_burns@DO_NOT_SPAM_ME_hotmail.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply