hi,
I am having while accessing the asp pages in our the problem is
"Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
/pressreleases/pressroom.asp, line 90 "
If i restart the system then i am able to connect the database and working
well.. but afterdays again i am getting same error.. so please help me in
this. Thanks in advance
rajavelWhy are you using named pipes? See http://www.aspfaq.com/2126 for optimal
connection strings...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Rajavelu Dhakshinamurthy" <rajavelu_d@.dev.visualsoft-tech.com> wrote in
message news:#xySVGH7DHA.2404@.TK2MSFTNGP12.phx.gbl...
> hi,
> I am having while accessing the asp pages in our the problem is
> "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
> /pressreleases/pressroom.asp, line 90 "
>
> If i restart the system then i am able to connect the database and working
> well.. but afterdays again i am getting same error.. so please help me in
> this. Thanks in advance
> rajavel
>
>|||Either you have your database open while you are executing an asp page which
either reads or writes from a datagase or,
You don't have the permission to read/write your database
Click on My Computer icon on your desktop, keep clicking until you find the
folder where your database is. Right click on the database and select
properties and make sure the correct permissions are selected.
regards,
harsh.
"Rajavelu Dhakshinamurthy" <rajavelu_d@.dev.visualsoft-tech.com> wrote in
message news:#xySVGH7DHA.2404@.TK2MSFTNGP12.phx.gbl...
> hi,
> I am having while accessing the asp pages in our the problem is
> "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
> /pressreleases/pressroom.asp, line 90 "
>
> If i restart the system then i am able to connect the database and working
> well.. but afterdays again i am getting same error.. so please help me in
> this. Thanks in advance
> rajavel
>
>|||In article <uukjTUH7DHA.2760@.TK2MSFTNGP09.phx.gbl>, "harsh" <harshalmistry@.hotmail.com> wrote:
>Either you have your database open while you are executing an asp page which
>either reads or writes from a datagase or,
>You don't have the permission to read/write your database
>Click on My Computer icon on your desktop, keep clicking until you find the
>folder where your database is. Right click on the database and select
>properties and make sure the correct permissions are selected.
>regards,
>harsh.
Huh?
I'm afraid you didn't catch the fact that this is a SQL Server DB.
SQL Server doesn't work like that.
What exactly is the SQL statement that is bombing out doing?
Have you tried running profiler when this occurs?|||Check this general guide how to troubleshoot the 80004005 error as well:
http://support.microsoft.com/default.aspx?scid=kb;en-us;306518.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Rajavelu Dhakshinamurthy" <rajavelu_d@.dev.visualsoft-tech.com> wrote in
message news:#xySVGH7DHA.2404@.TK2MSFTNGP12.phx.gbl...
> hi,
> I am having while accessing the asp pages in our the problem is
> "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
> /pressreleases/pressroom.asp, line 90 "
>
> If i restart the system then i am able to connect the database and working
> well.. but afterdays again i am getting same error.. so please help me in
> this. Thanks in advance
> rajavel
>
>
Showing posts with label ole. Show all posts
Showing posts with label ole. Show all posts
Wednesday, March 21, 2012
error '80004005' while accessing the ASP pages
hi,
I am having while accessing the asp pages in our the problem is
"Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
/pressreleases/pressroom.asp, line 90 "
If i restart the system then i am able to connect the database and working
well.. but afterdays again i am getting same error.. so please help me in
this. Thanks in advance
rajavelWhy are you using named pipes? See http://www.aspfaq.com/2126 for optimal
connection strings...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Rajavelu Dhakshinamurthy" <rajavelu_d@.dev.visualsoft-tech.com> wrote in
message news:#xySVGH7DHA.2404@.TK2MSFTNGP12.phx.gbl...
> hi,
> I am having while accessing the asp pages in our the problem is
> "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
> /pressreleases/pressroom.asp, line 90 "
>
> If i restart the system then i am able to connect the database and working
> well.. but afterdays again i am getting same error.. so please help me in
> this. Thanks in advance
> rajavel
>
>|||Either you have your database open while you are executing an asp page which
either reads or writes from a datagase or,
You don't have the permission to read/write your database
Click on My Computer icon on your desktop, keep clicking until you find the
folder where your database is. Right click on the database and select
properties and make sure the correct permissions are selected.
regards,
harsh.
"Rajavelu Dhakshinamurthy" <rajavelu_d@.dev.visualsoft-tech.com> wrote in
message news:#xySVGH7DHA.2404@.TK2MSFTNGP12.phx.gbl...
> hi,
> I am having while accessing the asp pages in our the problem is
> "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
> /pressreleases/pressroom.asp, line 90 "
>
> If i restart the system then i am able to connect the database and working
> well.. but afterdays again i am getting same error.. so please help me in
> this. Thanks in advance
> rajavel
>
>|||In article <uukjTUH7DHA.2760@.TK2MSFTNGP09.phx.gbl>, "harsh" <harshalmistry@.hotmail.com>
wrote:
>Either you have your database open while you are executing an asp page whic
h
>either reads or writes from a datagase or,
>You don't have the permission to read/write your database
>Click on My Computer icon on your desktop, keep clicking until you find the
>folder where your database is. Right click on the database and select
>properties and make sure the correct permissions are selected.
>regards,
>harsh.
Huh?
I'm afraid you didn't catch the fact that this is a SQL Server DB.
SQL Server doesn't work like that.
What exactly is the SQL statement that is bombing out doing?
Have you tried running profiler when this occurs?|||Check this general guide how to troubleshoot the 80004005 error as well:
http://support.microsoft.com/defaul...b;en-us;306518.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Rajavelu Dhakshinamurthy" <rajavelu_d@.dev.visualsoft-tech.com> wrote in
message news:#xySVGH7DHA.2404@.TK2MSFTNGP12.phx.gbl...
> hi,
> I am having while accessing the asp pages in our the problem is
> "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
> /pressreleases/pressroom.asp, line 90 "
>
> If i restart the system then i am able to connect the database and working
> well.. but afterdays again i am getting same error.. so please help me in
> this. Thanks in advance
> rajavel
>
>
I am having while accessing the asp pages in our the problem is
"Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
/pressreleases/pressroom.asp, line 90 "
If i restart the system then i am able to connect the database and working
well.. but afterdays again i am getting same error.. so please help me in
this. Thanks in advance
rajavelWhy are you using named pipes? See http://www.aspfaq.com/2126 for optimal
connection strings...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Rajavelu Dhakshinamurthy" <rajavelu_d@.dev.visualsoft-tech.com> wrote in
message news:#xySVGH7DHA.2404@.TK2MSFTNGP12.phx.gbl...
> hi,
> I am having while accessing the asp pages in our the problem is
> "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
> /pressreleases/pressroom.asp, line 90 "
>
> If i restart the system then i am able to connect the database and working
> well.. but afterdays again i am getting same error.. so please help me in
> this. Thanks in advance
> rajavel
>
>|||Either you have your database open while you are executing an asp page which
either reads or writes from a datagase or,
You don't have the permission to read/write your database
Click on My Computer icon on your desktop, keep clicking until you find the
folder where your database is. Right click on the database and select
properties and make sure the correct permissions are selected.
regards,
harsh.
"Rajavelu Dhakshinamurthy" <rajavelu_d@.dev.visualsoft-tech.com> wrote in
message news:#xySVGH7DHA.2404@.TK2MSFTNGP12.phx.gbl...
> hi,
> I am having while accessing the asp pages in our the problem is
> "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
> /pressreleases/pressroom.asp, line 90 "
>
> If i restart the system then i am able to connect the database and working
> well.. but afterdays again i am getting same error.. so please help me in
> this. Thanks in advance
> rajavel
>
>|||In article <uukjTUH7DHA.2760@.TK2MSFTNGP09.phx.gbl>, "harsh" <harshalmistry@.hotmail.com>
wrote:
>Either you have your database open while you are executing an asp page whic
h
>either reads or writes from a datagase or,
>You don't have the permission to read/write your database
>Click on My Computer icon on your desktop, keep clicking until you find the
>folder where your database is. Right click on the database and select
>properties and make sure the correct permissions are selected.
>regards,
>harsh.
Huh?
I'm afraid you didn't catch the fact that this is a SQL Server DB.
SQL Server doesn't work like that.
What exactly is the SQL statement that is bombing out doing?
Have you tried running profiler when this occurs?|||Check this general guide how to troubleshoot the 80004005 error as well:
http://support.microsoft.com/defaul...b;en-us;306518.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Rajavelu Dhakshinamurthy" <rajavelu_d@.dev.visualsoft-tech.com> wrote in
message news:#xySVGH7DHA.2404@.TK2MSFTNGP12.phx.gbl...
> hi,
> I am having while accessing the asp pages in our the problem is
> "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
> /pressreleases/pressroom.asp, line 90 "
>
> If i restart the system then i am able to connect the database and working
> well.. but afterdays again i am getting same error.. so please help me in
> this. Thanks in advance
> rajavel
>
>
Error 7399: OLE DB provider 'SQLOLEDB' reported an error.
Hello everyone!
I try to setup a linked server connection to an other SQL Server and receive
the following error message:
Error 7399: OLE DB provider 'SQLOLEDB' reported an error.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initialize
returned 0x80004005: ].
I am using a trusted connection.
Does anybody have an idea what I am doing wrong here? Or how I can get a
more specific error message?
Thanks for any hints!
brgds,
tom.Hi Thomas:
Please see the KB article, it may be useful:
http://support.microsoft.com/defaul...kb;en-us;314530
Best Wishes
Wei Ci Zhou
I try to setup a linked server connection to an other SQL Server and receive
the following error message:
Error 7399: OLE DB provider 'SQLOLEDB' reported an error.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initialize
returned 0x80004005: ].
I am using a trusted connection.
Does anybody have an idea what I am doing wrong here? Or how I can get a
more specific error message?
Thanks for any hints!
brgds,
tom.Hi Thomas:
Please see the KB article, it may be useful:
http://support.microsoft.com/defaul...kb;en-us;314530
Best Wishes
Wei Ci Zhou
Error 7399: OLE DB provider Microsoft.Jet.OLEDB.4.0 reported an error.
I tried to make one with following options in enterprise manager:
Server type: Other data source
Provider name: test
Product name: Access 2000
Data source: c:\db\test.mdb
Provider string: Microsoft.Jet.OLEDB.4.0
When I try to access the linked server tables I receive following error:
Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
When I try to make a view (select * from linkedserver1...table) I receive following error:
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: Disk or network error.]
Can anyone help me? the only thing I want to do is link an access table to SQL Server (NOT sql server table in access but access table in sql server!)Have you definately got the paths setup right?
'c:\db\test.mdb' needs to be on the SQL Server machine itself and has the system got the correct permissions to access the mdb file.
If you check this and this is all OK then is it not a possibility to import your table into SQL Server?|||make sure that u are connected to you Domain Server.
and that u make a System DSN (best solution in DSN) correctly to your SQL Server.
hope this will help u
bye
Server type: Other data source
Provider name: test
Product name: Access 2000
Data source: c:\db\test.mdb
Provider string: Microsoft.Jet.OLEDB.4.0
When I try to access the linked server tables I receive following error:
Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
When I try to make a view (select * from linkedserver1...table) I receive following error:
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: Disk or network error.]
Can anyone help me? the only thing I want to do is link an access table to SQL Server (NOT sql server table in access but access table in sql server!)Have you definately got the paths setup right?
'c:\db\test.mdb' needs to be on the SQL Server machine itself and has the system got the correct permissions to access the mdb file.
If you check this and this is all OK then is it not a possibility to import your table into SQL Server?|||make sure that u are connected to you Domain Server.
and that u make a System DSN (best solution in DSN) correctly to your SQL Server.
hope this will help u
bye
error 7399, OLE DB-errorrtrace, opendatasource
I would like to read data from an sql server using ad hoc queries in two seperate sessions (opendatasource). However, when I try to access both databanks the following error is generated:
Server: Nachr.-Nr. 7399, Schweregrad 16, Status 1, Zeile 3
Der OLE DB-Provider 'Microsoft.Jet.OLEDB.4.0' meldete einen Fehler. Der Provider hat keine Informationen zu dem Fehler bereitgestellt.
OLE DB-Fehlertrace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IOpenRowset::OpenRowset returned 0x80004005: Der Provider hat keine Informationen zu dem Fehler bereitgestellt.].
thanks
Tulpe,
This looks like your SQL Server is actually passing you through to a linked
server for a Jet database (Access). Is that what is happening? If so,
there are a few KB articles that may help.
http://support.microsoft.com/default...b;en-us;296711
http://support.microsoft.com/default...b;en-us;818182
http://support.microsoft.com/default...b;en-us;814398
http://support.microsoft.com/default...b;en-us;285833
Russell Fields
"Tulpe" <anonymous@.discussions.microsoft.com> wrote in message
news:A6F5B481-5BAE-4DEB-AF78-D6147D5C1FB7@.microsoft.com...
> I would like to read data from an sql server using ad hoc queries in two
seperate sessions (opendatasource). However, when I try to access both
databanks the following error is generated:
> Server: Nachr.-Nr. 7399, Schweregrad 16, Status 1, Zeile 3
> Der OLE DB-Provider 'Microsoft.Jet.OLEDB.4.0' meldete einen Fehler. Der
Provider hat keine Informationen zu dem Fehler bereitgestellt.
> OLE DB-Fehlertrace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IOpenRowset::OpenRowset returned 0x80004005: Der Provider hat keine
Informationen zu dem Fehler bereitgestellt.].
> thanks
Server: Nachr.-Nr. 7399, Schweregrad 16, Status 1, Zeile 3
Der OLE DB-Provider 'Microsoft.Jet.OLEDB.4.0' meldete einen Fehler. Der Provider hat keine Informationen zu dem Fehler bereitgestellt.
OLE DB-Fehlertrace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IOpenRowset::OpenRowset returned 0x80004005: Der Provider hat keine Informationen zu dem Fehler bereitgestellt.].
thanks
Tulpe,
This looks like your SQL Server is actually passing you through to a linked
server for a Jet database (Access). Is that what is happening? If so,
there are a few KB articles that may help.
http://support.microsoft.com/default...b;en-us;296711
http://support.microsoft.com/default...b;en-us;818182
http://support.microsoft.com/default...b;en-us;814398
http://support.microsoft.com/default...b;en-us;285833
Russell Fields
"Tulpe" <anonymous@.discussions.microsoft.com> wrote in message
news:A6F5B481-5BAE-4DEB-AF78-D6147D5C1FB7@.microsoft.com...
> I would like to read data from an sql server using ad hoc queries in two
seperate sessions (opendatasource). However, when I try to access both
databanks the following error is generated:
> Server: Nachr.-Nr. 7399, Schweregrad 16, Status 1, Zeile 3
> Der OLE DB-Provider 'Microsoft.Jet.OLEDB.4.0' meldete einen Fehler. Der
Provider hat keine Informationen zu dem Fehler bereitgestellt.
> OLE DB-Fehlertrace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IOpenRowset::OpenRowset returned 0x80004005: Der Provider hat keine
Informationen zu dem Fehler bereitgestellt.].
> thanks
error 7399, OLE DB-errorrtrace, opendatasource
I would like to read data from an sql server using ad hoc queries in two seperate sessions (opendatasource). However, when I try to access both databanks the following error is generated
Server: Nachr.-Nr. 7399, Schweregrad 16, Status 1, Zeile
Der OLE DB-Provider 'Microsoft.Jet.OLEDB.4.0' meldete einen Fehler. Der Provider hat keine Informationen zu dem Fehler bereitgestellt
OLE DB-Fehlertrace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IOpenRowset::OpenRowset returned 0x80004005: Der Provider hat keine Informationen zu dem Fehler bereitgestellt.]
thanksTulpe,
This looks like your SQL Server is actually passing you through to a linked
server for a Jet database (Access). Is that what is happening? If so,
there are a few KB articles that may help.
http://support.microsoft.com/default.aspx?scid=kb;en-us;296711
http://support.microsoft.com/default.aspx?scid=kb;en-us;818182
http://support.microsoft.com/default.aspx?scid=kb;en-us;814398
http://support.microsoft.com/default.aspx?scid=kb;en-us;285833
Russell Fields
"Tulpe" <anonymous@.discussions.microsoft.com> wrote in message
news:A6F5B481-5BAE-4DEB-AF78-D6147D5C1FB7@.microsoft.com...
> I would like to read data from an sql server using ad hoc queries in two
seperate sessions (opendatasource). However, when I try to access both
databanks the following error is generated:
> Server: Nachr.-Nr. 7399, Schweregrad 16, Status 1, Zeile 3
> Der OLE DB-Provider 'Microsoft.Jet.OLEDB.4.0' meldete einen Fehler. Der
Provider hat keine Informationen zu dem Fehler bereitgestellt.
> OLE DB-Fehlertrace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IOpenRowset::OpenRowset returned 0x80004005: Der Provider hat keine
Informationen zu dem Fehler bereitgestellt.].
> thankssql
Server: Nachr.-Nr. 7399, Schweregrad 16, Status 1, Zeile
Der OLE DB-Provider 'Microsoft.Jet.OLEDB.4.0' meldete einen Fehler. Der Provider hat keine Informationen zu dem Fehler bereitgestellt
OLE DB-Fehlertrace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IOpenRowset::OpenRowset returned 0x80004005: Der Provider hat keine Informationen zu dem Fehler bereitgestellt.]
thanksTulpe,
This looks like your SQL Server is actually passing you through to a linked
server for a Jet database (Access). Is that what is happening? If so,
there are a few KB articles that may help.
http://support.microsoft.com/default.aspx?scid=kb;en-us;296711
http://support.microsoft.com/default.aspx?scid=kb;en-us;818182
http://support.microsoft.com/default.aspx?scid=kb;en-us;814398
http://support.microsoft.com/default.aspx?scid=kb;en-us;285833
Russell Fields
"Tulpe" <anonymous@.discussions.microsoft.com> wrote in message
news:A6F5B481-5BAE-4DEB-AF78-D6147D5C1FB7@.microsoft.com...
> I would like to read data from an sql server using ad hoc queries in two
seperate sessions (opendatasource). However, when I try to access both
databanks the following error is generated:
> Server: Nachr.-Nr. 7399, Schweregrad 16, Status 1, Zeile 3
> Der OLE DB-Provider 'Microsoft.Jet.OLEDB.4.0' meldete einen Fehler. Der
Provider hat keine Informationen zu dem Fehler bereitgestellt.
> OLE DB-Fehlertrace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IOpenRowset::OpenRowset returned 0x80004005: Der Provider hat keine
Informationen zu dem Fehler bereitgestellt.].
> thankssql
error 7399, OLE DB-errorrtrace, opendatasource
I would like to read data from an sql server using ad hoc queries in two sep
erate sessions (opendatasource). However, when I try to access both databan
ks the following error is generated:
Server: Nachr.-Nr. 7399, Schweregrad 16, Status 1, Zeile 3
Der OLE DB-Provider 'Microsoft.Jet.OLEDB.4.0' meldete einen Fehler. Der Prov
ider hat keine Informationen zu dem Fehler bereitgestellt.
OLE DB-Fehlertrace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IOpenRowse
t::OpenRowset returned 0x80004005: Der Provider hat keine Informationen zu
dem Fehler bereitgestellt.].
thanksTulpe,
This looks like your SQL Server is actually passing you through to a linked
server for a Jet database (Access). Is that what is happening? If so,
there are a few KB articles that may help.
http://support.microsoft.com/defaul...kb;en-us;296711
http://support.microsoft.com/defaul...kb;en-us;818182
http://support.microsoft.com/defaul...kb;en-us;814398
http://support.microsoft.com/defaul...kb;en-us;285833
Russell Fields
"Tulpe" <anonymous@.discussions.microsoft.com> wrote in message
news:A6F5B481-5BAE-4DEB-AF78-D6147D5C1FB7@.microsoft.com...
> I would like to read data from an sql server using ad hoc queries in two
seperate sessions (opendatasource). However, when I try to access both
databanks the following error is generated:
> Server: Nachr.-Nr. 7399, Schweregrad 16, Status 1, Zeile 3
> Der OLE DB-Provider 'Microsoft.Jet.OLEDB.4.0' meldete einen Fehler. Der
Provider hat keine Informationen zu dem Fehler bereitgestellt.
> OLE DB-Fehlertrace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IOpenRowset::OpenRowset returned 0x80004005: Der Provider hat keine
Informationen zu dem Fehler bereitgestellt.].
> thanks
erate sessions (opendatasource). However, when I try to access both databan
ks the following error is generated:
Server: Nachr.-Nr. 7399, Schweregrad 16, Status 1, Zeile 3
Der OLE DB-Provider 'Microsoft.Jet.OLEDB.4.0' meldete einen Fehler. Der Prov
ider hat keine Informationen zu dem Fehler bereitgestellt.
OLE DB-Fehlertrace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IOpenRowse
t::OpenRowset returned 0x80004005: Der Provider hat keine Informationen zu
dem Fehler bereitgestellt.].
thanksTulpe,
This looks like your SQL Server is actually passing you through to a linked
server for a Jet database (Access). Is that what is happening? If so,
there are a few KB articles that may help.
http://support.microsoft.com/defaul...kb;en-us;296711
http://support.microsoft.com/defaul...kb;en-us;818182
http://support.microsoft.com/defaul...kb;en-us;814398
http://support.microsoft.com/defaul...kb;en-us;285833
Russell Fields
"Tulpe" <anonymous@.discussions.microsoft.com> wrote in message
news:A6F5B481-5BAE-4DEB-AF78-D6147D5C1FB7@.microsoft.com...
> I would like to read data from an sql server using ad hoc queries in two
seperate sessions (opendatasource). However, when I try to access both
databanks the following error is generated:
> Server: Nachr.-Nr. 7399, Schweregrad 16, Status 1, Zeile 3
> Der OLE DB-Provider 'Microsoft.Jet.OLEDB.4.0' meldete einen Fehler. Der
Provider hat keine Informationen zu dem Fehler bereitgestellt.
> OLE DB-Fehlertrace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IOpenRowset::OpenRowset returned 0x80004005: Der Provider hat keine
Informationen zu dem Fehler bereitgestellt.].
> thanks
Error 7399 connection refused
I wonder if any of you good people can help?
I dont know how to go about this problem that im having.
error 7399: OLE DB provider 'msdasql', [3kodbc.dll] connect: connection
refused] OLE DB error trace [ole/db Provider 'MSDASQL' IDBInitialize::
Initialize returned 0x80004005
does this mean that a password was changed somewhere? should i get a hold of
the administrator to the server that mine cannot connect to?
thanks in advance
ron
it was a firewall configuration issue...
thanks anyway fellas
"ronnieronski" <ronald_padilla@.msn.com> wrote in message
news:OCaBFT0cEHA.2816@.TK2MSFTNGP11.phx.gbl...
> I wonder if any of you good people can help?
> I dont know how to go about this problem that im having.
> error 7399: OLE DB provider 'msdasql', [3kodbc.dll] connect: connection
> refused] OLE DB error trace [ole/db Provider 'MSDASQL' IDBInitialize::
> Initialize returned 0x80004005
> does this mean that a password was changed somewhere? should i get a hold
of
> the administrator to the server that mine cannot connect to?
>
> thanks in advance
> ron
>
I dont know how to go about this problem that im having.
error 7399: OLE DB provider 'msdasql', [3kodbc.dll] connect: connection
refused] OLE DB error trace [ole/db Provider 'MSDASQL' IDBInitialize::
Initialize returned 0x80004005
does this mean that a password was changed somewhere? should i get a hold of
the administrator to the server that mine cannot connect to?
thanks in advance
ron
it was a firewall configuration issue...
thanks anyway fellas
"ronnieronski" <ronald_padilla@.msn.com> wrote in message
news:OCaBFT0cEHA.2816@.TK2MSFTNGP11.phx.gbl...
> I wonder if any of you good people can help?
> I dont know how to go about this problem that im having.
> error 7399: OLE DB provider 'msdasql', [3kodbc.dll] connect: connection
> refused] OLE DB error trace [ole/db Provider 'MSDASQL' IDBInitialize::
> Initialize returned 0x80004005
> does this mean that a password was changed somewhere? should i get a hold
of
> the administrator to the server that mine cannot connect to?
>
> thanks in advance
> ron
>
Error 7399 connection refused
I wonder if any of you good people can help?
I dont know how to go about this problem that im having.
error 7399: OLE DB provider 'msdasql', [3kodbc.dll] connect: connection
refused] OLE DB error trace [ole/db Provider 'MSDASQL' IDBInitialize::
Initialize returned 0x80004005
does this mean that a password was changed somewhere? should i get a hold of
the administrator to the server that mine cannot connect to?
thanks in advance
ronit was a firewall configuration issue...
thanks anyway fellas
"ronnieronski" <ronald_padilla@.msn.com> wrote in message
news:OCaBFT0cEHA.2816@.TK2MSFTNGP11.phx.gbl...
> I wonder if any of you good people can help?
> I dont know how to go about this problem that im having.
> error 7399: OLE DB provider 'msdasql', [3kodbc.dll] connect: connectio
n
> refused] OLE DB error trace [ole/db Provider 'MSDASQL' IDBInitialize::
> Initialize returned 0x80004005
> does this mean that a password was changed somewhere? should i get a hold
of
> the administrator to the server that mine cannot connect to?
>
> thanks in advance
> ron
>
I dont know how to go about this problem that im having.
error 7399: OLE DB provider 'msdasql', [3kodbc.dll] connect: connection
refused] OLE DB error trace [ole/db Provider 'MSDASQL' IDBInitialize::
Initialize returned 0x80004005
does this mean that a password was changed somewhere? should i get a hold of
the administrator to the server that mine cannot connect to?
thanks in advance
ronit was a firewall configuration issue...
thanks anyway fellas
"ronnieronski" <ronald_padilla@.msn.com> wrote in message
news:OCaBFT0cEHA.2816@.TK2MSFTNGP11.phx.gbl...
> I wonder if any of you good people can help?
> I dont know how to go about this problem that im having.
> error 7399: OLE DB provider 'msdasql', [3kodbc.dll] connect: connectio
n
> refused] OLE DB error trace [ole/db Provider 'MSDASQL' IDBInitialize::
> Initialize returned 0x80004005
> does this mean that a password was changed somewhere? should i get a hold
of
> the administrator to the server that mine cannot connect to?
>
> thanks in advance
> ron
>
Monday, March 19, 2012
Error 7356 - do we have to live with that?
To resolve a well know issue with quering a linked server:
(OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column
was supplied during execution that was not found at compile time.
OLE DB error trace [Non-interface error: OLE DB provider returned an extra
column at execution time: ProviderName=.....)
I change the table name to a view returning all columns of the same table.
I have been doing this since SQL 7.0.
1. Is it an unfixable bug we have to live with?
2. Is there a better way of fixing the problem other than creating a view?
Thanks,
-StanHi Stan,
What is your SQL Server version? Is it SQL Server 7.0 SP4 or SQL Server
2000 SP3?
From your post, I am not sure about the steps to reproduce the problem.
Could you post it so that I can check further?
Bill Cheng
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--
| From: "Stan" <nospam@.yahoo.com>
| Subject: Error 7356 - do we have to live with that?
| Date: Fri, 12 Sep 2003 14:15:35 -0400
| Lines: 20
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <OjwKinVeDHA.616@.TK2MSFTNGP11.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 12.148.36.131
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:306189
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| To resolve a well know issue with quering a linked server:
|
| (OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra
column
| was supplied during execution that was not found at compile time.
| OLE DB error trace [Non-interface error: OLE DB provider returned an
extra
| column at execution time: ProviderName=.....)
|
| I change the table name to a view returning all columns of the same table.
|
| I have been doing this since SQL 7.0.
|
| 1. Is it an unfixable bug we have to live with?
|
| 2. Is there a better way of fixing the problem other than creating a view?
|
| Thanks,
|
| -Stan
|
|
||||Hi Stan,
I have found several articles regarding error "OLE DB provider 'SQLOLEDB'
supplied inconsistent metadata. An extra column was supplied during
execution that was not found at compile time." However, for SQL Server 7.0,
there is an article.
266337 PRB: Some SQL Server 7.0 Service Pack 2 Updates Must be Added
Manually
http://support.microsoft.com/?id=266337
However, I did not find any known issue regarding the same error on SQL
Server 2000. According to your description, it seems that the problem also
occurs on SQL Server 2000. Am I right? Since the problem randomly occurs,
it is very difficult to troubleshoot. However, please try the following
steps first:
1. The output from running "sp_helpserver" from the SQL Server 2000 machine
and the name of the linked server which encounters the problem.
2. Does dropping the linked server and adding it back work?
3. The output from the Component Checker from SQL Server 2000.
http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-
BF53-14332EF092C9&displaylang=en
Bill Cheng
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--
| From: "Stan" <nospam@.yahoo.com>
| References: <OjwKinVeDHA.616@.TK2MSFTNGP11.phx.gbl>
<zOPgrT2eDHA.3900@.cpmsftngxa07.phx.gbl>
| Subject: Re: Error 7356 - do we have to live with that?
| Date: Mon, 15 Sep 2003 08:02:11 -0400
| Lines: 71
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <ejcAJF4eDHA.1712@.TK2MSFTNGP11.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 12.148.36.131
| Path:
cpmsftngxa07.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08|||Bill,
> However, I did not find any known issue regarding the same error on SQL
> Server 2000. According to your description, it seems that the problem also
> occurs on SQL Server 2000. Am I right?
It ocurrs in the query on SQL Server 2000 against SQL Server 7.0 linked
server.
So, the culprilt is probably SQL Server 7.0
> 2. Does dropping the linked server and adding it back work?
No, it does not
Thanks!
-Stan|||Bill,
> However, I did not find any known issue regarding the same error on SQL
> Server 2000. According to your description, it seems that the problem also
> occurs on SQL Server 2000. Am I right?
It ocurrs in the query on SQL Server 2000 against SQL Server 7.0 linked
server.
So, the culprilt is probably SQL Server 7.0
> 2. Does dropping the linked server and adding it back work?
No, it does not
Thanks!
-Stan|||Hi Stan,
According to my research, we need to install Service pack 4 and also apply
the Instcat.sql manually.
Bill Cheng
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--
| From: "Stan" <nospam@.yahoo.com>
| References: <OjwKinVeDHA.616@.TK2MSFTNGP11.phx.gbl>
<zOPgrT2eDHA.3900@.cpmsftngxa07.phx.gbl>
<ejcAJF4eDHA.1712@.TK2MSFTNGP11.phx.gbl>
<noEhU9LfDHA.1388@.cpmsftngxa06.phx.gbl>
<#OO9DMRfDHA.2320@.TK2MSFTNGP12.phx.gbl>
<0fWgE0dfDHA.2588@.cpmsftngxa06.phx.gbl>
| Subject: Re: Error 7356 - do we have to live with that?
| Date: Thu, 18 Sep 2003 15:34:12 -0400
| Lines: 69
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <eNgonvhfDHA.1732@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 12.148.36.131
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:307320
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Bill,
|
| No, we don't have the hotfix on 7.0. Woudn't be better to put the latest
| service pack for SQL 7.0 (I guess it SP4)?
|
| ""Bill Cheng [MSFT]"" <billchng@.online.microsoft.com> wrote in message
| news:0fWgE0dfDHA.2588@.cpmsftngxa06.phx.gbl...
| > Hi Stan,
| >
| > Have you tried the methods in 266337? I have not found any known issue
| > regarding this in SQL Server 2000.
| >
| > Has the error occurred after you apply 266337 on SQL Server 7.0? If so,
| > could you let me know what operations you have performed before the
error
| > occurs?
| >
| >
| > Bill Cheng
| > Microsoft Online Partner Support
| >
| > Get Secure! - www.microsoft.com/security
| > This posting is provided "as is" with no warranties and confers no
rights.
| > --
| > | From: "Stan" <nospam@.yahoo.com>
| > | References: <OjwKinVeDHA.616@.TK2MSFTNGP11.phx.gbl>
| > <zOPgrT2eDHA.3900@.cpmsftngxa07.phx.gbl>
| > <ejcAJF4eDHA.1712@.TK2MSFTNGP11.phx.gbl>
| > <noEhU9LfDHA.1388@.cpmsftngxa06.phx.gbl>
| > | Subject: Re: Error 7356 - do we have to live with that?
| > | Date: Wed, 17 Sep 2003 07:57:59 -0400
| > | Lines: 21
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| > | Message-ID: <#OO9DMRfDHA.2320@.TK2MSFTNGP12.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.server
| > | NNTP-Posting-Host: 12.148.36.131
| > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| > | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:306904
| > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > |
| > | Bill,
| > |
| > | > However, I did not find any known issue regarding the same error on
| SQL
| > | > Server 2000. According to your description, it seems that the
problem
| > also
| > | > occurs on SQL Server 2000. Am I right?
| > |
| > | It ocurrs in the query on SQL Server 2000 against SQL Server 7.0
linked
| > | server.
| > | So, the culprilt is probably SQL Server 7.0
| > |
| > | > 2. Does dropping the linked server and adding it back work?
| > | No, it does not
| > |
| > |
| > |
| > | Thanks!
| > |
| > | -Stan
| > |
| > |
| > |
| > |
| >
|
|
|
(OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column
was supplied during execution that was not found at compile time.
OLE DB error trace [Non-interface error: OLE DB provider returned an extra
column at execution time: ProviderName=.....)
I change the table name to a view returning all columns of the same table.
I have been doing this since SQL 7.0.
1. Is it an unfixable bug we have to live with?
2. Is there a better way of fixing the problem other than creating a view?
Thanks,
-StanHi Stan,
What is your SQL Server version? Is it SQL Server 7.0 SP4 or SQL Server
2000 SP3?
From your post, I am not sure about the steps to reproduce the problem.
Could you post it so that I can check further?
Bill Cheng
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--
| From: "Stan" <nospam@.yahoo.com>
| Subject: Error 7356 - do we have to live with that?
| Date: Fri, 12 Sep 2003 14:15:35 -0400
| Lines: 20
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <OjwKinVeDHA.616@.TK2MSFTNGP11.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 12.148.36.131
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:306189
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| To resolve a well know issue with quering a linked server:
|
| (OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra
column
| was supplied during execution that was not found at compile time.
| OLE DB error trace [Non-interface error: OLE DB provider returned an
extra
| column at execution time: ProviderName=.....)
|
| I change the table name to a view returning all columns of the same table.
|
| I have been doing this since SQL 7.0.
|
| 1. Is it an unfixable bug we have to live with?
|
| 2. Is there a better way of fixing the problem other than creating a view?
|
| Thanks,
|
| -Stan
|
|
||||Hi Stan,
I have found several articles regarding error "OLE DB provider 'SQLOLEDB'
supplied inconsistent metadata. An extra column was supplied during
execution that was not found at compile time." However, for SQL Server 7.0,
there is an article.
266337 PRB: Some SQL Server 7.0 Service Pack 2 Updates Must be Added
Manually
http://support.microsoft.com/?id=266337
However, I did not find any known issue regarding the same error on SQL
Server 2000. According to your description, it seems that the problem also
occurs on SQL Server 2000. Am I right? Since the problem randomly occurs,
it is very difficult to troubleshoot. However, please try the following
steps first:
1. The output from running "sp_helpserver" from the SQL Server 2000 machine
and the name of the linked server which encounters the problem.
2. Does dropping the linked server and adding it back work?
3. The output from the Component Checker from SQL Server 2000.
http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-
BF53-14332EF092C9&displaylang=en
Bill Cheng
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--
| From: "Stan" <nospam@.yahoo.com>
| References: <OjwKinVeDHA.616@.TK2MSFTNGP11.phx.gbl>
<zOPgrT2eDHA.3900@.cpmsftngxa07.phx.gbl>
| Subject: Re: Error 7356 - do we have to live with that?
| Date: Mon, 15 Sep 2003 08:02:11 -0400
| Lines: 71
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <ejcAJF4eDHA.1712@.TK2MSFTNGP11.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 12.148.36.131
| Path:
cpmsftngxa07.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08|||Bill,
> However, I did not find any known issue regarding the same error on SQL
> Server 2000. According to your description, it seems that the problem also
> occurs on SQL Server 2000. Am I right?
It ocurrs in the query on SQL Server 2000 against SQL Server 7.0 linked
server.
So, the culprilt is probably SQL Server 7.0
> 2. Does dropping the linked server and adding it back work?
No, it does not
Thanks!
-Stan|||Bill,
> However, I did not find any known issue regarding the same error on SQL
> Server 2000. According to your description, it seems that the problem also
> occurs on SQL Server 2000. Am I right?
It ocurrs in the query on SQL Server 2000 against SQL Server 7.0 linked
server.
So, the culprilt is probably SQL Server 7.0
> 2. Does dropping the linked server and adding it back work?
No, it does not
Thanks!
-Stan|||Hi Stan,
According to my research, we need to install Service pack 4 and also apply
the Instcat.sql manually.
Bill Cheng
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--
| From: "Stan" <nospam@.yahoo.com>
| References: <OjwKinVeDHA.616@.TK2MSFTNGP11.phx.gbl>
<zOPgrT2eDHA.3900@.cpmsftngxa07.phx.gbl>
<ejcAJF4eDHA.1712@.TK2MSFTNGP11.phx.gbl>
<noEhU9LfDHA.1388@.cpmsftngxa06.phx.gbl>
<#OO9DMRfDHA.2320@.TK2MSFTNGP12.phx.gbl>
<0fWgE0dfDHA.2588@.cpmsftngxa06.phx.gbl>
| Subject: Re: Error 7356 - do we have to live with that?
| Date: Thu, 18 Sep 2003 15:34:12 -0400
| Lines: 69
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <eNgonvhfDHA.1732@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 12.148.36.131
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:307320
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Bill,
|
| No, we don't have the hotfix on 7.0. Woudn't be better to put the latest
| service pack for SQL 7.0 (I guess it SP4)?
|
| ""Bill Cheng [MSFT]"" <billchng@.online.microsoft.com> wrote in message
| news:0fWgE0dfDHA.2588@.cpmsftngxa06.phx.gbl...
| > Hi Stan,
| >
| > Have you tried the methods in 266337? I have not found any known issue
| > regarding this in SQL Server 2000.
| >
| > Has the error occurred after you apply 266337 on SQL Server 7.0? If so,
| > could you let me know what operations you have performed before the
error
| > occurs?
| >
| >
| > Bill Cheng
| > Microsoft Online Partner Support
| >
| > Get Secure! - www.microsoft.com/security
| > This posting is provided "as is" with no warranties and confers no
rights.
| > --
| > | From: "Stan" <nospam@.yahoo.com>
| > | References: <OjwKinVeDHA.616@.TK2MSFTNGP11.phx.gbl>
| > <zOPgrT2eDHA.3900@.cpmsftngxa07.phx.gbl>
| > <ejcAJF4eDHA.1712@.TK2MSFTNGP11.phx.gbl>
| > <noEhU9LfDHA.1388@.cpmsftngxa06.phx.gbl>
| > | Subject: Re: Error 7356 - do we have to live with that?
| > | Date: Wed, 17 Sep 2003 07:57:59 -0400
| > | Lines: 21
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| > | Message-ID: <#OO9DMRfDHA.2320@.TK2MSFTNGP12.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.server
| > | NNTP-Posting-Host: 12.148.36.131
| > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| > | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:306904
| > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > |
| > | Bill,
| > |
| > | > However, I did not find any known issue regarding the same error on
| SQL
| > | > Server 2000. According to your description, it seems that the
problem
| > also
| > | > occurs on SQL Server 2000. Am I right?
| > |
| > | It ocurrs in the query on SQL Server 2000 against SQL Server 7.0
linked
| > | server.
| > | So, the culprilt is probably SQL Server 7.0
| > |
| > | > 2. Does dropping the linked server and adding it back work?
| > | No, it does not
| > |
| > |
| > |
| > | Thanks!
| > |
| > | -Stan
| > |
| > |
| > |
| > |
| >
|
|
|
Error 7303 Could not initialize data source object of OLE DB provi
I am trying to link to an AS400 server. When I set up the link I am getting
Error 7303 Could not initialize data source object of OLE DB provider.
I know that there are problably parameters that I need to add to the
connection but am not sure where to start. Can someone help me troubleshoot
this issue?
Install Client Access on the SQL Server box and make sure
you have the client updated with whatever service pack level
based on updates to the AS400. Then configure the linked
server as described in books online under Linked Servers,
configuring.
For data source, use the IP address of the AS400.
For provider string, you need to include the library you are
using, connect timeout setting and code page. There is some
documentation for the settings in the Client Access help
files.
You'd set the provider string somewhat like:
InitCat=YourLibrary;CCSID=37;PCCodePage=1252;
Data Source=xxx.xxx.xxx.xxx
Settings will depend on how your AS400 is configured. Again,
the Client Access help files have information on the
necessary connection string settings.
-Sue
On Fri, 14 Oct 2005 08:22:11 -0700, Linda Ibarra
<LindaIbarra@.discussions.microsoft.com> wrote:
>I am trying to link to an AS400 server. When I set up the link I am getting
>Error 7303 Could not initialize data source object of OLE DB provider.
>I know that there are problably parameters that I need to add to the
>connection but am not sure where to start. Can someone help me troubleshoot
>this issue?
Error 7303 Could not initialize data source object of OLE DB provider.
I know that there are problably parameters that I need to add to the
connection but am not sure where to start. Can someone help me troubleshoot
this issue?
Install Client Access on the SQL Server box and make sure
you have the client updated with whatever service pack level
based on updates to the AS400. Then configure the linked
server as described in books online under Linked Servers,
configuring.
For data source, use the IP address of the AS400.
For provider string, you need to include the library you are
using, connect timeout setting and code page. There is some
documentation for the settings in the Client Access help
files.
You'd set the provider string somewhat like:
InitCat=YourLibrary;CCSID=37;PCCodePage=1252;
Data Source=xxx.xxx.xxx.xxx
Settings will depend on how your AS400 is configured. Again,
the Client Access help files have information on the
necessary connection string settings.
-Sue
On Fri, 14 Oct 2005 08:22:11 -0700, Linda Ibarra
<LindaIbarra@.discussions.microsoft.com> wrote:
>I am trying to link to an AS400 server. When I set up the link I am getting
>Error 7303 Could not initialize data source object of OLE DB provider.
>I know that there are problably parameters that I need to add to the
>connection but am not sure where to start. Can someone help me troubleshoot
>this issue?
Error 7303 Could not initialize data source object of OLE DB provi
I am trying to link to an AS400 server. When I set up the link I am getting
Error 7303 Could not initialize data source object of OLE DB provider.
I know that there are problably parameters that I need to add to the
connection but am not sure where to start. Can someone help me troubleshoot
this issue?Install Client Access on the SQL Server box and make sure
you have the client updated with whatever service pack level
based on updates to the AS400. Then configure the linked
server as described in books online under Linked Servers,
configuring.
For data source, use the IP address of the AS400.
For provider string, you need to include the library you are
using, connect timeout setting and code page. There is some
documentation for the settings in the Client Access help
files.
You'd set the provider string somewhat like:
InitCat=YourLibrary;CCSID=37;PCCodePage=
1252;
Data Source=xxx.xxx.xxx.xxx
Settings will depend on how your AS400 is configured. Again,
the Client Access help files have information on the
necessary connection string settings.
-Sue
On Fri, 14 Oct 2005 08:22:11 -0700, Linda Ibarra
<LindaIbarra@.discussions.microsoft.com> wrote:
>I am trying to link to an AS400 server. When I set up the link I am getting
>Error 7303 Could not initialize data source object of OLE DB provider.
>I know that there are problably parameters that I need to add to the
>connection but am not sure where to start. Can someone help me troubleshoot
>this issue?
Error 7303 Could not initialize data source object of OLE DB provider.
I know that there are problably parameters that I need to add to the
connection but am not sure where to start. Can someone help me troubleshoot
this issue?Install Client Access on the SQL Server box and make sure
you have the client updated with whatever service pack level
based on updates to the AS400. Then configure the linked
server as described in books online under Linked Servers,
configuring.
For data source, use the IP address of the AS400.
For provider string, you need to include the library you are
using, connect timeout setting and code page. There is some
documentation for the settings in the Client Access help
files.
You'd set the provider string somewhat like:
InitCat=YourLibrary;CCSID=37;PCCodePage=
1252;
Data Source=xxx.xxx.xxx.xxx
Settings will depend on how your AS400 is configured. Again,
the Client Access help files have information on the
necessary connection string settings.
-Sue
On Fri, 14 Oct 2005 08:22:11 -0700, Linda Ibarra
<LindaIbarra@.discussions.microsoft.com> wrote:
>I am trying to link to an AS400 server. When I set up the link I am getting
>Error 7303 Could not initialize data source object of OLE DB provider.
>I know that there are problably parameters that I need to add to the
>connection but am not sure where to start. Can someone help me troubleshoot
>this issue?
Sunday, March 11, 2012
Error 534 trying to run report
I have written a report in the Crystal IDE that runs fine. It is using OLE DB to a SQL Server database. When I then try to run that report at runtime, outside of Crystal, I get an error 534 returned. I am using the CPRE32 API and I am using version 8.5.Try looking up the error number or error description on www.google.com or on Crystal's Website: http://support.businessobjects.com/search/advsearch.asp|||I have done both of those. There is quite a bit of good information out there. But none of it so far has helped me. I recently tried switching from using P2SOLEDB.DLL to P2SSQL.DLL just to see what would happen, but I still get 534...|||Have you verified database?I usually get error 534 when database verification is needed.|||I will post this info here in hopes that it will help others who search for this problem.
The solution to my 534 problem was to use the PESetNthTableLocation API call. I had to call Crystal support to get this information.
The problem was caused by my changing database names at runtime.
I wrote all my reports to report on database "A", so to Crystal, the database "location" was "A.dbo.tablename". Then, at runtime, if the user of my application was running the reports on database "B", I was calling PESetNthTableLogOnInfo and setting the database to "B". However, according to Crystal support, sometimes that is not enough. Sometimes you also have to change the database location. So, once I called PESetNthTableLocation (setting it to "B.dbo.tablename") in addition to PESetNthTableLogOnInfo, it worked fine...
The solution to my 534 problem was to use the PESetNthTableLocation API call. I had to call Crystal support to get this information.
The problem was caused by my changing database names at runtime.
I wrote all my reports to report on database "A", so to Crystal, the database "location" was "A.dbo.tablename". Then, at runtime, if the user of my application was running the reports on database "B", I was calling PESetNthTableLogOnInfo and setting the database to "B". However, according to Crystal support, sometimes that is not enough. Sometimes you also have to change the database location. So, once I called PESetNthTableLocation (setting it to "B.dbo.tablename") in addition to PESetNthTableLogOnInfo, it worked fine...
Subscribe to:
Posts (Atom)