dbTalk Databases Forums  

Error getting data from dbIV using transform object

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Error getting data from dbIV using transform object in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jim
 
Posts: n/a

Default Error getting data from dbIV using transform object - 12-09-2004 , 09:19 AM






I'm trying to pull data from a dbIV database(Goldmine 6.5) using the dbIV
driver that comes with DTS.

When I try to retrieve data I get the message: "unexpected error from
external db driver(15877)".

What is required to fix this problem? Is there a better driver that can be
used?

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Error getting data from dbIV using transform object - 12-09-2004 , 01:42 PM






Can you connect any other way?
If == yes then can you use a DSN and the "Other" Data Source to connect?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Jim" <Jim (AT) discussions (DOT) microsoft.com> wrote

Quote:
I'm trying to pull data from a dbIV database(Goldmine 6.5) using the dbIV
driver that comes with DTS.

When I try to retrieve data I get the message: "unexpected error from
external db driver(15877)".

What is required to fix this problem? Is there a better driver that can be
used?



Reply With Quote
  #3  
Old   
Jim
 
Posts: n/a

Default Re: Error getting data from dbIV using transform object - 12-09-2004 , 05:19 PM



Used the "other" connection and received an error: "Error Source: Microsoft
OLE DB Provider for ODBC Drivers. Error Description: [Microsoft][ODBC dbase
Driver] Index file not found."

The directory that contains the dbase files does not have the extension
..ndx(the extension is .mdx). The directory has .dbf and .ndx files.

Is an .mdx file compatible with dbaseIV?


"Allan Mitchell" wrote:

Quote:
Can you connect any other way?
If == yes then can you use a DSN and the "Other" Data Source to connect?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Jim" <Jim (AT) discussions (DOT) microsoft.com> wrote

I'm trying to pull data from a dbIV database(Goldmine 6.5) using the dbIV
driver that comes with DTS.

When I try to retrieve data I get the message: "unexpected error from
external db driver(15877)".

What is required to fix this problem? Is there a better driver that can be
used?




Reply With Quote
  #4  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Error getting data from dbIV using transform object - 12-10-2004 , 12:12 AM



dBASE IV, dBASE V, and FoxPro Indexes for dBASE IV files have an MDX extension; indexes for FoxPro files have a CDX extension
I do not have much experience with dBase though

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Jim" <Jim (AT) discussions (DOT) microsoft.com> wrote

Quote:
Used the "other" connection and received an error: "Error Source: Microsoft
OLE DB Provider for ODBC Drivers. Error Description: [Microsoft][ODBC dbase
Driver] Index file not found."

The directory that contains the dbase files does not have the extension
.ndx(the extension is .mdx). The directory has .dbf and .ndx files.

Is an .mdx file compatible with dbaseIV?


"Allan Mitchell" wrote:

Can you connect any other way?
If == yes then can you use a DSN and the "Other" Data Source to connect?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Jim" <Jim (AT) discussions (DOT) microsoft.com> wrote

I'm trying to pull data from a dbIV database(Goldmine 6.5) using the dbIV
driver that comes with DTS.

When I try to retrieve data I get the message: "unexpected error from
external db driver(15877)".

What is required to fix this problem? Is there a better driver that can be
used?






Reply With Quote
  #5  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Error getting data from dbIV using transform object - 12-10-2004 , 12:20 AM



dBASE IV, dBASE V, and FoxPro Indexes for dBASE IV files have an MDX extension; indexes for FoxPro files have a CDX extension
I do not have much experience with dBase though

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Jim" <Jim (AT) discussions (DOT) microsoft.com> wrote

Quote:
Used the "other" connection and received an error: "Error Source: Microsoft
OLE DB Provider for ODBC Drivers. Error Description: [Microsoft][ODBC dbase
Driver] Index file not found."

The directory that contains the dbase files does not have the extension
.ndx(the extension is .mdx). The directory has .dbf and .ndx files.

Is an .mdx file compatible with dbaseIV?


"Allan Mitchell" wrote:

Can you connect any other way?
If == yes then can you use a DSN and the "Other" Data Source to connect?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Jim" <Jim (AT) discussions (DOT) microsoft.com> wrote

I'm trying to pull data from a dbIV database(Goldmine 6.5) using the dbIV
driver that comes with DTS.

When I try to retrieve data I get the message: "unexpected error from
external db driver(15877)".

What is required to fix this problem? Is there a better driver that can be
used?







Reply With Quote
  #6  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Error getting data from dbIV using transform object - 12-10-2004 , 12:20 AM



dBASE IV, dBASE V, and FoxPro Indexes for dBASE IV files have an MDX extension; indexes for FoxPro files have a CDX extension
I do not have much experience with dBase though

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Jim" <Jim (AT) discussions (DOT) microsoft.com> wrote

Quote:
Used the "other" connection and received an error: "Error Source: Microsoft
OLE DB Provider for ODBC Drivers. Error Description: [Microsoft][ODBC dbase
Driver] Index file not found."

The directory that contains the dbase files does not have the extension
.ndx(the extension is .mdx). The directory has .dbf and .ndx files.

Is an .mdx file compatible with dbaseIV?


"Allan Mitchell" wrote:

Can you connect any other way?
If == yes then can you use a DSN and the "Other" Data Source to connect?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Jim" <Jim (AT) discussions (DOT) microsoft.com> wrote

I'm trying to pull data from a dbIV database(Goldmine 6.5) using the dbIV
driver that comes with DTS.

When I try to retrieve data I get the message: "unexpected error from
external db driver(15877)".

What is required to fix this problem? Is there a better driver that can be
used?








Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.