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? 10 7889
"level8" <le****@freemai l.hu> wrote in message
news:58******** *************** ***@posting.goo gle.com... 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 "Configurin g Linked Servers" in Books Online.
Simon
"Simon Hayes" <sq*@hayes.ch > wrote in message news:<41******* ***@news.bluewi n.ch>... "level8" <le****@freemai l.hu> wrote in message news:58******** *************** ***@posting.goo gle.com...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 "Configurin g 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ó
level8 (le****@freemai l.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.likvi d.likvid?
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
Erland Sommarskog <es****@sommars kog.se> wrote in message news:<Xn******* *************** @127.0.0.1>... level8 (le****@freemai l.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.likvi d.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ó
level8 (le****@freemai l.hu) writes: Erland Sommarskog <es****@sommars kog.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.likvi d.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****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
Erland Sommarskog <es****@sommars kog.se> wrote in message news:<Xn******* *************** @127.0.0.1>... level8 (le****@freemai l.hu) writes: Erland Sommarskog <es****@sommars kog.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.likvi d.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.
level8 (le****@freemai l.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****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
Erland Sommarskog <es****@sommars kog.se> wrote in message news:<Xn******* *************** @127.0.0.1>... level8 (le****@freemai l.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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: ads |
last post by:
Hi Everyone,
I'm starting learning python about 2 weeks, and still have
difficulties to create GUI based application because I never learn
about classes and other OOP things. Does anyone knows how to
create text console application like clipper using python.
Thanks,
|
by: ads |
last post by:
Thank you for the respon,
But right now I'm still not ready using linux, a lot of my client were
using windows. Is someone know what should I use to create text
console application like clipper using python in (stupid) windows?
Thanks
:)
--------------- Replied message --------------
|
by: Matrx |
last post by:
Can anyone help me create a sql querry with the following clipper/dbase code
or help me understand what the hell it means???
If you can help please don't hesitate to contact me at
matrx88NOSPAM@magma.ca.
remove the NOSPAM from my e-mail.
Thanks in advance to all of you that take the time to look at this post!!
Here is the code:
STATIC...
|
by: Ivan |
last post by:
Hi,
SQL Server 2000 SP3
Windos 2000 Server SP4
I have a DTS package that imports data from a dBase IV databse with
files located in two folders (dBF1 and dBF2). I use a transform data
task to transform the data.
They were running properly, but last week we installed W2K SP4, and
|
by: Joseph |
last post by:
Hello,
I have a C# program that builds a txt file and then, calls an external
exe (this external exe simply imports this txt file into a DBF (DBase) file.
(we copy a template of the DBF file into the process folder where the exe
lies and then this clipper EXE does the data move from the txt file to the
DBF file).
This process works fine...
| |
by: heyitsme_ryan |
last post by:
Ei guys I’m Ryan from Philippines, I need your advice and
recommendations about Windows 2003 Server and SQL Server 2000
installation. Well, here’s the scenario.
First is for windows 2003 server:
We have a windows 2003 server that is a Logon Server and we have at
least 90 workstation here in our office to manage. The problem is when
we...
|
by: Rob |
last post by:
Hi,
I have been asked by a customer to try to resurrect a rather ancient
application their organisation uses that was written in Clipper.
This I am fine with. However, there is a module that was written in C. I
do not have a C compiler and was wondering if one of you fine people could
compile it into an .obj file so that I can link it in...
|
by: Sarah |
last post by:
Hi
I am using vb.net
Is it possible to fetch data from foxpro tables (vfp8) and update tables in sql server 2000? The table structures of the foxpro tables are different from those in sql server. Depending on the data fetched, I would like to update relavent table columns in sql server. How can this be done
Regards
Sarah
|
by: cbbibleboy |
last post by:
Howdy!
I'm having a bit of trouble with my DirectDraw clipper. The code compiles fine and runs without a hitch; however, it doesn't work. That is, there is no clipping! I get the exact same behavior as when I have no clipper used. It's all very mysterious as I've compared my code with dozens of others' that work, yet I can't find any...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |