HOW LINKED DbASE FOLDER TO SQL 2005 64 BIT? PLEASE HELP ME

I HAVE SQL2005 32 BIT ( TEST) AND SECOND MACHINE 64 BIt
(PRODUCTION).
IN 32 BIT I LINKED SUCCESFULL DBASE FOLDER (FILES CLIPPER) BY
OPENROWSET BY:
select * from OPENROWSET('MSDASQL',
'Driver={Microsoft dBase Driver};SourceDB=c:\MyApp\;SourceType=db
f',
'select * from MyTable')
IN 64 bit SQL2k5 I have message :
"MSDASQL provider not regisetered"
IN SQL MANAGER registration 'MSDASQL' provider is impossible?.
Do YOU HAVE INFORMATION , HOW LINKED DBASE FOLDER TO SQL2005 64
BIT '
PLEASE HELP MEYou cannot use a 32 bit ODBC driver from SQL-2005 64 bit; you can only use
64 bit drivers. Unless you find a 64 bit driver for dBase, you cannot open
your dBase folder directly from SQL-2005 64 bit.
For a possible solution, see:
[url]http://gorm-braarvig.blogspot.com/2005/11/access-database-from-sql-200564.html[/ur
l]
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
<gramir@.lanet.wroc.net> wrote in message
news:1174123698.892870.223050@.p15g2000hsd.googlegroups.com...
>I HAVE SQL2005 32 BIT ( TEST) AND SECOND MACHINE 64 BIt
> (PRODUCTION).
> IN 32 BIT I LINKED SUCCESFULL DBASE FOLDER (FILES CLIPPER) BY
> OPENROWSET BY:
> select * from OPENROWSET('MSDASQL',
> 'Driver={Microsoft dBase Driver};SourceDB=c:\MyApp\;SourceType=db
f',
> 'select * from MyTable')
> --
> IN 64 bit SQL2k5 I have message :
> "MSDASQL provider not regisetered"
> IN SQL MANAGER registration 'MSDASQL' provider is impossible?.
> Do YOU HAVE INFORMATION , HOW LINKED DBASE FOLDER TO SQL2005 64
> BIT '
> PLEASE HELP ME
>