How To Create A Connection Into Sybase Database

Sep 12, 2007

Hi, i already create a connection to sybase(ASA) with odbc from ssis (from "data sources" section). but when i try to make data flow source it cann't. so i try to make a connection using "data source views" but when the process comes to end, it becomes error. from my analysis, the Sybase db cannot accept sql command with "[]", because in the fase "data source views" i have to select one or more table, and the default microsoft is using "[]", like: select * from [dbo].[customer], but sybase db cannot handle this. does anyone have the solution for this? Thanks.

Sincerely

Yugicm

View 1 Replies


ADVERTISEMENT

SSIS Project Failing To Run Even Though I Verified Remote Sybase Connection Via Connection Manager

Apr 7, 2008



When running the project in debug mode or non-debug mode, I get the following error from MS Visual Studio:

TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Package [Connection manager "SYBASE_CONNECTION"]: The connection manager failed to defect from the transaction.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------

Any ideas???

View 8 Replies View Related

Create Linked Server To SYBASE ASA 9.0

Apr 2, 2008


Hi all,

I´m trying to create a linked server to a Sybase database (.db file) so i can create some reports in sql 2005 (with Reporting Services and Report Designer). After reading all articles I did the following.

1) Installe Adaptive Server Anyhwere (Interactive Sql) 9.0.2 on the server.
2) Created a USER DSN to the Db file (Control Panel - odbc connections) and it works fine: The Settings for the ODBC are:


ODBC Tab


Data Source Name: dbNOM

Login Tab


Supply userID and Password: (selected)

User ID: DBA

Password: SQL

Database Tab


Server Name: dbNOM

StartLine: C:Program FilesSybaseSQL Anywhere 9win32dbeng9.exe

Database Name: (blank)

Database File: c:Project FolderDataBase.db
As I said, when i go for "test connection", works fine.

3) Sql Management Studio - Object Explorer - Server Objects - New Linked Server, with settings as following:


General


Linked Server: lkDbNom

Server Type: Other Data Source

Provider: Sybase Adaptive Server Anywhere Provider 9.0

Product Name: Sybase

Product Name: dbNom (the dsn name, right?)

Security


Be made using this security context.- Remote Login: DBA; Password: SQL (same as DSN)
All other settings, as default, click in OK and shows no errors (aparently it creates the linked server successfully). But when i try to query the linked server with:


SELECT * FROM OPENQUERY ('SYBASE', 'SELECT * FROM nom_Robot')

And i get the following message:


Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'SYBASE'.

Even better, if i go to the Object Explorer - Server Objects, i test the connection and it´s ok, but when i try to retrieve the catalog an error displays:

TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The OLE DB provider "ASAProv.90" for linked server "SYBASE" reported an error. Access denied.
Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "ASAProv.90" for linked server "SYBASE". (Microsoft SQL Server, Error: 7399)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=7399&LinkId=20476


So, i really don´t understand what is missing in my linked server, i tried with MDASQL (OLEDB for ODBC) but it doesn´t even completes to create the linked server.

The database file is ok because, because in another server (one that doesn´t have SQL, only visual studio) i did the following:

1) Installe Adaptive Server Anyhwere (Interactive Sql) 9.0.2 on the server.
2) Created a DSN to the Db file, and it works fine. (copied the db file, so is local, no remote access), exactly the same setting as i did on the sql 2005 server.
3) Created a connection in visual studio 2008 (server explorer - data connections), i can retrieve sdata...but of course the provider is .NET Framework Data Provider for ODBC and i cannot use the same connection string.

Any ideas?

P.S.

View 7 Replies View Related

Linked Server Connection To Sybase

Mar 11, 2004

Has anyone had problems using an OLEDB linked server connection to Sybase ASE 12.5? I'm having major performance problems when I use string criteria in the where clause. Queries that return 1 row and execute in less than a second using a native Sybase connection take 40 seconds to run using the linked server OLEDB connection. If I use ints in the where clause performance is almost exactly the same between native and linked connections.

Any ideas???

View 9 Replies View Related

Sybase And SQLServer2005 Connection Problem

Aug 6, 2007

Dear all,

Installed sybase adaptive server Enterprize version 12.5.1 on Win2k3.

Database is working fine and started on Port No 2638.

While connecting to Sybase from Diver Sybase ASE ODBC Driver i am not able to connect to the database and getting error "connection time out" and "Verify Host Name and Port Number".

When i create a Connection from Integration Services 2005 i can connect to the Sybase Database and retive the table name but when i try to preview the table information i get the following error.

"Unable to retrieve column information from the DataSource".

Do i need to any other ODBC Driver to connect to sybase database.


regards,

sufian

View 2 Replies View Related

Sybase Connection In Xml Config File - Help

Jan 31, 2007

Hi all

I'm trying to connect to a Sybase DB using an OLE DB connection. Now, it works fine when I run the project without the package config enabled, but when I add the Sybase connection to the xml config file, & enable it the connection fails.

This is the error I see in the progress Tab

[Connection manager "AcidPrd.basketUser"] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "ASE OLE DB Provider" Hresult: 0x80004005 Description: "Login Failed. Check for valid user ID, server name and password.". An OLE DB record is available. Source: "ASE OLE DB Provider" Hresult: 0x80004005 Description: "[Native Error code: 4002] [DataDirect ADO Sybase Provider] Login failed. ".

Can anyone help.

Thanks,

Jon

View 6 Replies View Related

Can't Create Connection To Database

Feb 29, 2004

I am having trouble creating a connection to an MS SQL 2000 database located on a server at the hosting company I'm using, with code running from my localhost. It works when the code is executed on the server at my hosting company, but not when it is executed locally, on my computer. Also, I can't connect to the database using Enterprise Manager. The error I get is this:

SQL Server does not exist or access denied

It has worked before, so I don't understand why it doesn't anymore. It's not a firewall issue, since I have tried to connect with my firewall disabled as well.

Any tips or ideas?

View 4 Replies View Related

How To Create A Connection To Access Database

Dec 27, 2006

Hi guys,

I want to create a report from Access Database. Can anybody tell me how to connect and create a data source from Access data source. A step by step guide is preferable. I am more concerned on the connection string.

Thanks.

View 5 Replies View Related

Connection Strings For Create Database Queries

May 12, 2006

I'm using connection strings to SQL Server Express that have the form

"DataSource= .SQLEXPRESS;AttachDbFilename="(path to my development directory)CurrentDevelopmentDB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"

I'm assuming this works because the DB is already there, created "manually".

How might I build a connection string for a SQLCommand for a "Create DataBase" query?

I'm confused about what the AttachDbFileName would be, or if there would be another variable in its place, since there's no file yet.

Any guidance on this would be appreciated.

Thanks!

View 4 Replies View Related

Sybase 15.xxx Version (linking Sybase To Sqlserver 2005)

May 18, 2008

hi,

i tried the document below pertaining to linking sybase 12.5 to sqlserver 2000 and sqlserver 2005

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=311875&SiteID=17
http://www.sybase.com/content/1029118/1029118.doc

but when our company upgrade the sybase to 15.x i can't find the oledb configuration stated on the document.



so i can't linked the sybase 15.x now to sqlserver 2005. can somebody help me.!!!please...

where i can find the oledb configuration in sybase 15.xx..

tnx..

View 1 Replies View Related

SQL 2012 :: Dynamically Create Connection To A Database Within SSIS Package

Aug 6, 2015

I am trying to dynamically create the connection to a database within an SSIS package.

the requirement is to allow the user to pass through the database as a variable and that variable will dynamically create the connection string in the connection manager.

Is this possible, if so how?

View 0 Replies View Related

Convert The Database From Sybase 11.0.3 To MS SQL 6.5

Nov 9, 1998

Hi! We are trying to convert the database from Sybase 11.0.3 to MS SQL 6.5. Is there any quick/easy way to do the conversion without using bcp? any third party software we may use to make the conversion easier? Thank you very much!

View 2 Replies View Related

Cannot Access Database: Sybase

Feb 4, 2008

At first my office had blackout and sybase server unable to shutdown properly.

I have 4 database in that sybase server on unix AIX5 and only 3 database up and can be access after restart except for 1 database(mydb) show message recovery failed:

00:00000:00001:2008/02/02 21:08:30.73 server Recovering database 'mydb'.
00:00000:00001:2008/02/02 21:08:30.76 server Starting diagnostics for read fail
ure:
00:00000:00001:2008/02/02 21:08:30.77 server Device Information:
Device number = 8
Phyname = /data/my_db/mydbdatadev
00:00000:00001:2008/02/02 21:08:30.77 server Buffer Information:
Buf addr = 0x5068965c, Mass addr = 0x5068965c
Buf pageno = 114268, Mass pageno = 114268, dbid
= 6
00:00000:00001:2008/02/02 21:08:30.77 server
Buf virtpg = 134331998, Mass virtpg = 134331998
Buf stat = 0x1, Mass stat = 0x1008
Mass keep = 1, Mass awaited = 0

00:00000:00001:2008/02/02 21:08:30.77 server Page Information from first read a
ttempt: Page read from disk ppageno = 114268, pobjid = 1680005985, pindid = 255
pnextpg = 0, pprevpg = 0 plevel = 241, pstat = 0x4030 pts_hi = 0, pts_lo = 52098
23
00:00000:00001:2008/02/02 21:08:30.77 server Page Information from second read
attempt: Page read from disk ppageno = 114268, pobjid = 1680005985, pindid = 255
pnextpg = 0, pprevpg = 0 plevel = 241, pstat = 0x4030 pts_hi = 0, pts_lo = 5209
823

00:00000:00001:2008/02/02 21:08:30.77 server SDES Information:
dbid = 6, objid = 8, scur.pageid = 114268
sstat = 0x0, sstat2 = 0x4000000
suid = 1, cacheid = 0
00:00000:00001:2008/02/02 21:08:30.77 server PSS Information:
pstat = 0x1000, pcurdb = 6, pspid = 1
p2stat = 0x110, p3stat = 0x1000081e
plasterror = 0, preverror = 0, pattention = 0

00:00000:00001:2008/02/02 21:08:30.77 server End diagnostics for read failure:
00:00000:00001:2008/02/02 21:08:30.77 server Run the DBCC command 'dbcc tableal
loc' for both the objects 8, 1680005985
00:00000:00001:2008/02/02 21:08:30.78 server Error: 605, Severity: 21, State: 1
00:00000:00001:2008/02/02 21:08:30.78 server An attempt was made to fetch logic
al page '114268' in database 'mydb' from cache 'default data cache'. Page belo
ngs to object with id '1680005985', not to object 'syslogs'.
00:00000:00001:2008/02/02 21:08:30.80 server Error: 3414, Severity: 21, State:
1
00:00000:00001:2008/02/02 21:08:30.80 server Database 'mydb' (dbid 6): Recove
ry failed. Check the SQL Server errorlog for further information as to the cause

then i used sql to dbcc mydb and this message come out:
server message:number 921,severity 14
server 'mydb_prod',line1:
database 'mydb' has not been recovered yet - please wait and try again

tq for reply, any added information please let me know.
please help.

View 2 Replies View Related

Control Transaction In Sybase Database Using Sql-server 2000

Apr 20, 2004

Can anyone help me with this scenario!!!!
I have a sybase database and a sqlserver 2000 database.
I want to insert data into sybase database table thru sql-server 2000 using distributed queries
When i execute the following the transaction


Create procedure myCurrentDataBaseProcedure
as
begin

begin tran
insert into mytable values(1)
if @@error <>0
begin
rollback transaction
return
end
insert into sybasedatabaseserver.databasename.dbo.tablename values(1)
if @@error <>0
begin
rollback transaction
return
end
commit transaction
end

The procedure is created in sql server database
trying to execute this procedure..shows error
The first part of the procedure is executed.

But the error is here
insert into sybasedatabaseserver.databasename.dbo.tablename values(1)
The data is succesfully inserted in the local database
I am unable to insert data into the remote database
Can anyone suggest me wht shd i do in this scenario
Are there any drivers to be loaded to commit this transactions

Pl.Help

View 5 Replies View Related

Cant Create New Database / CREATE DATABASE Permission Denied In Database Master (error 262)

Oct 2, 2007

 
 I am using SQL express and Visual web developer on windows Vista.
When I try to create a new database the following message appears.
 
CREATE DATABASE permission denied in database master (error 262)
I log on to my computer as an administrator.
Help appreciated
 Prontonet
 
 
 

View 4 Replies View Related

Cannot Set Connection Property Of Backup Database Task If Connection String Is Customized In Connection Object

Aug 23, 2006

I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.

Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.

Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.

Is this an intrinsic issue?

View 2 Replies View Related

The SSE Provider Did Not Find The Database File Specified In The Connection String. At The Configured Trust Level (below High Trust Level), The SSE Provider Can Not Automatically Create The Database File.

Aug 31, 2007

The problem that I am having is that with Visual Web Developer I am creating a webpage and having it directly put online, so for example when I start a new ASP.NET page, I select the location to be HTTP, with the location http://MYWEBSERVER/Website   and for the language and Visual BasicI notice a couple of things, first that there is no longer a a link under the Main toolbar "Website" selection called the ASP.NET configuration.  So how can I configure what I want to have users be able to do?  It seems that this choice is only available if I am building the ASP.NET page on my "localhost".  So that is the first problem.  So I am able to get the pages to work, atleast the things such as the textboxes to show up etc, (Even things as advanced as the "Login" box).  How ever when I try to get someone to try to login  I am taken to a page that has an server error.  The error is:
"The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file. "
The Stack Trace Errors are at the bottom.  I think this is happening because the automatically generated databases are not getting built online as they are on my computer.  On my computer I have MSSQL express.  So either the databases are not getting built for some reason, (and I think that is the case as I don't see any in the folder).  So I think that somehow I have to create a database on my server, and then somehow configure the ASP.NET file, perhaps in the Web.Config file to look for that new database.  Is this the correct methodology?   Is there some simpler way that I can just somehow upload things as they are and have them work correctly on my server?   The error says that either the Server did not find the database or that the trust level was insufficient.  I don't think that is it as I just looked again and I don't see any .MDF files.  So how would I go about getting this to work right? Is there a way to do this with MySQL also?  So that I don't have to use MSSQL?  My server only allows 1 DataBase for that.
Thanks and I hope my question makes sense.  It is basically how can I get it to be able to create and check users etc. online?
Brian
[ProviderException: The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.]   System.Web.DataAccess.SqlConnectionHelper.EnsureSqlExpressDBFile(String connectionString) +2555237   System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +87   System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121   System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105   System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42   System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83   System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160   System.Web.UI.WebControls.Login.AttemptLogin() +105   System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35   System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
 

View 1 Replies View Related

Created SQL Server Database Using SYBASE DLL &&amp; Data, But Data Problem

Jan 21, 2008



Hello,

I took our SYBASE DDL and created the tables on an SQL Server Express datbase on a PC and then downloaded our data from UNIIX using the WinSCP utility and BULK Inserted the data into the SQL Server database and everything uploaded fine apparently, but when we go to use the data we are getting some data differences.


Do you know of any data conversion issues that may be coming into play here maybe?

Thanks very much!
BobK

View 1 Replies View Related

Boolean: {[If [table With This Name] Already Exists In [this Sql Database] Then [ Don't Create Another One] Else [create It And Populate It With These Values]}

May 20, 2008

the subject pretty much says it all, I want to be able to do the following in in VB.net code):
 
{[If [table with this name] already exists [in this sql database] then [ don't create another one] else [create it and populate it with these values]}
 
How would I do this?

View 3 Replies View Related

Dynamic Create Table, Create Index Based Upon A Given Database

Jul 20, 2005

Can I dynamically (from a stored procedure) generatea create table script of all tables in a given database (with defaults etc)a create view script of all viewsa create function script of all functionsa create index script of all indexes.(The result will be 4 scripts)Arno de Jong,The Netherlands.

View 1 Replies View Related

Can CREATE DATABASE Or CREATE TABLE Be Wrapped In Transactions?

Jul 20, 2005

I have some code that dynamically creates a database (name is @FullName) andthen creates a table within that database. Is it possible to wrap thesethings into a transaction such that if any one of the following fails, thedatabase "creation" is rolledback. Otherwise, I would try deleting on errordetection, but it could get messy.IF @Error = 0BEGINSET @ExecString = 'CREATE DATABASE ' + @FullNameEXEC sp_executesql @ExecStringSET @Error = @@ErrorENDIF @Error = 0BEGINSET @ExecString = 'CREATE TABLE ' + @FullName + '.[dbo].[Image] ( [ID][int] IDENTITY (1, 1) NOT NULL, [Blob] [image] NULL , [DateAdded] [datetime]NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]'EXEC sp_executesql @ExecStringSET @Error = @@ErrorENDIF @Error = 0BEGINSET @ExecString = 'ALTER TABLE ' + @FullName + '.[dbo].[Image] WITHNOCHECK ADD CONSTRAINT [PK_Image] PRIMARY KEY CLUSTERED ( [ID] ) ON[PRIMARY]'EXEC sp_executesql @ExecStringSET @Error = @@ErrorEND

View 2 Replies View Related

Create Script To Create/Refresh Identical Database

Mar 26, 2008



I'm new to using SSIS and have been reading and learning slowly how to use it. I'm trying to create an identical copy of our database for reporting. I've used the Import/Export wizard, but have had some issues with foreign keys and with sql_variant columns.

I've tried searching for anything but haven't had any luck as of yet. I guess I don't even know where to start or what to look for.

Any help would be appreciated. Thanks!

View 9 Replies View Related

Cannot Create ADO Connection To DB Anymore...

Jul 20, 2005

I rebuilt my machine a few weeks back - re-installed the developer version...The app in question can see all it's tables in the SQL back end via ODBC andeverything looks normal via Enterprise Manager, but I can no longer createan ADO Connection.Source code is unchanged, what's changed is the PC rebuild and consequentre-installatin of SQL Server developer version.I suspect it's something to do with the provider (at least that's the only thingI can see in the .Connect string that's not verifiably correct....)The error looks like this after I trap and format it:-----------------------------------------------------------------12/30/03 21:34:30v0.71 Userid: UPQC on SAGProc: basADO: ADO_ConnectionCreate-2147467259: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server doesnot exist or access denied.Errors encountered when trying to connect:''''''''''[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist oraccess denied.----------Connect String:Provider=SQLOLEDB.1;SERVER=SAG;DATABASE=TRETS;UID= Trets;PWD=trets-----------------------------------------------------------------Can anybody see anything obvious to look for?I'm thinking I need to know how to verify/validate the presence of provider"SQLOLEDB.1"... But how?--PeteCresswell

View 1 Replies View Related

Error In Trying To Create A New Connection.

Jan 27, 2008

I'll ask for patience cause am new to this....but I am trying to create a new connection while trying to add a new Data Source in Visual Studios, and I keep getting the error "Login failed for user 'Mohaminho-PCMohaminho'." I have tried several things that my little knowledge knows, but no success.
Any ideas anyone?

View 7 Replies View Related

How To Create A Socket/IP Connection Using SQL?

Jun 30, 2007

I just want to know how to create a socket/IP connection using SQL prodecure or function

please help..

thanx

View 3 Replies View Related

Error Message When Trying To Create An SQL Connection

Mar 13, 2008

Hi,Just recently I am getting the following error when trying to connect to an SQL DB: Exception has been thrown by target of an invocation. This happens even if I create a new website/solution. Procedure I use:open server explorer and click on create a new connectionchoose SQL server from the listenter my IP address and credentials, click on test and everything is fine. When I go to select the DB the dropdown box is empty, if I type in my database name and click on ok I get the following message:Exception has been thrown by target of an invocationI know it is nothing to do with SQL or credentials as I can create a datasource to my SQL server using my colleagues computer!I have removed VS 2005 from my computer and reinstalled only to be met with the same problem.reinstalling my computer is a last resort!Any ideas?Cheers,  Ps, I can connect to my DB using VB code behind.   

View 3 Replies View Related

Do We Have To Create Connection Before Creating SqlCacheDependency?

May 23, 2008

do we have to create connection and assign it to command object before creating SqlCacheDepency? chek the code below. SqlServer is not invalidating cache when there is update. When i create Dependency using command object, at that time command object does not have connection. It will assign connection to command object in Excute method
SqlCommand cmd = new SqlCommand(commandText);cmd.CommandType = CommandType.StoredProcedure;SqlCacheDependency cacheItem = new SqlCacheDependency(cmd);DataSet result;result = DBHelper.Execute(cmd);HttpRuntime.Cache.Insert(cacheItemName, result, cacheItem); 

View 4 Replies View Related

Cannot Create A Connection To Data Source

Apr 27, 2007

Hi all,

I am trying to view report that i deployed to reporting service but when i try to view it, it gives error:

An error has occurred during report processing.
Cannot create a connection to data source 'INVC'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors

the datasource is ODBC

View 3 Replies View Related

Cannot Create A Connection To Data Source

Jan 22, 2008



Hi,

When I view a report, I get the error message:

An error has occureed during report processing.

Cannot create a connection to data source "data source name"

Cannot open database "database name" requested by the login, The login failed, Login failed for user "username".

The data source will connnect to my OLAP server and I believe I have right to access the OLAP server.

Why the error occurred? Somebody can help me? Thanks very much!

View 4 Replies View Related

Failed When Create An ODBC Connection

Apr 21, 2008

Dear all,

I want to create an ODBC connection using windows authentication but it always failed. The error display that the database server not found. Is the any configuration I should set before create the ODBC ?
Thanks in advance.


Best regards,

Hery

View 5 Replies View Related

RS2008: Cannot Create Connection When Using Impersonation

Apr 9, 2008

I am testing RS2008 CTP6.
When I view a Adventureworks sample report (e.g. company sales) I get this errormessage when I use the option "Impersonate the authenticated user after a connection has been made to the data source" :


Cannot create a connection to data source 'AdventureWorks'.

Must declare the scalar variable "@ImpersonatedUser".


All other connection options without impersonate works fine.
Any idea what can cause this problem?

Thanks in advance.

View 1 Replies View Related

Cannot Create A Connection To Data Source

Mar 6, 2006

Why is it that sometimes I get this error and sometimes not after I deploy the same shared data souce to my Report Server?

Even if I try deleting the datasouce through Report Manager the redeploy it from VS 2005, it still errors out when I run my report. I am able to run my report fine in VS.



An error has occurred during report processing.



Cannot create a connection to data source 'mydatasourcenamehere'.



For more information about this error navigate to the report server on the local server machine, or enable remote error

View 3 Replies View Related

Cannot Create A Connection To The Datasource 'DataSource1'

Jan 23, 2007

Hello, I Created a report with reportbuilder, after clicking on Run Report I got this message, Its very strange it seems that its trying to generate or create a datasource.



Para obtener más información acerca de este error, vaya al servidor de informes en el equipo del servidor local o habilite los errores remotos
----------------------------
No se puede crear una conexión al origen de datos 'dataSource1'.
----------------------------
Error al procesar el informe.



View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved