Re: Disk or network error

Hi

You don't say of you can open the DBASE file from DBASE on the remote
machine? Are you using a mapped drive or UNC name? Have you checked that the
permissions are correct for the SQL Server service account?

John
"Shwetabh" <shwetabhgoel@xxxxxxxxx> wrote in message
news:1144529567.672831.5960@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi

I have written an application in VB through which I can convert DBASE
IV database to MS SQL Server database. Also, the application provides
database manipulation features to the user like addition, deletion etc
of records.
I am using OPENROWSET for conversion purposes. Also the server is MS
SQL Server 2000.
Now this application workks fine when I have installed the instance of
MS SQL Server on my local machine. It converts the database and stores
it on the server perfectly and there are no isues.
However, when I try to use the application to connect with MS SQL
Server on another machine, there are a few problems. I connect to the
other MS SQL Server on other machine through named pipes. My
application successfully accesses the database and allows user to
modify it according to his needs.
For this I created the user account of that user on the machine.
But when I try to convert the database, I get the following error
message:

[Microsoft ODBC Dbase driver]Disk or Network Error

Here is the line in VB code which is causing all the trouble:

con.Execute "select * into " & UCase(X) & " from
OPENROWSET('MSDASQL','Driver={Microsoft dBASE Driver
(*.dbf)};DEFAULTDIR=" & BaseData & ";SourceType=DBF','select * from " &
UCase(X) & "')"

Here, X is the dbf file name, BaseData is the path name of file.
I gave the user full rights but i am still getting this error message.
Now, what am I doing wrong here?

Regards,
Shwetabh



.

Relevant Pages

  • Re: Select command with multiple tables
    ... there are about 40 DBASE tables each of which contains fields ... This software will connect to SQL server and retrieve the ... Now my dillema is that should I just create a database containing all ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Disk or network error
    ... I have written an application in VB through which I can convert DBASE ... IV database to MS SQL Server database. ... Here, X is the dbf file name, BaseData is the path name of file. ...
    (comp.databases.ms-sqlserver)
  • Re: Select command with multiple tables
    ... there are about 40 DBASE tables each of which contains fields ... This software will connect to SQL server and retrieve the ... Now my dillema is that should I just create a database containing all ...
    (comp.databases.ms-sqlserver)
  • Re: SQL
    ... the Peformance analyzer is not bad in making suggestions ... performance it is relatively easy to upsize to SQL server. ... > Dan, thanks thats useful. ... > the size of the dBase will be less than 10MB. ...
    (microsoft.public.access.modulesdaovba)
  • DTS Import Error when importing DBASE file
    ... I am using MS SQL SERVER 2000 and its Data Transformation Service ... to import my DBASE IV database to MS SQL server database. ... Here LowesRetailDB is a DBASE IV file. ...
    (microsoft.public.sqlserver.dts)