Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Web Wiz 8x -- Access to MS SQL success
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Web Wiz 8x -- Access to MS SQL success
 Post Reply Post Reply Page  <123
Author
 Rating: Topic Rating: 3 Votes, Average 4.00  Topic Search Topic Search  Topic Options Topic Options
romadhon View Drop Down
Newbie
Newbie


Joined: 24 December 2007
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote romadhon Quote  Post ReplyReply Direct Link To This Post Posted: 10 January 2008 at 11:49am
thanks god i can convert ms access to mssql
but..
i can't connect it from dataconnection
because i can't connect the mssql where i'am use my user but i have to use trusted user
so, what i fill in dataconnection.asp?

can you tell me what a password of user "sa" ?
Thanks so much
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 10 January 2008 at 12:01pm
You can not use a trusted connection when connecting from ASP as you are using a TCP/IP connection.

SQL Server needs to be installed in mixed mode with TCP/IP connections enabled. You then need to either login using the built in sa account or create a user is SQL Server.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
romadhon View Drop Down
Newbie
Newbie


Joined: 24 December 2007
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote romadhon Quote  Post ReplyReply Direct Link To This Post Posted: 10 January 2008 at 11:48pm
i'am use sqlexpress.
what can i do for it?
i tried create user in SQL. but it can't connect too.
so?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 11 January 2008 at 9:47am
You need to install SQL Express in mixed mode.

By default SQl Express installs with the instance name SQLEXPESS so you would use the following to connect on a localhost machine:-

localhost/SQLEXPRESS
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
manos2000 View Drop Down
Newbie
Newbie


Joined: 03 October 2004
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote manos2000 Quote  Post ReplyReply Direct Link To This Post Posted: 18 February 2008 at 9:17pm
When migrating the database from access to MSSQL is the any need to change any file except connections.asp?
I changed only this (left acces version files) and works ok with MSSQL db.
 
regards
 
manos
Back to Top
lordtec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 16 July 2007
Location: Brazil
Status: Offline
Points: 213 		Post Options Post Options   Thanks (0) Thanks(0)   Quote lordtec Quote  Post ReplyReply Direct Link To This Post Posted: 05 September 2009 at 4:36pm
This conversion is for MySQL 5.1 or SQL Server 2005?

Is there a difference?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 07 September 2009 at 1:53pm
This is for Microsoft SQL Server 2005 or 2008 which is a translational database system produced by Microsoft.

mySQL 5.1 is a free database system now owned by Sun Microsystems. it is not a relational database systems and has different data types, so databases written for mySQL often need a very different schema to that of Access and SQL Server.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply Page  <123

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.