> Hi All,

> I have an Access 2000 adp that I want to use to view CR reports.  So I'm
> using the CR viewer and the following code:

> Dim fcrApp As CRAXDRT.Application
> Dim fcrRpt As CRAXDRT.Report
> Dim strtest As String

> Set fcrApp = New CRAXDRT.Application
> Set fcrRpt = fcrApp.OpenReport("f:\IT\test.rpt")

> strtest = fcrRpt.Database.Tables.Count
> fcrRpt.Database.Tables(1).SetLogOnInfo "G:\ODBC\WTP SQL"

> CRViewer1.ReportSource = fcrRpt
> CRViewer1.ViewReport

> It works a treat on the same box as the SQL Server and CR are installed
on.
> However I get the 'Physical Database Not Found' error when used on another
> machine on the network.

> It has the same drive mappings and I'm sure I've registered all the .dll's
> etc.  Any help / ideas would be much appreciated.  Anyone know more about
> this error?  Is it caused by an ODBC error normally?

> Thanks
> Steve

> Before calling SetLogOnInfo, you need to set Table.Location property. For
> SQL Server, the location property must be a fully qualified table name.
> e.g., MyDatabase.dbo.MyTable

> > Hi All,

> > I have an Access 2000 adp that I want to use to view CR reports.  So I'm
> > using the CR viewer and the following code:

> > Dim fcrApp As CRAXDRT.Application
> > Dim fcrRpt As CRAXDRT.Report
> > Dim strtest As String

> > Set fcrApp = New CRAXDRT.Application
> > Set fcrRpt = fcrApp.OpenReport("f:\IT\test.rpt")

> > strtest = fcrRpt.Database.Tables.Count
> > fcrRpt.Database.Tables(1).SetLogOnInfo "G:\ODBC\WTP SQL"

> > CRViewer1.ReportSource = fcrRpt
> > CRViewer1.ViewReport

> > It works a treat on the same box as the SQL Server and CR are installed
> on.
> > However I get the 'Physical Database Not Found' error when used on
another
> > machine on the network.

> > It has the same drive mappings and I'm sure I've registered all the
.dll's
> > etc.  Any help / ideas would be much appreciated.  Anyone know more
about
> > this error?  Is it caused by an ODBC error normally?

> > Thanks
> > Steve

> Thanks, but no joy!

> Mt database is WTP and my table is a SP called test, so I've tried
> Wtp.dbo.Test but I still get the 'Physical Database Not Found' error.

> Any other ideas?

> Steve

> > Before calling SetLogOnInfo, you need to set Table.Location property.
For
> > SQL Server, the location property must be a fully qualified table name.
> > e.g., MyDatabase.dbo.MyTable

> > > Hi All,

> > > I have an Access 2000 adp that I want to use to view CR reports.  So
I'm
> > > using the CR viewer and the following code:

> > > Dim fcrApp As CRAXDRT.Application
> > > Dim fcrRpt As CRAXDRT.Report
> > > Dim strtest As String

> > > Set fcrApp = New CRAXDRT.Application
> > > Set fcrRpt = fcrApp.OpenReport("f:\IT\test.rpt")

> > > strtest = fcrRpt.Database.Tables.Count
> > > fcrRpt.Database.Tables(1).SetLogOnInfo "G:\ODBC\WTP SQL"

> > > CRViewer1.ReportSource = fcrRpt
> > > CRViewer1.ViewReport

> > > It works a treat on the same box as the SQL Server and CR are
installed
> > on.
> > > However I get the 'Physical Database Not Found' error when used on
> another
> > > machine on the network.

> > > It has the same drive mappings and I'm sure I've registered all the
> .dll's
> > > etc.  Any help / ideas would be much appreciated.  Anyone know more
> about
> > > this error?  Is it caused by an ODBC error normally?

> > > Thanks
> > > Steve

> Just re-read your original message. I have got a few questions.

> 1. Are you accessing a table on SQL Server or in an ACCESS database?

> 2. If you are accessing the SQL Server, your use of SetLogOnInfo is
> incorrect.

> SetLogonInfo expects a servername/odbcdatasourcename, databasename,
username
> and password.

> "G:\ODBC\WTP SQL" doesn't look like a server name or an ODBC data source
> name.

> > Thanks, but no joy!

> > Mt database is WTP and my table is a SP called test, so I've tried
> > Wtp.dbo.Test but I still get the 'Physical Database Not Found' error.

> > Any other ideas?

> > Steve

> > > Before calling SetLogOnInfo, you need to set Table.Location property.
> For
> > > SQL Server, the location property must be a fully qualified table
name.
> > > e.g., MyDatabase.dbo.MyTable

> > > > Hi All,

> > > > I have an Access 2000 adp that I want to use to view CR reports.  So
> I'm
> > > > using the CR viewer and the following code:

> > > > Dim fcrApp As CRAXDRT.Application
> > > > Dim fcrRpt As CRAXDRT.Report
> > > > Dim strtest As String

> > > > Set fcrApp = New CRAXDRT.Application
> > > > Set fcrRpt = fcrApp.OpenReport("f:\IT\test.rpt")

> > > > strtest = fcrRpt.Database.Tables.Count
> > > > fcrRpt.Database.Tables(1).SetLogOnInfo "G:\ODBC\WTP SQL"

> > > > CRViewer1.ReportSource = fcrRpt
> > > > CRViewer1.ViewReport

> > > > It works a treat on the same box as the SQL Server and CR are
> installed
> > > on.
> > > > However I get the 'Physical Database Not Found' error when used on
> > another
> > > > machine on the network.

> > > > It has the same drive mappings and I'm sure I've registered all the
> > .dll's
> > > > etc.  Any help / ideas would be much appreciated.  Anyone know more
> > about
> > > > this error?  Is it caused by an ODBC error normally?

> > > > Thanks
> > > > Steve

> Hi CW

> Thanks for your help on this:

> 1. I'm using a Stored Proc on SQL server - I could possibly use a table,
but
> SP would be better.

> 2. Yes I thought this I was orignally using the sytax you suggest, this
> didn't work either, but as I am using NT authentication on the SQL side
> technically I don't have a username / password.  I put G:\ODBC\WTP SQL as
> the dsn as I was hoping to use one data source file on the server (G:\ODBC
> is a mapped server drive).  However, I have tried using the dsn locally
and
> this didn't work.

> All of these variants work on the development PC just not on another
network
> one.

> Cheers for all your help

> Steve

> > Just re-read your original message. I have got a few questions.

> > 1. Are you accessing a table on SQL Server or in an ACCESS database?

> > 2. If you are accessing the SQL Server, your use of SetLogOnInfo is
> > incorrect.

> > SetLogonInfo expects a servername/odbcdatasourcename, databasename,
> username
> > and password.

> > "G:\ODBC\WTP SQL" doesn't look like a server name or an ODBC data source
> > name.

> > > Thanks, but no joy!

> > > Mt database is WTP and my table is a SP called test, so I've tried
> > > Wtp.dbo.Test but I still get the 'Physical Database Not Found' error.

> > > Any other ideas?

> > > Steve

> > > > Before calling SetLogOnInfo, you need to set Table.Location
property.
> > For
> > > > SQL Server, the location property must be a fully qualified table
> name.
> > > > e.g., MyDatabase.dbo.MyTable

> > > > > Hi All,

> > > > > I have an Access 2000 adp that I want to use to view CR reports.
So
> > I'm
> > > > > using the CR viewer and the following code:

> > > > > Dim fcrApp As CRAXDRT.Application
> > > > > Dim fcrRpt As CRAXDRT.Report
> > > > > Dim strtest As String

> > > > > Set fcrApp = New CRAXDRT.Application
> > > > > Set fcrRpt = fcrApp.OpenReport("f:\IT\test.rpt")

> > > > > strtest = fcrRpt.Database.Tables.Count
> > > > > fcrRpt.Database.Tables(1).SetLogOnInfo "G:\ODBC\WTP SQL"

> > > > > CRViewer1.ReportSource = fcrRpt
> > > > > CRViewer1.ViewReport

> > > > > It works a treat on the same box as the SQL Server and CR are
> > installed
> > > > on.
> > > > > However I get the 'Physical Database Not Found' error when used on
> > > another
> > > > > machine on the network.

> > > > > It has the same drive mappings and I'm sure I've registered all
the
> > > .dll's
> > > > > etc.  Any help / ideas would be much appreciated.  Anyone know
more
> > > about
> > > > > this error?  Is it caused by an ODBC error normally?

> > > > > Thanks
> > > > > Steve

> I see that you are using file DSN. Though usually a file dsn would have
the
> format of DataSourceName.dsn, but yours is WTP SQL.

> In addition, you need to specify database name, even if you are using
> integrated security. Your code has only specified data source name.

> > Hi CW

> > Thanks for your help on this:

> > 1. I'm using a Stored Proc on SQL server - I could possibly use a table,
> but
> > SP would be better.

> > 2. Yes I thought this I was orignally using the sytax you suggest, this
> > didn't work either, but as I am using NT authentication on the SQL side
> > technically I don't have a username / password.  I put G:\ODBC\WTP SQL
as
> > the dsn as I was hoping to use one data source file on the server
(G:\ODBC
> > is a mapped server drive).  However, I have tried using the dsn locally
> and
> > this didn't work.

> > All of these variants work on the development PC just not on another
> network
> > one.

> > Cheers for all your help

> > Steve

> > > Just re-read your original message. I have got a few questions.

> > > 1. Are you accessing a table on SQL Server or in an ACCESS database?

> > > 2. If you are accessing the SQL Server, your use of SetLogOnInfo is
> > > incorrect.

> > > SetLogonInfo expects a servername/odbcdatasourcename, databasename,
> > username
> > > and password.

> > > "G:\ODBC\WTP SQL" doesn't look like a server name or an ODBC data
source
> > > name.

> > > > Thanks, but no joy!

> > > > Mt database is WTP and my table is a SP called test, so I've tried
> > > > Wtp.dbo.Test but I still get the 'Physical Database Not Found'
error.

> > > > Any other ideas?

> > > > Steve

> > > > > Before calling SetLogOnInfo, you need to set Table.Location
> property.
> > > For
> > > > > SQL Server, the location property must be a fully qualified table
> > name.
> > > > > e.g., MyDatabase.dbo.MyTable

> > > > > > Hi All,

> > > > > > I have an Access 2000 adp that I want to use to view CR reports.
> So
> > > I'm
> > > > > > using the CR viewer and the following code:

> > > > > > Dim fcrApp As CRAXDRT.Application
> > > > > > Dim fcrRpt As CRAXDRT.Report
> > > > > > Dim strtest As String

> > > > > > Set fcrApp = New CRAXDRT.Application
> > > > > > Set fcrRpt = fcrApp.OpenReport("f:\IT\test.rpt")

> > > > > > strtest = fcrRpt.Database.Tables.Count
> > > > > > fcrRpt.Database.Tables(1).SetLogOnInfo "G:\ODBC\WTP SQL"

> > > > > > CRViewer1.ReportSource = fcrRpt
> > > > > > CRViewer1.ViewReport

> > > > > > It works a treat on the same box as the SQL Server and CR are
> > > installed
> > > > > on.
> > > > > > However I get the 'Physical Database Not Found' error when used
on
> > > > another
> > > > > > machine on the network.

> > > > > > It has the same drive mappings and I'm sure I've registered all
> the
> > > > .dll's
> > > > > > etc.  Any help / ideas would be much appreciated.  Anyone know
> more
> > > > about
> > > > > > this error?  Is it caused by an ODBC error normally?

> > > > > > Thanks
> > > > > > Steve

> Hi,

> In desperation I have installed a very bare install of CR on the network
> computer.  It is now working OK.  This would leave me to believe it is a
dll
> issue.  I had crviewer.dll and craxdrt.dll registered.  To you knowledge
are
> there any others?

> Steve

> > I see that you are using file DSN. Though usually a file dsn would have
> the
> > format of DataSourceName.dsn, but yours is WTP SQL.

> > In addition, you need to specify database name, even if you are using
> > integrated security. Your code has only specified data source name.

> > > Hi CW

> > > Thanks for your help on this:

> > > 1. I'm using a Stored Proc on SQL server - I could possibly use a
table,
> > but
> > > SP would be better.

> > > 2. Yes I thought this I was orignally using the sytax you suggest,
this
> > > didn't work either, but as I am using NT authentication on the SQL
side
> > > technically I don't have a username / password.  I put G:\ODBC\WTP SQL
> as
> > > the dsn as I was hoping to use one data source file on the server
> (G:\ODBC
> > > is a mapped server drive).  However, I have tried using the dsn
locally
> > and
> > > this didn't work.

> > > All of these variants work on the development PC just not on another
> > network
> > > one.

> > > Cheers for all your help

> > > Steve

> > > > Just re-read your original message. I have got a few questions.

> > > > 1. Are you accessing a table on SQL Server or in an ACCESS database?

> > > > 2. If you are accessing the SQL Server, your use of SetLogOnInfo is
> > > > incorrect.

> > > > SetLogonInfo expects a servername/odbcdatasourcename, databasename,
> > > username
> > > > and password.

> > > > "G:\ODBC\WTP SQL" doesn't look like a server name or an ODBC data
> source
> > > > name.

> > > > > Thanks, but no joy!

> > > > > Mt database is WTP and my table is a SP called test, so I've tried
> > > > > Wtp.dbo.Test but I still get the 'Physical Database Not Found'
> error.

> > > > > Any other ideas?

> > > > > Steve

> > > > > > Before calling SetLogOnInfo, you need to set Table.Location
> > property.
> > > > For
> > > > > > SQL Server, the location property must be a fully qualified
table
> > > name.
> > > > > > e.g., MyDatabase.dbo.MyTable

> > > > > > > Hi All,

> > > > > > > I have an Access 2000 adp that I want to use to view CR
reports.
> > So
> > > > I'm
> > > > > > > using the CR viewer and the following code:

> > > > > > > Dim fcrApp As CRAXDRT.Application
> > > > > > > Dim fcrRpt As CRAXDRT.Report
> > > > > > > Dim strtest As String

> > > > > > > Set fcrApp = New CRAXDRT.Application
> > > > > > > Set fcrRpt = fcrApp.OpenReport("f:\IT\test.rpt")

> > > > > > > strtest = fcrRpt.Database.Tables.Count
> > > > > > > fcrRpt.Database.Tables(1).SetLogOnInfo "G:\ODBC\WTP SQL"

> > > > > > > CRViewer1.ReportSource = fcrRpt
> > > > > > > CRViewer1.ViewReport

> > > > > > > It works a treat on the same box as the SQL Server and CR are
> > > > installed
> > > > > > on.
> > > > > > > However I get the 'Physical Database Not Found' error when
used
> on
> > > > > another
> > > > > > > machine on the network.

> > > > > > > It has the same drive mappings and I'm sure I've registered
all
> > the
> > > > > .dll's
> > > > > > > etc.  Any help / ideas would be much appreciated.  Anyone know
> > more
> > > > > about
> > > > > > > this error?  Is it caused by an ODBC error normally?

> > > > > > > Thanks
> > > > > > > Steve

> Yeah, there are a large number of DLLs that are required by CR to run
> properly. Did you use MSI or PDW to include all the relevant run time
> libraries?

> > Hi,

> > In desperation I have installed a very bare install of CR on the network
> > computer.  It is now working OK.  This would leave me to believe it is a
> dll
> > issue.  I had crviewer.dll and craxdrt.dll registered.  To you knowledge
> are
> > there any others?

> > Steve

> > > I see that you are using file DSN. Though usually a file dsn would
have
> > the
> > > format of DataSourceName.dsn, but yours is WTP SQL.

> > > In addition, you need to specify database name, even if you are using
> > > integrated security. Your code has only specified data source name.

> > > > Hi CW

> > > > Thanks for your help on this:

> > > > 1. I'm using a Stored Proc on SQL server - I could possibly use a
> table,
> > > but
> > > > SP would be better.

> > > > 2. Yes I thought this I was orignally using the sytax you suggest,
> this
> > > > didn't work either, but as I am using NT authentication on the SQL
> side
> > > > technically I don't have a username / password.  I put G:\ODBC\WTP
SQL
> > as
> > > > the dsn as I was hoping to use one data source file on the server
> > (G:\ODBC
> > > > is a mapped server drive).  However, I have tried using the dsn
> locally
> > > and
> > > > this didn't work.

> > > > All of these variants work on the development PC just not on another
> > > network
> > > > one.

> > > > Cheers for all your help

> > > > Steve

> > > > > Just re-read your original message. I have got a few questions.

> > > > > 1. Are you accessing a table on SQL Server or in an ACCESS
database?

> > > > > 2. If you are accessing the SQL Server, your use of SetLogOnInfo
is
> > > > > incorrect.

> > > > > SetLogonInfo expects a servername/odbcdatasourcename,
databasename,
> > > > username
> > > > > and password.

> > > > > "G:\ODBC\WTP SQL" doesn't look like a server name or an ODBC data
> > source
> > > > > name.

> > > > > > Thanks, but no joy!

> > > > > > Mt database is WTP and my table is a SP called test, so I've
tried
> > > > > > Wtp.dbo.Test but I still get the 'Physical Database Not Found'
> > error.

> > > > > > Any other ideas?

> > > > > > Steve

> > > > > > > Before calling SetLogOnInfo, you need to set Table.Location
> > > property.
> > > > > For
> > > > > > > SQL Server, the location property must be a fully qualified
> table
> > > > name.
> > > > > > > e.g., MyDatabase.dbo.MyTable

> > > > > > > > Hi All,

> > > > > > > > I have an Access 2000 adp that I want to use to view CR
> reports.
> > > So
> > > > > I'm
> > > > > > > > using the CR viewer and the following code:

> > > > > > > > Dim fcrApp As CRAXDRT.Application
> > > > > > > > Dim fcrRpt As CRAXDRT.Report
> > > > > > > > Dim strtest As String

> > > > > > > > Set fcrApp = New CRAXDRT.Application
> > > > > > > > Set fcrRpt = fcrApp.OpenReport("f:\IT\test.rpt")

> > > > > > > > strtest = fcrRpt.Database.Tables.Count
> > > > > > > > fcrRpt.Database.Tables(1).SetLogOnInfo "G:\ODBC\WTP SQL"

> > > > > > > > CRViewer1.ReportSource = fcrRpt
> > > > > > > > CRViewer1.ViewReport

> > > > > > > > It works a treat on the same box as the SQL Server and CR
are
> > > > > installed
> > > > > > > on.
> > > > > > > > However I get the 'Physical Database Not Found' error when
> used
> > on
> > > > > > another
> > > > > > > > machine on the network.

> > > > > > > > It has the same drive mappings and I'm sure I've registered
> all
> > > the
> > > > > > .dll's
> > > > > > > > etc.  Any help / ideas would be much appreciated.  Anyone
know
> > > more
> > > > > > about
> > > > > > > > this error?  Is it caused by an ODBC error normally?

> > > > > > > > Thanks
> > > > > > > > Steve

> Ah!  This could be my problem - I just copied the two mentioned across.
> MSI? PDW? Please explain?

> Thanks - Really appreciate the help

> Steve

> > Yeah, there are a large number of DLLs that are required by CR to run
> > properly. Did you use MSI or PDW to include all the relevant run time
> > libraries?

> > > Hi,

> > > In desperation I have installed a very bare install of CR on the
network
> > > computer.  It is now working OK.  This would leave me to believe it is
a
> > dll
> > > issue.  I had crviewer.dll and craxdrt.dll registered.  To you
knowledge
> > are
> > > there any others?

> > > Steve

> > > > I see that you are using file DSN. Though usually a file dsn would
> have
> > > the
> > > > format of DataSourceName.dsn, but yours is WTP SQL.

> > > > In addition, you need to specify database name, even if you are
using
> > > > integrated security. Your code has only specified data source name.

> > > > > Hi CW

> > > > > Thanks for your help on this:

> > > > > 1. I'm using a Stored Proc on SQL server - I could possibly use a
> > table,
> > > > but
> > > > > SP would be better.

> > > > > 2. Yes I thought this I was orignally using the sytax you suggest,
> > this
> > > > > didn't work either, but as I am using NT authentication on the SQL
> > side
> > > > > technically I don't have a username / password.  I put G:\ODBC\WTP
> SQL
> > > as
> > > > > the dsn as I was hoping to use one data source file on the server
> > > (G:\ODBC
> > > > > is a mapped server drive).  However, I have tried using the dsn
> > locally
> > > > and
> > > > > this didn't work.

> > > > > All of these variants work on the development PC just not on
another
> > > > network
> > > > > one.

> > > > > Cheers for all your help

> > > > > Steve

> > > > > > Just re-read your original message. I have got a few questions.

> > > > > > 1. Are you accessing a table on SQL Server or in an ACCESS
> database?

> > > > > > 2. If you are accessing the SQL Server, your use of SetLogOnInfo
> is
> > > > > > incorrect.

> > > > > > SetLogonInfo expects a servername/odbcdatasourcename,
> databasename,
> > > > > username
> > > > > > and password.

> > > > > > "G:\ODBC\WTP SQL" doesn't look like a server name or an ODBC
data
> > > source
> > > > > > name.

> > > > > > > Thanks, but no joy!

> > > > > > > Mt database is WTP and my table is a SP called test, so I've
> tried
> > > > > > > Wtp.dbo.Test but I still get the 'Physical Database Not Found'
> > > error.

> > > > > > > Any other ideas?

> > > > > > > Steve

> > > > > > > > Before calling SetLogOnInfo, you need to set Table.Location
> > > > property.
> > > > > > For
> > > > > > > > SQL Server, the location property must be a fully qualified
> > table
> > > > > name.
> > > > > > > > e.g., MyDatabase.dbo.MyTable

> > > > > > > > > Hi All,

> > > > > > > > > I have an Access 2000 adp that I want to use to view CR
> > reports.
> > > > So
> > > > > > I'm
> > > > > > > > > using the CR viewer and the following code:

> > > > > > > > > Dim fcrApp As CRAXDRT.Application
> > > > > > > > > Dim fcrRpt As CRAXDRT.Report
> > > > > > > > > Dim strtest As String

> > > > > > > > > Set fcrApp = New CRAXDRT.Application
> > > > > > > > > Set fcrRpt = fcrApp.OpenReport("f:\IT\test.rpt")

> > > > > > > > > strtest = fcrRpt.Database.Tables.Count
> > > > > > > > > fcrRpt.Database.Tables(1).SetLogOnInfo "G:\ODBC\WTP SQL"

> > > > > > > > > CRViewer1.ReportSource = fcrRpt
> > > > > > > > > CRViewer1.ViewReport

> > > > > > > > > It works a treat on the same box as the SQL Server and CR
> are
> > > > > > installed
> > > > > > > > on.
> > > > > > > > > However I get the 'Physical Database Not Found' error when
> > used
> > > on
> > > > > > > another
> > > > > > > > > machine on the network.

> > > > > > > > > It has the same drive mappings and I'm sure I've
registered
> > all
> > > > the
> > > > > > > .dll's
> > > > > > > > > etc.  Any help / ideas would be much appreciated.  Anyone
> know
> > > > more
> > > > > > > about
> > > > > > > > > this error?  Is it caused by an ODBC error normally?

> > > > > > > > > Thanks
> > > > > > > > > Steve

> MSI = Microsoft Installer Service - preferred way to distribute VB app

> PDW = Package and Deployment Wizard

> You can't just copy the 2 DLLs. CRAXDRT and CRViewer have lots of
dependent
> dlls and its dependency is controlled by using various dep files. The
> version of CRAXDRT.dep supplied from CR 8.6 CD is invalid. You have to get
> the correction from CD support website.

> > Ah!  This could be my problem - I just copied the two mentioned across.
> > MSI? PDW? Please explain?

> > Thanks - Really appreciate the help

> > Steve

> > > Yeah, there are a large number of DLLs that are required by CR to run
> > > properly. Did you use MSI or PDW to include all the relevant run time
> > > libraries?

> > > > Hi,

> > > > In desperation I have installed a very bare install of CR on the
> network
> > > > computer.  It is now working OK.  This would leave me to believe it
is
> a
> > > dll
> > > > issue.  I had crviewer.dll and craxdrt.dll registered.  To you
> knowledge
> > > are
> > > > there any others?

> > > > Steve

> > > > > I see that you are using file DSN. Though usually a file dsn would
> > have
> > > > the
> > > > > format of DataSourceName.dsn, but yours is WTP SQL.

> > > > > In addition, you need to specify database name, even if you are
> using
> > > > > integrated security. Your code has only specified data source
name.

> > > > > > Hi CW

> > > > > > Thanks for your help on this:

> > > > > > 1. I'm using a Stored Proc on SQL server - I could possibly use
a
> > > table,
> > > > > but
> > > > > > SP would be better.

> > > > > > 2. Yes I thought this I was orignally using the sytax you
suggest,
> > > this
> > > > > > didn't work either, but as I am using NT authentication on the
SQL
> > > side
> > > > > > technically I don't have a username / password.  I put
G:\ODBC\WTP
> > SQL
> > > > as
> > > > > > the dsn as I was hoping to use one data source file on the
server
> > > > (G:\ODBC
> > > > > > is a mapped server drive).  However, I have tried using the dsn
> > > locally
> > > > > and
> > > > > > this didn't work.

> > > > > > All of these variants work on the development PC just not on
> another
> > > > > network
> > > > > > one.

> > > > > > Cheers for all your help

> > > > > > Steve

> > > > > > > Just re-read your original message. I have got a few
questions.

> > > > > > > 1. Are you accessing a table on SQL Server or in an ACCESS
> > database?

> > > > > > > 2. If you are accessing the SQL Server, your use of
SetLogOnInfo
> > is
> > > > > > > incorrect.

> > > > > > > SetLogonInfo expects a servername/odbcdatasourcename,
> > databasename,
> > > > > > username
> > > > > > > and password.

> > > > > > > "G:\ODBC\WTP SQL" doesn't look like a server name or an ODBC
> data
> > > > source
> > > > > > > name.

> > > > > > > > Thanks, but no joy!

> > > > > > > > Mt database is WTP and my table is a SP called test, so I've
> > tried
> > > > > > > > Wtp.dbo.Test but I still get the 'Physical Database Not
Found'
> > > > error.

> > > > > > > > Any other ideas?

> > > > > > > > Steve

> > > > > > > > > Before calling SetLogOnInfo, you need to set
Table.Location
> > > > > property.
> > > > > > > For
> > > > > > > > > SQL Server, the location property must be a fully
qualified
> > > table
> > > > > > name.
> > > > > > > > > e.g., MyDatabase.dbo.MyTable

> > > > > > > > > > Hi All,

> > > > > > > > > > I have an Access 2000 adp that I want to use to view CR
> > > reports.
> > > > > So
> > > > > > > I'm
> > > > > > > > > > using the CR viewer and the following code:

> > > > > > > > > > Dim fcrApp As CRAXDRT.Application
> > > > > > > > > > Dim fcrRpt As CRAXDRT.Report
> > > > > > > > > > Dim strtest As String

> > > > > > > > > > Set fcrApp = New CRAXDRT.Application
> > > > > > > > > > Set fcrRpt = fcrApp.OpenReport("f:\IT\test.rpt")

> > > > > > > > > > strtest = fcrRpt.Database.Tables.Count
> > > > > > > > > > fcrRpt.Database.Tables(1).SetLogOnInfo "G:\ODBC\WTP SQL"

> > > > > > > > > > CRViewer1.ReportSource = fcrRpt
> > > > > > > > > > CRViewer1.ViewReport

> > > > > > > > > > It works a treat on the same box as the SQL Server and
CR
> > are
> > > > > > > installed
> > > > > > > > > on.
> > > > > > > > > > However I get the 'Physical Database Not Found' error
when
> > > used
> > > > on
> > > > > > > > another
> > > > > > > > > > machine on the network.

> > > > > > > > > > It has the same drive mappings and I'm sure I've
> registered
> > > all
> > > > > the
> > > > > > > > .dll's
> > > > > > > > > > etc.  Any help / ideas would be much appreciated.
Anyone
> > know
> > > > > more
> > > > > > > > about
> > > > > > > > > > this error?  Is it caused by an ODBC error normally?

> > > > > > > > > > Thanks
> > > > > > > > > > Steve

> Thanks you've been a massive help!

> I will investigate both options fully.  How do I actally know what dll's
> anyway, is there somewhere in CR that lists them?

> Steve

> > MSI = Microsoft Installer Service - preferred way to distribute VB app

> > PDW = Package and Deployment Wizard

> > You can't just copy the 2 DLLs. CRAXDRT and CRViewer have lots of
> dependent
> > dlls and its dependency is controlled by using various dep files. The
> > version of CRAXDRT.dep supplied from CR 8.6 CD is invalid. You have to
get
> > the correction from CD support website.

> > > Ah!  This could be my problem - I just copied the two mentioned
across.
> > > MSI? PDW? Please explain?

> > > Thanks - Really appreciate the help

> > > Steve

> > > > Yeah, there are a large number of DLLs that are required by CR to
run
> > > > properly. Did you use MSI or PDW to include all the relevant run
time
> > > > libraries?

> > > > > Hi,

> > > > > In desperation I have installed a very bare install of CR on the
> > network
> > > > > computer.  It is now working OK.  This would leave me to believe
it
> is
> > a
> > > > dll
> > > > > issue.  I had crviewer.dll and craxdrt.dll registered.  To you
> > knowledge
> > > > are
> > > > > there any others?

> > > > > Steve

> > > > > > I see that you are using file DSN. Though usually a file dsn
would
> > > have
> > > > > the
> > > > > > format of DataSourceName.dsn, but yours is WTP SQL.

> > > > > > In addition, you need to specify database name, even if you are
> > using
> > > > > > integrated security. Your code has only specified data source
> name.

> > > > > > > Hi CW

> > > > > > > Thanks for your help on this:

> > > > > > > 1. I'm using a Stored Proc on SQL server - I could possibly
use
> a
> > > > table,
> > > > > > but
> > > > > > > SP would be better.

> > > > > > > 2. Yes I thought this I was orignally using the sytax you
> suggest,
> > > > this
> > > > > > > didn't work either, but as I am using NT authentication on the
> SQL
> > > > side
> > > > > > > technically I don't have a username / password.  I put
> G:\ODBC\WTP
> > > SQL
> > > > > as
> > > > > > > the dsn as I was hoping to use one data source file on the
> server
> > > > > (G:\ODBC
> > > > > > > is a mapped server drive).  However, I have tried using the
dsn
> > > > locally
> > > > > > and
> > > > > > > this didn't work.

> > > > > > > All of these variants work on the development PC just not on
> > another
> > > > > > network
> > > > > > > one.

> > > > > > > Cheers for all your help

> > > > > > > Steve

> > > > > > > > Just re-read your original message. I have got a few
> questions.

> > > > > > > > 1. Are you accessing a table on SQL Server or in an ACCESS
> > > database?

> > > > > > > > 2. If you are accessing the SQL Server, your use of
> SetLogOnInfo
> > > is
> > > > > > > > incorrect.

> > > > > > > > SetLogonInfo expects a servername/odbcdatasourcename,
> > > databasename,
> > > > > > > username
> > > > > > > > and password.

> > > > > > > > "G:\ODBC\WTP SQL" doesn't look like a server name or an ODBC
> > data
> > > > > source
> > > > > > > > name.

> > > > > > > > > Thanks, but no joy!

> > > > > > > > > Mt database is WTP and my table is a SP called test, so
I've
> > > tried
> > > > > > > > > Wtp.dbo.Test but I still get the 'Physical Database Not
> Found'
> > > > > error.

> > > > > > > > > Any other ideas?

> > > > > > > > > Steve

> > > > > > > > > > Before calling SetLogOnInfo, you need to set
> Table.Location
> > > > > > property.
> > > > > > > > For
> > > > > > > > > > SQL Server, the location property must be a fully
> qualified
> > > > table
> > > > > > > name.
> > > > > > > > > > e.g., MyDatabase.dbo.MyTable

> > > > > > > > > > > Hi All,

> > > > > > > > > > > I have an Access 2000 adp that I want to use to view
CR
> > > > reports.
> > > > > > So
> > > > > > > > I'm
> > > > > > > > > > > using the CR viewer and the following code:

> > > > > > > > > > > Dim fcrApp As CRAXDRT.Application
> > > > > > > > > > > Dim fcrRpt As CRAXDRT.Report
> > > > > > > > > > > Dim strtest As String

> > > > > > > > > > > Set fcrApp = New CRAXDRT.Application
> > > > > > > > > > > Set fcrRpt = fcrApp.OpenReport("f:\IT\test.rpt")

> > > > > > > > > > > strtest = fcrRpt.Database.Tables.Count
> > > > > > > > > > > fcrRpt.Database.Tables(1).SetLogOnInfo "G:\ODBC\WTP
SQL"

> > > > > > > > > > > CRViewer1.ReportSource = fcrRpt
> > > > > > > > > > > CRViewer1.ViewReport

> > > > > > > > > > > It works a treat on the same box as the SQL Server and
> CR
> > > are
> > > > > > > > installed
> > > > > > > > > > on.
> > > > > > > > > > > However I get the 'Physical Database Not Found' error
> when
> > > > used
> > > > > on
> > > > > > > > > another
> > > > > > > > > > > machine on the network.

> > > > > > > > > > > It has the same drive mappings and I'm sure I've
> > registered
> > > > all
> > > > > > the
> > > > > > > > > .dll's
> > > > > > > > > > > etc.  Any help / ideas would be much appreciated.
> Anyone
> > > know
> > > > > > more
> > > > > > > > > about
> > > > > > > > > > > this error?  Is it caused by an ODBC error normally?

> > > > > > > > > > > Thanks
> > > > > > > > > > > Steve