Hi there,
We have purchased a new server and SQL 2005 in order to use Sage MMS.
We have since heard that due to a "Microsoft Issue" between .NET and SQL 2005, Sage are not recommending their MMS product to be used with SQL 2005.
Well basically, we'd already bought SQL 2005 and are now being told that we need to purchase and install SQL 2000 in order to use Sage MMS.
Does anyone have any ideas on how we can remedy this?
Thank you.
Hi all
i have a page with this code
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" DataSourceID="SqlDataSource1" PageSize="36">
<PagerSettings Mode="NumericFirstLast" Position="TopAndBottom" />
<Columns>
<asp:BoundField DataField="ACCOUNT_REF" HeaderText="ACCOUNT_REF" SortExpression="ACCOUNT_REF" />
<asp:BoundField DataField="NAME" HeaderText="NAME" SortExpression="NAME" />
<asp:BoundField DataField="ADDRESS_1" HeaderText="ADDRESS_1" SortExpression="ADDRESS_1" />
<asp:BoundField DataField="ADDRESS_2" HeaderText="ADDRESS_2" SortExpression="ADDRESS_2" />
<asp:BoundField DataField="ADDRESS_3" HeaderText="ADDRESS_3" SortExpression="ADDRESS_3" />
<asp:BoundField DataField="ADDRESS_4" HeaderText="ADDRESS_4" SortExpression="ADDRESS_4" />
<asp:BoundField DataField="ADDRESS_5" HeaderText="ADDRESS_5" SortExpression="ADDRESS_5" />
</Columns>
<PagerStyle HorizontalAlign="Center" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SageConnectionString %>"
ProviderName="<%$ ConnectionStrings:SageConnectionString.ProviderName %>"
SelectCommand="SELECT ACCOUNT_REF, NAME, ADDRESS_1, ADDRESS_2, ADDRESS_3, ADDRESS_4, ADDRESS_5 FROM SALES_LEDGER">
</asp:SqlDataSource>
On my local machien this works great and I'm very happy with it
I then uploaded the site onto the server
on running the page i get this
ERROR [08001] Cannot find all files in data pathERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 2.00ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).
can anyone suggest a eresolution? i'm confused since it works on my local machine fine but not on the server
Hi,
Sorry this is a cross-post, but I don't know where to put it.
Does anyone know where I can get an ODBC driver for sage line 100? I need to port the data in Sage to another ERP (on Progress).
Any help is much appreciated,
Ciaran O'Neill.
Hello, not sure if this is in the right forum or not...
I have a .DTA file from Sage which is a Database file, im assuming anyway, how can i convert it into a format where i can view it in say access or excel, something like that, or anything really just so i can read it all properly... i can read it in word - buts of it but its all mangled and awful...
Thanks
HI all,
I'm a newbie to all this so if I ask soem stupid questions then I appologise.
I was given a project on getting the reports within sage to work, You may be asking why then post in the SQL forum.
Ah well that is because Sage is as helpfull as a chocolate teapot to write reports with!!
I have try and found the limitation way to fast for my liking. So in my desperation to have a happy boss, I have turned away from the internal reporting and tryed to work on the SQL reporting.
I have found the \severname
eports function and I am nowtrying to find my way around.
Do any of you know a good place to pick up any information on the getting started. I konw that its going to be an uphil fight with sage cross referancing more times than i have hot dinners! but Sages and Crystal reports are not working for me, in the respect I can not get the look and functionality that I want.
Well i think that that sould cover it?!
I fyou know of any resource or step by step howto's then that would be great.
many Thanks
Michael
Hi,
There's a nullable Timestamp data type column in all tables in Sage SQL database.
When using Insert SQL query add a new record, with a NULL for the Timestamp column, into a table it seems alright. When opening the table it shows the inserted data in the Timestamp column is Binary. But when reading the record by Sage program there's an error message as the following:
'Fractional truncation: table scheme.opheadm unique_no 24969592 1'.
Any idea what the problem is?
Thanks,
Yabing
Hi
We would like to install Sql 2005 Enterprise Edition (including database engine, reporting service, integration service and analysis service) as a sepearte instance on a server which already has Sql 2000 with reporting services and analysis services. We do not want to disturb the existing sql 2000 setup.
If we do that then what will happen to my earlier sql 2000 reporting service? Will it be upgraded to sql 2005 reporting service? I heard that reporting services are instance unaware application. Where will be the default reporting service database available?
Please help us.
Regards,
Sankar N
Dear all
I have a company that sells fruit and vegetables to the catering industry.
I take orders in the evening for the next day, and buy my fruit and vegetables from wholesale market to deliver to my customers on the next day.
I have sage simply accounting.
I have to enter invoices day before I print them, so I can get a list of items i should buy next day (and also sort them into different routes)
My question is, is there a way to update all the prices on the active invoices (i.e. not printed or posted) for the previous day, after I enter new prices for the fruit and vegetables???
I need this as at the moment I hava to go into individual invoices and enter the products and quantities again.
Many thanks
hh
I am attempting to move some SQL 2000 databases to SQL 2005. My main production database does not seem to want to move. When I use the SQL 2005 GUI the .bak backup file is marked 'Incomplete'. When I attempt to restore the backup file I get a 'RESTORE detected an error on page (0:0) in database' message. I saw a thread in the SQL Express forum suggesting trying to restore from the T-SQL level to get the GUI out of the picture and I get the same 'error on page (0:0)' message. However when I take the same file and use SQL 2000 Enterprise Manager it restores with no problems.
Any ideas?
Thanks
Mike Mattix
Hi, I am trying to edit some data from a SQL2000-datasource in ASP.NET 2.0 and have a problem with a column that has bit-data and is used for selection. SQL2005 works fine when declaring <SelectParameters> <asp:Parameter DefaultValue="TRUE" Name="APL" Type="boolean" /> </SelectParameters>When running this code with SQL2000, there are no error-msgs, but after editing a record the "APL"-column looses its value of 1 and is set to 0. Looks like an issue with type-conversion, we've hit incompatibilities between SQL200 and 2005 with bit/boolean several times before. So, how is this done correctly with SQL2000? (I've tried setting the Type to "int16" -> err. Also setting Defval="1" gave an err) ThanksMichael
View 2 Replies View RelatedHi,i have SQL 2000 and 2005 on same machine(with different intance names,of course), my laptop - XP with SP2. The 2005 works fine but i can'tconnect on SQL 2000. All the the SQL services are started.Any idea? Have i to reinstall 2000?Tks,Lourival
View 1 Replies View RelatedI have to merge the data from two databases, one is in SQL Server 2005 format, one is in 2000. The merged data will then reside on a SQL Server 2000 platform. Is there an easy way to do this through Management Studio or Enterprise Manager? Or will we have to export the data from the 2005 database to a flat file and import it into a new 2000 database. And then do the merge?
TIA
I am in the process of migrating from Sql Server 2000 to 2005. Part of my plan is to move some database's to 2005, but use the 2000 compatibility mode for the short term. My issue is this, our DR boxes are still on SQL Server 2000, would I still be able to use our log shipping processes? Or would I be better off in starting with migrating the DR boxes to 2005 first?
Thanks in advance.
I have several SQL 2000 servers I need to setup transactional (non updatable) replication with. The structure is:
SQL Server 2000 as Publisher/Distributor
SQL Server 2005 Standard as Subscriber
The connection is via the Internet with snapshots using FTP.
I setup the first set (2 databases at location A). They work wonderfully. I created the publication and then subscribed using MGMT Studio for 2K5.
II am setting up the same scenario for location B. Here is my problem:
In MGMT Studio I connect to the publisher (SANDRA). I right-click a publication and choose New Subscriptions..., the publication is already selected. I click next - Run each agent at its Subscriber is selected and the only option (this is desired), I click Next
HERE IS THE PROBLEM:
On the Subscriber's screen there are no Subscribers listed. When setting up location A the subscribing server was listed and I could choose a database. The Next button is greyed out and there is no way to create/add one.
I tried setting up the subscription by right-clicking the subcribing server's Replication folder in MGMT Studio but I get the same result (except that I have to authenticate with the publishing server which works fine).
WHAT'S DIFFERENT:
Location A is SQL Server Standard (SP3) running on SBS2K3. It is obviously on a domain and so SQL Server and the SQL Agent are running under domain accounts. Location B is a Windows XP SP2 machine running SQL Server Personal Edition (it actually says Development Edition in the properties window).
The databases are the same strucutre, different data. At location A the firewall is set to allow 1433->*any* and *any*->1433 where *any* is 1024 or higher. On the XP machine the firewall is set to allow port 1433. I don't think this is the issue because I've turned the firewall off on the XP machine and I get the same result.
ANY IDEAS?
Most of our sql servers ar still sql 2000. Our programmers created many sql 2000 database diagrams using EM. But they can not access them under sql 2005. (They now have only sql 2005 tools installed on their boxes.)
Question: can we reinstall the sql 2000 client tools on their boxes without affecting the current sql 2005 install on their boxes?
Question: is there any workaround negating the need to ihstall the sql 2000 client?
TIA,
barkingdog
Hello Everyone,
I'm trying to connect to Desktop SQL Server 2000 from Windows mobile PC Emulator (VS 2005). I need a direct connection using connection string to SQL Server 2000 through local wireless network without IIS.
Bellow is the code that I use. After executing this code I get an error on line Conn.Open(). Error says SQL Server does not exist or access denied.
SQL is un and running, and I can log in using SA username from the desktop. Even if I chance IP for another SQL server in my connection string I still get the same error. There is no firewall of any kind running.
Dim connectionSTR As String = "Persist Security Info=False;Integrated Security=False;Server=192.168.0.202,1433;initial catalog=MyDB;user id=sa;password=;"
Dim Conn As SqlConnection
Conn = New SqlConnection(connectionSTR)
Conn.Open()
If Conn.State = ConnectionState.Open Then
MessageBox.Show("Open")
End If
About my environment: SQL Server 2000 is running on Desktop PC with Windows XP SP2. Application which I need to connect to SQL Server is in Visual Studio 2005. I execute the application in Windows Mobile PC Emulator and try to connect to SQL Server from emulator.
Your advice and help is very appreciated
Thank you
Ika
Hello,
I would like to ask you if there is better to recreate database structure on 2005 from 2000 and move data or to just load
2000 backup.
Currently I loaded the backup, but I am wondering if there might be slightly better performance on 2005 when recreating structure on 2005 to loading 2000 backup?
Does loading 2000 backup create 2005 binary structure?
Thanks for help in advance
How do SQL 2000 service packs play a role in upgrading? That is, can SQL 2000 Standard with no Service Packs(SP) be upgraded to SQL 2005 Standard, or does SQL 2000 Standard have to have a certain service pack??
View 1 Replies View RelatedP4 2.8G Hz, 512 M RAM.thanks.
View 3 Replies View RelatedIf we changed the sort order from BIN to BIN2 but kept everything else the same will it have any effect on replication? So in SQL 2005 if I were to change my default collation from Latin1_General_Bin to Latin1_General_Bin2, would that cause replication to break? I suspect that it will not be an issue since it is just sort order that is changing and the code page stays the same.
BTW, this is transactional replication. Sorry, I left that out of my original post.
Thanks,
Grant
Hi all.My webhost prepared a server for me with sql 2000 instead of sql 2005.Will my asp.net 2005 application work there?I generated a script to export my sql server 2005 objectsLots of failures appeard.IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name =N'aspnet_WebEvent_FullAccess' AND type = 'R')CREATE ROLE [aspnet_WebEvent_FullAccess]GOThis is the error:Server: Msg 170, Level 15, State 1, Line 2Line 2: Incorrect syntax near 'ROLE'.The object is part of the asp.net security/login components - I did not create these objects myself!Please tell me what to do next..........TIAGuy
View 5 Replies View RelatedHi, What would I lose out(functionality wise) if I were to use MS SQL 2000 instead of 2005? What are the main differences, and considerations to be factored in before choose which database to work on?
View 2 Replies View RelatedHi
I'm doing my fierst steps in .net and sql
I have made a website base on sql data in sql2005
'and find out that my hosting company (I'm host on shear server ) is only supporting sql2000 how can I convert it to 2000 ?
Or is there anther trick?
Thanks
assaf
i have developed my project in asp.net 2.0 +ajax +c# as backend with sql server 2000 as back end
now my question is can i change my sql server to 2005
will it gives any problem in furture
all my queries will run properly
HI,
I Have my websites developed in sql 2005 and my host is providing SQL 2000.
WHAT problem i might face will my site run ?
or do i need to change things??
I want to use SQL 2000 with VS 2005. I do have SQL 2005 Express installed but i would rather use SQL 2000 because all my DBs are currently in this version and I want to get up and developing now and then convert them to SQL 2005 one at a time. LATER...When I try to connect to SQL 2000 through VS 2005 I keep getting this error that tells me it can not connect to SQL 2005 Express. This is my conncetion string:
Const connectionString As String = "Server=localhost;Trusted_Connection=True;Database=Northwind"One thing that I see wrong with the error is that I thought SQL 2005 did not have Northwind anymore. And 2 this is a sample app from MS website. So why would it try to connect to SQL 2005 Express. This is my first try at connecting to a DB with VS 2005.Please Help.-J
Hi, I am currently developing my website to ASP.NET 2.0 using SQL Server 2005 Express Edition.
However, after long hour to figure out, my hosting company doesn't use
sql 2005. They only have SQL Server 2000. Even I have to pay for using
SQL 2000.
My question is, what is the different between SQL 2000 and 2005 in term of using it in a server?
My condition is that I am developing my database under SQL Server 2005
EE, now, can it be uploaded to be used in a server with SQL 2000?
Thanks in advanced for all help, time and your support. HAVE a good day!
can anyone point me to where microsoft are displaying the product expiry of SQL 2000, ie how soon do we need to be looking at adopting the new version?
View 2 Replies View RelatedWe are starting a new project and for production we are all set, we are getting a new server and decided to go with 2005 (the rest of our production machines are running 2000).
Could someone let me know if we will have any problems installing 2005 on our Development and QA Servers that are currently hosting 2000 or would it be in our best interest to purchase separate servers to run 2005? If you could share your first hand experiences that would be great.
Thanks
-John
Can i run 2000 and 2005 on the same computer, will i have any consideration i have to take
View 2 Replies View Relatedqueation:
why running the follwing qry in sql 2005 is not working?
SELECT i.namelong "AMC_FULL_NAME",
s.acqdate "FORECLOSURE_ACQ_DT",
m.ns_acqdate "DATE_OF_RELEASE",
m.ns_conphon "SERVICER_PHONE",
0 "TOTAL_AMT_DELQ"
from country i,
city m,
state s
where m.deptno *= i.code1
and i.cd_type = 'dept'
and m.uniq_id *= s.muniq_id
Josephine
Is it ok to run both 2005 & 2000 on the same machine? For dev. purposes?
Thanks
I just imported a database from SQL 2000 to SQL 2005
In SQL 2000 i have two users WEBFORMS WEBFORMSUSER
I see in 2005 it created two schemas and two users.
Database is called WEBFORMS
All tables are dbo.
Is it best to make all the tables become WEBFORMS.Employee
and then have one Schema called WEBFORMS
One user called WEBFORMSUSER that access WEBFORMS Schema.
Any directions would be appreciated