Friday, March 16, 2012

PLEASE HELP ME! Access to SQL-Server!?!

Hi to all!

I am new to asp and databases...I got a program, that uses an access database...now I want the program to write the information into a SQL-database...what must I do?

Or what is important to change on the code?

thx

juviFirst migrate the data from access to SQL Server using the tools provided by SQL. Second, you will need to change your connection string to use the SQL data provider (www.connectionstrings.com). Lastly, you will probably need to change some of your queries b/c access queries are slightly different from T-SQL queries.

0 comments:

Post a Comment