SQL Server and Clipper/dBase

[level8]

I would like to see a Clipper/dbase DBF file as a table in SQL Server
7.0. How can I SELECT rows from DBF file? Should I use OLE DB Provider
or ODBC, and how?

[Simon Hayes]

"level8" <le****@freemail.hu> wrote in message
news:58**************************@posting.google.c om...

I would like to see a Clipper/dbase DBF file as a table in SQL Server
7.0. How can I SELECT rows from DBF file? Should I use OLE DB Provider
or ODBC, and how?

You can set up a linked server using either OLE DB or ODBC (using the OLE DB
provider for ODBC) - see "Configuring Linked Servers" in Books Online.

Simon

[level8]

"Simon Hayes" <sq*@hayes.ch> wrote in message news:<41**********@news.bluewin.ch>...

"level8" <le****@freemail.hu> wrote in message
news:58**************************@posting.google.c om...

I would like to see a Clipper/dbase DBF file as a table in SQL Server
7.0. How can I SELECT rows from DBF file? Should I use OLE DB Provider
or ODBC, and how?

You can set up a linked server using either OLE DB or ODBC (using the OLE DB
provider for ODBC) - see "Configuring Linked Servers" in Books Online.

Simon

Hi, Simon,
I have a d:\temp\likvid.dbf file. I created an ODBC connection named
"dbase" and after that I created a linked server named LL. In
Enterprise Manager I can see the LL and the LIKVID table, but that's
all. When I "select * from ll...likvid" in Query Analizer, then I get
a message: "Invalid schema or catalog specified for provider
'MSDASQL'." What is the problem?

Regard
László

[Erland Sommarskog]

level8 (le****@freemail.hu) writes:

I have a d:\temp\likvid.dbf file. I created an ODBC connection named
"dbase" and after that I created a linked server named LL. In
Enterprise Manager I can see the LL and the LIKVID table, but that's
all. When I "select * from ll...likvid" in Query Analizer, then I get
a message: "Invalid schema or catalog specified for provider
'MSDASQL'." What is the problem?

What does the Schema and Catalog column say for LIKVID? You probably need
to supply something between the dots, but not knowing DBASE, I have no
idea of what. May be ll.likvid.likvid.likvid?

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[level8]

Erland Sommarskog <es****@sommarskog.se> wrote in message news:<Xn**********************@127.0.0.1>...

level8 (le****@freemail.hu) writes:

I have a d:\temp\likvid.dbf file. I created an ODBC connection named
"dbase" and after that I created a linked server named LL. In
Enterprise Manager I can see the LL and the LIKVID table, but that's
all. When I "select * from ll...likvid" in Query Analizer, then I get
a message: "Invalid schema or catalog specified for provider
'MSDASQL'." What is the problem?

What does the Schema and Catalog column say for LIKVID? You probably need
to supply something between the dots, but not knowing DBASE, I have no
idea of what. May be ll.likvid.likvid.likvid?

Hi, Erland,

Yes. My problem is same: What does the Schema and Catalog column say
for a single DBF file? The dBase program isn't important now, it's
only one data file. I don't know that how the SQL Server can see it
through the ODBC. When I try the connection name (dbase) or the
directory (d:\temp) between dots, then the result is same.

Do you have other idea?

László

[Erland Sommarskog]

level8 (le****@freemail.hu) writes:

Erland Sommarskog <es****@sommarskog.se> wrote in message

news:<Xn**********************@127.0.0.1>...

What does the Schema and Catalog column say for LIKVID? You probably need
to supply something between the dots, but not knowing DBASE, I have no
idea of what. May be ll.likvid.likvid.likvid?

Yes. My problem is same: What does the Schema and Catalog column say
for a single DBF file? The dBase program isn't important now, it's
only one data file. I don't know that how the SQL Server can see it
through the ODBC. When I try the connection name (dbase) or the
directory (d:\temp) between dots, then the result is same.

You are right that Schema and Catalog may not very relevant for a DBF
file, but what I meant was: When you look at the tables in the linked
server from Enterprise Manager, what values do you see there? Would
these work?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[level8]

Erland Sommarskog <es****@sommarskog.se> wrote in message news:<Xn**********************@127.0.0.1>...

level8 (le****@freemail.hu) writes:

Erland Sommarskog <es****@sommarskog.se> wrote in message

news:<Xn**********************@127.0.0.1>...

What does the Schema and Catalog column say for LIKVID? You probably need
to supply something between the dots, but not knowing DBASE, I have no
idea of what. May be ll.likvid.likvid.likvid?

Yes. My problem is same: What does the Schema and Catalog column say
for a single DBF file? The dBase program isn't important now, it's
only one data file. I don't know that how the SQL Server can see it
through the ODBC. When I try the connection name (dbase) or the
directory (d:\temp) between dots, then the result is same.

You are right that Schema and Catalog may not very relevant for a DBF
file, but what I meant was: When you look at the tables in the linked
server from Enterprise Manager, what values do you see there? Would
these work?

Nothing. A big nothing. I can see only LIKVID table as an object (or
icon), but I can not see into the table. I can not open this table in
Enterprise Manager.

[Erland Sommarskog]

level8 (le****@freemail.hu) writes:

Nothing. A big nothing. I can see only LIKVID table as an object (or
icon), but I can not see into the table. I can not open this table in
Enterprise Manager.

I'm afraid that I've run out of suggestions. Well, ll.[ ].[ ].LIKVID
maybe.

I did find a thread on a Russian SQL forum where various suggestions
are tried. My Russian is very rudimentary, but maybe of the suggestions
there is something you could try.
http://www.sql.ru/forum/actualthread...&tid=14519&hl=


--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[level8]

Erland Sommarskog <es****@sommarskog.se> wrote in message news:<Xn**********************@127.0.0.1>...

level8 (le****@freemail.hu) writes:

Nothing. A big nothing. I can see only LIKVID table as an object (or
icon), but I can not see into the table. I can not open this table in
Enterprise Manager.

I'm afraid that I've run out of suggestions. Well, ll.[ ].[ ].LIKVID
maybe.

I did find a thread on a Russian SQL forum where various suggestions
are tried. My Russian is very rudimentary, but maybe of the suggestions
there is something you could try.
http://www.sql.ru/forum/actualthread...&tid=14519&hl=

Thanks.
Your suggestion was almost good.
The solution is ll.[d:\temp]..likvid.

[Erland Sommarskog]

level8 (le****@freemail.hu) writes:

Your suggestion was almost good.
The solution is ll.[d:\temp]..likvid.

Great to hear that you got it working!

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Ellen K.]

Our legacy apps are Clipper/dBase and we discovered that trying to
link to the Advantage Database Server to talk to them was Not A Good
Thing.

If you set up your dbf "database" as an ODBC data source, you can use
DTS to import a table or the result of a simple query into a SQL
Server table, where you can work with it. NOTE: Do NOT try to use
OLE DB against it, this blows up DTS.

On 2 Sep 2004 01:52:24 -0700, le****@freemail.hu (level8) wrote:

"Simon Hayes" <sq*@hayes.ch> wrote in message news:<41**********@news.bluewin.ch>...

"level8" <le****@freemail.hu> wrote in message
news:58**************************@posting.google.c om...

>I would like to see a Clipper/dbase DBF file as a table in SQL Server
> 7.0. How can I SELECT rows from DBF file? Should I use OLE DB Provider
> or ODBC, and how?

You can set up a linked server using either OLE DB or ODBC (using the OLE DB
provider for ODBC) - see "Configuring Linked Servers" in Books Online.

Simon

Hi, Simon,
I have a d:\temp\likvid.dbf file. I created an ODBC connection named
"dbase" and after that I created a linked server named LL. In
Enterprise Manager I can see the LL and the LIKVID table, but that's
all. When I "select * from ll...likvid" in Query Analizer, then I get
a message: "Invalid schema or catalog specified for provider
'MSDASQL'." What is the problem?

Regard
László