link to oracle error

Hi
I am connecting from SQL server 2000 to oracle 9i.
I used following command and entry in tnsnames.ora file.
I am unable to run 2 select queries parallely from SQL server to oracle.
It throws me this error message.
I am amble to insert, delete. select from one connection without any errors.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Oracle error occurred, but error message
could not be retrieved from Oracle.]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005: ].
Links created by
sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'
Presumptively, your Oracle server is e2.
1- We/I will need to see the tnsnames.ora entry- it is possible the
parameter should be 'e2.world' or similar and not just 'e2'
2- Is your %Oracle_Home% environmental variable set
3- is the Oracle Listener looking for the 'e2' as the service name on it's
server?
Joseph R.P. Maloney, CSP,CCP,CDP
"Mangesh Deshpande" wrote:

> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any errors.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error message
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'
|||Hi,
Have you had a look in the Knowledge base?
http://support.microsoft.com/default...b;en-us;280106
http://support.microsoft.com/default...b;en-us;814398
Regards
"Mangesh Deshpande" wrote:

> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any errors.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error message
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'
sql

link to oracle error

Hi
I am connecting from SQL server 2000 to oracle 9i.
I used following command and entry in tnsnames.ora file.
I am unable to run 2 select queries parallely from SQL server to oracle.
It throws me this error message.
I am amble to insert, delete. select from one connection without any errors.
--
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Oracle error occurred, but error message
could not be retrieved from Oracle.]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005: ].
--
Links created by
sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'Presumptively, your Oracle server is e2.
1- We/I will need to see the tnsnames.ora entry- it is possible the
parameter should be 'e2.world' or similar and not just 'e2'
2- Is your %Oracle_Home% environmental variable set
3- is the Oracle Listener looking for the 'e2' as the service name on it's
server?
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Mangesh Deshpande" wrote:
> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any errors.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error message
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'|||Hi,
Have you had a look in the Knowledge base?
http://support.microsoft.com/default.aspx?scid=kb;en-us;280106
http://support.microsoft.com/default.aspx?scid=kb;en-us;814398
Regards
"Mangesh Deshpande" wrote:
> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any errors.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error message
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'

link to oracle error

Hi
I am connecting from SQL server 2000 to oracle 9i.
I used following command and entry in tnsnames.ora file.
I am unable to run 2 select queries parallely from SQL server to oracle.
It throws me this error message.
I am amble to insert, delete. select from one connection without any errors.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Oracle error occurred, but error mess
age
could not be retrieved from Oracle.]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005: ].
--
Links created by
sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'Presumptively, your Oracle server is e2.
1- We/I will need to see the tnsnames.ora entry- it is possible the
parameter should be 'e2.world' or similar and not just 'e2'
2- Is your %Oracle_Home% environmental variable set
3- is the Oracle Listener looking for the 'e2' as the service name on it's
server?
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Mangesh Deshpande" wrote:

> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any error
s.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error me
ssage
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initializ
e
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'|||Hi,
Have you had a look in the Knowledge base?
http://support.microsoft.com/defaul...kb;en-us;280106
http://support.microsoft.com/defaul...kb;en-us;814398
Regards
"Mangesh Deshpande" wrote:

> Hi
> I am connecting from SQL server 2000 to oracle 9i.
> I used following command and entry in tnsnames.ora file.
> I am unable to run 2 select queries parallely from SQL server to oracle.
> It throws me this error message.
> I am amble to insert, delete. select from one connection without any error
s.
> --
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: Oracle error occurred, but error me
ssage
> could not be retrieved from Oracle.]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initializ
e
> returned 0x80004005: ].
> --
> Links created by
> sp_addlinkedserver 'e2', 'Oracle', 'MSDAORA', 'production'
> sp_addlinkedsrvlogin 'e2', false, 'amnon', 'offshore','offtest34'

Link to Oracle database

Hi all,
I have installed Oracle client tool on the SQL server and have checked the tns file. Everythings look fine, even from the server I can run SQL Plus and connect to the Oracle database. When I create a link and try to refresh tables under linked serve, I ge
t this error: Error 7399:OLE DB provider 'MSDAORA' reported an error. I reinstalled MDAC 2.8, but I get the same error.
Any help would be appreciated.
Shahri
That's a generic error. Try turning on trace flag 7300 or
us SQL Profiler to capture the OLEDB Errors event. This
should give you to get more information about the error.
Additionally, you'll want to check the following article:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106
-Sue
On Wed, 16 Jun 2004 08:43:37 -0700, Shahri
<Shahri@.discussions.microsoft.com> wrote:

>Hi all,
>I have installed Oracle client tool on the SQL server and have checked the tns file. Everythings look fine, even from the server I can run SQL Plus and connect to the Oracle database. When I create a link and try to refresh tables under linked serve, I g
et this error: Error 7399:OLE DB provider 'MSDAORA' reported an error. I reinstalled MDAC 2.8, but I get the same error.
>Any help would be appreciated.
>Shahri

Link to Oracle database

Hi all,
I have installed Oracle client tool on the SQL server and have checked the t
ns file. Everythings look fine, even from the server I can run SQL Plus and
connect to the Oracle database. When I create a link and try to refresh tabl
es under linked serve, I ge
t this error: Error 7399:OLE DB provider 'MSDAORA' reported an error. I rein
stalled MDAC 2.8, but I get the same error.
Any help would be appreciated.
ShahriThat's a generic error. Try turning on trace flag 7300 or
us SQL Profiler to capture the OLEDB Errors event. This
should give you to get more information about the error.
Additionally, you'll want to check the following article:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106
-Sue
On Wed, 16 Jun 2004 08:43:37 -0700, Shahri
<Shahri@.discussions.microsoft.com> wrote:

>Hi all,
>I have installed Oracle client tool on the SQL server and have checked the tns file
. Everythings look fine, even from the server I can run SQL Plus and connect to the
Oracle database. When I create a link and try to refresh tables under linked serve,
I g
et this error: Error 7399:OLE DB provider 'MSDAORA' reported an error. I reinstalled MDAC 2.
8, but I get the same error.
>Any help would be appreciated.
>Shahri

Link to dbf file

Hi. I have a dbf file that has about 1.2 million lines of
data. That file is produced by another system's
proecesses. I'm wondering if there's a way for me to link
my SQL Server database to that file? Any suggestions would
be great. Thanks!
dbf file is: M:\Data\Shipped.dbfHi,
Yes, it is possible.
You can create a linked server from the Enterprise Manager (EM). Please try
the steps.
1. Create an ODBC DSN for the .dbf file by using 'ODBC Data Source
Administrator' in Administarive tools.
2. Select Microsoft OLE Provider for ODBC drivers to create a new linked
server. You should specify the datasource and catalog in the boxes.
3. In security tab, you should configure it to access this .dbf file
without problem.
You can do the same using TSQL, Have a look into the below link, You have
various options to connect to DBase and Foxpro dbf files.
http://groups.google.co.in/groups?q...le&hl=en&lr=&ie
=UTF-8&oe=UTF-8&selm=VA.0000447d.0110b58c%40compuserve.com&rnum=7
Thanks
Hari
MCDBA
"mj" <anonymous@.discussions.microsoft.com> wrote in message
news:133ab01c411ed$1a65b150$a101280a@.phx
.gbl...
> Hi. I have a dbf file that has about 1.2 million lines of
> data. That file is produced by another system's
> proecesses. I'm wondering if there's a way for me to link
> my SQL Server database to that file? Any suggestions would
> be great. Thanks!
> dbf file is: M:\Data\Shipped.dbf
>

Link to dbf file

Hi. I have a dbf file that has about 1.2 million lines of
data. That file is produced by another system's
proecesses. I'm wondering if there's a way for me to link
my SQL Server database to that file? Any suggestions would
be great. Thanks!
dbf file is: M:\Data\Shipped.dbf
Hi,
Yes, it is possible.
You can create a linked server from the Enterprise Manager (EM). Please try
the steps.
1. Create an ODBC DSN for the .dbf file by using 'ODBC Data Source
Administrator' in Administarive tools.
2. Select Microsoft OLE Provider for ODBC drivers to create a new linked
server. You should specify the datasource and catalog in the boxes.
3. In security tab, you should configure it to access this .dbf file
without problem.
You can do the same using TSQL, Have a look into the below link, You have
various options to connect to DBase and Foxpro dbf files.
http://groups.google.co.in/groups?q=...e&hl=en&lr=&ie
=UTF-8&oe=UTF-8&selm=VA.0000447d.0110b58c%40compuserve.com&rnum= 7
Thanks
Hari
MCDBA
"mj" <anonymous@.discussions.microsoft.com> wrote in message
news:133ab01c411ed$1a65b150$a101280a@.phx.gbl...
> Hi. I have a dbf file that has about 1.2 million lines of
> data. That file is produced by another system's
> proecesses. I'm wondering if there's a way for me to link
> my SQL Server database to that file? Any suggestions would
> be great. Thanks!
> dbf file is: M:\Data\Shipped.dbf
>

LINK REMOTE SQL SERVER 2000 Database

I have a local mdb file and remote sql server 2000 database..
i know only my remote table user name and password...
my mdb file and sql database are same...
I tried to link my remote database
I click link table and odbc from my mdb...
i choose machine data source and new ...
i choose sql server and i write my server ip and click next...
i write my database username and password but it failss.
how can i link my remotet sql server 2000 database? what is my fault...
?Hi
This sounds like you are using access? In which case you may have a better
response in an access newsgroup.
If you are using an ODBC data source then you may need to set up a system
DSN in the ODBC configuration applet found in the Administrators menu.
If this is a remote database that you are connecting to, then you will need
to make sure that any firewalls/routers are not blocking access to this
server.
Posting the full error number and message will help.
John
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:%23UZZ1ehMFHA.4028@.tk2msftngp13.phx.gbl...
>I have a local mdb file and remote sql server 2000 database..
> i know only my remote table user name and password...
> my mdb file and sql database are same...
> I tried to link my remote database
> I click link table and odbc from my mdb...
> i choose machine data source and new ...
> i choose sql server and i write my server ip and click next...
> i write my database username and password but it failss.
> how can i link my remotet sql server 2000 database? what is my fault...
> ?
>

LINK REMOTE SQL SERVER 2000 Database

I have a local mdb file and remote sql server 2000 database..
i know only my remote table user name and password...
my mdb file and sql database are same...
I tried to link my remote database
I click link table and odbc from my mdb...
i choose machine data source and new ...
i choose sql server and i write my server ip and click next...
i write my database username and password but it failss.
how can i link my remotet sql server 2000 database? what is my fault...
?You may need to setup a dsn on your own computer that points to the SQL
Server database. Be aware that if you are not the Administrator for this
database, you may not have the permissions needed to link a table from this
SQL Server to your mdb database. This is for good reason as this could give
you privileges that you are not authorized to have. I would contact the SQL
Server database administrator.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:%23Pm15dhMFHA.3988@.tk2msftngp13.phx.gbl...
>I have a local mdb file and remote sql server 2000 database..
> i know only my remote table user name and password...
> my mdb file and sql database are same...
> I tried to link my remote database
> I click link table and odbc from my mdb...
> i choose machine data source and new ...
> i choose sql server and i write my server ip and click next...
> i write my database username and password but it failss.
> how can i link my remotet sql server 2000 database? what is my fault...
> ?
>
>
>sql

LINK REMOTE SQL SERVER 2000 Database

I have a local mdb file and remote sql server 2000 database..
i know only my remote table user name and password...
my mdb file and sql database are same...
I tried to link my remote database
I click link table and odbc from my mdb...
i choose machine data source and new ...
i choose sql server and i write my server ip and click next...
i write my database username and password but it failss.
how can i link my remotet sql server 2000 database? what is my fault...
?You may need to setup a dsn on your own computer that points to the SQL
Server database. Be aware that if you are not the Administrator for this
database, you may not have the permissions needed to link a table from this
SQL Server to your mdb database. This is for good reason as this could give
you privileges that you are not authorized to have. I would contact the SQL
Server database administrator.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:%23Pm15dhMFHA.3988@.tk2msftngp13.phx.gbl...
>I have a local mdb file and remote sql server 2000 database..
> i know only my remote table user name and password...
> my mdb file and sql database are same...
> I tried to link my remote database
> I click link table and odbc from my mdb...
> i choose machine data source and new ...
> i choose sql server and i write my server ip and click next...
> i write my database username and password but it failss.
> how can i link my remotet sql server 2000 database? what is my fault...
> ?
>
>
>

LINK REMOTE SQL SERVER 2000 Database

I have a local mdb file and remote sql server 2000 database..
i know only my remote table user name and password...
my mdb file and sql database are same...
I tried to link my remote database
I click link table and odbc from my mdb...
i choose machine data source and new ...
i choose sql server and i write my server ip and click next...
i write my database username and password but it failss.
how can i link my remotet sql server 2000 database? what is my fault...
?
Hi
This sounds like you are using access? In which case you may have a better
response in an access newsgroup.
If you are using an ODBC data source then you may need to set up a system
DSN in the ODBC configuration applet found in the Administrators menu.
If this is a remote database that you are connecting to, then you will need
to make sure that any firewalls/routers are not blocking access to this
server.
Posting the full error number and message will help.
John
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:%23UZZ1ehMFHA.4028@.tk2msftngp13.phx.gbl...
>I have a local mdb file and remote sql server 2000 database..
> i know only my remote table user name and password...
> my mdb file and sql database are same...
> I tried to link my remote database
> I click link table and odbc from my mdb...
> i choose machine data source and new ...
> i choose sql server and i write my server ip and click next...
> i write my database username and password but it failss.
> how can i link my remotet sql server 2000 database? what is my fault...
> ?
>

LINK REMOTE SQL SERVER 2000 Database

I have a local mdb file and remote sql server 2000 database..
i know only my remote table user name and password...
my mdb file and sql database are same...
I tried to link my remote database
I click link table and odbc from my mdb...
i choose machine data source and new ...
i choose sql server and i write my server ip and click next...
i write my database username and password but it failss.
how can i link my remotet sql server 2000 database? what is my fault...
?
You may need to setup a dsn on your own computer that points to the SQL
Server database. Be aware that if you are not the Administrator for this
database, you may not have the permissions needed to link a table from this
SQL Server to your mdb database. This is for good reason as this could give
you privileges that you are not authorized to have. I would contact the SQL
Server database administrator.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:%23Pm15dhMFHA.3988@.tk2msftngp13.phx.gbl...
>I have a local mdb file and remote sql server 2000 database..
> i know only my remote table user name and password...
> my mdb file and sql database are same...
> I tried to link my remote database
> I click link table and odbc from my mdb...
> i choose machine data source and new ...
> i choose sql server and i write my server ip and click next...
> i write my database username and password but it failss.
> how can i link my remotet sql server 2000 database? what is my fault...
> ?
>
>
>

LINK REMOTE SQL SERVER 2000 Database

I have a local mdb file and remote sql server 2000 database..
i know only my remote table user name and password...
my mdb file and sql database are same...
I tried to link my remote database
I click link table and odbc from my mdb...
i choose machine data source and new ...
i choose sql server and i write my server ip and click next...
i write my database username and password but it failss.
how can i link my remotet sql server 2000 database? what is my fault...
?
You may need to setup a dsn on your own computer that points to the SQL
Server database. Be aware that if you are not the Administrator for this
database, you may not have the permissions needed to link a table from this
SQL Server to your mdb database. This is for good reason as this could give
you privileges that you are not authorized to have. I would contact the SQL
Server database administrator.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:%23Pm15dhMFHA.3988@.tk2msftngp13.phx.gbl...
>I have a local mdb file and remote sql server 2000 database..
> i know only my remote table user name and password...
> my mdb file and sql database are same...
> I tried to link my remote database
> I click link table and odbc from my mdb...
> i choose machine data source and new ...
> i choose sql server and i write my server ip and click next...
> i write my database username and password but it failss.
> how can i link my remotet sql server 2000 database? what is my fault...
> ?
>
>
>

LINK REMOTE SQL SERVER 2000 Database

I have a local mdb file and remote sql server 2000 database..
i know only my remote table user name and password...
my mdb file and sql database are same...
I tried to link my remote database
I click link table and odbc from my mdb...
i choose machine data source and new ...
i choose sql server and i write my server ip and click next...
i write my database username and password but it failss.
how can i link my remotet sql server 2000 database? what is my fault...
?
You may need to setup a dsn on your own computer that points to the SQL
Server database. Be aware that if you are not the Administrator for this
database, you may not have the permissions needed to link a table from this
SQL Server to your mdb database. This is for good reason as this could give
you privileges that you are not authorized to have. I would contact the SQL
Server database administrator.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:%23Pm15dhMFHA.3988@.tk2msftngp13.phx.gbl...
>I have a local mdb file and remote sql server 2000 database..
> i know only my remote table user name and password...
> my mdb file and sql database are same...
> I tried to link my remote database
> I click link table and odbc from my mdb...
> i choose machine data source and new ...
> i choose sql server and i write my server ip and click next...
> i write my database username and password but it failss.
> how can i link my remotet sql server 2000 database? what is my fault...
> ?
>
>
>
sql

Link problem in my script file

I have a script file that I need to change the link because the view is leaving out some records. The problem description follows the script.

The script is:

CREATE view v_Flight_Check(Flight_No, Doc_No, Flight_Doc_No, Leg_no, Actual_Departing_Date, Actual_Arriving_Date,
Flight_Legs, Actual_Hours, Actual_Over_Load, Actual_Landings, Actual_Air_Time, Flight_Type_A, Flight_Type_B,
Aircraft_Id, Doc_Status,Aircraft_Doc_No,LogBookPage, Actual_From_Airport,Actual_To_Airport, Actual_Flight_Legs, FLActual_Hours, FLActual_Over_Load,
Start_ECU_Airframe_Hrs, End_Ecu_Airframe_Hrs, End_Ecu_Ac_hrs,
Crew,Position, From_Leg_Doc_No, To_Leg_Doc_No,Last_Name, First_Name, Tail_No,HSN,Serial_No,RECORD_TYPE) AS

SELECT DISTINCT Flight_Log.Flight_No,Flight_Log_Leg.Doc_no, Flight_Log_Leg.Flight_Doc_No, Flight_Log_Leg.Leg_no, Flight_Log_Leg.Actual_Departing_Date, Flight_Log_Leg.Actual_Arriving_Date,
Flight_Log_Leg.Flight_Legs, Flight_Log_Leg.Actual_Hours, Flight_Log_Leg.Actual_Over_Load, Flight_Log_Leg.Actual_Landings, Flight_Log_Leg.Actual_Air_Time, Flight_Log_Leg.Flight_Type_A, Flight_Log_Leg.Flight_Type_B,
Flight_Log.Aircraft_Id, Flight_log.Doc_Status, Flight_Log.Aircraft_Doc_No,Flight_Log.LogBookPage, Flight_Log.Actual_From_Airport,Flight_Log.Actual_To_Airport, Flight_Log.Actual_Flight_Legs, Flight_Log.Actual_Hours, Flight_Log.Actual_Over_Load,
Flight_Log.Start_ecu_Airframe_hrs, Flight_Log.End_ECU_Airframe_hrs,Flight_Log.End_ecu_ac_hrs,
Flight_Log_Crew.User_code,Flight_Log_Crew.Position, Flight_Log_Crew.From_Leg_Doc_No, Flight_Log_Crew.To_Leg_Doc_No, Userlist.L_name,UserList.F_Name,Aircraft_hdr.tail_no,Aircraft_hdr.hsn, Aircraft_Hdr.Serial_No,'FL'

FROM GDB_01_4.dbo.FLIGHT_LOG,
GDB_01_4.dbo.Aircraft_HDR,
GDB_01_4.dbo.Flight_Log_leg Right Outer Join
GDB_01_4.dbo.FLIGHT_LOG_CREW ON GDB_01_4.dbo.FLIGHT_LOG_CREW.FLIGHT_LOG_DOC_NO = GDB_01_4.dbo.FLIGHT_LOG_LEG.FLIGHT_DOC_NO,
GDB_01_4.dbo.Userlist

Where Flight_Log.Doc_No = Flight_Log_Leg.Flight_Doc_No and
FLIGHT_LOG_LEG.DOC_NO >= fLIGHT_LOG_CREW.FROM_LEG_DOC_NO AND FLIGHT_LOG_LEG.DOC_NO <= fLIGHT_LOG_CREW.TO_LEG_DOC_NO and
Flight_Log_Crew.User_Code = Userlist.ccode and Flight_Log.Aircraft_Doc_No = Aircraft_Hdr.Doc_No

The problem is that if there was no crew listed on the Flight Leg, the entire flight and leg is left off. I need all of the records in the FLight Leg Table, even if no crew was listed.

Does anyone know how I can fix this? My script writing skills are minimal.

Thanks

SBoyd

You need to move some of the conditions in the WHERE clause to the OUTER JOIN ON clause. This should provide the results you are looking for. It is however hard to tell which conditions without looking at some data and the relationship between the tables in detail.

Link problem in my script file

I have a script file that I need to change the link because the view is leaving out some records. The problem description follows the script.

The script is:

CREATE view v_Flight_Check(Flight_No, Doc_No, Flight_Doc_No, Leg_no, Actual_Departing_Date, Actual_Arriving_Date,
Flight_Legs, Actual_Hours, Actual_Over_Load, Actual_Landings, Actual_Air_Time, Flight_Type_A, Flight_Type_B,
Aircraft_Id, Doc_Status,Aircraft_Doc_No,LogBookPage, Actual_From_Airport,Actual_To_Airport, Actual_Flight_Legs, FLActual_Hours, FLActual_Over_Load,
Start_ECU_Airframe_Hrs, End_Ecu_Airframe_Hrs, End_Ecu_Ac_hrs,
Crew,Position, From_Leg_Doc_No, To_Leg_Doc_No,Last_Name, First_Name, Tail_No,HSN,Serial_No,RECORD_TYPE) AS

SELECT DISTINCT Flight_Log.Flight_No,Flight_Log_Leg.Doc_no, Flight_Log_Leg.Flight_Doc_No, Flight_Log_Leg.Leg_no, Flight_Log_Leg.Actual_Departing_Date, Flight_Log_Leg.Actual_Arriving_Date,
Flight_Log_Leg.Flight_Legs, Flight_Log_Leg.Actual_Hours, Flight_Log_Leg.Actual_Over_Load, Flight_Log_Leg.Actual_Landings, Flight_Log_Leg.Actual_Air_Time, Flight_Log_Leg.Flight_Type_A, Flight_Log_Leg.Flight_Type_B,
Flight_Log.Aircraft_Id, Flight_log.Doc_Status, Flight_Log.Aircraft_Doc_No,Flight_Log.LogBookPage, Flight_Log.Actual_From_Airport,Flight_Log.Actual_To_Airport, Flight_Log.Actual_Flight_Legs, Flight_Log.Actual_Hours, Flight_Log.Actual_Over_Load,
Flight_Log.Start_ecu_Airframe_hrs, Flight_Log.End_ECU_Airframe_hrs,Flight_Log.End_ecu_ac_hrs,
Flight_Log_Crew.User_code,Flight_Log_Crew.Position, Flight_Log_Crew.From_Leg_Doc_No, Flight_Log_Crew.To_Leg_Doc_No, Userlist.L_name,UserList.F_Name,Aircraft_hdr.tail_no,Aircraft_hdr.hsn, Aircraft_Hdr.Serial_No,'FL'

FROM GDB_01_4.dbo.FLIGHT_LOG,
GDB_01_4.dbo.Aircraft_HDR,
GDB_01_4.dbo.Flight_Log_leg Right Outer Join
GDB_01_4.dbo.FLIGHT_LOG_CREW ON GDB_01_4.dbo.FLIGHT_LOG_CREW.FLIGHT_LOG_DOC_NO = GDB_01_4.dbo.FLIGHT_LOG_LEG.FLIGHT_DOC_NO,
GDB_01_4.dbo.Userlist

Where Flight_Log.Doc_No = Flight_Log_Leg.Flight_Doc_No and
FLIGHT_LOG_LEG.DOC_NO >= fLIGHT_LOG_CREW.FROM_LEG_DOC_NO AND FLIGHT_LOG_LEG.DOC_NO <= fLIGHT_LOG_CREW.TO_LEG_DOC_NO and
Flight_Log_Crew.User_Code = Userlist.ccode and Flight_Log.Aircraft_Doc_No = Aircraft_Hdr.Doc_No

The problem is that if there was no crew listed on the Flight Leg, the entire flight and leg is left off. I need all of the records in the FLight Leg Table, even if no crew was listed.

Does anyone know how I can fix this? My script writing skills are minimal.

Thanks

SBoyd

You need to move some of the conditions in the WHERE clause to the OUTER JOIN ON clause. This should provide the results you are looking for. It is however hard to tell which conditions without looking at some data and the relationship between the tables in detail.

link crystal report 10 with vb 6.0

1. how can i link crystal report 10 with vb6.0
2. how can get the (picture or image) in crystal report 10 from direct to the file through vb6.0 application
send me answer please.......There is a special forum for crystal reports so please ask your request there. I think thats the place you would get help|||I want to connect crystal report 11 with vb 6.0
please tell me the code for it .
reply me as soon as possible|||please tell me the code|||I want to connect crystal report 11 with vb 6.0
please tell me the code for it .
reply me as soon as possible|||I want to link crystal report 11 with vb 6.0, but I am not geting any output,
so please tell me the code for it.
reply me as soon as possible.|||I want to coonect crystal report with vb 6.0, please tell me the code for it.
please reply me as soon as possible.|||I want to coonect crystal report with vb 6.0, please tell me the code for it.
please reply me as soon as possible. i have the code for crystal report 8 but in it crystal report 11 is not showing any output|||i have the code for crystal report 8 but in it crystal report 11 is not showing any output.,|||Send your code for crystal 8 and that could be a better start than repeating your posts|||I want to connect crystal report 11 with vb 6.0
please tell me the code for it .
reply me as soon as possibleShow your code, what you have done so far so we can see what the problem is. Are you using DE (Dataenviroment ) ?

Line/Paragraph Breaks in SQL Server/XML output

Hi again,
I was trying out a stored proc that outputs a huge XML file. It works fine
but my problem is the linebreaks it comes out with. What I did to test it
was to output it as text using Query Analyzer and then saved it as an XML
file with the headers and root elements. It kept on giving me errors. I
found out that it was because of paragraph breaks that split tags and such
thus causing the errors on the XML.
What I did to remedy the problem was to copy and paste to word then Searched
and Replaced for paragraph breaks and removed them. When I saved this to an
XML file, it worked fine. I tried doing a REPLACE on the resulting
textstream from an ASP page but it was giving me errors.
So my question is, how do I remove those linebreaks from the XML output so
that my ASP page is correctly rendered? Is there a setting I missed?
Thanks a bunch guys!
Jeeves
How exactly are you outputing the file from the Stored Proc? The basic
problem is that SQL Server 2000 doesn't have a native XML type, so it treats
the results of a FOR XML query as a string (this changes in SQL Server
2005). A better approach might be to use the SQLOLEDB or SQLXMLOLEDB
provider to retrieve the XML as a stream or DOMDocument in your ASP script.
--
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
"Jeeves De Veyra" <me@.jeevester.com> wrote in message
news:e5GUZR6rEHA.2016@.TK2MSFTNGP12.phx.gbl...
Hi again,
I was trying out a stored proc that outputs a huge XML file. It works fine
but my problem is the linebreaks it comes out with. What I did to test it
was to output it as text using Query Analyzer and then saved it as an XML
file with the headers and root elements. It kept on giving me errors. I
found out that it was because of paragraph breaks that split tags and such
thus causing the errors on the XML.
What I did to remedy the problem was to copy and paste to word then Searched
and Replaced for paragraph breaks and removed them. When I saved this to an
XML file, it worked fine. I tried doing a REPLACE on the resulting
textstream from an ASP page but it was giving me errors.
So my question is, how do I remove those linebreaks from the XML output so
that my ASP page is correctly rendered? Is there a setting I missed?
Thanks a bunch guys!
Jeeves
|||Jeeves mentioned that the result was saved through the Query Analyzer.
The QA in SQL Server 2000 should not be used for that since it does not
support the XML stream. In SQL Server 2000, the XML stream is build on top
of the rowset streaming of TDS by sending a 4kB block as a row. The query
analyzer just shows the rows as it normally would.
The best ways to save your data in an ASP script is to use stream interface
of the OLEDB provider as Graeme points out. If you want to store it
manually, you can either write a VB Script or you can use the SQLXML ISAPI
component and then save it through your browser.
Best regards
Michael
"Graeme Malcolm" <graemem_cm@.hotmail.com> wrote in message
news:%237OwhoEsEHA.376@.TK2MSFTNGP14.phx.gbl...
> How exactly are you outputing the file from the Stored Proc? The basic
> problem is that SQL Server 2000 doesn't have a native XML type, so it
> treats
> the results of a FOR XML query as a string (this changes in SQL Server
> 2005). A better approach might be to use the SQLOLEDB or SQLXMLOLEDB
> provider to retrieve the XML as a stream or DOMDocument in your ASP
> script.
> --
> --
> Graeme Malcolm
> Principal Technologist
> Content Master Ltd.
> www.contentmaster.com
>
> "Jeeves De Veyra" <me@.jeevester.com> wrote in message
> news:e5GUZR6rEHA.2016@.TK2MSFTNGP12.phx.gbl...
> Hi again,
> I was trying out a stored proc that outputs a huge XML file. It works fine
> but my problem is the linebreaks it comes out with. What I did to test it
> was to output it as text using Query Analyzer and then saved it as an XML
> file with the headers and root elements. It kept on giving me errors. I
> found out that it was because of paragraph breaks that split tags and such
> thus causing the errors on the XML.
> What I did to remedy the problem was to copy and paste to word then
> Searched
> and Replaced for paragraph breaks and removed them. When I saved this to
> an
> XML file, it worked fine. I tried doing a REPLACE on the resulting
> textstream from an ASP page but it was giving me errors.
> So my question is, how do I remove those linebreaks from the XML output so
> that my ASP page is correctly rendered? Is there a setting I missed?
> Thanks a bunch guys!
> Jeeves
>
>
sql

Line Feed in Text Box on rdl file

I am triyng to add a line feed char to my DB string which is assigned to a
text box, cant figure out how.
Line One"\n"Line Twotry appending a char(10) at the end of the string.
Ex:
print 'abcd'+char(10)+'efgh'
or
print 'abcd'+char(13)+'efgh'
"Adi" wrote:

> I am triyng to add a line feed char to my DB string which is assigned to a
> text box, cant figure out how.
> Line One"\n"Line Two|||Maybe use both. Most windows apps look for a Carriage Return and a Line
Feed together.
print 'abcd'+char(13)+char(10)+'efgh'
However, is this post even in the right forum? Are you trying to do this in
SQL Server, in VB.Net, Javascript?
"tthrone" <tthrone@.discussions.microsoft.com> wrote in message
news:D577C263-F691-4AE3-B7BD-6219F1F90B94@.microsoft.com...
> try appending a char(10) at the end of the string.
> Ex:
> print 'abcd'+char(10)+'efgh'
> or
> print 'abcd'+char(13)+'efgh'
> "Adi" wrote:
>
a

Line Chart in RS - simple design question

I have a simply data file that I want to make a time-based line chart and I can't seem to get charts in RS to do it. The data file structure is as follows: (first line is column labels and each row is a case with three data points - one for each year)

school 2003 2004 2005

SchA 100 122 133

SchB 121 145 115

SchC 98 112 120

I can't seem to get the right series, category, and data fields to get a very simple line chart for each school (one trend line for each school connecting the three data points all one the same chart). It's trivial in Excel and using pivot tables, but RS charts is not structured the same way.?

The fields in the SQL result set returned are School, 2003, 2004, & 2005.

Any help for this seemingly simply problem would be appreciated. Thanks

Ed Sloat

your resultset has to look like this:

Year SchA SchB SchC

2003 100 121 98

2004 122 145 112

2005 133 115 120

SchA, SchB, SchC are your value fields
Year is your category field

this should work fine|||

Gerhard, Thanks for the reply. I did try this and it does work but it requires a fundemental restructuring of the underlying data. From your answer, I am guessing the RS charting assumes a single static (required) data structure for the charting features and does not allow for flexibility in the defining the data rerlationships,... which makes it much less functional than charting in Excel or in other statistical/data analysis software. Seem like it makes some pretty trival/common data display tasks much more difficult.

Thanks.

Ed

|||

OK, Select the line chart, then Select School and drop them under 'Drop Series fields here', Select years and drop them under 'Drop Categroy fields here' and finally Select the data fields and drop them 'Drop data fields here' areas.