mysql to Microsoft SQL

[parames]

Hi list..

Currenly i'm using mysql database with ODBC connection (windows 98 and asp)and now i have to change to Microsoft SQL database..So,

1) Is there a lot of things to be changed..

2) Can i use ODBC connection to connect to Microsoft SQL database.
If can, please give me an example..

3) I download mysql database from mysql.com, so, can i donwload Microsoft SQL from anywhere..

please help..

rgds,
parames.s

 

[Antzz]

1) Is there a lot of things to be changed..
Ans: Nope, if you are using standard SQL. If you are using native SQL for mySQL(and I am not very familiar with mySQL) then you will have to change the SQL statements since you will get syntax errors

2) Can i use ODBC connection to connect to Microsoft SQL database.
If can, please give me an example..
Ans: Yep, you can. I am assuming you will be using VB.
* Create a connection object
Set l_Conn = New adodb.Connection
l_Conn.Open (ls_Conn)
* Here ls_Conn is a connection string and it might look like this :
"uid=myuid;pwd=mypwd;driver={SQL Server};database=mydb;dsn=,,connection=adConnectAsync"
The above is an example of a dsnless connection. In fact this is more efficient in case you want to bypass ODBC. In case of ODBC, just assign the database DSN to that parameter and it should work ok.

3) I download mysql database from mysql.com, so, can i donwload Microsoft SQL from anywhere.
Ans: Microsoft has stopped providing free trial versions of the database. So unfortunately, as far as I know you will need to download it. Unless of course you buy a SQL Server book and get a trial version on a CD(which is included with the book).