connecting to mysql

Results 1 to 2 of 2

Thread: connecting to mysql

  1. #1
    Join Date
    Dec 1969

    Default connecting to mysql

    I need to connect to a mySQL database using a dsnless connection this is what im using at the moment<BR><BR>ConnectionString1a = "Driver=MySQL;Server=localhost;UID=root;PWD=;OPTIO N=16386;Database=test"<BR><BR>but i&#039;m getting the error<BR><BR>[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified <BR><BR>anyone help or does anyone know of any tutorials of aspmysql as oppoesed to php<BR><BR>thanks<BR>

  2. #2
    NPKumar Guest

    Default RE: connecting to mysql

    Try this.<BR><BR>connectString1a="Provider=sqloledb;Se rver=xxx;Databse=test;UID=root;PWD=;" <BR><BR>I am using this .Its working fine .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts