Anyone familiar with Ensim?

[Anjari]

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

[dj4uk]

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

[dj4uk]

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

[dj4uk]

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

Try them both and see which works.

[Anjari]

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

[dj4uk]

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