# DSN MySql

**URL:** <https://forum.kirupa.com/t/dsn-mysql/91163>\
**Category:** Uncategorized\
**Created:** [September 29, 2003, 9:19pm UTC](https://forum.kirupa.com/t/dsn-mysql/91163 "2003-09-29T21:19:40Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![boristheblade](https://avatars.discourse-cdn.com/v4/letter/b/848f3c/32.png) [@boristheblade](https://forum.kirupa.com/u/boristheblade)\
**Post date:** [September 29, 2003, 9:19pm UTC](https://forum.kirupa.com/t/dsn-mysql/91163/1 "2003-09-29T21:19:40Z")

</div>

Hi - I need som help please!  
I have Mysql running on my C drive

The web server is a on a local network Z drive running IIS.

I downloaded and installed the latest MyODBC.

I created a system DSN from control panel, and when I click on ‘Test Data Source’ I have success. But when I try to connect on my asp page, it gives me the following error.

Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

here is my aspcode  
\<%  
set conn=Server.CreateObject(“ADODB.Connection”)

conn.Open “chrisDSN”  
%\>

I greatly appreciate any help or advice. In a lot of trouble!! Thanks