MsSQLPureImageCache & SQL2000

Apr 10, 2010 at 12:38 PM

Hi,

 

Does MsSQLPureImageCache cache provider support MS SQL 2000?

 

I've implemented the code as instructed. 

Created a separate user for GMAP on the server with full rights and tested the connectionstring

During initialization, no table is created by GMAP.

Also, when creating the table myself, the table is not filled. I suspect the GMAP code is not compliant to SQL 2000?

 

Br,

Guy

Coordinator
Apr 10, 2010 at 12:45 PM

please paste your debug trace

Apr 10, 2010 at 5:56 PM

Currently i'm using gmap dll's as references in my project.

i'm not using the actual source as there was no need (so far). Hence i'm not able to trace an error.

Any suggestions?

 

 

Coordinator
Apr 10, 2010 at 6:00 PM

use the source, run debug, show me error ;}

Apr 10, 2010 at 7:07 PM

i was suspecting that answer :) i'll have a look and inform you.

 

Apr 23, 2010 at 4:18 PM

Ok, had a look and did some tests:

The problem is the SQL language that is used in the code:

using(SqlCommand cmd = new SqlCommand( "

CREATE TABLE [GMapNETcache] (

[Type] [int]   NOT NULL,

[Zoom] [int]   NOT NULL

[X]    [int]   NOT NULL

 [Y]    [int]   NOT NULL

[Tile] [image] NOT NULL

CONSTRAINT [PK_GMapNETcache] PRIMARY KEY CLUSTERED (Type, Zoom, X, Y) 

 

SQL2000 doesn't like the square brackets. The SQL that was successful is:

CREATE TABLE GMapNETcache  

(Type integer   NOT NULL, Zoom integer   NOT NULL,X    integer   NOT NULL,  Y    integer   NOT NULL,  Tile image NOT NULL,CONSTRAINT PK_GMapNETcache PRIMARY KEY CLUSTERED (Type, Zoom, X, Y))

 

The same applies for the other INSERT and SELECT statement. The SQL without squared brackets would be in my opinion be more generalized form and hence have preference.

 

Are you willing to change that in your code?

 

 

 

Coordinator
Apr 24, 2010 at 12:40 PM

i can do that, but i have no idea how to test it, anyway sql2000 is 10 years old stuff

Coordinator
Apr 24, 2010 at 4:50 PM

can you do that, and create fork?

May 1, 2010 at 1:13 PM

Hi Radioman,

 

i've implemented the changes in the MSSQLPureImageCache.cs.

Also tested it on SQL2000 and SQL2005. Both work.

 

concerning this fork thing,

i created a fork and put some name and description. so how do i actually provide the changes?

(never done this before)

Br,Guy

Coordinator
May 1, 2010 at 1:27 PM
Edited May 2, 2010 at 10:05 AM

perfect! ...well, now just commit your changes and push to the codeplex server, thanks for your help

p.s. check http://blogs.msdn.com/codeplex/archive/2010/03/05/codeplex-mercurial-support-for-forks.aspx 

Coordinator
May 5, 2010 at 7:51 PM

Are you still alive? We wanna your changes, please push it to codeplex server ;}