Anyone familiar with Ensim?

What is the path for the MYSQL database?

for example:



quote:
--------------------------------------------------------------------------------
<%
DIM objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath ("acrow") & ";"
objConn.Open
%>
--------------------------------------------------------------------------------



gives me


quote:
--------------------------------------------------------------------------------
Microsoft JET Database Engine error '80004005'

Could not find file 'c:\webppliance\conf\domains\acrow\Inetpub\wwwroot
\siteadmin\acrow'.

/siteadmin/default.asp, line 6
--------------------------------------------------------------------------------



This is on Ensim: Windows Site Administrator 3.2.1-3 (acrow)

can anyone help?

Thanks,

Anjari

I've used ensim and found it a real pain to use. I'm sure I've got the connection string at work - I'll get back to you on Monday!

You can try http://forum.ensim.com if you need more immediate help.

DJ

Try the connection string:
"DRIVER=org.gjt.mm.mysql.Driver;URL={jdbc:mysql://localhost:3306/databasename};uid=username;pwd=password;"

If this doesn't work try changing localhost for the server name or IP address. If this still doesn't work check which port MySQL is on (3306 is the default).

HTH.

DJ

The other option is:
"Driver={mySQL};Server=MyServerName;Option=16834;Database=mydb;uid=username;pwd=password"

Try them both and see which works.

DJ thanks for getting back to me...

We have decided to upgrade to 2003 and drop ENSIM all together... It was nothing but problems for us.

Thanks anyway,

Anjari

A very good decision - should stop you having sleepless nights.