Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,150,088 members, 7,807,252 topics. Date: Wednesday, 24 April 2024 at 11:37 AM |
Nairaland Forum / Science/Technology / Programming / Help On Vb6 With Mysql And Mssql (1068 Views)
Generating Crystal Report With MYSQL Database For A VB.NET Application / Genrating Crystal Report With Mysql Database In A Vb.net Application / Login Code In Vb6.0 (2) (3) (4)
(1) (Reply)
Help On Vb6 With Mysql And Mssql by tolubonnke: 4:09am On Nov 20, 2009 |
i have been sending this request for some time now but i've really not got any reply. i use access for my vb right from time and i need some one to bring me up on using mysql and microsoft sql/ the most difficult part has been the connection with vb6 and making it work on networking pls help me i am counting on u guys. a simple application as an illustration will be very alright. thanks. |
Re: Help On Vb6 With Mysql And Mssql by tolubonnke: 4:11am On Nov 20, 2009 |
i hope you people will help me soon |
Re: Help On Vb6 With Mysql And Mssql by olutope200: 5:28pm On Nov 20, 2009 |
Using ADODB dim cn as new adodb.connection dim rs as new adodb.recordset Sub ConnectToSQLDatabase() cn.connctionstring="Provider=SQLOLEDB.1;Password=mypassword;Persist Security Info=True;User ID=username;Initial Catalog=mydatabase;Data Source=MyServer" cn.open End Sub change mypassword to the SQL database password username to SQL database username myserver to SQL server instance name mydatabase to SQL database name Call me if u need further assistance - 08036774862 |
(1) (Reply)
Scratch Card As A General Programming Tool / Great Minds Needed / A Programmer's Personal Blog~~ Questions?
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 6 |