The ISP do have the driver installed and they also know what they are
talking about. The problem is they won't talk to me because I am not
the reseller (ie their customer). The reseller I have used knows
nothing about MySQL - he knows everything else but MySQL.
Mat
On Thursday, February 5, 2004, at 02:34 PM, ghuntress@stripped wrote:
> Matt,
>
> Are you sure that they have the MySQL driver installed on their
> webserver? Since you say that they have no experience with MySQL,
> they probably do not, and that would be your problem.
>
> Regards,
>
> Gary H.
>> I am having problems with making a connection between my website and
>> the MySQL db on a different server. I have tried both hand coding and
>> using the MyOLEDB application for MySQL. What am I doing wrong? If you
>> think this looks a little strange, it is because it is a dreamweaver
>> connection file.
>>
>> This is an error that I get when I try to browser the site:
>> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>> [Microsoft][ODBC Driver Manager] Data source name not found and no
>> default driver specified
>> /csi/index.asp, line 8
>>
>> This is the code on index.asp, line 8:
>> Recordset.ActiveConnection = MM_connection_STRING
>>
>>
>> and here is the code from the connection file:
>> <%
>> ' FileName="Connection_odbc_conn_dsn.htm"
>> ' Type="ADO"
>> ' DesigntimeType="ADO"
>> ' HTTP="false"
>> ' Catalog=""
>> ' Schema=""
>> Dim MM_connection_STRING
>> MM_connection_STRING = "Driver={ mySQL };" & _
>> " Server =servername.com;" & _
>> " Port =3306;" & _
>> " Option =131072;" & _
>> "Stmt=;" & _
>
>> "Database=databasename_db;" & _
>> "Uid=database_user;" & _
>> "Pwd=database_pass"
>> %>
>>
>> Can somebody please tell me what is wrong with this? My ISP is a
>> reseller who has no experience of MySQL and because he is the customer
>> (not me) they will only talk to him. Besides that they are quite
>> useless when it comes to dreamweaver.
>>
>> Thanks
>>
>> Mat
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=1
>>
>
>
