Forums

This topic is locked

connection strings?

Posted 18 Sep 2001 10:32:10
1
has voted
18 Sep 2001 10:32:10 simon bloodworth posted:
i have tried to use the connection string
driver={mysql}; database=yourdatabase;server=yourserver;uid=username;pwd=password;option=16386;

but it keeps coming back with errors. i contacted my isp and i told them the connection string they supplied me will not work either and they said
This will not work in UltraDev because you will not have the JDBC driver
running on your PC - while using UltraDev on your PC just use the MyODBC
driver and only change the connection string for the uploaded asp scripts.

if this is the case i am not sure which scripting to edit, is it the connections or the results page. sorry to be a pain in the rear but it really is bugging me.

thanks




S Bloodworth

Replies

Replied 18 Sep 2001 10:51:44
18 Sep 2001 10:51:44 Andrew Watson replied:
This can be annoying and what i do in my local site is this, In the connections folder i have two copies of the asp connection file (where the string is to be found) One of which is renamed with a capital R as a prefix (for remote). This is then altered to use the connection string required for the remote site. So when I upload or Synchronize my site i just rename Rconnection.asp to connection.asp. Allowing my site to operate both locally and remotely with minimal hassle.

That aside, it is definately the asp file within the connections folder of your site that you need to alter. (i dont use MySQL so i cant help with the syntax of the string)

Cheers
<img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>
Leed
Ayrshire

Reply to this topic