mk21 1 Posted August 15, 2013 Report Share Posted August 15, 2013 Unfortunately, no one seems to have developed a way to integrate uBot with SQL Server yet, so I need a way to transfer the results of a SQL Server query directly into either mySQL or SQLite so that I can use uBot to complete my process. Does anyone know of a way to do this, inside or outside of uBot? Quote Link to post Share on other sites
UBotDev 276 Posted August 15, 2013 Report Share Posted August 15, 2013 Well UBot supports mySQL, so you can connect to DB and do anything. Beside that I think Aymen developed a plugin for SQLLite, so you could also connect to that DB from UBot...Here is the link: http://www.ubotstudio.com/forum/index.php?/topic/12960-sell-sqlite-database-plugin/ Quote Link to post Share on other sites
mk21 1 Posted August 15, 2013 Author Report Share Posted August 15, 2013 Thanks for the response, but I guess I wasn't clear enough. I have to use SQL Server to store the data for my business (3rd party software). So what I need to be able to do is communicate between uBot and SQL Server, but I think the only way I'll be able to do so is using either mySQL or SQLite as a bridge somehow. I'm just slightly stumped at the moment as to how to accomplish this. Quote Link to post Share on other sites
LoWrIdErTJ - BotGuru 904 Posted August 15, 2013 Report Share Posted August 15, 2013 I've sent you a message about sql server.. should take care of your issue.. Quote Link to post Share on other sites
mk21 1 Posted August 15, 2013 Author Report Share Posted August 15, 2013 Many, many, many thanks to TJ for helping me out with this. He's my hero of the month at this point, and I don't see anyone giving him much of a challenge. Quote Link to post Share on other sites
LoWrIdErTJ - BotGuru 904 Posted August 15, 2013 Report Share Posted August 15, 2013 lmao, your welcome bud.. Quote Link to post Share on other sites
UBotDev 276 Posted August 16, 2013 Report Share Posted August 16, 2013 Sorry, I've read that wrong...it makes sense now. Quote Link to post Share on other sites
flexfanatic 0 Posted August 16, 2013 Report Share Posted August 16, 2013 Not sure what the solution was for the OP but for those wondering for a way to get data from MySQL to MSSQL you could query this information by setting up a "Linked Server" in SQL Server Management Studio. Quote Link to post Share on other sites
LoWrIdErTJ - BotGuru 904 Posted August 16, 2013 Report Share Posted August 16, 2013 send me a pm if you want to work with remote sql server Quote Link to post Share on other sites
Sanjeev 46 Posted August 17, 2013 Report Share Posted August 17, 2013 I wonder if it is possible to use this tool to shell out commands to sql server?Command Line Utilities 11 for SQL Server: Quote Link to post Share on other sites
flexfanatic 0 Posted August 18, 2013 Report Share Posted August 18, 2013 If Ubot Studio can run commands from a windows command line (CMD.exe) then you could use a batch command that would use T-SQL (connect to MSSQL, run queries, stored procedures, etc). Quote Link to post Share on other sites
Sanjeev 46 Posted August 18, 2013 Report Share Posted August 18, 2013 I may be wrong, but I think We can run batch commands in Ubot - using Ubotdev's advanced shell plugins! And even pass Ubot variables to the application and recieve back the command output and save it to a variable inside of Ubot. Quote Link to post Share on other sites
blumi40 222 Posted August 18, 2013 Report Share Posted August 18, 2013 http://www.sendspace.com/file/f0cnbxFree Plugin !Connects to any kind of Databaseserver even Excell if needet because it use odbc 2 Quote Link to post Share on other sites
Sanjeev 46 Posted August 19, 2013 Report Share Posted August 19, 2013 blumi40!Thanks. Quote Link to post Share on other sites
Sanjeev 46 Posted August 19, 2013 Report Share Posted August 19, 2013 I couldn't find any new databse options in the downloaded plugin...? Quote Link to post Share on other sites
blumi40 222 Posted August 19, 2013 Report Share Posted August 19, 2013 Open DB Command Quote Link to post Share on other sites
Sanjeev 46 Posted August 19, 2013 Report Share Posted August 19, 2013 I downloaded from the link you provided -and re-installed it twice -Open.Framework.dll . File Size: 22.50KBI searched through all the nodes - there is no open db command? Quote Link to post Share on other sites
blumi40 222 Posted August 19, 2013 Report Share Posted August 19, 2013 Quote Link to post Share on other sites
Sanjeev 46 Posted August 19, 2013 Report Share Posted August 19, 2013 Don't see that in my Ubot..... Quote Link to post Share on other sites
pftg4 102 Posted August 19, 2013 Report Share Posted August 19, 2013 not in mine either and i have plugin installed looking at yours arno i'm missing quite a lot maybe post updated .dll ????????? Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.