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 |
|
aim22
Starting Member
7 Posts |
 Posted - 2007-11-09 : 13:56:36
|
| Hello, im a begginer in Linked Servers. I use the following connection string:"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\Emplea.DB;Extended Properties=Paradox 5.x;"But when clicking on the Tables icon i get the following error:Error 7399: OLE DB Provider 'Microsoft.Jet.OLEDB.4.0' reported an error.OLEDB Error trace[OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ]Im aware it could be a very silly mistake im making, as i said im a begginer and been only looking into this for a couple hours.Thanks. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-09 : 18:30:14
|
| DataSource=C:\Emplea.DBI think that should be the PATH only, not the filenameKristen |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-10 : 00:12:41
|
| Did you try with gui interface in em? Another option is create odbc dsn for Paradox then create linked server with odbc provider. |
|
|
|
aim22
Starting Member
7 Posts |
Posted - 2007-11-14 : 13:04:07
|
| I get the same error, This after creating the DSN for paradox 4.xwith the difference of the provider (now MSDASQL). I been looking into this and a lot of people have the same problem, with many different providers. It's not a timeout error nor a read/write permission error.Honestly, i have no idea of what it is.Any ideas? :(Thank you. |
|
|
|
|
|
|
Linked servers... Paradox database