Hi,
I am having problems registering a SQL Server Table. With Access
everything was fine but now that we have upgraded to SL Server when I
register the table it is readonly so no modifications can be made to it.
This is the code I use to create the Linked table:
Register Table "TABNAME" Type ODBC toolkit ODBC Table "SELECT pk_col1,
col2, col3 FROM table1" Connection "DSN= mydsn;UID= XXXXX;pwd=
XXXXX;database= MYDB;" into "C:\mydir\mytable.tab"
This is the tab file that's created:
!table
!version 500
!charset WindowsLatin1
Definition Table
Type ODBC
begin_metadata
"\IsReadOnly" = "FALSE"
"\DATALINK" = ""
"\DATALINK\MapReadOnly" = "TRUE"
"\DATALINK\Query" = "select pk_col1, col2, col3 from table1"
"\DATALINK\ConnectionString" =
"DSN=mydsn;Description=MyDSN;UID=XXXXX;APP=MapInfo Professional(TM) for
Microsoft(r) Windows(tm);WSID=PC001;DATABASE=MYDB"
"\CACHE" = "ON"
"\MBRSEARCH" = "ON"
end_metadata
Any Ideas?
********************************************************************
This message is intended only for the use of the person(s) ("the intended
recipient(s)") to whom it is addressed. It may contain information which is
privileged and confidential within the meaning of applicable law. If you
are not the intended recipient, please contact the sender as soon as
possible. The views expressed in this communication may not necessarily
be the views held by LGCSB (Local Government Computer Services Board).
Any attachments have been checked by a virus scanner and appear to be
clean.
Please ensure that you also scan all messages, as LGCSB does not accept
any liability for contamination or damage to your systems.
********************************************************************
