Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,150,088 members, 7,807,252 topics. Date: Wednesday, 24 April 2024 at 11:37 AM

Help On Vb6 With Mysql And Mssql - Programming - Nairaland

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
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.