Sybase and SQLServer2005 Connection Problem

SQL Server Integration Services

Index ‹ SQL Server
- Archive
  - Windows Forms
  - SQL Server
  - IE
  - VC++
  - ISV
  - Visual C#
  - SharePoint
  - VFP
  - Visual Studio
  - Architecture
  - VS 2008
  - VB
  - Windows Live
  - VS Express
  - Office
  - Windows Vista
  - Game
  - Dotnet
  - Smart Device

- Previous
  - 1
    - File Attachment Size I hace an Execute SQL task which calls a sproc which contains the sp_send_mail system sproc to e-mail a set of query results . It is OK as long as the query results are small, but I get this error if they get too big: - File attachment or query results size exceeds allowable value of 1000000 bytes. any way to change (and where to change) this value. Dave Tag: Sybase and SQLServer2005 Connection Problem
  - 2
    - Simple Data Flow Hangs Is your database filling up Is it configured to autogrow Is there room Tag: Sybase and SQLServer2005 Connection Problem
  - 3
    - dataware house..General. "There several methodologies" i would like to know about the several methodologies which exists..I will be using Sql Server 2005 to implent though.. Tag: Sybase and SQLServer2005 Connection Problem
  - 4
    - Xml Ssis Data Flow Component? There is a table with a column that contains Xml documents. For each record from my Data Flow Source, I want to pass in the Xml document and the node to interrogate, and return the value contained in the node. Like the Crm component, this is probably one I will have to write from scratch in C#, but I would like to avoid having to create the custom component if it already exists in the public arena. Does anyone know of any Xml Ssis Data Flow Components that are downloadable for free Tag: Sybase and SQLServer2005 Connection Problem
  - 5
    - 'Identity Insert off' not detected, validation error It is a property on the connection as I said, and Kirk has written, so I don't know why can you not find. There are not many properties of an OLE-DB connection, and one of them is RetainSameConnection. It is only shown in the properties grid, not the pretty form. Tag: Sybase and SQLServer2005 Connection Problem
  - 6
    - System.Security.HostProtectionException:The protected resources (only available with full trust) we All .... What is "GetEffectiveTemperature" See, if you can comment out any calls that are done to other assemblies. Seems that you are appearantly callig a method which is not trusted or at a trust level that is lower than the actual one. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: Sybase and SQLServer2005 Connection Problem
  - 7
    - Ranking by One Field, Displaying Multiple Fields One obvious issue is that .CurrentMember should be applied to a hierarchy, not to a level, so: [Lender Name].[Master - DBA - Deed Stamp].[Lender Master Entity]. CurrentMember should probably be: [Lender Name].[Master - DBA - Deed Stamp]. CurrentMember Tag: Sybase and SQLServer2005 Connection Problem
  - 8
    - Receive "Procedure or function expects parameter..." error unexpectedly Maybe I am missing something completely obvious but as far as I can tell I aren't! I am trying to simply pass a parameter to a stored proc to return results. Easy So I thought so too... This is my stored procedure below (in it's ALTER PROCEDURE form): ALTER PROCEDURE [dbo] . [spd_Tester] -- Add the parameters for the stored procedure here @Check int AS BEGIN SELECT * FROM tblPerson WHERE PersonID = @Check END Now I know this is a SQL Server forum but I figure anyone who reads this probably does some application programming as well, so here is the code that calls this. It's in VBA using Access 2003. I figure the error is being returned from SQL Server Express so that's why I have come to this forum instead of an Access forum! I could be wrong though... Here is the code that calls this: Dim rs As ADODB.Recordset Dim cmd As ADODB.Command Set cmd = New ADODB.Command 'Run sql command With cmd .ActiveConnection = CurrentProject.Connection .CommandText = "dbo.spd_Tester" .Parameters.Append .CreateParameter("@Check", adInteger, adParamInput, , Me.txtFirstName) 'Execute, return recordset Set rs = .Execute End With Now I figure this should work. However, I get the error "Procedure or function 'spd_Tester' expects parameter '@Check' , which was not supplied." when I execute the procedure with the number 1 in the txtFirstName text box. Can someone tell me what I am doing wrong The tblPerson table has data in it, if I run the select from a query window, specifying a value for @Check, it works just fine. Thanks in advance! Tag: Sybase and SQLServer2005 Connection Problem
  - 9
    - Restore to a new database failed In this section of the error message: =================================== System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c :\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL \sequoia.mdf'. (Microsoft.SqlServer.Express.Smo) ------------------------------ you can see that the restore is attempting to put the file in the MSSQL folder -NOT the BackUp folder. You may wish to explore using the 'WITH MOVE ' parameter for the RESTORE command in order to RESTORE the backup to a different location. Refer to Books Online, Topic: RESTORE Tag: Sybase and SQLServer2005 Connection Problem
  - 10
    - SSIS Execution problems Try adding the following line after your pkgResults line: pkg.Dispose() Tag: Sybase and SQLServer2005 Connection Problem
  - 11
    - "Report is being generated" Any answer Tag: Sybase and SQLServer2005 Connection Problem
  - 12
    - Ideal Event handling Technique I did move all of my tasks into a Sequence Container and set the event handler for the container. But no vain. Its still the same old story. Tag: Sybase and SQLServer2005 Connection Problem
  - 13
    - order two by two successively, any way? Hello Wei, Below, I have demonstrated how you might create your own function to rate the differences between two strings (This checks pairs of characters). I have also provided the Query to use that function. Based upon the very limited sample data, this should give you a good idea about how to solve your problem. (You will notice that I have added a couple of rows of additional sample data. Code Snippet CREATE FUNCTION dbo.Similar ( @s1 varchar(250), @s2 varchar(250) ) RETURNS decimal(5,2) AS BEGIN DECLARE @Counter int, @NoMatch int SELECT @Counter = 1, @NoMatch = 0 WHILE ( datalength( @s1 ) >= @Counter ) BEGIN IF substring( @s1, @Counter, 2 ) <> substring( @s2, @Counter, 2 ) SET @NoMatch = ( @NoMatch + 1 ) SET @Counter = ( @Counter + 1 ) END RETURN @NoMatch END GO DECLARE @MyTable table ( RowID int IDENTITY, MyData varchar(30) ) INSERT INTO @MyTable VALUES ( 'Thisissentence1' ) INSERT INTO @MyTable VALUES ( 'Thelastsentence.' ) INSERT INTO @MyTable VALUES ( 'Thisissentence3. ' ) INSERT INTO @MyTable VALUES ( 'Thisnosentence3.' ) INSERT INTO @MyTable VALUES ( 'Thisnotsentence3.' ) INSERT INTO @MyTable VALUES ( 'Thatissentence4.' ) INSERT INTO @MyTable VALUES ( 'Thatissentence2.' ) SELECT dt.MyData1, avg( Diff) FROM ( SELECT m1.MyData AS MyData1, m2.MyData AS MyData2, dbo.Similar( m1.MyData, m2.MyData ) as Diff FROM @MyTable m1 JOIN @MyTable m2 ON m1.RowID <> m2.RowID GROUP BY dbo.Similar( m1.MyData, m2.MyData ), m1.MyData, m2.MyData ) dt GROUP BY dt.MyData1 ORDER BY avg( Diff ) MyData1 ------------------------------ ---------------------------------------- Thisissentence1 7.166666 Thisissentence3. 7.333333 Thisnosentence3. 8.000000 Thatissentence2. 8.166666 Thatissentence4. 8.166666 Thelastsentence. 13.000000 Thisnotsentence3. 13.333333 Tag: Sybase and SQLServer2005 Connection Problem
  - 14
    - From SQL Server 2005 to 2000 It would be advisable to change the compatability level of the 9.0 database to 8.0. Tag: Sybase and SQLServer2005 Connection Problem
  - 15
    - Retrieving a datetime with a time of midnight (from a typical datetime) I used the dateadd method both of you suggested and it worked perfectly. Thank you very much. Tag: Sybase and SQLServer2005 Connection Problem
  - 16
    - Possible to use a Sharepoint List as a Datasource? I would suggest that you use the informations provided by Teun Duynstee in this link: http://www.teuntostring.net/blog/2005/09/reporting-over-sharepoint-lists-with.html Cheers Markus Tag: Sybase and SQLServer2005 Connection Problem
- Next
  - 1
    - Canned SMSS reports How does one make the canned SMSS reports such as disk usage available from 1.) Local workstation for administrators of SQL can run then on SQL instances from the Object view of Management studio. All we see is the reports tab greyed out. 2.)From a reports server. My goal is to be able to run these reports on all of the SQL servers and not just a local instance. Do those servers need anything installed It was my thought that one should be able to highlight a server / database and run these reports. Have I errorred in my believes in this Yes, I know these seems rather basic but it seems there is a right way to make this occur and a wrong way. MDSN has yet to give up this information to me. If anyone knows the links or answers kindly post in the blog and also email me at brucehelp@yahoo.com . This link covers the discussion but does not have the methods to achieve the installation of the canned reports. http://blogs.msdn.com/sqlrem/archive/2006/05/16/SSMS_Reports_1.aspx "Did you know that there is a set of pre-made reports in Management Studio that can help database administrators gather information in many common areas There are reports for CPU, memory, disk, sessions, queries, transactions, and more baked right into Management Studio. You can access these reports in SQL Server 2005 and SQL Server 2005 SP1 by following these steps: " Tag: Sybase and SQLServer2005 Connection Problem
  - 2
    - Complex Math functions you can also create user defined function (UDF) for other mathematical functions that you need.. like factorial, permutations, etc. Tag: Sybase and SQLServer2005 Connection Problem
  - 3
    - Default parameter = current year I would like to default my first parameter, which is year, to the current year. I'm querying against a cube. I've tried setting the default =Non-queried =year(today), tried a few MDX field names, and also tried setting the current year as the default in my data set. I can't seem to get the parameter to accept a default. Tag: Sybase and SQLServer2005 Connection Problem
  - 4
    - "XML Source" xsd relative path pc_83 wrote: Hi JayH, If the package is executed in the SQL Server where should the xsd file be stored I have a Web Service Task for extracting data from a Web service . It writes the web service output in a xml file and after that this xml file is used as a source for a XML Source. Finally the data from the web service is inserted in a SQL Server database. Where in the database then, not in the file system, should I store the xml file and the xsd for it And actually this relative path question came out because the SSIS packages we develop are under source control and if they do not support relative paths it is very difficult for two people to work on the same package under source control. Best regards, pc Not sure I understand your question, but I think your only options are to have the XSD on the disk or inside the XML. The XML can either be a file or a variable. You could read the XSD from the database and insert that into the XML you get from the web service if you want to avoid the disk. I understand the Source Control scenario very well. In my case, we decided that all package paths would be relative to each user's profile. Each developer was required make their working folder the same location under "My Documents". This was also handy since multiple users could log into the big development server and work on the same solution without interfering with each other's child packages, raw files, etc. All paths were constructed dynamically at run-time using expression-based variables and the USERPROFILE environment variable that was read with a package configuration. Tag: Sybase and SQLServer2005 Connection Problem
  - 5
    - Creating a blank row in a table between positive & negative values I have a table that displays a bunch of data based on their percentage changes. There is a parameter (let's say 5%) that the user can set to display only the data which either increased more than 5% or decreased more than 5%. I want to have a space between the positive changes and the negative changes. ie, to create a blank row between the +'s and the -'s. Does anyone know of a way to do this Thanks, Steven Tag: Sybase and SQLServer2005 Connection Problem
  - 6
    - SQL Server 2005 rejects remote internet connections Hi Emanuel, Running the Server 2005 Surface Area Configuration tool shows "Local and remote connections" and "Using TCP/IP only" are selected for MSSQLSERVER (the default instance). Running sp_configure (without parameters) against MSSQLSERVER (default instance) returns: Name Min Max config_value run_value allow updates 0 1 0 0 clr enabled 0 1 0 0 cross db ownership chaining 0 1 0 0 default language 0 9999 0 0 max text repl size (B) 0 2147483647 65536 65536 nested triggers 0 1 1 1 remote access 0 1 1 1 remote admin connections 0 1 0 0 remote login timeout (s) 0 2147483647 20 20 remote proc trans 0 1 0 0 remote query timeout (s) 0 2147483647 600 600 server trigger recursion 0 1 1 1 show advanced options 0 1 0 0 user options 0 32767 0 0 I used Windows Update to update the SBS server including SQL: SBS 2003 Service Pack 2 SQL 2005 Service Pack 2 MSSQLSERVER file version 2005.090.3054.00 I also set Sharepoint to use Dynamic port assigment, because Sharepoint was also listening on port 1433 by default. I did not expect this resolve my issue (and it didn't), but I simply wanted to take Sharepoint out of the equation. ADDITIONAL INFORMATION I've completed more testing and the following is a better description of the issue: I have a Godaddy.com(ISP) ASP.net 2.0 website that connects to a Godaddy SQL 2005 instance with no problem. I also have Gravityfree(ISP) ASP.net 2.0 website that connects to the GravityFree SQL 2005 instance with no problem. I want to host the website at an ISP like Godaddy and I want the website to connect to a SQL Server at my office (FYI -The website will have high traffic and high uptime. The SQL server will house a selection of very large downloadable content with a fraction of the traffic where uptime is not as critical. Godaddy limits shared hosting accounts to 200MB and the requirement is at least 15GB - one option is a dedicated SQL server at Godaddy) I have tested connecting from a Godaddy ASP.net webpage to the Gravityfree SQL intance using a working connection string and I get the same connection failure. (This connection uses a named instance, therefore specifying a correct port is unnecessary) I have also tested connecting from a Gravityfree ASP.net webpage to the Godaddy SQL intance using a working connection string and I get the same connection failure. (Again this connection uses a named instance, therefore specifying a correct port is unnecessary) Attempting to connect from either the Godaddy or the GravityFree website to the SQL Server(MSSQLSERVER) at my office results in the same type of connection failure. From all this, I see that if I host a website application and SQL Server together on the same network (my own or an ISP) then I will be able to create working SQL connections. But instead, I really want to connect my web app to a SQL instance on another network. During the setup of SQL Server, I remember there is a prompt for a Domain. Is access to an instance of SQL Server limited to that Domain specified in that setting By now, I've reviewed several hundred posts on SQL 2005 connectivity and the great majority of these deal with connectivity issues related to the development environment involving firewall, ports, network, and SQL configuration settings on the same network. I've only found a couple posts that implied (not specifically addressed) the cross-network question I am attempting to resolve, and those posts were treated the same way and remain unresloved. So the question is how to connect a website application to a SQL Instance on a diferent domain/network Because I believe this is a distinct question, I've opted to start this thread rather than posting to an existing one. Tag: Sybase and SQLServer2005 Connection Problem
  - 7
    - DTS package If you are using SSIS, there is an Excel Source connection which you would hook up to a Row Count Transformation. Two pieces, very simple. No code or formula required. However, it sounds like you are using DTS (the old product that SSIS replaces) Tag: Sybase and SQLServer2005 Connection Problem
  - 8
    - Unable to Create New web Site in IIS 5.1 I'm not sure if this is a licensing restriction in XP, or just something they removed from the interface. Perhaps a MSFT person could comment on it. Tag: Sybase and SQLServer2005 Connection Problem
  - 9
    - SQL Server 2005 Installation On Windows Vista Home Premium I'm getting the same warning when I attempt to install SQL Server 2005 Express Edition with Advanced Services SP2. The install proceeds, but Reporting Services (more imporant to me) and Full-Text Search (less important to me) are not installed. I used the Windows Features applet and selected all of the Internet Information Services items that are listed in KB Article 920201, with the exception of "Windows Authentication", which is not in my list. ("IIS Metabase" and "IIS 6 WMI" are worded slightly different--"IIS Metabase and IIS 6 configuration compatibility" and "IIS 6 WMI Compatibility", respectively--but I did select them both.) When I re-ran the SQLEXPR_ADV installer, I got the same warning...and Reporting Services and Full-Text Search were not installed. I even went back into the Windows Features applet and selected all remaining unselected "Internet Information Services" items, and then re-ran the SQLEXPR_ADV installer. I got the same warning...and Reporting Services and Full-Text Search were not installed. Any ideas as to what the problem might be Tag: Sybase and SQLServer2005 Connection Problem
  - 10
    - Exception from HRESULT: 0xC0048004 Hi, there; I created a SSIS package in a ASP.NEP application which importing data from some .dbf file. "Exception from HRESULT: 0xC0048004" happened to two tables. I had a look this exception at http://msdn2.microsoft.com/en-us/library/ms345164.aspx, it says: The index is not valid. But there is no index defined in my destination table. Does anybody how to resolve it Thanks Tag: Sybase and SQLServer2005 Connection Problem
  - 11
    - Changing destination database for SSIS Package You may want to read through this post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1043984&SiteID=1 Tag: Sybase and SQLServer2005 Connection Problem
  - 12
    - I4 to I8 in Aggregation I'm using an Aggregation task to summarize an input file by item and week before inserting it into a SQL table. Two of the fields I'm summing, because their totals per record can occasionally exceed 32k, are defined as int (I4) instead of smallint (I2). However, the summarized total never exceeds the value an int can hold. I ran into a problem on the insert, however, with SSIS telling me it couldn't insert an I8 value into an I4 table field. I discovered the metadata for the summed totals had automatically been set to bigint (I8), and the mapping was failing. I didn't see a way to change that metadata within the Aggregation task itself, so I added a Data Conversion task to convert the totals to four-byte signed integers and enable the mapping. Was that the proper workaround Tag: Sybase and SQLServer2005 Connection Problem
  - 13
    - Pass variables to an OPENQUERY Hi all, Does anyone know if it is possible to pass variabes to an openquery statement I am trying to do something like this: OPENQUERY(LinkServer, 'SELECT column1, column2 FROM table WHERE column3 ='' + @@variable1 +'' AND column4 = '' +@@variable2 +'') Many thanks in advance, -Vicky Tag: Sybase and SQLServer2005 Connection Problem
  - 14
    - Order By ignoring the hyphen character Hi, I'm using the following SQL script to return a list of part number and the order is not what I expect. Perhaps this is a collation problem but I have no idea where to look to modify that. Thanks in advance, John select part from transactions T where (T.transdate between '20070701' and '20070705') and (T.transtype = 'ISSU' or T.transtype = 'RTRN') order by part Here is the beginning of the Transactions table create script CREATE TABLE [Transactions] ( [RecNo] [int] IDENTITY (1,1) NOT NULL, [Part] [nvarchar] (30) NOT NULL , [TransDate] [nvarchar] (8) NOT NULL , [TransType] [nvarchar] (4) NOT NULL , [FromLoc] [nvarchar] (10) , The 'Part' column is an alphanumeric field. The problem I am having is that the Order By seems to ignore the hyphen character '-' when the returned rows are ordered by the Part (which can contain hyphens in any column). Here is an example of what I get. 130909N9 130909N9 130909N9 1-480698-0 * These two should not be here 1-480699-0 * 15-423 164-07700 164-07700 164-07700 1683 I was expecting this ( and I get this in and older database ). 068-03000 068-03000 06A19956 074-03200 077-367-0 08DU08 1-480698-0 * These should be here eariler in the data 1-480699-0 100-364072 100-364072 Tag: Sybase and SQLServer2005 Connection Problem
  - 15
    - can't replicate table with column name too long (from sql server 2005 to oracle) I know I can use a custom script, but the problem is that the replication will still delete that table (that was already created on the Oracle side) and try to create a new one with the same column names as in Sql Server. And even if I have the table already created (in Oracle ) how will Sql Server know how to map the columns in Sql Server to the ones in Oracle Are there any options in the replication that control this Tag: Sybase and SQLServer2005 Connection Problem
  - 16
    - Logical equivalent IN operator in a Conditional Split Transformation Phil Brammer wrote: No such thing. Really I guess not exactly but FINDSTRING() might work Tag: Sybase and SQLServer2005 Connection Problem

mohd sufian

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

Re: Sybase and SQLServer2005 Connection Problem

David Noor (Microsoft)

Hi Sufian,

I haven't used that particular driver before, but from the symptoms I think you might be able to work around the difficulties you're having. Even though Preview is not working, that doesn't necessarily mean that you can't use the driver to build functioning packages -- try creating your package using the component and executing it, and you may find that you're still able to use this driver.

If not, I'd suggest taking a look at the SSIS Connectivity wiki at http://ssis.wik.is to find the best options for connecting to Sybase from SSIS.

-David

Re: Sybase and SQLServer2005 Connection Problem

Karunakaran

Did you try specifying the port number explicitly in the odbc settings By default it takes 5000 as port.