Run-time error (R6009)

I installed a program that put Microsoft SQL Server on my system, Windows XP. The next day I tried to load a MSDOS Database program, Nutplus (Ultrapls), now I get a Run-Time error, R6009. The program will not load. Please help!!!!!, Thank you in advance.This seems to be a third party application and if your query is not related to SQL Server then approach vendor for suitable fix.

Running the related program on the save server as the database

Hello Community
I have a question relating to the recommended setup of the sql server. We
use sage with sql backend, both running on the same server. we are
experiencing major performance degradation over the WAN but not on the LAN,
the sage support are blaming the network, i am blaming the server, as when we
reboot the server the performance picks up again over a period of 10 days the
performance dies.
I am asking of there are known issues running the program on the same server
as the database.
Regards
Andy
Andy
In general it is recomended to have a server dedicated to SQL Server only.
"Andy" <Andy@.discussions.microsoft.com> wrote in message
news:71F12DDD-D3D4-4274-AAFB-0AC850B4CC24@.microsoft.com...
> Hello Community
> I have a question relating to the recommended setup of the sql server. We
> use sage with sql backend, both running on the same server. we are
> experiencing major performance degradation over the WAN but not on the
> LAN,
> the sage support are blaming the network, i am blaming the server, as when
> we
> reboot the server the performance picks up again over a period of 10 days
> the
> performance dies.
> I am asking of there are known issues running the program on the same
> server
> as the database.
> Regards
> Andy
|||If you are seeing poor performance over the WAN at the same time the LAN is
performing adequately then Sage is probably correct that you have a network
issue.
As far as running SQL and the application on the same server... I know the
*recommended* practice is to dedicate a server to SQL, but realistically
that costs $$$. As long as the two applications are not bumping into each
other and causing memory, disk, or processor contention then they should be
ok on the same server. The only way to tell is to fire up perfmon and let
it run for a while and see if your server is running short on anything.
"Andy" <Andy@.discussions.microsoft.com> wrote in message
news:71F12DDD-D3D4-4274-AAFB-0AC850B4CC24@.microsoft.com...
> Hello Community
> I have a question relating to the recommended setup of the sql server. We
> use sage with sql backend, both running on the same server. we are
> experiencing major performance degradation over the WAN but not on the
> LAN,
> the sage support are blaming the network, i am blaming the server, as when
> we
> reboot the server the performance picks up again over a period of 10 days
> the
> performance dies.
> I am asking of there are known issues running the program on the same
> server
> as the database.
> Regards
> Andy
sql

Running the related program on the save server as the database

Hello Community
I have a question relating to the recommended setup of the sql server. We
use sage with sql backend, both running on the same server. we are
experiencing major performance degradation over the WAN but not on the LAN,
the sage support are blaming the network, i am blaming the server, as when we
reboot the server the performance picks up again over a period of 10 days the
performance dies.
I am asking of there are known issues running the program on the same server
as the database.
Regards
AndyAndy
In general it is recomended to have a server dedicated to SQL Server only.
"Andy" <Andy@.discussions.microsoft.com> wrote in message
news:71F12DDD-D3D4-4274-AAFB-0AC850B4CC24@.microsoft.com...
> Hello Community
> I have a question relating to the recommended setup of the sql server. We
> use sage with sql backend, both running on the same server. we are
> experiencing major performance degradation over the WAN but not on the
> LAN,
> the sage support are blaming the network, i am blaming the server, as when
> we
> reboot the server the performance picks up again over a period of 10 days
> the
> performance dies.
> I am asking of there are known issues running the program on the same
> server
> as the database.
> Regards
> Andy|||If you are seeing poor performance over the WAN at the same time the LAN is
performing adequately then Sage is probably correct that you have a network
issue.
As far as running SQL and the application on the same server... I know the
*recommended* practice is to dedicate a server to SQL, but realistically
that costs $$$. As long as the two applications are not bumping into each
other and causing memory, disk, or processor contention then they should be
ok on the same server. The only way to tell is to fire up perfmon and let
it run for a while and see if your server is running short on anything.
"Andy" <Andy@.discussions.microsoft.com> wrote in message
news:71F12DDD-D3D4-4274-AAFB-0AC850B4CC24@.microsoft.com...
> Hello Community
> I have a question relating to the recommended setup of the sql server. We
> use sage with sql backend, both running on the same server. we are
> experiencing major performance degradation over the WAN but not on the
> LAN,
> the sage support are blaming the network, i am blaming the server, as when
> we
> reboot the server the performance picks up again over a period of 10 days
> the
> performance dies.
> I am asking of there are known issues running the program on the same
> server
> as the database.
> Regards
> Andy

Running the related program on the save server as the database

Hello Community
I have a question relating to the recommended setup of the sql server. We
use sage with sql backend, both running on the same server. we are
experiencing major performance degradation over the WAN but not on the LAN,
the sage support are blaming the network, i am blaming the server, as when w
e
reboot the server the performance picks up again over a period of 10 days th
e
performance dies.
I am asking of there are known issues running the program on the same server
as the database.
Regards
AndyAndy
In general it is recomended to have a server dedicated to SQL Server only.
"Andy" <Andy@.discussions.microsoft.com> wrote in message
news:71F12DDD-D3D4-4274-AAFB-0AC850B4CC24@.microsoft.com...
> Hello Community
> I have a question relating to the recommended setup of the sql server. We
> use sage with sql backend, both running on the same server. we are
> experiencing major performance degradation over the WAN but not on the
> LAN,
> the sage support are blaming the network, i am blaming the server, as when
> we
> reboot the server the performance picks up again over a period of 10 days
> the
> performance dies.
> I am asking of there are known issues running the program on the same
> server
> as the database.
> Regards
> Andy|||If you are seeing poor performance over the WAN at the same time the LAN is
performing adequately then Sage is probably correct that you have a network
issue.
As far as running SQL and the application on the same server... I know the
*recommended* practice is to dedicate a server to SQL, but realistically
that costs $$$. As long as the two applications are not bumping into each
other and causing memory, disk, or processor contention then they should be
ok on the same server. The only way to tell is to fire up perfmon and let
it run for a while and see if your server is running short on anything.
"Andy" <Andy@.discussions.microsoft.com> wrote in message
news:71F12DDD-D3D4-4274-AAFB-0AC850B4CC24@.microsoft.com...
> Hello Community
> I have a question relating to the recommended setup of the sql server. We
> use sage with sql backend, both running on the same server. we are
> experiencing major performance degradation over the WAN but not on the
> LAN,
> the sage support are blaming the network, i am blaming the server, as when
> we
> reboot the server the performance picks up again over a period of 10 days
> the
> performance dies.
> I am asking of there are known issues running the program on the same
> server
> as the database.
> Regards
> Andy

Running SQL Scripts from VB

HI All,
I think I am posting this to the right group , If not Please Ignore .
Does anyone know how to run a Sql script from a VB Program . My
requirement is something like this : From my VB Code , I need to
execute a sql script which will internally create a Temporary Stored
Procedure . This Stored Procedure has one column that gets filled up
with the further processing of the sql script . Later on I need to
select all the rows from this proc ( if any ) .
Kindly , Post reply if solution is known to anyone of you .
Thanks In advance ,
triveni
Hi
"triveni504@.gmail.com" wrote:

> HI All,
> I think I am posting this to the right group , If not Please Ignore .
> Does anyone know how to run a Sql script from a VB Program . My
> requirement is something like this : From my VB Code , I need to
> execute a sql script which will internally create a Temporary Stored
> Procedure . This Stored Procedure has one column that gets filled up
> with the further processing of the sql script . Later on I need to
> select all the rows from this proc ( if any ) .
> Kindly , Post reply if solution is known to anyone of you .
> Thanks In advance ,
> triveni
>
You can look at the ADO examples that come with SQL Server see
http://msdn2.microsoft.com/en-us/library/aa173708(SQL.80).aspx regarding
where they can be found.
Your terminology does not seem correct I assume that you want to create a
temporary table. If there is a large number of statements in your script you
may want to encapsulate this in a stored procedure and just execute that from
your code. This will reduce the amount of network traffic and will also allow
you to implement some error handling.
John

Running SQL Scripts from VB

HI All,
I think I am posting this to the right group , If not Please Ignore .
Does anyone know how to run a Sql script from a VB Program . My
requirement is something like this : From my VB Code , I need to
execute a sql script which will internally create a Temporary Stored
Procedure . This Stored Procedure has one column that gets filled up
with the further processing of the sql script . Later on I need to
select all the rows from this proc ( if any ) .
Kindly , Post reply if solution is known to anyone of you .
Thanks In advance ,
triveniHi
"triveni504@.gmail.com" wrote:
> HI All,
> I think I am posting this to the right group , If not Please Ignore .
> Does anyone know how to run a Sql script from a VB Program . My
> requirement is something like this : From my VB Code , I need to
> execute a sql script which will internally create a Temporary Stored
> Procedure . This Stored Procedure has one column that gets filled up
> with the further processing of the sql script . Later on I need to
> select all the rows from this proc ( if any ) .
> Kindly , Post reply if solution is known to anyone of you .
> Thanks In advance ,
> triveni
>
You can look at the ADO examples that come with SQL Server see
http://msdn2.microsoft.com/en-us/library/aa173708(SQL.80).aspx regarding
where they can be found.
Your terminology does not seem correct I assume that you want to create a
temporary table. If there is a large number of statements in your script you
may want to encapsulate this in a stored procedure and just execute that from
your code. This will reduce the amount of network traffic and will also allow
you to implement some error handling.
John

Running SQL Scripts from VB

HI All,
I think I am posting this to the right group , If not Please Ignore .
Does anyone know how to run a Sql script from a VB Program . My
requirement is something like this : From my VB Code , I need to
execute a sql script which will internally create a Temporary Stored
Procedure . This Stored Procedure has one column that gets filled up
with the further processing of the sql script . Later on I need to
select all the rows from this proc ( if any ) .
Kindly , Post reply if solution is known to anyone of you .
Thanks In advance ,
triveniHi
"triveni504@.gmail.com" wrote:

> HI All,
> I think I am posting this to the right group , If not Please Ignore .
> Does anyone know how to run a Sql script from a VB Program . My
> requirement is something like this : From my VB Code , I need to
> execute a sql script which will internally create a Temporary Stored
> Procedure . This Stored Procedure has one column that gets filled up
> with the further processing of the sql script . Later on I need to
> select all the rows from this proc ( if any ) .
> Kindly , Post reply if solution is known to anyone of you .
> Thanks In advance ,
> triveni
>
You can look at the ADO examples that come with SQL Server see
http://msdn2.microsoft.com/en-us/library/aa173708(SQL.80).aspx regarding
where they can be found.
Your terminology does not seem correct I assume that you want to create a
temporary table. If there is a large number of statements in your script you
may want to encapsulate this in a stored procedure and just execute that fro
m
your code. This will reduce the amount of network traffic and will also allo
w
you to implement some error handling.
John