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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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