Conversion Of DBase II To SQL Server

Aug 28, 2007

I have been asked to look into converting a DBase II database on an AS400 to MS SQL Server 2000 or newer running on Windows 2003 or newer.

I know that it can be done but how hard will it be and how long could it take?

Are there any conversion packages out there that will do the majority of the leg work for us?

We also need to convert all of the screens written in RPG to a web based application. We want to get rid of the AS400.

Thanks
enak

View 5 Replies


ADVERTISEMENT

Linked Server SQL To DBASE(DB4)

Mar 23, 2006

Please anybody help me.
Can't get oledb for odbc work.Need an explanation what to put in each field of linked server properties General tab to get connected. Have ODBC server DSN working fine with Crystal reports.
Did this:
exec sp_addlinkedserver @server = 'ODBC_TEST' ,
@srvproduct = 'dBase',
@provider = 'MSDASQL',
@datasrc = 'DB4_GBS'
GO
-- Adding linked server login:

EXEC sp_addlinkedsrvlogin 'ODBC_TEST', 'false', 'sqlLogin', 'sqlpassword', NULL
Getting error : datasource name not found and no default driver specified.

I also attempt to create OLEDB ODBCless link and can't do it because after that I have to change path in TEMP and TMP variables and restart db, but I cann ot restart the server.
:eek:

View 10 Replies View Related

SQL Server And Clipper/dBase

Jul 20, 2005

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

View 10 Replies View Related

How Can I Get Sql Server Dbase Software?

Nov 7, 2007

Dear All,

Can some one help me to get or how to get an SQL SERVER dbase software cos have been trying to download bt i dnt get it right.

Urgent!!!!!!!!!!


OBALALU, Babatunde S.

View 5 Replies View Related

Restoring A SQL 7.0 Server Backup To A Different DBase

Dec 25, 1999

Hi,

I have used the backup tool in MS Access 2000.ADP many times
To make a nice backup of my adp Projects server objects(tables & data) that
I have in my MS SQL Sever 7.0 dBase. and then have successfully restored them back to the same computer that I have backed them up to. .

But now I need to transfer server SQL 7.0 DAT backup files over to two other types of computer setups..

I need to transfer these files and import or restore them onto another
computer that has MS Access 2000 and SQL 7.0 on a NT Server 4.0 platform and
also to a computer that has MS Access 2000 and MSDE on a win98 platform..

Have tried many different things but cannot seem to find a way to transfer or restore the SQL 7.0 DAT files to a different named dbase NT server with SQL 7.0 or to a win98 client with a named dbase on a MSDE file. the ADP client portion is just a simple file transfer but these SQL Server 7.0 DAT backup files... argh!

I am completely stumped even after trying many things and consulting the SQL
server manual.

Christopher James

View 1 Replies View Related

DBase IV Linked Server Very Slow

Mar 6, 2001

I've connect some .DBF file to SQL server 7 with linked server option. My table have about 200.000 records. I've tried with ODBC and Jet 4.0 option (found in www.mssqlserver.com) but I've very slow response if I use a "where" in the select instance.
In fact I've the response after 10 seconds and during this seconds the processor go to 100%.
Does anyone found a most speed way to do this?

Thanks,
Andrea

View 1 Replies View Related

Acccessing Dbase From SQL Server 2000

Apr 8, 2002

Hi,
I am stephen and am working with SQL server 2000 and .NET, i want to develop web pages(am just experimenting) using VB.NET and am using SQL server 2000 to retrieve data and publishing using IIS web server.
"the problem is when the webpage displays, it asks for authentication win NT but when i hit OK button. it displays the page."
i want to eliminate this windows NT pop-up box. is it the problem of IIS server security settings or SQL server settings?
any views or suggestions will be greatly appreciated.
stephen

View 1 Replies View Related

Linked Server To DBASE 5 Tables

Apr 28, 2004

I am trying to create a linked server to some dbase 5 tables. I have read several other posts about using the OPENROWSET option and that does work however, I would like to be able to create a linked server for easier access.

End Goal: I am developing an ASP based app that needs to join a DB5 table to a SQL table.

Any help on the linked server properties in Enterprise Manager for dbase5 or on the proper sp_addlinkedserver function for dbase5 would be highly appreciated.

Joe

View 2 Replies View Related

Appending Data Changes To A Dbase On A Host Server

Sep 27, 2000

Hello,

I need help in generating a stored proc script (SQL Server 7.0)that will:

document the changes of each field in a dbase (SQL Server 7.0)
appending the deltas (changes) to the dbase on a different, say production server for each affected field
prompt the user (dba, developer, super user) for the fields to involve in the comparing and documenting of changes (deltas).

thanks in advance for your help!

ALSO: Does SQL Server 2000 handle this situation better than SQL Server 7.0

Gunnar

View 1 Replies View Related

SQL Server Linked Table To Dbase III Files

Feb 2, 2005

Hi,

I am trying to use linked tables to connect SQL Server 2000 to a legacy system using dbase III files. (I need real time read only access to these files)

I have created a linked table from SQL server to a folder on the C drive which contains the dbase III files, using an ODBC DSN which uses "Microsoft dbase driver (*.dbf)". DSN tested successfully using Excel. Linked server connection is then created using "Microsoft OLE DB Provider for ODBC drivers".

The dbase tables appear OK in Enterprise manager, but I cannot get a query to work in SQL Anayzer, using the 4-part name syntax.

My query is just :
SELECT * FROM LinkedTable...customers

Error message is "Invalid schema or catalog specified for provider 'MSDASQL'". Now I am pretty sure dbase files do not support any sort of schema / catalog set up, so I suspect SQL Server is looking for something it is not going to get.

One clue might be that in Enterprise manager, under the catalog column, I get the pathname to the dbase file, ie c:customers.dbf, which I cannot enter in the 4-part syntax.

Any suggestion welcome !!!

View 2 Replies View Related

Can't Connect To Oracle Dbase With SQL Server 2005 Express

Dec 16, 2005

Hi,I'm attempting to connect to an Oracle database using SQL Server 2005Express (OS is Windows XP Professional) and having absolutely no luck.Here is the information SQL Plusgives me about the database when I log in -Connected to:Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.6.0 - ProductionAs you can see I have no problem connecting with the Oracle specifictools (SQL PLUS and PL/SQL Developer).I've tried creating a linked server with both the Microsoft providedOLE DB provider and the Oracle provider. With the Microsoft Provider Iget the following error when attempting a query in the query editwindow.OLE DB provider "MSDAORA" for linked server "ORACLE" returned message"Oracle client and networking components were not found. Thesecomponents are supplied by Oracle Corporation and are part of theOracle Version 7.3.3 or later client software installation.Provider is unable to function until these components are installed.".Msg 7303, Level 16, State 1, Line 2Cannot initialize the data source object of OLE DB provider "MSDAORA"for linked server "ORACLE".When I try connecting withe Oracle provider I get the following -OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLETEST2"returned message "ORA-01017: invalid username/password; logon denied".Msg 7303, Level 16, State 1, Line 2Cannot initialize the data source object of OLE DB provider"OraOLEDB.Oracle" for linked server "ORACLETEST2".I've set the password up as a local to remote login mapping using thesecurity page of the Linked Server property dialog. The username /password are definitely correct -- I used them to log in using SQL PLUSand PL/SQL Developer. I'm using an Oracle 9 client.PLEASE HELP !!!!!Thanks,Signed Frustrated

View 8 Replies View Related

Accessing V 7 Dbase From Sql Server 2005 Enterprise Edition

Apr 11, 2008



Hi, i would appreciate any help with this issue i have come across when trying to access a version 7 dbase from within sql server 2005.


The error message is telling me that "This version of SQL server man studio can only be used to connect to SQL Server 2000 and SQL servers 2005"

I am new with SQL server so ill explain how im accessing it. I am connecting a server with sql 2005 on it via net support then through this trying to access another server with v 7 on it.

Thanks for the help in advance.

View 13 Replies View Related

How To Upload A MS Word Textfile Onto A SQL Server Dbase, Please Help! Urgently Needed!

Dec 27, 2006

Hello there guyz!ahm, i just want to ask, how can i upload a MS word text file to a SQL Dbase? I know i must use the Input File, the one in the Toolbox menu for HTML controls. but i need to know 1. How can i link the SQL dbase to the Input file Button? 2.  How to put the MS word file onto the SQL dbase? 3. what should i use to declare the MS Word file on the SQL Dbase? is it variable? char? etc... THank you so much! Please i Really need this one to put up my thesis system. and if it isn't much of a task, please can anyone  send me  the  SOURCE CODES  for my  questions?  

View 9 Replies View Related

Cannot Import/link Data From DBase With SQL Server DTS Nor Access Anymore..

Jul 20, 2005

Hi,SQL Server 2000 SP3Windos 2000 Server SP4I have a DTS package that imports data from a dBase IV databse withfiles located in two folders (dBF1 and dBF2). I use a transform datatask to transform the data.They were running properly, but last week we installed W2K SP4, andnow the transform task for files from dBF2 are not working properly.I have two tranform tasks to extract data from files in dBF2 folder.If I double click to open the transform data task of either of them,Enterprise Manager crashes with the errrormmc.exe applicatio ErrorThe instruction "xxxx" referenced memory at "xxx". The memory couldnot be read.Althoug the transform task for one of the files will run, the otherwill not run giving the messageError Source: DTS packageCatastrophic failureAlso, I have an Access database that has links to the same dBasefiles. For files from dBF2 folder, I'm able to see the data from oneof the files, but if I double click to see the data from the other,access crashes with no specific error message. Nothing has changed ondBase related files (permission wise).The transform tasks to extract data from the other dBase folder (dBF1)files are working fine, and data is accesible from Access.Any advice how to tackle this one?

View 2 Replies View Related

SQL Triggers: Transfer Data From SQL Server 2000 To Visual FoxPro DBase

Jul 23, 2005

Hi all,I am fairly new to using triggers and was seeking some help from thosethat have experience with them. I am looking to transfer data from aSQL 2000 database to a Visual FoxPro database on another computer. Iwould like to transfer about three fields of data to a VFP table eachtime an insert is made on the SQL table. I am some what familiar withthe structure of creating the trigger but here is what I would likehelp with: Selecting the SQL data to transfer, Connecting to VFPdatabase, Insert SQL data into VFP table.CREATE TRIGGER [xyz] ON [dbo].[AAA]FOR INSERT??? Select a,b,c from SQL table??? Connect to VFP Database and Table??? Insert into VFP table Values a,b,cAny information, tips, or even an example Trigger procedure would helpand be greatly appreciated.Thank you,Brett

View 1 Replies View Related

Can Windows 2003 Server Backup Utility Be Used To Backup A SQL 2000 Dbase

Dec 28, 2007

Windows 2003 backup utility uses the shadow copy option that allows it to copy open files.
Therefore, can I use this utility to backup the .mdf and .ldf files for my SQL 2000 database?
I can then attach the .mdf files if I need to restore the database to another server.
Can anyone tell me if this is safe? I've tried it and it worked but I'm worried there maybe some lurking danger in using this approach.

View 4 Replies View Related

Transfer From DBase To MS SQL

Jun 12, 2004

In my project, I need to transfer the database from dBase to MS SQL 2000. I only have the .dbf files for the dBase database. Can someone give me a help? Thanks in advance.

View 1 Replies View Related

How Can I Access Dbase?

Aug 30, 2006

Hi,

I want to access dbase database, can anyone help?

I try :

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Data Source=D:Account;Extended Properties=DBASE III;',
TRANS.DBF)

and I got the following message :

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not find installable ISAM.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

Thanks and I really appreciate any help
joe

View 3 Replies View Related

SQl Dbase Query From Different Folders

Feb 4, 2008

HI, I have a Dbase Database stored in several subfolders. I allready made my connection with a sqldatasource and a gridview, and all works fine when i do a query with the tables in to root folder. The problem is when I try to include tables from the subfolders, the compiler send me a syntax error in the FROM Clausule
I Allready try this.
 SELECT products.id, products.descri, condition.discount  from products, clientscondition where products.line=condition.line
 SELECT producst.id, products.descri, clientscondition.discount from products, clientscondition where products.line=condition.line
 SELECT products.id, products.descri, condition.discount from products, condition in 'clients' where products.line=condition.line
 SELECT producst.id, products.descri, clientscondition.discount from products, 'clients'.condition where products.line=condition.line
And many other different combinations. I would like to be helped if you know the correct syntax or a link where i can consult the syntax for VB.net and dbase with several folders
Another option a tried is having a query from 2 different datasources, but I donĀ“t know how to make a reference to the 2 sqldatassources in a new one to be linked to the gridview

View 7 Replies View Related

OpenRowset On A DBase IV File

May 26, 2000

Has anyone had any experience using the openrowset function to access a dbase IV file? I can access the file using ADO from within VB but not getting anywhere using openrowset. If anyone knows the syntax or has an example it would be greatly appreciated.

Thanks in advance...

Jim

View 4 Replies View Related

Copy Dbase To SQL Performance

Mar 6, 2002

I am searching for a better way to move data from DBase3 files into SQL Server 2k. The Dbase file has approximately 2 million records and after applying a SELECT statement to retrieve the data I need to move, there are still over 600,000 records. To move this data I have used DTS (data pump) to transform the data- THIS IS UNBEARABLY SLOW. Next, I created an exe to transform the data to a flat file and then used BULK INSERT to copy the data. The exe is slow, but the BULK INSERT is fast. I have moved the source and destination to the local Server to increase performance, but with little imporvement.
My question:
Is there a better way to move large amounts of data from DBase3 files to SQL Server without waiting 38 hours to move 600,000 rows? Thanks for your help.

View 1 Replies View Related

MS Access DBase Question

Feb 7, 2006

Hello a,,

I have a MS SQL database that I use MS ACESS to add data to and also to query.

My question is how can I setup the MS Access database so that it will not allow duplicate entries to be added to the MS SQL database? I know How I could do it using php via a webpage but I need to be able to do this using the MS Access program directly since thats what we use to add and search the dbase with.

thanks

View 5 Replies View Related

How To Transfer Data From DBase To SQL?

Sep 13, 2004

I have some database files with .dbf from dBase and I want to transfer data from the .dbf files to Microsoft SQL database (2000). Can someone help me with that? Thanks.

View 4 Replies View Related

Detach Dbase On SAN With SQL2005

Apr 16, 2007

I'm not sure if this is the right place for this but I have an issue.



I have a SQL2005 server with SAN drives for the MDF/LDF files. I have updated recently to SP2.



When I detach a Dbase using the appropriate command it strips the Security on the file level (which SP2 is supposed to fix) and I am unable to attach the database.



I am using a domain account to do this with from the query analyser window.



Anyone have any thoughts on this?

View 6 Replies View Related

Connect Dbase II In Ssis

Aug 22, 2006

I am having trouble connecting dbf of version dbase II. I can connect dbase III and dbase IV in ssis package,but can't connect dbase II.hope your help!

View 3 Replies View Related

Dbase Access On A 64-bit System

Nov 21, 2006

Hello all...

I created several SSIS packages on a 32-bit system, using odbc to to access the dbase source file. Finally, after setting up a proxy, etc., we got the package to run and import data. We then needed to move the packages to a 64-bit system. So, we built our manifests, and installed all of our packages. We are using several dtsConfig files for our packages, and in there we specify the DSN that we will be accessing. I understand that MS does not support odbc drivers in a 64-bit world (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=85703&SiteID=1). Has anyone been faced with this issue? How did you get past it? I accessed the 32-bit odbc drivers on the 64-bit system, and i setup a dsn that points to the dbase file, but when i run the job, the log file has an error that the dsn was not found. However, when I run the package itself, it runs as expected...

Please help!!  :-)

Craig

View 1 Replies View Related

How To Generaate A Report With ASP.Net From A MS_SQL DBase

Mar 4, 2004

You guys are probably going to tell me to go to school (training, and I'd like to)
My question is, I have a stored procedure in our MS_SQL 7 dbase that pukes out the info in a table with MSAccess. What I would like to do is, have a nice customized report be generated via http link. I designed and made such a report that queries the SQL sp_ with Crystal Report 8 I installed the browser plug in on a test workstation launched the report (via web) and I get prompted for access credentials (username & Password). Nothing works except the sa account in on the SQL server (and I am a sysadmin on that server),. I am giving that up in hopes to achieve this goal with a ASP page, but I really do not even know where to start. remember I have a storeed procedure that does the querying for me, so if there is a way to make "form that queries the sp_ maybe? ...I don't know really new at this.

View 1 Replies View Related

Update Query Based On Another Dbase

Jun 5, 2000

Can i update a field in a table in 1 dbase based upon data in another table in another dbase.
could somebody let me know if this is possible.
Thanks

View 1 Replies View Related

Transfering SQL6.5 Dbase To SQL7.0

May 5, 2000

I Completely new to SQL, can anyone give me a URL to find this information.?
Thanks

View 1 Replies View Related

SQL DBase In Restore Mode.. Need To Stop

Sep 18, 2001

I have a database in a restore mode. The SQL Enterprise Manager says the database is in a 'Loading' phase. How can this operation be cancelled?

Thanks,
Brian

View 1 Replies View Related

How Do I Export A Table To Dbf (dbase) File ?

Dec 29, 2006

besides using the costly EMS Data export application?

I'm using the SQL 2005 Express version......I heard the enterprise manager can do the job but I can't afford a standard edition yet....

View 11 Replies View Related

Foreach Loop For DBASE IV Problem

Apr 17, 2006

I've followed the steps on how to use the ForEach loop container using a Flat Text file and it's working fine. I tried reading the text file and put it in my SQL table. However, I have some DBF files as well and the ForEach loop does not work at all with my DBF files.

Here is my scenario:

A connection manager pointed to C:DBF_FILES

On the Control Flow: a Foreach loop container with Foreach file enumerator. (checks for IFUL*.DBF files and retrieves the Fully qualified name.

Within the foreach loop container is my DataFlow (import)

Within the dataflow:

OLEDB datasource
data access mode: Table name or View Name variable
Variable nam: username::Filefound

Now from this point on, I'm already having problems, here is the error:

An OLEDB error has occured.
An OLEDB record is available. Source: "Microsoft OLE DB Provider for ODBC Drivers.
Data source name not found and no default driver specified.
Error at data flow task...

There is also some error that say i don't have a destination table specified. Plus the error is on the OLEDB datasource not having a destination table? I don't understand this part.

Please help!




View 22 Replies View Related

SSIS Import Of DBase Tables

Feb 4, 2007



I followed the steps outlined in

http://msdn2.microsoft.com/en-us/library/aa337084.aspx

and was successful at importing ".dbf" files from a dBase 7.0 folder.

However, this import was quite slow: approx. 2000 rows per second. Some of the tables I must import have over 8,000,000 rows, which would then take 4,000 seconds, or over one hour. This import rate seems unaffected by whether or not I put a "Copy Column" Data Flow Transformation task between the "OLE DB Source" and "OLE DB Destination" objects.

In SQL Server 2000 it was much faster to import such large tables. The 8 million row table takes only 14 minutes (800 seconds) with SQL Server 2000 -- giving a transfer rate approx. 5 times as fast.

Is there any way to speed up this process in SQL Server 2005? (In SQL Server 2000 there was a "Use fast load" option on the "Options" tab of the "Transform Data Task Properties." I have not yet found any similar option for SQL Server 2005.)

My receiving database is using the "Simple" model, so there is no need to create transaction entries for loading these large tables. There are also no indexes on these tables: the data are being loaded into new tables created in SSIS.

Thanks for your help with this issue.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved