NO Guru to help me???

This is the remainder of Setting of database Dynamically to crystalreport
is it possible to set database (Oracle 9i) by front end VB6
dynamically to crystal reports
if Yes, How ?
thats all for nowHi, let me know if you are still looking for the solution of this problem ?|||hi

still I am waiting for the solution

can U help Me ?

THANKS|||Hi Vaibhav,

I have done it in PowerBuilder backend MS Sql server. From crystal's point of view it should be the same. I would like to understand the way you are doing it rightnow. If you could provide me sample code that would be great. According to me it's a very basic problem of Crystal ( switching of database and relevant tables) .

Thanks|||Hi
Thankx For reply

Actually i am having 100+reports
for all the Reports I am connecting my database through Set database option from crystal

if any time I wants to chage the database user for all the reports I have to change through set database option

Is there any easy to cchange the database user From VB 6.0

thanks and regards
vaibhav|||Hello Vaibhav,

This is how we have designed it in our app.

As soon as user logs in we store his UseID, Password and Database in session.

While retrieving report we reset connection object using following commands :

g_ole_crx_connection_info.deleteAll

// Add new connection
g_ole_crx_connection_info.add("DSN", "Xtreme Sample Database 9")
g_ole_crx_connection_info.add("Database", "C:\Program Files\Crystal Decisions\Crystal Reports 9\Samples\En\Databases\xtreme.mdb from session")
g_ole_crx_connection_info.add("User ID", "UID from session")
g_ole_crx_connection_info.add("Password", "PWD from session")

// Verify the database.
g_ole_crx_report.database.Verify

This of course is a PowerBuilder code but do u already have something like this in your VB application ? and is this acceptable ?

Thanks
:confused:

No Failover and client crashes ODBC DSN Setting for Failover in connection String

We have set up Mirroring with a witness server and everything works fine when we failover from the SQL Management console.

However, if we failover when our Maccola client is connected, the client blows up - clearly because it can no longer connect to the database.

The ODBC DSN used by the Maccola client shows a checkbox for the 'select a failover server' but the checkbox is grayed out.

Also the summary of settings for the DSN at the end of the wizard reveals that the failover to server (y/N) option is set to N.

The default setting for this DSN is 'populate the remaining values by querying the server' but it doesn't appear to be getting the settings for failover from the server or any other interactive DSN settings either. The server is clearly set for mirroring.

Another suspicious item is that the DSN cannot connect to the server with SA permissions, even though the server is set to mixed security and we use the correct authentication.

Is it possible that the client MACHINE is not authenticating with the domain or sql server properly. We are logged into the client with the domain account that is the SQL admin account on the sql server box.

We should be able to interact with the sql server settings through the ODBC DSN on the client shoulnd't we?

Are we missing a service pack on the client?

Thanks,

Kimball

Have you referred to Maccola vendor in this case about the compatibility, I would guess this is to with that drivers.

No Failover and client crashes ODBC DSN Setting for Failover in connection String

We have set up Mirroring with a witness server and everything works fine when we failover from the SQL Management console.

However, if we failover when our Maccola client is connected, the client blows up - clearly because it can no longer connect to the database.

The ODBC DSN used by the Maccola client shows a checkbox for the 'select a failover server' but the checkbox is grayed out.

Also the summary of settings for the DSN at the end of the wizard reveals that the failover to server (y/N) option is set to N.

The default setting for this DSN is 'populate the remaining values by querying the server' but it doesn't appear to be getting the settings for failover from the server or any other interactive DSN settings either. The server is clearly set for mirroring.

Another suspicious item is that the DSN cannot connect to the server with SA permissions, even though the server is set to mixed security and we use the correct authentication.

Is it possible that the client MACHINE is not authenticating with the domain or sql server properly. We are logged into the client with the domain account that is the SQL admin account on the sql server box.

We should be able to interact with the sql server settings through the ODBC DSN on the client shoulnd't we?

Are we missing a service pack on the client?

Thanks,

Kimball

Have you referred to Maccola vendor in this case about the compatibility, I would guess this is to with that drivers.

No entries show up in SQL Server Profiler trace

Hi,
I have inherited a SQL Server 2000 machine with 59 databases on it,
several of which I suspect are no longer used.
I am setting up a SQL Profiler trace to show me which databases are
still being accessed, and by which machine/user.
There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
7, 2000 and 2005.
The problem I'm encountering is this:
I start the Profiler trace on SQL Server machine A
>From my local machine's Query Analyzer, I then query a table in one of
the suspect databases on machine A, via a linked server entry in my
local SQL Server instance
None of this query activity against the database is logged in Profiler
on machine A
What am I missing?
Thanks in advance-
Jason
I figured it out. I am now monitoring the event class "Security
Audit->Audit Object Persmission Event", and bringing back the data
columns ObjectName, LoginName, and Hostname to know what's being looked
at, by whom, and from what machine.
JasonReber@.gmail.com wrote:
> Hi,
> I have inherited a SQL Server 2000 machine with 59 databases on it,
> several of which I suspect are no longer used.
> I am setting up a SQL Profiler trace to show me which databases are
> still being accessed, and by which machine/user.
> There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
> 7, 2000 and 2005.
> The problem I'm encountering is this:
> I start the Profiler trace on SQL Server machine A
> the suspect databases on machine A, via a linked server entry in my
> local SQL Server instance
> None of this query activity against the database is logged in Profiler
> on machine A
> What am I missing?
> Thanks in advance-
> Jason

No entries show up in SQL Server Profiler trace

Hi,
I have inherited a SQL Server 2000 machine with 59 databases on it,
several of which I suspect are no longer used.
I am setting up a SQL Profiler trace to show me which databases are
still being accessed, and by which machine/user.
There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
7, 2000 and 2005.
The problem I'm encountering is this:
I start the Profiler trace on SQL Server machine A
>From my local machine's Query Analyzer, I then query a table in one of
the suspect databases on machine A, via a linked server entry in my
local SQL Server instance
None of this query activity against the database is logged in Profiler
on machine A
What am I missing?
Thanks in advance-
JasonI figured it out. I am now monitoring the event class "Security
Audit->Audit Object Persmission Event", and bringing back the data
columns ObjectName, LoginName, and Hostname to know what's being looked
at, by whom, and from what machine.
JasonReber@.gmail.com wrote:
> Hi,
> I have inherited a SQL Server 2000 machine with 59 databases on it,
> several of which I suspect are no longer used.
> I am setting up a SQL Profiler trace to show me which databases are
> still being accessed, and by which machine/user.
> There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
> 7, 2000 and 2005.
> The problem I'm encountering is this:
> I start the Profiler trace on SQL Server machine A
> the suspect databases on machine A, via a linked server entry in my
> local SQL Server instance
> None of this query activity against the database is logged in Profiler
> on machine A
> What am I missing?
> Thanks in advance-
> Jason

No entries show up in SQL Server Profiler trace

Hi,
I have inherited a SQL Server 2000 machine with 59 databases on it,
several of which I suspect are no longer used.
I am setting up a SQL Profiler trace to show me which databases are
still being accessed, and by which machine/user.
There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
7, 2000 and 2005.
The problem I'm encountering is this:
I start the Profiler trace on SQL Server machine A
>From my local machine's Query Analyzer, I then query a table in one of
the suspect databases on machine A, via a linked server entry in my
local SQL Server instance
None of this query activity against the database is logged in Profiler
on machine A
What am I missing?
Thanks in advance-
JasonI figured it out. I am now monitoring the event class "Security
Audit->Audit Object Persmission Event", and bringing back the data
columns ObjectName, LoginName, and Hostname to know what's being looked
at, by whom, and from what machine.
JasonReber@.gmail.com wrote:
> Hi,
> I have inherited a SQL Server 2000 machine with 59 databases on it,
> several of which I suspect are no longer used.
> I am setting up a SQL Profiler trace to show me which databases are
> still being accessed, and by which machine/user.
> There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
> 7, 2000 and 2005.
> The problem I'm encountering is this:
> I start the Profiler trace on SQL Server machine A
> >From my local machine's Query Analyzer, I then query a table in one of
> the suspect databases on machine A, via a linked server entry in my
> local SQL Server instance
> None of this query activity against the database is logged in Profiler
> on machine A
> What am I missing?
> Thanks in advance-
> Jason

next run date

I am setting up a new job that will run weekly. However, after setting up the
job the "NEXT RUN DATE" does not display. If I set up this job on another
server this date does get displayed. What might be the reason for this
behavior?
Can you post the results of the following query here:
SELECT * FROM msdb..sysjobschedules s1
WHERE EXISTS ( SELECT * FROM msdb..sysjobs s2
WHERE s2.job_id = s1.job_id )
AND s2.name = <jobname> );
Replace <jobname> with the name of your job.
Anith
|||Hi,
Below are the results:
schedule_id job_id name
enabled
-- --
37 DE69831F-F6EA-4E71-89B3-6542F82A8D2F test1
freq_typefreq_intervalfreq_subday_typefreq_subday_interval
8 4 1 0
freq_relative_intervalfreq_recurrence_factor
active_start_dateactive_end_date
0 1 2008031099991231
active_start_timeactive_end_timenext_run_datenext_run_time
100000 235959 0 0
date_created
03/10/2008 15:27:27.27
"Anith Sen" wrote:

> Can you post the results of the following query here:
> SELECT * FROM msdb..sysjobschedules s1
> WHERE EXISTS ( SELECT * FROM msdb..sysjobs s2
> WHERE s2.job_id = s1.job_id )
> AND s2.name = <jobname> );
> Replace <jobname> with the name of your job.
> --
> Anith
>
>
|||I see that the next_run_date and next_run_time is not getting inserted into
the sysjobschedules table in msdb database after I create the job. What might
be the reason that this is not getting inserted? This works correctly on
other servers. Is this a permissions issue?
Thanks in advance.
"ronnie" wrote:
[vbcol=seagreen]
> Hi,
> Below are the results:
> schedule_id job_id name
> enabled
> -- --
> --
> 37 DE69831F-F6EA-4E71-89B3-6542F82A8D2F test1
> freq_typefreq_intervalfreq_subday_typefreq_subday_interval
> ----
> 8 4 1 0
> freq_relative_intervalfreq_recurrence_factor
> active_start_dateactive_end_date
> --
> 0 1 2008031099991231
>
> active_start_timeactive_end_timenext_run_datenext_run_time
> ----
> 100000 235959 0 0
>
> date_created
> --
> 03/10/2008 15:27:27.27
>
>
>
>
>
> "Anith Sen" wrote:

next run date

I am setting up a new job that will run weekly. However, after setting up the
job the "NEXT RUN DATE" does not display. If I set up this job on another
server this date does get displayed. What might be the reason for this
behavior?Can you post the results of the following query here:
SELECT * FROM msdb..sysjobschedules s1
WHERE EXISTS ( SELECT * FROM msdb..sysjobs s2
WHERE s2.job_id = s1.job_id )
AND s2.name = <jobname> );
Replace <jobname> with the name of your job.
--
Anith|||Hi,
Below are the results:
schedule_id job_id name
enabled
-- --
-- --
37 DE69831F-F6EA-4E71-89B3-6542F82A8D2F test 1
freq_type freq_interval freq_subday_type freq_subday_interval
-- -- -- --
8 4 1 0
freq_relative_interval freq_recurrence_factor
active_start_date active_end_date
-- --
-- --
0 1 20080310 99991231
active_start_time active_end_time next_run_date next_run_time
-- -- -- --
100000 235959 0 0
date_created
--
03/10/2008 15:27:27.27
"Anith Sen" wrote:
> Can you post the results of the following query here:
> SELECT * FROM msdb..sysjobschedules s1
> WHERE EXISTS ( SELECT * FROM msdb..sysjobs s2
> WHERE s2.job_id = s1.job_id )
> AND s2.name = <jobname> );
> Replace <jobname> with the name of your job.
> --
> Anith
>
>|||I see that the next_run_date and next_run_time is not getting inserted into
the sysjobschedules table in msdb database after I create the job. What might
be the reason that this is not getting inserted? This works correctly on
other servers. Is this a permissions issue?
Thanks in advance.
"ronnie" wrote:
> Hi,
> Below are the results:
> schedule_id job_id name
> enabled
> -- --
> -- --
> 37 DE69831F-F6EA-4E71-89B3-6542F82A8D2F test 1
> freq_type freq_interval freq_subday_type freq_subday_interval
> -- -- -- --
> 8 4 1 0
> freq_relative_interval freq_recurrence_factor
> active_start_date active_end_date
> -- --
> -- --
> 0 1 20080310 99991231
>
> active_start_time active_end_time next_run_date next_run_time
> -- -- -- --
> 100000 235959 0 0
>
> date_created
> --
> 03/10/2008 15:27:27.27
>
>
>
>
>
> "Anith Sen" wrote:
> > Can you post the results of the following query here:
> >
> > SELECT * FROM msdb..sysjobschedules s1
> > WHERE EXISTS ( SELECT * FROM msdb..sysjobs s2
> > WHERE s2.job_id = s1.job_id )
> > AND s2.name = <jobname> );
> >
> > Replace <jobname> with the name of your job.
> >
> > --
> > Anith
> >
> >
> >

newbie: setting up SQL MAIL

My system:
I have installed Sql Server 2000 on my server (MS windows server 2003
enterprise edtion)
In addition Exchange Server 2003 standard edition is installed on this
server.
Every users on my network, have an e-mail account in exchange
On the clients, every user have Outlook Express with a MAPI profile.
My problem is that when I in SqlServer properties specifies SQL Mail profile
and
push the Test-button I get this error message:
"Error 18025: xp_test_mapi_profile : failed with mail error 0x80040111".
And if I just push the Ok-button in the dialoge specifying SQL Mail profile.
I get this message:
"The MAPI profile was not found on the server, Are you this is what you
want?" (yes/no-button)
The profile name i specified is used in Outllook express to send email using
MAPI...
so why do I get this error..'?. (remember I'm a newbie)
Eh, I know that running Exchange and SqlServer on the same server is not a
good thing,
slow performance..etc... I´d setup this system in the porpose of learning
about
sqlserver&exchange&win2k3server...
JeffI was sure that a MAPI-compliant client, such as Outlook, had to be
installed *on* the SQL Server machine, and that it had to use an account
that SQL Server was privy to...
I think there's a way to make it work with Outlook Express, but I'm not sure
it's supported.
Maybe some helpful links here (including the possibility of using SMTP
instead of Exchange/MAPI/SQL Mail)?
http://www.aspfaq.com/2403
"Jeff" <it_consultant1@.hotmail.com> wrote in message
news:uQeBHVweDHA.3528@.tk2msftngp13.phx.gbl...
> My system:
> I have installed Sql Server 2000 on my server (MS windows server 2003
> enterprise edtion)
> In addition Exchange Server 2003 standard edition is installed on this
> server.
> Every users on my network, have an e-mail account in exchange
> On the clients, every user have Outlook Express with a MAPI profile.
> My problem is that when I in SqlServer properties specifies SQL Mail
profile
> and
> push the Test-button I get this error message:
> "Error 18025: xp_test_mapi_profile : failed with mail error 0x80040111".
> And if I just push the Ok-button in the dialoge specifying SQL Mail
profile.
> I get this message:
> "The MAPI profile was not found on the server, Are you this is what you
> want?" (yes/no-button)
> The profile name i specified is used in Outllook express to send email
using
> MAPI...
> so why do I get this error..'?. (remember I'm a newbie)
> Eh, I know that running Exchange and SqlServer on the same server is not a
> good thing,
> slow performance..etc... I´d setup this system in the porpose of learning
> about
> sqlserver&exchange&win2k3server...
> Jeff
>
>|||If you continue to have problems try smtp mail. It's much simpler and more
reliable than mapi.
http://sqldev.net/xp/xpsmtp.htm
Paul
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23XB1%23pyeDHA.1748@.TK2MSFTNGP10.phx.gbl...
> I was sure that a MAPI-compliant client, such as Outlook, had to be
> installed *on* the SQL Server machine, and that it had to use an account
> that SQL Server was privy to...
> I think there's a way to make it work with Outlook Express, but I'm not
sure
> it's supported.
> Maybe some helpful links here (including the possibility of using SMTP
> instead of Exchange/MAPI/SQL Mail)?
> http://www.aspfaq.com/2403
>
>
> "Jeff" <it_consultant1@.hotmail.com> wrote in message
> news:uQeBHVweDHA.3528@.tk2msftngp13.phx.gbl...
> > My system:
> > I have installed Sql Server 2000 on my server (MS windows server 2003
> > enterprise edtion)
> > In addition Exchange Server 2003 standard edition is installed on this
> > server.
> >
> > Every users on my network, have an e-mail account in exchange
> >
> > On the clients, every user have Outlook Express with a MAPI profile.
> >
> > My problem is that when I in SqlServer properties specifies SQL Mail
> profile
> > and
> > push the Test-button I get this error message:
> > "Error 18025: xp_test_mapi_profile : failed with mail error
0x80040111".
> >
> > And if I just push the Ok-button in the dialoge specifying SQL Mail
> profile.
> > I get this message:
> > "The MAPI profile was not found on the server, Are you this is what you
> > want?" (yes/no-button)
> >
> > The profile name i specified is used in Outllook express to send email
> using
> > MAPI...
> >
> > so why do I get this error..'?. (remember I'm a newbie)
> >
> > Eh, I know that running Exchange and SqlServer on the same server is not
a
> > good thing,
> > slow performance..etc... I´d setup this system in the porpose of
learning
> > about
> > sqlserver&exchange&win2k3server...
> >
> > Jeff
> >
> >
> >
>