Server.MapPath

[William Gower]

I am trying to run the following in my connection string

"Data Source = Server.MapPath('private\Union.mdb')"

The asp application is in c:\inetpub\wwwroot\Unit12 and the database is one
directory lower in private.

It keeps trying to map it to

'C:\WINDOWS\system32\private\Union.mdb'

How do I get rid of the c:\windows\system32

Incidently this is being run in my Application_Start

 

[Cor Ligthert]

Hi William,

You can add the connection string to your connection in the load event.

Something as:

myconnection.ConnectionString = "myconnectionstring"

Mostly you do not need that complete genereated one.

Have a look here for connectionstrings.

http://www.connectionstrings.com/

http://www.able-consulting.com/ADO_Conn.htm

I hope this helps?

Cor