Create link to dBase?

Hello,
I was wondering what is the best way to link MS SQL server 2000 to dBase IV.
From what I can gather, we should create a linked server and use the MS Jet
4.0 OLE DB provider to connect to Borland's BDE. Then BDE links to the
dBase files.
Is this the correct way? If so, does anyone know where to get a working
version of BDE?
Thanks,
Marc.Using linked server is one of the ways, and I will probably go with that.
But am not sure where to get your BDE drivers...try Googling :-)
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Marc Thompson" <(NO SPAM) my email address is marc at sycron dot com> wrote
in message news:uuRlYTt%23DHA.3284@.TK2MSFTNGP09.phx.gbl...
Hello,
I was wondering what is the best way to link MS SQL server 2000 to dBase IV.
From what I can gather, we should create a linked server and use the MS Jet
4.0 OLE DB provider to connect to Borland's BDE. Then BDE links to the
dBase files.
Is this the correct way? If so, does anyone know where to get a working
version of BDE?
Thanks,
Marc.|||I have googled for it but haven't found a way to get a copy yet.
I am open to any methods really. I really would prefer not to use BDE.
Thanks,
Marc.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:OzhenZt#DHA.2072@.TK2MSFTNGP11.phx.gbl...
> Using linked server is one of the ways, and I will probably go with that.
> But am not sure where to get your BDE drivers...try Googling :-)
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Marc Thompson" <(NO SPAM) my email address is marc at sycron dot com>
wrote
> in message news:uuRlYTt%23DHA.3284@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I was wondering what is the best way to link MS SQL server 2000 to dBase
IV.
> From what I can gather, we should create a linked server and use the MS
Jet
> 4.0 OLE DB provider to connect to Borland's BDE. Then BDE links to the
> dBase files.
> Is this the correct way? If so, does anyone know where to get a working
> version of BDE?
> Thanks,
> Marc.
>
>

Create link from the report?

Is it possible create button or link from one report to another report?On Aug 1, 11:26 am, GGill <GG...@.discussions.microsoft.com> wrote:
> Is it possible create button or link from one report to another report?
There are several options available depending on your needs. You can
either use a subreport control that incorporates another report into a
report. Or you can use 'Jump to report' or 'Jump to URL' as part of
the properties (Navigation tab) of a textbox, image, table cell,
matrix cell, etc (via right-clicking the control -> selecting
Properties and selecting the Navigation tab). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||IT WORKED.
THANK YOU SO MUCH.
"EMartinez" wrote:
> On Aug 1, 11:26 am, GGill <GG...@.discussions.microsoft.com> wrote:
> > Is it possible create button or link from one report to another report?
>
> There are several options available depending on your needs. You can
> either use a subreport control that incorporates another report into a
> report. Or you can use 'Jump to report' or 'Jump to URL' as part of
> the properties (Navigation tab) of a textbox, image, table cell,
> matrix cell, etc (via right-clicking the control -> selecting
> Properties and selecting the Navigation tab). Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||You're welcome. Glad I could help.
Regards,
Enrique Martinez
Sr. Software Consultant
GGill wrote:
> IT WORKED.
> THANK YOU SO MUCH.
>
> "EMartinez" wrote:
> > On Aug 1, 11:26 am, GGill <GG...@.discussions.microsoft.com> wrote:
> > > Is it possible create button or link from one report to another report?
> >
> >
> > There are several options available depending on your needs. You can
> > either use a subreport control that incorporates another report into a
> > report. Or you can use 'Jump to report' or 'Jump to URL' as part of
> > the properties (Navigation tab) of a textbox, image, table cell,
> > matrix cell, etc (via right-clicking the control -> selecting
> > Properties and selecting the Navigation tab). Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant
> >
> >

Create Link from SQL 2000 to AS400

Hi
I have found an
issue when I try to view or access the tables on the AS400 from my client machine. I receive the following error when I make that attempt:

Error 7399: OLE DB Provider 'MSDASQL' reported an error.
Data Source Name not found and no default driver specified.

Any help anyone can give me on this issue would be greatly appreciated

Thanks
PhilHi,

Could you be more specific?

You need to create link from SQL 2000 to AS400 but which is the AS400 database?
You have installed the adequate driver?

My apologies for my english. I currently write in portuguese.

Regards,

Dlson Castro.
delson_castro@.ig.com.br

Originally posted by pholtquist
Hi
I have found an
issue when I try to view or access the tables on the AS400 from my client machine. I receive the following error when I make that attempt:

Error 7399: OLE DB Provider 'MSDASQL' reported an error.
Data Source Name not found and no default driver specified.

Any help anyone can give me on this issue would be greatly appreciated

Thanks
Phil|||It sounds like the error is from the linked server defined incorrectly on SQL Server.

You say yhou are accessing the tables from your client machine. If the SQL Server is on a different machine, remember that you need to set up the ODBC DSN (or the 'DB2OLEDB' driver) on the server, not your client.

See sp_addlinkedserver in BOL for a description of what is needed.

Please provide more information if this does not help or is unclear.

HueyStLoui

Originally posted by pholtquist
Hi
I have found an
issue when I try to view or access the tables on the AS400 from my client machine. I receive the following error when I make that attempt:

Error 7399: OLE DB Provider 'MSDASQL' reported an error.
Data Source Name not found and no default driver specified.

Any help anyone can give me on this issue would be greatly appreciated

Thanks
Phil