|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
|
||||
|
||||
|
DB Connection using Mixed Mode Authentication
i have the following code in connecting to my ms sql database. unfortunately, it dont work when the server uses a mixed mode authentication (SQL and windows authentication). can anyone help me on this? thanks in advance
Set cnn = Server.CreateObject("ADODB.Connection") cnn.open "PROVIDER=SQLOLEDB;DATA SOURCE=server_name;UID=user;PWD=password;DATABASE=dbname" |
|
#2
|
|||
|
|||
|
try to see if your server accept Mixed connection first of all
|
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > DB Connection using Mixed Mode Authentication |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|