Hami
|
| Posted: 05/22/2002, 3:30 PM |
|
Hi
My database is on the MS SQL Server in my local Network. How do I connect to it? Please note that my project works well in the same server with MS ACCESS.
Thanks for your help!
I m using code charge 2.0. ASP code , NT4 IIS4
Hamid
|
|
|
 |
www.adenin.nl
|
| Posted: 05/22/2002, 9:53 PM |
|
Just connect the string to MS SQL as you did with MS Access.
that is all.
Regards,
Marco
|
|
|
|
Nicole
|
| Posted: 05/23/2002, 1:10 AM |
|
Hami,
Design time connection.
Open Data Link Properties window and go to Provider tab. Select 'Microsoft OLE DB Provider for SQL server' provider and go to Connection tab. First, specify server name, further settings depend on your SQL Server Login settings. If in Login 'Windows NT authentication' is selected, hen in CC select 'Windows NT Integrated Security' option. If in Login 'SQL Server authentication' is selected, then in CC select 'Use a specific user name and password' option and enter db login and password.
Then select db on server from drop down list.
Click 'Test Connection' to verify connection. Once it is successful, click Ok to close Data Link Properties window.
|
|
|
|
Hamid
|
| Posted: 05/25/2002, 2:50 PM |
|
Nicole,
It is still not working!!
When I tested the connection I got " test connection succeced".
When I chose properties, Design, type, DNS, in my browser I have this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'CFA-INF-02\IUSR_CFA-INF-02'.
/sysinv4/Common.asp, line 25
When I chose properties, Design, type, custom, in my browser I have this this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'CFA-INF-02\IUSR_CFA-INF-02'.
/sysinv4/Common.asp, line 25
Thanks for your help.
Hamid
|
|
|
|
Nicole
|
| Posted: 05/27/2002, 12:57 AM |
|
Hamid,
1. You need to give the IUSR_CFA-INF-02 account access to the database. The ASP pages are logging in using that account.
2. check following article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q247931
|
|
|
|
Hamid
|
| Posted: 06/01/2002, 7:39 PM |
|
Thanks a lot , It works.
Hamid
|
|
|
|
|
