Recent content by bchaney

Hey I got it. Here is my code that works: Dim connstr As String Dim insstr As String Dim conn As New ADODB.Connection Dim cmd As ADODB.Command Dim equipid As String connstr = "DRIVER={MySQL ODBC 5.1...

@pbaldy That last post really helped me. I'm currently doing more research on mysql. I got the code finally to accept but now mysql is throwing back an error saying I don't have command execute privileges. I'm trying to work through that now. When I finally get through this part I'll post...

@cyberwolf Sorry about posting that code. I had tried to take out the date variable to rule out my date being in the wrong format (access looks for a date type variable and I could have been converting it into a string). I hurriedly put the code back in to send to the forum. The same result...

Okay sorry to bother you guys about this post. I kind of figured out the problem for the code above and kind of stumbled on a new problem. The above problem was due to me trying to msgbox cmd. which i found out i cannot do. That was giving me the mismatch error. I commented that part out for...

sorry i didn't answer your question with my response above. this code was originally doing the insert statement. but i ran into problems with the characters ' and ". those characters have to be allowed in the description fields and from what i've gathered reading online, the only way to do...

it's kinda both. i saw code that showed how to make a stored procedure. however this sql statement is only going to be used for this particular insert. but the insert has a field where the user can input all different kinds of characters: ',",/, etc. so looking online everyone said the only...

Hi all. i'm trying to learn how to write paramterized queries. from what i've pieced together on the internet i've made a few efforts. i'm having trouble though and i'm sure it's something i'm not doing right. here is my insert code and parameters i'm trying to enter. i have ms access 2003...

alright i think i got it working. it was a setting issue on my end. this site helped me out to properly set up a user account step by step. http://crunchbang.org/archives/2008/04/17/create-mysql-user-accounts-from-the-command-line/ i was continuously creating user accounts in the improper...

alright thanks again for your help in making sure it was just a parameter issue (pretty much i screwed something up, lol). i'll post again after i talk with mysql and look up their manual. at least that way the final result will be here for someone else if they have a similar problem.

okay i did all of that. i entered in my password at the prompt but it returned host is not allowed to connect to this mysql server. i did all of this through the command prompt on the local machine that has mysql server installed. i'm still tryin to figure out what my user is set up for in...

okay that did something now. my syntax for telnet was (so you can check): microsoft telnet> o maintenanceloft 3306 and it brought this up: z(then some kind of diamond shape)Host 'maintenanceloft.companyname.local' is not allowed to connect to this MySQL server. so i guess this means...

cmd.exe i couldn't ping mysql. used: c:>ping mysql c:>mysqlping neither worked i also tried telnet to open port 3306. error message is: Microsoft Telnet> o 3306 Connecting To 3306. . .Could not open connection to the host, on port 23: Connect failed

i talked to IT and the port 3306 is not blocked and confirmed we are active directory. so i brought up all the ports that were open and listening through command prompt but 3306 isn't listening. it's established but not listening.

oh okay. yeah i did the ping with just my computers name and it pinged fine. as far as i know it's a private network. so we know now its an active directory and that i can ping the computer from a remote source just by using the machine name. i'll check the port with IT here. Following...

okay i did what you said for option number 2. now i'm getting host is not allowed to connect to this mysql server. i put in the full computer name from my computer properties window. it has a domain name with it. is that important? the full name is maintenanceloft.companyname.local and...