December 16, 2008 at 9:15 am
I'm trying to create a linked server to a paradox version 4 database and haven't had any luck so far. I've tried going through the GUI wizard and also through Stored Procedures. Both methods result in this error
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
"The linked server has been created but failed a connection test. Do you want to keep the linked server?"
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TIMESLIPS" reported an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TIMESLIPS".
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TIMESLIPS" returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.". (Microsoft SQL Server, Error: 7399)
As you can see i'm trying to use the Jet 4.0 driver. I'm pointing to the folder storing my .db files. I've even copied all the .db files locally to avoid any security permission problems over the network, as well as lock out problems from my other users accessing the Paradox database.
For the secutiry options i've tried all the options. I assume that if my Paradox database has authentication built in then i choose the option "Be made using this security context:" at which point i entered my username and password for the database. Is this accurate? Do i need to use some sort of database administrator account? I'm not familiar with Paradox or BDE at all so any thoughts or suggestions would be very helpful.
Thanks
December 16, 2008 at 9:26 am
AFAIK, paradox is a fancy name for a csv. Have you tried linking to it as a text file and see what happens then?
There shouldn't be any need for security there (unless I'm thinking about the wrong db system).
December 16, 2008 at 9:45 am
I tried connecting using the Jet 4.0 driver and "Text" as the provider string and i was able to get connected however it's not seeing the database properly. When i run the command exec sp_tables_ex @table_server = 'TIMESLIPS' i only get 13 results with weird names for the tables. I know the database has many more tables than are showing up. I tried querying one of the tables that did show up and the results weren't parsed properly. Can i change the delimiter to a TAB rather than a comma?
December 16, 2008 at 4:56 pm
Fool around with the settings, I'm sure it's possible to play with that in the text mode however I have never done that.
More to the point I was off on the db type. I was expecting it to contain only a single table not 13 (maybe I just dealt with a real simple db back then).
December 17, 2008 at 8:03 am
ok, thanks for your help with this. Anyone else have any ideas?
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply