Can't Connect to Account DB NEED HELP ;/

12/23/2013 08:43 codexpert1#1

my srGlobalService.ini ;

Code:

[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=SRO\DEVRIM;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=password;passwordhere;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697

dbconnect;

Code:

<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=SRO\DEVRIM;Initial Catalog=SRO_VT_ACCOUNT;userID=sa;password=passwordhere;"
DBConnA.Open strConnectA

%>

HELP!

12/23/2013 08:55 3lyka#2

Try to connect via SQL Server Management Studio with userID=sa;password=passwordhere

12/23/2013 08:56 codexpert1#3

Quote:

Originally Posted by 3lyka

Try to connect via SQL Server Management Studio with userID=sa;password=passwordhere

Succes , i logined. :(

12/23/2013 09:01 3lyka#4

Try replace SERVER=SRO\DEVRIM with (local) "SERVER=(local)" . You did DSN?

12/23/2013 09:10 codexpert1#5

[Only registered and activated users can see links. Click Here To Register...]

12/23/2013 09:11 3lyka#6

If you have TeamViewer i can take a look. PM me with TeamViewer info