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?
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.
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?
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.
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."
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
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.
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.
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.
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.
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.
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.
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.
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!
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?
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.
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:
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".
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.
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 ?
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
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,
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!
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
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
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
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?
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..
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?
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...
