Hi,
I downloaded MapXtreme v3.0 for Windows (trial). Everything works fine. But, when I
try to change MS Access "mapstats.mdb" database with MS SQL Server nothing works.
Using MS Access wizard I uploaded mapstats.mdb to MS SQL Server in pre-pared database
named mapstats, with UID=mapinfo and PWD=map.
Then, I changed following asp files:
a) In ThematicsConstants.asp changed Const cThDatabaseFile = "mapstats.mdb" with
Const cThDatabaseFile = ""
and
Const cThDatabaseDir = "C:\Program Files\MapInfo\MapX 5.0\Data" with
Const cThDatabaseDir = ""
b) In Thematics.asp changed objConnection.ConnectionString = "Driver={Microsoft Access
Driver (*.mdb)};DBQ=" & strDatabaseFile & ";DefaultDir=" & strDatabaseDir &
";Uid=Admin;Pwd=;"
with
objConnection.ConnectionString = "Provider=SQLOLEDB.1;Password=map;Persist Security
Info=True;User ID=mapinfo;Initial Catalog=mapstats"
This string was copied from pre-pared mapstats.udl file enabling correct and checked
connection with MS SQL Server.
Also, it is important to mention that no error received from the IE browser but only
same, initial map of the World was displayed.
Any help or suggestion is highly appreciated.
Best regards,
Maky
---------------------------------
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
