sql server connect: HOW LINKED DbASE FOLDER TO SQL 2005 64 BIT? PLEASE HELP ME!!!!!!! -- sql server connect

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

gramir NO[at]SPAM lanet.wroc.net
3/17/2007 2:28:18 AM

sql server connect:

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=dbf',
'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

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

Sylvain Lafontaine
3/18/2007 12:28:27 AM

You 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:
http://gorm-braarvig.blogspot.com/2005/11/access-database-from-sql-200564.html

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

[quoted text, click to view]