Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
MySQL INSERT INTO Problem
Here's the code: <% // Create Memory Variable Dim m_strSQL // // Build the SQL statement m_strSQL = "INSERT INTO <TableName>(fieldname2,fieldname3,fieldname4,fieldname5,fieldname6, Etc...) VALUES... -
ASP and Database Connection Question
OK Guys, I got the database open with the following code (which all works perfectly).... // Build the sql statement m_strSQL = "select * from <datatable> where Remote_IP Like '%" & Request.ServerVariables("REMOTE_ADDR") & "%';" // Create the MySQL Connection. set MySQLConn =... -
Asp Connection Strings Query
OK Guys, I got the database open with the following code (which all works perfectly).... // Build the sql statement m_strSQL = "select * from <datatable> where Remote_IP Like '%" & Request.ServerVariables("REMOTE_ADDR") & "%';" // Create the MySQL Connection. set MySQLConn =... -
Asp Connection Strings Query
Excellent !! Thanks very much for that one. Next silly question, Can I use an IP address for "SERVER" instead of "data.domain.com"? -
Asp Connection Strings Query
I am a novice at using database websites. I need to connect to a MySQL database on a remote server using ASP...... I have been given the following by tech support at my ISP (Fasthosts)..... "DRIVER={MySQL ODBC 3.51 Driver};SERVER=data.domain.com;PORT=3306;DATABASE=myDatabase...
