compatibility question

compatibility question

• Dman82

  It depends. Are you using user instances(its in the connection string) are you using varchar(max), xml types Are you using the new security features

  Any of the above will prevent the app from working on a sql server 200 machine.

  
  
  

• Morwyn

  There will not be a conflict but you may have to make code changes, there are a fair number of features in SQL Express that will not work with SQL 2000. I suggest downloading a copy of MSDE for yourself(which is free) so you can test before going live with the hoster.
  
  

• Benjamin Fallar III

  i am only using one mdf file and my asp.net program just deals with the common add, edit, delete transactions. would these transactions differ from version to version of MSSQL
  
  honestly i did not think there would be a problem coz these transactions are very common. pls correct me if i am wrong.
  
  

• tsreddy02

  can I implement the membership control (provided by ASP.NET) on MSDE i can try migrating from SQLEXxpress to MSDE but im not sure if membership control works on that MSDE. sorry if i really sound dumb. im a newbie.
  

• mkuczara

  There is a tool that comes with ASP.Net that supports installation of the databases, aspnet_regsql.exe is its name, check and see if it can install the tables for membership control, I believe it supports SQL 2000 ie MSDE.
  
  

• skgma

  Euan Garden wrote:

  There is a tool that comes with ASP.Net that supports installation of the databases, aspnet_regsql.exe is its name, check and see if it can install the tables for membership control, I believe it supports SQL 2000 ie MSDE.

  
  
  i just tried it and it installed all the membership tables using this MSDE.
  thanks for the help Euan Garden.
  
  
  

• SimonGUK

  2 issues here;

  1/ MSDE does NOT support user instances so you need to change your conection string to a regular one.

  2/ You are trying to attach a SQL2005 db to a SQL2000 machine, this will not work, you will need to move the data and schema onto a SQL Server 2000 implementation.

  
  
  

• Erklarbar

  Euan Garden wrote:

  It depends. Are you using user instances(its in the connection string) are you using varchar(max), xml types Are you using the new security features Any of the above will prevent the app from working on a sql server 200 machine.

  
  
  this is my connection string:
  <add name="conn_name" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dbase_name.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
  
  sql2000 doesnt support user instance, does it
  
  ___________________________________
  i just installed MSDE to make a test. i tried attaching my mdf file (created by SQL Express) to the MSDE but i got this error message:
  
  "An error occured when attaching the database"
  
  i attached that mdf file to the SQL Express and i encountered no problem at all. do you think i will encounter the same problem with my hosting company
  
  thanks for your time Euan.
  
• compatibility question