LOAD DATA INFILE problem with drive letter mapping

[David Armour]

Hi!

I have a strange problem with a new server we have just installed. It is running Windows Server 2003.

When I type the following query:

LOAD DATA INFILE 'S:/TEMP/mydata.dat' REPLACE INTO TABLE MYDB.MYTABLE

I get a file not found error.

S: is mapped to a shared folder on the server itself. The SQL is written by the users who refer to this share by the mapped drive letter.

The map is S: = \\SERVER.GB.COM\COMMON and is present and working on the server itself.

When I type this:

LOAD DATA INFILE \\\\SERVER.GB.COM\\COMMON\\TEMP\\mydata.dat REPLACE INTO TABLE MYDB.MYTABLE

it works perfectly.

Can anyone explain why the map 'S:' would not work here?


Regards.