Cool Connection DSN specific from ODBC or DBI

I am new to the group and discountasp.net. We are able to use LittleAdmin database management tool to do one record/transaction at a time. But, we want to add a whole category including static files that will be built using database inputs. Does anybody have working DSN setting/string that could be used with Microsoft (ODBC) or Perl (DBI) for the remote XXXXX.discountasp.net server ... the connection string given by the LittleAdmin->connections does not work. Thanks, Chisai.

 

I forgot to mention that I am getting a "Can't connect to MySQL server on 'localhost' (10061) at line 21" in perl script. I am using the (DBI) interface in this case along with the connection string generated in the LittleAdmin database manager. The driver is the mysql driver. at sql2kXXX.discountasp.net.

 

I posted this under open discussions; however, this to be a better place to post this.

I am new to the group and discountasp.net. We are able to use LittleAdmin database management tool to do one record/transaction at a time. But, we want to add a whole category including static files that will be built using database inputs. Does anybody have working DSN setting/string that could be used with Microsoft (ODBC) or Perl (DBI) for the remote XXXXX.discountasp.net server ... the connection string given by the LittleAdmin->connections does not work. Thanks, Chisai.

The error I am getting is "Can't connect to MySQL serger on 'localhost' (10061)". I am using the mysql driver and full domain path the the server XXXXXX.discountasp.net as the Data Source= .

 

Got Something that Works

I was able to get it working using a combination of the Microsoft ODBC administrative tool and the Perl DBI::ODBC. Able to log into sql2kXXX.discountasp.net SQL server and verify database version, list tables, and run select queries on tables using Perl scripts. I want to try a few different connections techniques and will list the connection strings at a later date. Just happy to be able to get some work done. Thanks for the URL's!!