OLAP Connection error

Below code at web.config file, when i change Data Source to other pc name....an error occur 'The data provider didn't supply any further error information'...
let said change the datasource 'localhost' to 'webserver' error will occur...so i cannot run the program at my pc and link the olap database at server...

<add key="OLAPConnectionString" value="Provider=MSOLAP.2;Data Source=localhost;Initial Catalog=Foodmart 2000;" />The other PC that you are trying to connect should have the same users and user rights as the first one.

In addition to that, the Analysis Server on your second PC should know about these users as well.

I found that security with Analysis Server is very tight.

Good Luck

of any concern??

This is a reoccurring error in one of our Domain Controllers event logs…

Event Type: Error
Event Source: KDC
Event Category: None
Event ID: 11
Date: 7/24/2007
Time: 6:23:05 AM
User: N/A
Computer: DC2
Description:
There are multiple accounts with name MSSQLSvc/dbsrvr-02.olntv.local:1433 of type DS_SERVICE_PRINCIPAL_NAME.

the Server dbsrvr-02 (sql server 2000 standard edition sp3a) has a default instance and it looksl ike 2 named instances installed that we are not using. Ive searched this error and cannot find a thing.. should this concern me? anyone ?Fyi http://www.eventid.net/display.asp?eventid=11&eventno=569&source=KDC&phase=1 and also if you areusing active directory, i t means there are duplicate entries in Active Directory for this service principal name. A directory administrator can use ldp.exe to search for the duplicates and either ldp.exe again or adsiedit.msc to delete the duplicates.

ODS

In the Event Log I'm received next message:
Source: MSSQLServer
Category: ODS
ID: 17052
Error: 17833, Severity: 18, State: 1 yyyy-mm-dd hh:mm:ss ods ListenOn
connection 'servername' is already in use.
But my SQL Server are working normally.
What's a problem?
Michael S. Androsov
EXPOCENTRHi,
Another application or service running in the server would have taken
control of the port before SQL Server starts.
Have a look into the below article.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;293107
Thanks
Hari
MCDBA
"Michael S. Androsov" <androsov@.expocentr.ru> wrote in message
news:f99f3e13.0403030156.77a793c5@.posting.google.com...
> In the Event Log I'm received next message:
> Source: MSSQLServer
> Category: ODS
> ID: 17052
> Error: 17833, Severity: 18, State: 1 yyyy-mm-dd hh:mm:ss ods ListenOn
> connection 'servername' is already in use.
> But my SQL Server are working normally.
> What's a problem?
> Michael S. Androsov
> EXPOCENTR|||"Hari" <hari_prasad_k@.hotmail.com> wrote in message news:<OkydjcQAEHA.712@.tk2msftngp13.phx.gbl>...
> Hi,
> Another application or service running in the server would have taken
> control of the port before SQL Server starts.
> Have a look into the below article.
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;293107
> Thanks
> Hari
> MCDBA
> "Michael S. Androsov" <androsov@.expocentr.ru> wrote in message
> news:f99f3e13.0403030156.77a793c5@.posting.google.com...
> > In the Event Log I'm received next message:
> > Source: MSSQLServer
> > Category: ODS
> > ID: 17052
> > Error: 17833, Severity: 18, State: 1 yyyy-mm-dd hh:mm:ss ods ListenOn
> > connection 'servername' is already in use.
> >
> > But my SQL Server are working normally.
> >
> > What's a problem?
> >
> > Michael S. Androsov
> > EXPOCENTR
I have't other applications working with 1433 or 1118 ports. If this
applications exist my SQL Server will not working. But now the server
is working.
Michael S. Androsov
EXPOCENTR

odd things...I''m totally stuck

Hi all of you,

I've got a .dtproj project along with 10 dtsx packages. Up to here everything is fine, every package have its own source files, sql destinations and so on..

Issue comes when I try create a flat file source connection for the eleven one.

I get this message:

The component has detected potential metadata corruption during validation.
Error at Data Flow Task [Flat File Source [1]]: Failed to find any non-special error column in output "Flat File Source Error Output" (3).

It may not be possible to recover to a valid state using a component-specific editor. Do you want to use the Advanced Editor dialog box for editing this component?

Otherwise if I'm gonna to open a new .dtproj project separately no problem at all, I mean, appears the suitable window, "Connection Manager", "Column", "Error output" on the left and so on..

It's very strange. The rest of the packages, the same situation. Fortunately, all of them are stored on the server.

I don't get the point at all. Could you please tell me what the hell is happening?

Thanks in advance and regards,

amazing...after closing the project and re-opening the bloody eleven package appears without nothing... tasks, everything is lost.. only a white surface..

Is it possible that it has became a rotten project?

|||

Sorry. "Work offline"......

sql

Odd error with Reporting Services and Oracle

I've got a fairly simple report that hits oracle with two parameters set as strings.

When I run the query in the designer, I get

Error Source: System.Data.OracleClient
Error Message: ORA-01858: a non-numeric character was found where a numeric was expected

However, when I run the report in preview everything just works. Same inputs on the parameters.

Any ideas?

What types are your parameters and what is the SQL you are using in your DataSet? I've seen this kind of error passing a parameter that is declared as a string in the report to an oracle parameter that is compared against a Date type in Oracle.

Mike

|||Sorery I meant to post a followup to this. The solution is that SQL RS 2k5 takes a string that happens to be a date and makes it a date without telling.

When it goes into oracle as this "Date" it will go in in the default SQL date format. So you need to match the format mask in the oracle TO_Date function call to the 3 letter month sql format.

Interesting, RS 2K did not do this.

ODBC-based to OLE DB-based data transfer

I would like to transfer selected data from an ODBC-based table to a OLEDB-based table. However, there isn't a data flow source on the Data Flow Design screen to accomodate such an action. Please help!

Roberto,

You need to create a package with a DataFlow task in it; then inside of the DataFlow; then from the toolbox you can use a Data Reader component to use an ODBC connection. Additionally you will need to add any data transformation logic/tasks and an OLE DB destination component.

There is not such 'all-in-one' task to perform what you want; but you have many components that you can combine together to get it

Rafael Salas

ODBC-based to OLE DB-based data transfer

I would like to transfer selected data from an ODBC-based table to a OLEDB-based table. However, there isn't a data flow source on the Data Flow Design screen to accomodate such an action. Please help!

Roberto,

You need to create a package with a DataFlow task in it; then inside of the DataFlow; then from the toolbox you can use a Data Reader component to use an ODBC connection. Additionally you will need to add any data transformation logic/tasks and an OLE DB destination component.

There is not such 'all-in-one' task to perform what you want; but you have many components that you can combine together to get it

Rafael Salas

ODBC to MSDE

I need to write a VB.Net application in VS.net 2003 that copies several tables from an ODBC data source to MSDE tables. I do not have Enterprise Manager or DTS to use. Is there an example of this in VS? I was hoping VS has some built in tools for this. If not, bulk Insert?

Help appreciated.
thanks,
FrankI would consider using MS Access for this, as it accesses both ODBC and MSDE data sources quite well (presuming this is not something that needs to run like a service).|||I ruled out Access because of several reasons. My next step is to schedule the scripts thru the SQL agent that MSDE comes with.

Help appreciated.
Thanks,
Frank

ODBC source error message on Vista 64

I tried to create an ODBS syste data source but I get this error:

Connection Failed:

SQLState:'01000'

SQL Server Error:10061

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect())

Connection Failed:

SQLState:'08001'

SQL Server Error:17

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Server does not Excist or access denied.

Thanks

The connection string you are using is either not right are the server is not reachable. For investigating this issue you should answer some questions. Is the server on the same server as the SQL Server ? Which version are you using ? Are you using a named instance ? Are you using the default port or any other manually configured one ? DO you h ave a firewall enabled, if yes, did you configure exceptions for outgoing communication for the designated port mentioned above ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

ODBC Select Data Source in Crystal reports - continuously prompts

I've created an ODBC entry for crystal reports. When I go to refresh and
run a report, it always prompts me with a select data source and SQL server
is at the bottom of the list under dBase, Excel and MS Access Database. If
I select it, the report runs. How do I have it automatically choose that
source so I don't have to select it each time?
Thank you.You should ask this question in a Crystal support newsgroup or site.
This one is for SQL Server, so your pickings will be slim.
-- Mary
MCW Technologies
http://www.mcwtech.com
On Fri, 26 Dec 2003 13:41:50 -0500, "microsoft"
<advice1one@.hotmail.com> wrote:

quote:

---

>I've created an ODBC entry for crystal reports. When I go to refresh and
>run a report, it always prompts me with a select data source and SQL server
>is at the bottom of the list under dBase, Excel and MS Access Database. If
>I select it, the report runs. How do I have it automatically choose that
>source so I don't have to select it each time?
>Thank you.
>

---

|||Thank you, I figured it out, I needed to change the ODBC connector to named
pipes.
"Mary Chipman" <mchip@.nomail.please> wrote in message
news:do51vv0gshsu7e2g9mr6bl0i9sinf4bq4t@.
4ax.com...

quote:

---

> You should ask this question in a Crystal support newsgroup or site.
> This one is for SQL Server, so your pickings will be slim.
> -- Mary
> MCW Technologies
> http://www.mcwtech.com
> On Fri, 26 Dec 2003 13:41:50 -0500, "microsoft"
> <advice1one@.hotmail.com> wrote:
>
server[QUOTE]
If[QUOTE]
>

---

ODBC Program & Heterogeneous queries problem

Best All,

What I am doing is following:
1. I created a stored procedure "testit" which select records from another data source in another SQL Server, like:

------------
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
go

create procedure testit
as begin
select * from [AnotherSQLServer].bugtest.dbo.mssent
end

grant execute on testit to public
------------

2. I can execute this stored procedure in SQL Query Analyser with success.

3. BUT: now I write a ODBC program trying to call this stored procedure, then it give me following "famous" error:
42000 [Microsoft][ODBC SQL Server Driver][SQL Server]Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.

The ODBC program looks like this:
--------
strcpy((char *) sqltext, "{call testit}");
rc = SQLPrepare(hstmt, (unsigned char *) sqltext, SQL_NTS);
rc = SQLExecute(hstmt);
--------

My Question:
1. Does ODBC API support Heterogeneous queries ?
2. If well, how to solve above problem?

Thanks a lot,

MelThe solution can be found here:

http://dbforums.com/t905850.html

use some thing like this (before calling SQLConnect() ):
SQLSetConnectAttr( hdbc,SQL_COPT_SS_ANSI_NPW,(void *) SQL_AD_ON, 0);

ODBC password not saved in configuration file

Hi,

I have an SSIS package that pipes data from an iSeries data source to a SQL Server table. The connection manager I am using is the .Net Providers\Odbc Data Provider

When I run this SSIS package on my developer PC (from inside BIDS or using the Management Studio Execute Package Utility) it works. However when I run the package from within a SQL Server Agent Job it fails.

I have enabled logging and the error message given is:

System.Data.Odbc.OdbcException: ERROR [28000] [IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=8002 - CWBSY0002 - Password for user MALLPRESS on server SMICHC is not correct, Password length = 0, Prompt Mode = Never, System IP Address = 172.16.0.4 ERROR [28000] [IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=8002 - CWBSY0002 - Password for user MALLPRESS on server SMICHC is not correct, Password length = 0, Prompt Mode = Never, System IP Address = 172.16.0.4

It gives the message “Password length = 0” despite the fact that I have specified a password in the package.

To try to get around this I have added an XML configuration file to the SSIS package. In this configuration file I’ve set values for the ConnectionString, UserName, and Password.

I still get the above error about a password length of 0.

I have also tried to execute the package using dtexec, but this gives a similar error.

The SQL used to run this is:

xp_cmdshell 'dtexec /sq "\SCSRV-06\DTS Packages\Staging\StagingBranchImport"'

This has got me stumped, and I’m not sure where to go from here as these packages need to be programmatically run each morning. At the moment I am manually running them from within BIDS.

All packages that don’t use an iSeries connection manager run successfully in SQL Agent jobs.

I have also tried using the OLEDB connection manager (ibm db2 udb for iseries ibmda400 ole db provider) without success.

Any help would be very appreciated.

Thanks, Matt

SSIS will NOT store the password in the file for you. You have to edit the file manually to put the password in there. Have you done that?

-Jamie

|||

Hi Jamie,

Yes I have manually edited the config file and entered the password.

Matt

|||

Just to let anyone who's interested know....

I now have it working. The problem was that I did not have administrator access to the server, and so was using a network share to store the configuration file. I now how admin access to the windows server, and have moved the config file to the server's C:\, which has fixed the problem.

Matt

|||

Thanks for posting the solution, I am just ran into that problem today - ODBC works fine on local machine but when I move to production I get the password length error, even though I set the password in my package. I will try the package configuration file tomorrow.

I'm having the same problem with the iSeries Access OLEDB drivers - I can't seem to get them to work. Did you ever get them to work? I'm using 5v3 iSeries Access.

ODBC password not saved in configuration file

Hi,

I have an SSIS package that pipes data from an iSeries data source to a SQL Server table. The connection manager I am using is the .Net Providers\Odbc Data Provider

When I run this SSIS package on my developer PC (from inside BIDS or using the Management Studio Execute Package Utility) it works. However when I run the package from within a SQL Server Agent Job it fails.

I have enabled logging and the error message given is:

System.Data.Odbc.OdbcException: ERROR [28000] [IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=8002 - CWBSY0002 - Password for user MALLPRESS on server SMICHC is not correct, Password length = 0, Prompt Mode = Never, System IP Address = 172.16.0.4 ERROR [28000] [IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=8002 - CWBSY0002 - Password for user MALLPRESS on server SMICHC is not correct, Password length = 0, Prompt Mode = Never, System IP Address = 172.16.0.4

It gives the message “Password length = 0” despite the fact that I have specified a password in the package.

To try to get around this I have added an XML configuration file to the SSIS package. In this configuration file I’ve set values for the ConnectionString, UserName, and Password.

I still get the above error about a password length of 0.

I have also tried to execute the package using dtexec, but this gives a similar error.

The SQL used to run this is:

xp_cmdshell 'dtexec /sq "\SCSRV-06\DTS Packages\Staging\StagingBranchImport"'

This has got me stumped, and I’m not sure where to go from here as these packages need to be programmatically run each morning. At the moment I am manually running them from within BIDS.

All packages that don’t use an iSeries connection manager run successfully in SQL Agent jobs.

I have also tried using the OLEDB connection manager (ibm db2 udb for iseries ibmda400 ole db provider) without success.

Any help would be very appreciated.

Thanks, Matt

SSIS will NOT store the password in the file for you. You have to edit the file manually to put the password in there. Have you done that?

-Jamie

|||

Hi Jamie,

Yes I have manually edited the config file and entered the password.

Matt

|||

Just to let anyone who's interested know....

I now have it working. The problem was that I did not have administrator access to the server, and so was using a network share to store the configuration file. I now how admin access to the windows server, and have moved the config file to the server's C:\, which has fixed the problem.

Matt

|||

Thanks for posting the solution, I am just ran into that problem today - ODBC works fine on local machine but when I move to production I get the password length error, even though I set the password in my package. I will try the package configuration file tomorrow.

I'm having the same problem with the iSeries Access OLEDB drivers - I can't seem to get them to work. Did you ever get them to work? I'm using 5v3 iSeries Access.

ODBC in SQL Query Analyzer

Is there any way to use an ODBC data source in MS SQL Query Analyzer? I
need to join an MS SQL table with a table from a non MSSQL database.
DTS would allow me to import the alient table but I want to avoid that,
if possible.
thanks"EoRaptor013" <rchrismon@.patmedia.net> wrote in message
news:1107369347.205441.278230@.g14g2000cwa.googlegr oups.com...
> Is there any way to use an ODBC data source in MS SQL Query Analyzer? I
> need to join an MS SQL table with a table from a non MSSQL database.
> DTS would allow me to import the alient table but I want to avoid that,
> if possible.
> thanks

Check out sp_addlinkedserver and "Configuring Linked Servers" in Books
Online - you can define a link to a data source on the MSSQL server, then
query it directly with TSQL.

Simon|||Check out the OPENROWSET function if your external datasource is also
OLE DB compatible. (There is, I think, is a OLE DB provider for ODBC
so you should be able to use this).

--
David Rowland
For a good monitor for Users and Server usage, try DBMonitor
http://dbmonitor.tripod.com

ODBC Import of Citadel to SQL 2005

How do you import using integration services or what ever to import from a Citadel database? I have created an ODBC Data Source using National Instruments ODBC driver for Citadel? I have tried using Microsoft Access, but the field names are longer than 62 characters and Access won't "link" to the ODBC Data Source.

The SQL Server Management Studio\Tasks\Import Wizard doesn't appear to have a way to specify an ODBC Data Source.

Try building a new data flow using the DataReader Source component.|||Thanks, I was able to access ODBC through the "SQL Server Business Intelligence Development Studio". Although that starts a new learning curve for me. Plus there seems to be something I don't understand about National Instrument's Citadel ODBC driver--when I query one of the tables only 35 records are returned and there should be several hundred thousand records available and several thousand for the queries date and time range. Not your problem--next step is to contact NI support about their driver, etc.