Can't connect to Database

Support for iMacros. The iMacros software is the unique solution for automating every activity inside a web browser, for data extraction and web testing.

Moderators: Community Moderators, iMacros Moderators

Forum rules
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the Google search box (at the top of each forum page) to see if a similar problem or question has already been addressed. This will search the entire contents of the forums as well as the iMacros Wiki.
3. We can respond much faster to your posts if you include the following information:

CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST

Answering your own posts (e.g. attempting to "bump" your topic) drops your topic from the list of unanswered threads, so it may actually receive less views.

Can't connect to Database

by piez0rz on Fri Dec 23, 2011 1:07 am

Hi,

I'm quite new to iMacros. I have been trying to use http://wiki.imacros.net/Database-2-Web.vbs.

From my understanding, this should work as long as I use:

Code: Select all
connstring = "Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;"

instead of:

Code: Select all
connstring = "driver={SQL Server};server=<SQLServerNameHere>;uid=<SQLUserIDHere>;pwd=<SQLPasswordHere>;database=databaseNameHere>"



However, I'm getting the following error: "[Microsoft][ODBC5.1 Driver] Access denied for user '----'@'------'(using password: YES)"

Is there something that I'm doing wrong here? What could cause this error and what are some of the possible solutions?
piez0rz
 
Posts: 2
Joined: Fri Dec 23, 2011 12:27 am

Re: Can't connect to Database

by tennisdude on Mon Mar 20, 2017 4:59 pm

I've been trying for days and haven't got the sample scripts to to work. Did you get get it to work in the end?
tennisdude
 
Posts: 7
Joined: Mon Jan 30, 2017 2:48 pm


Return to General Support & Discussions

Who is online

Users browsing this forum: No registered users and 5 guests

-->