Quote Originally Posted by Martin Moleman View Post
So you have a connection ID defined in 2 places. In dfconnid.ini (managed connection) and mssqldrv.int.
You should have only one definition. So what happens if you remove the definition in mssqldrv.int?

Also, the name of the connectionID is 2. I don't think it matters, but what if you give it an alphanumeric name like MyID?
Hey Martin, thanks for supporting me

i removed the MSSQLDRV.int string connection.

my DFConnid.ini

Code:
[connection1]
id=MyID
driver=MSSQLDRV
connection=SERVER=192.168.0.118;DATABASE=***
UID=GROUP
DFPWD=***
my table .int file:

Code:
DRIVER_NAME MSSQLDRV
SERVER_NAME DFCONNID=MyID
DATABASE_NAME CFOP
SCHEMA_NAME dbo


RECNUM_TABLE NO
PRIMARY_INDEX 1
TABLE_CHARACTER_FORMAT ANSI
USE_DUMMY_ZERO_DATE YES


FIELD_NUMBER 1
FIELD_LENGTH 8
FIELD_INDEX 1


INDEX_NUMBER 1
INDEX_NAME CFOP001
on Database Explorer/Builder works great, under studio still not working, same error.

may it have something to "reload" on filelist.cfg?

Click image for larger version. 

Name:	1.PNG 
Views:	30 
Size:	19.6 KB 
ID:	13977

tried to use SQL Connect/Repair wizard tool

Click image for larger version. 

Name:	2.PNG 
Views:	33 
Size:	19.0 KB 
ID:	13978

and got this error:

Click image for larger version. 

Name:	3.PNG 
Views:	55 
Size:	24.1 KB 
ID:	13979