Hi,

I am having trouble changing a connString for a friends website. It was developed with MySQL and our server has MS SQL Server 2000. Here is the old connstring.

var connString = "DRIVER={MySQL}; SERVER=209.132.240.96; DATABASE=gcem; USER=gcem; PASSWORD=emergency; OPTION=3;";

Here is the new connstring.

var connString = "Driver={SQL Native Client}; Server=SERVERNAMEHERE; Database=gcem; Integrated Security=SSPI;"

Does this look right?

Also will there be a problem recreating the data types in MS SQL Server 2000?

Thanks Matt

You can do this 2 ways, you can setup a DSN on your server and connect that way or you can use OLEDB such as this:

Dim conn
set conn = Server.CreateObject("ADODB.Connection")
conn.open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog = Northwind; User Id = sa; Password="

hth.

[Edit]
Forgot to tell you, going from MySQL to MS Sql you shouldn't have a problem with the data types and such. (Don't take my word as fact, I have only limited experience with getting MySQL and MS SQL to play nice together as we only use MS SQL at work.)

"The one language all programmers understand is profanity."

Hi,

Now I am getting an error in the log file the the server does not exist or the user is denied access.

Any help?

Thanks Matt

Hi,
  Does anybody know to convert mysql db to sql server 2005 db using c# for web application?

Thanks in advance.

Sachin