We're trying to get php and ultradev and mysql to work on linux. We got the JDBC drivers and it says to change the class file. Where is the classfile on linux. or do I need to just put it a certain directory? If anyone did this before can you tell me the steps you took

thanks

Keith Slater

You don't need to install the JDBC drivers onto your Linux server at all.

Just use a direct connection to your MySQL Server and it will be fine.

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

I am trying to acheive the same thing but due to my lack of knowledge of MySQL I am having a problem with the connection string.

Using help from my ISP I have now uploaded my database to my server and can make a connection to it using the driver on my local machine. I cannot however access it using the connection string to their server which means the site does not work online.

The following is the connection string they supplied.

Set Conn = Server.CreateObject("ADODB.Connection"
strConn = "Driver={MySQL}; DATABASE=usernamedb; UID=username; PASSWORD=secret"
Conn.Open strConn

Because UltrDev only has a sigle line text box I cannot enter 3 lines so I entered the string as follows which does not work.

Set Conn = Server.CreateObject("ADODB.Connection";strConn = "Driver={MySQL}; DATABASE=usernamedb; UID=username; PASSWORD=secret";Conn.Open strConn

I supect there is a syntax problem but as I know nothing about MySQL I do not know what the problem is.

If you can correct the string i will be grateful. Hopefully this will help both of us.

Davrus,

Please ensure that you read the FAQ (link in my sig), and make sure that you don't post the same question more than once to the list.

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>