Can't Connect to Account DB NEED HELP ;/

codexpert1 · 12/23/2013, 08:43

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!

3lyka · 12/23/2013, 08:55

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

codexpert1 · 12/23/2013, 08:56

Quote:

Originally Posted by 3lyka

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

Succes , i logined.

3lyka · 12/23/2013, 09:01

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

codexpert1 · 12/23/2013, 09:10

3lyka · 12/23/2013, 09:11

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