Query Problem: From Sybase ASA To SQLServer 2005

Apr 18, 2008

Hi,

I'm doing a migration from Sybase SQL Anywhere to SQL Server 2005.
This is one of the query that doesn't work:



select card_nr as cCard,

card_type as cType,

tab_cards_profile.profile_name as cProfile_name,

dbo.fn_name_pdcode( cCard, cType, tab_history.system_code ) as cCard_name,

dbo.fn_card_date_entry(cExit, cCard, cType, tab_history.system_code ) as cEntry,

evn_date+evn_time as cExit,

tab_history.profile_id,

payment_type,

dbo.fn_name_pdcode( param1, payment_type, tab_history.system_code ) as cPay_name,

param1,

datediff(minute, cEntry, cExit) as durata,

amount

from tab_history

LEFT OUTER JOIN tab_cards_profile ON ( tab_history.profile_id = tab_cards_profile.profile_id AND tab_history.card_type = tab_cards_profile.profile_type)

LEFT OUTER JOIN tab_personal_data ON tab_personal_data.name = cCard_name


Both the functions called

dbo.fn_name_pdcode( cCard, cType, tab_history.system_code ) as cCard_name,


dbo.fn_card_date_entry(cExit, cCard, cType, tab_history.system_code ) as cEntry


seems that can't work if I use as parameters alias of columns... This could be a problem; in sybase ASA that query can be executed.
there is any work around to help this query runs?

Thaks..

Luca



View 8 Replies


ADVERTISEMENT

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

Data Migration From Sybase 8.0 To Sqlserver 2005

Apr 7, 2006
















Hi all,

Here i had a task to migrate sybase 8.0 database to mssqlserver 2005 .how can i migrate this using INTEGRATED SERVICES (SSIS) or any other options. .Please try to provide some basical info because i am new to sybase versions.

View 2 Replies View Related

Does MS SQLServer Support Auditing In The Way That You Can For Sybase?

Aug 4, 2005

I know that there are tools like Lumigent, but an wondering about theinternal facilities to track events such as table creation, securityoperations (add login, add role), and such.Under Sybase, there is a set of procedures that permit you to settheses events and to record the results for later extraction andanalysis.The Profiler seems to have a lot of the same functionality but thisappears to be more along the lines of running a monitor.Can the events be tracked without Profiler running?Can the events being tracked be recorded in the system of SQLServerlogs?

View 4 Replies View Related

Problem Unicode Data 0x2300 In SQLServer 2000 SQLServer 2005 Express

Sep 20, 2006

Hi experts;
I have a problem with unicode character 0x2300
I created this table
create table testunicode (Bez nchar(128))

Insert Data
insert into testunicode (Bez)values('Œ€„’')
with 2 Unicode characters
Œ€ = 0x2300
„’ = 0x2122

Selecting the data
select Bez from testunicode
I see
"?„’"

„’ = 0x2122 is ok but instead of 0x2300 there is 0x3f

When I modify the insert statement like that ( 8960 = 0x2300 )
insert into testunicode (Bez)values(NCHAR(8960)+'„’')

and select again voila i see
"Œ€„’"
Does anyone have an idea?

Thanks

View 1 Replies View Related

Trying To 'load' A Copy Of A SQLServer 2000 Database To SQLServer 2005 Express

Apr 18, 2008



I am trying to 'load' a copy of a SQLServer 2000 database to SQLServer 2005 Express (on another host). The copy was provided by someone else - it came to me as a MDF file only, no LDF file.

I have tried to Attach the database and it fails with a failure to load the LDF. Is there any way to bypass this issue without the LDF or do I have to have that?

The provider of the database says I can create a new database and just point to the MDF as the data source but I can't seem to find a way to do that? I am using SQL Server Management Studio Express.

Thanks!!

View 1 Replies View Related

Replacing Sqlserver 2000 With Sqlserver 2005 Express

Jun 14, 2006

I have an app that uses a sqlserver 2000 jdbc driver to connect to a sqlserver 2000.

Is it possible to do a direct replacement of sqlserver 2000 with sqlserver 2005 express just by reconfiguring the app to point to the express? The app would still be using the sqlserver 2000 jdbc driver to try and make the connection.

If that is a possibility, what can be some differences in the configuration? Previously with 2000 the config information I entered is:

server name: "machinename"( or ip). I've also tried "machiname/SQLEXPRESS"

DB name: name of db instance

port: 1433(default)

user and pass.

My attempts so far results in

"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket."

and

"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL."

View 1 Replies View Related

Upgrade SQLServer Mobile (.sdf) Database To SQLServer 2005

Feb 9, 2006

Hello,

I have an SQLServer Mobile database, and I would like to know if there is a way to upgrade it to SQLServer 2005 (.mdf) database. My database has no records in it, just the structure (tables etc). What I am actually asking is if I can create automatically a new SQLServer 2005 Database with the same structure as my existin SQLSErver Mobile database

Thanks in advance,

TassosTS

View 1 Replies View Related

Query From Mssql To Sybase Sucks

Mar 21, 2006

Hi,

I got a big problem. I try to run a query on ms query analyzer or my .net-app, but in both cause, it wouldn't work. when i run the query in ms query analyzer it returns me this error-message:

Der aktuelle Zeilenwert der [verkauf_online]..[hs].[std_ftext].text-Spalte konnte nicht vom OLE DB-Provider 'MSDASQL' gelesen werden.
[OLE/DB provider returned message: Die angeforderte Konvertierung wird nicht unterstόtzt.]
OLE DB-Fehlertrace [OLE/DB Provider 'MSDASQL' IRowset::GetData returned 0x80040e1d].

sorry, its in german, i know but the most important fact is, that a conversion failed. i tried to read a text-field from a sybase asa-8-database which is linked with a ms sql-server 2000. I tried to find out more about the error-messe an the error-code (x80040e1d) but i couldn't find anything helpful.

Now, I just hope some of you can maybe help me.

View 2 Replies View Related

Migration Sybase To Sql Server 2005

Jan 3, 2008

Hi all,
I am Migrating a database from sybase to sql server 2000. I Have already created objects in sql server 2000. I have to only populate it with the data. I have decided to genrate insert script from the aquadata tool and run the script againgt sql server database. It works fine except for few table which have 1,50,000 and 9,00,000 rows. It shows insufficent memory error when i try to run the script with 1,50,000 and the script with 9,00,000 doesn't open in management studio. Please help.


Bharath JrDBA

View 9 Replies View Related

SQLSERVER 2005 X64 Linked Server To SQLSERVER 7.0

Jun 20, 2007

Hello people.

I am in the process of planning a server upgrade to sql2005 x64.

I created 2 linked servers: one to a SQL2000 sp4 server and one to a SQL7.0 SP3.

I have the following error when I query the linked servers.
OLE DB provider "SQLNCLI" for linked server "IVDM2K" returned message "Unspecified error".
OLE DB provider "SQLNCLI" for linked server "IVDM2K" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "IVDM2K". The provider supports the interface, but returns a failure code when it is used.

I am aware of KB 906954.
http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

I applied the instcat.sql on the SQL2000SP4 server and my linked server issues for that one are gone.

However, I ran the instcat.sql script on the SQL7.0 sp3 server and the linked server is still giving me an issue.

Can someone help me find a solution to this?

View 1 Replies View Related

Migration From Sybase 8.0 To Mssql Server 2005

Apr 7, 2006

Hi all,

Here i had a task to migrate sybase 8.0 database to mssqlserver 2005 .how can i migrate this using INTEGRATED SERVICES (SSIS) or any other options. .Please try to provide some basical info because i am new to sybase versions.

View 3 Replies View Related

How Can I Copy A Sybase Table Into SqlServerr 2005 Using SSIS?

Jul 2, 2007

I have used SSIS successfully to copy Oracle tables using Microsoft OLE DB provider for Oracle but I do not see any direct driver references to Sybase in the drop-down list. How do I use the ODBC driver (from Oracle or from Microsoft) I have available on the same computer? Thank you.

View 26 Replies View Related

Not Be Able To Reinstall SQLServer 2005 After SQLServer 2005 SP I

May 9, 2006

Hi every body,

I have SQLServer 2005 runs well for months and stop working after install SqlServer2005 SP1. I try to reinstall the SQLServer 2005 but I have problem when install work station component on my and the error is "There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor". Please help me to fix this bug. I do not want to reformat my machine.

John Dang



View 1 Replies View Related

How To Upgrade From SQLServer Management Studio Express 2005 To SQL Developer 2005

May 25, 2007

I currently have SQL Server Management Studio Express 2005 and would like to upgrade my machine to SQL Developer 2005 as easily as possible. Keeping my databases and such.



Any recommendations on the best way to do this would be greatly appreciated.



thanks!

View 3 Replies View Related

Problem With Visual Studio 2005 Pro + SQLserver 2005 Developer

Aug 20, 2006

Hello
Im pretty new to development so..... be nice guys.
I have VS2005 pro and SQL Server 2005 developer edition installed. When I open VS, in the server explorer i can connet to databases located on the SQL directory (SQL Server runs perfectly) But when i try to add an sql server to my project( add new item --> SQL database) it gives me an error saying "Connection to SQL server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component......"
HELP! donno what VS wants!

View 1 Replies View Related

Linked Server From SQL Server 2005 (x64) To Sybase

May 24, 2006

Hi,

We have been accessing databases on ASE 12.5 (on HPUX) from MS SQL Server 2000 (x32) successfully for years. We do this via linked servers we create on MS SQL Server. When creating the linked server, we would specify the Microsoft OLE Provider for ODBC as the provider, and the data source is the name of a DSN created with the Sybase ASE ODBC driver (4.20.00.67) that points the the HPUX box on which are the Sybase databases.

We have also gotten this to work just fine on MS SQL Server 2005 (x32) Standard Edition SP1. However, we cannot seem to get this to work on MS SQL Server 2005 (x64) Enterprise Edition SP1. The Microsoft OLE DB Provider is not available as an option when creating the linked server on MS SQL Server 2005 (x64). We have tried specifying the SQL Native Client as the provider, but this results in no connection being made and reports the following error:

OLE DB provider "SQLNCLI" for linked server "GCMTESTSQLNATIVE" returned message "Login timeout expired".

OLE DB provider "SQLNCLI" for linked server "GCMTESTSQLNATIVE" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".

Msg 53, Level 16, State 1, Line 0

Named Pipes Provider: Could not open a connection to SQL Server [53].

Do we need to use a different ASE driver when accessing Sybase databases fom the MS SQL Server (x64) platform? Or is there a way to successfully create a linked server on MS SQL Server 2005 (x64) that can communicate with the 32-bit ASE ODBC driver?

Thanks,

Rocco M.

View 7 Replies View Related

SQLServer DTS Query

May 7, 2005

Hi,
I have a DTS query to move data from Access to an existing SQLServer table. There is a date column. When I build the query and choose "all rows" I get a good transfer. The problem is when I choose criteria (from the date column) and select a value from the box that comes up with a list of dates--the dates that are in the date column are what comes up, obviously...so if I choose one, then my query ends up looking something like this:
...WHERE [table].'CurrentEndDate'>='5/6/2005'...
If I run the DTS package like this, I get a failure and an error message that reads "data type mismatch in criteria expression". I don't understand this error message since when I run for "all rows" the data transfers just fine. The Access and SQLServer colums are both formatted "DateTime".
Can anyone help me on how to fix this...I'm trying to set up the package so when it runs, it only selects the rows added to the ACCESS table since the last transfer. If there is a way to script that, plz advise.
Thx much,
Reid C.

View 2 Replies View Related

Instructions For Setting Up A Sybase ASE Server As A SQL Server 2005 Linked Server?

Dec 28, 2005

I have a Sybase Adaptive Server Enterprise server which I need to set up as a linked server in SQL Server 2005.  The Sybase server is version 12.5.2, and the Sybase ODBC driver version is 4.20.00.67.  I have already installed the Sybase client software on the server.


I also created a SystemDSN on the SQL Server to connect to the Sybase server.  I tested the connection and it was able to connect.

I ran the following code to create the linked server:

<code>

EXEC master.dbo.sp_addlinkedserver @server = N'LinkedServerName', @srvproduct=N'Sybase', @provider=N'MSDASQL', @datasrc=N'Sybase System DSN', @provstr=N'"Provider=Sybase.ASEOLEDBProvider;Server Name=servername,5000;Initial Catalog=databasename;User Id=username;Password=password"'

</code>

I then ran sp_tables_ex to make sure I could view the tables in the Sybase database.  Here is the error message I get:

<code>

OLE DB provider "MSDASQL" for linked server "LinkedServerName" returned message "[DataDirect][ODBC Sybase Wire Protocol driver]Error parsing connect string at offset 13. ".

Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LinkedServerName".

</code>

Any ideas what is happening here?

View 10 Replies View Related

Sqlserver 2005 SP2

Mar 7, 2007

is it safe now to install service pack 2 for the new test server which is having sqlserver 2005 and sp1

View 19 Replies View Related

Problem With Sub Query In Sqlserver

May 1, 2007

Hi
I am new user to sqlserver, I have been using access db for my project, and now decided to upsize it to sqlserver. I did, the db is converted to sql, using the upsize wizard in MS Access. Now I have two problems with sql server.
 No. 1: An embedded query that I wrote for data grid paging isnt working in sql server and giving me an error message, saying Incorrect syntax near the keyword 'order'. The query that is generated is:
Select cust_order.order_id as order_id,customers.fname as fname,customers.lname as lname, cust_order.order_date as order_date,cust_order.order_status as order_status from (select top 20 order_id,fname,lname,order_date,order_status from (select top 580 order_id,fname ,lname,order_date,order_status from cust_order,customers where customers.customer_id=cust_order.customer_id order by order_id) order by order_id desc) order by order_id;
There are actually three different queries, one (the simpler one) for page one is working, the other query is for page to till second last page that returns fix size of 20 records, while the last page returns the remaining 20 or less records: the above query is actually the one for last page. Here is the three queries:
If PN = 1 Then
SelectQuery = "select top " & perpage & " cust_order.order_id as order_id,customers.fname as fname , customers.lname as lname, cust_order.order_date as order_date,cust_order.order_status as order_status from cust_order,customers where customers.customer_id=cust_order.customer_id order by cust_order.order_id;"
Else
If PN = totPages And Remand > 0 Then
SelectQuery = "select cust_order.order_id as order_id,customers.fname as fname,customers.lname as lname, cust_order.order_date as order_date,cust_order.order_status as order_status from (select top " & Remand & " order_id,fname ,lname,order_date,order_status from (select top " & CLng(PN) * perpage & " order_id,fname,lname,order_date,order_status from cust_order,customers where customers.customer_id=cust_order.customer_id order by order_id) order by order_id desc) order by order_id;"
Else
SelectQuery = "select cust_order.order_id as order_id,customers.fname as fname,customers.lname as lname, cust_order.order_date as order_date,cust_order.order_status as order_status from (select top " & perpage & " order_id,fname,lname,order_date,order_status from (select top " & CLng(PN) * perpage & " order_id,fname ,lname,order_date,order_status from cust_order,customers where customers.customer_id=cust_order.customer_id order by order_id) order by order_id desc) order by order_id;"
End If
End If
I hope I can find someone help me with this. Its working in access just fine but not in sql server. 
 

View 3 Replies View Related

SqlServer Query Visualizer

Dec 4, 2007

I added the SqlServerQueryVisualizer dll to D:Program FilesMicrosoft Visual Studio 9.0Common7PackagesDebuggerVisualizers and I can see the sql statement generated by the LINQ object, however when I click on Execute an expcetion is thrown saying log in failed for user sa...
The user and password I'm using are 100% correct.
Any ideas ?

View 1 Replies View Related

Cross Tab Query In SqlServer

Nov 26, 2006

Hi,I have three tables with there fields given in brackets:User: [userId as int] (PK), [userName as navarchar]Divisions: [divisionId as int] (PK), [divisionName as nvarchar]DivisionsOfUsers: [userId as int],[divisionId as int]the "DivisionsOfUsers" tables has many-to-many relationships betweenuserid and divisionId.I would like to generate a result something like this:Division1 Division2 Division3User1 1 0 0User2 0 0 1User3 1 1 0User4 0 0 0and so on....where "1" indicates that the given User-Division combination exists and"0" denotes that it doesnt in the "DivisionOfUsers" table.I have tried all sorts of joins to get this data. But was unable to dothis.I have been told that this is possible by a cross-tab query. I dontknow how to generate this query.Can anybody give me a solution for this to be used in Sqlserver 2000 aswell as Sqlserver 2005.Thanks in advance

View 1 Replies View Related

Query Oracle -&> Sqlserver

Aug 14, 2007

select pippofrom(select person.name as pippofrom person)This query run in oracle....in sqlserver no!what can i do!?thank's

View 1 Replies View Related

SqlExpress --&> SqlServer 2005

Sep 26, 2006

Hello all,I develop under vs2005 and sqlExpress. How can I move my database to sql server2005?? I read somewhere that i need to use "sql server management studio express" which i already installed but for some reason I cant attach to a database under my windows XP account (no password for this account). Please help regards, 

View 3 Replies View Related

Cannot Connect To SQLServer 2005

May 14, 2007

After several attempts to install SQL2005 I finally got Microsoft SQL Server Management Studio installed.But now I get the error below:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)The sa account username/password are correct and don't work, windows authentication does not work, I have stopped/started all the services, I have all Protocols enabled correctly, I have my Firewall turned off. Is there anything else I can try? Anything! 

View 1 Replies View Related

Starting Sqlserver 2005

Jan 8, 2008

 
sql server 2005 is installed but some how the link in the programs group has been deleted.
i want start sql server 2005 from cmd prompt or by any other way
please let me know
 

View 3 Replies View Related

Can I Connect Asp 1 To Sqlserver 2005

Oct 18, 2005

Hi All,I hopen this isnt a stupid question but can I connect asp 1 to sqlserver 2005? i want to update the database used on a ASP.net 1 project, I seem to be able to get it to connect but cant get it to see the tables?Thanks for any helpLee

View 5 Replies View Related

Can't Install SQLServer 2005

Nov 7, 2005

I installed Visual Studio 2005 (released edition) that I downloaded from MSDN, and then went to install the released edition of SQL Server 2005.  On the SQL Server 2005 setup "components to install" screen,  all but the last choice ("Workstation components, Books Online, and development tools" are grayed out so I cannot install them.The machine on which I was installing these had just been re-imaged and was clean.How do I get around this so I can install SQL Server2005? Mark

View 1 Replies View Related

SQLServer 2005 And 2000

Oct 18, 2006

Hi all,

We do our development in SQLServer 2005. We want to backup and restore our database into the client's side who use SQLServer 2000. Backup and restore cannot work. We try to script the database in 2005 and change the option script to 2000. This fails also. What other option I can use?

Regards

View 8 Replies View Related

Sqlserver 2005 Installation

Jan 26, 2007

This is my first task of installing sqlserver 2005 on 64 bit machine in windows 2003 environment.
As a DBA what are the thnigs i need to know for the successful installation of sqlserver 2005 and what the things that are need to be installed along with sqlserver, and what are the accounts to be created like all the things i need to know..

Any help will be a great for me ...

Thanks in advance

View 1 Replies View Related

SQLServer 2005 Beta

Jul 20, 2005

What's the deal with SQLServer 2005 Beta?I've just got a magazine with a free cover disk with VB 2005 beta,and also includes SQLServer 2005. I've installed it, but I can't get itto do anything. It seems to have installed ok, there are the data filesfor allthe usual system and example databases in place, and TaskManager shows that SQLServer is definitely running. However theonly tool that came with it is called 'Computer Management' whichallows configuration options on the network, and to start and stopSQL Server. There are none of the Enterprise Manager controls toaccess the database, create tables, create users and so on. Enterprisemanager from SQL Server 2000 seems unable to detect the newinstallation.What's going on? Are there client tools I can download to access thedatabase with?

View 3 Replies View Related

Need Help To Install The Sqlserver 2005

May 29, 2008

Hi Folks,

I have installed the sql server last month, that time sql server shows the Instance like "SelComputerSQLEXPRESS" after one week from installed i have uninstall the sql server express edition. now i have installed again this sql server but it doesnt shows the Instance, I have tried lot of times, but still it shows the same empty. I cant find any intance in my local machine, In Management studio Connect to server dialod window Server Name Box Shows the Empty Box, But i can connect remote servers, Any can help to resolve this issue, i am currently using winXp Profession with SP2...

Thanks

View 5 Replies View Related







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