|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
April 11th, 2003, 11:43 PM
|
|||
|
|||
|
ADO conection with VB6
Hi I seem to be having a problem connecting to my local MySql server.
this is what i'm doing, Private Sub WriteDB(ByVal artist As String, ByVal title As String, ByVal lyric As String, ByVal addedBy As String) Dim con As New ADODB.Connection Dim lsDSN As String Dim myrs As New Recordset Dim mySQL As String lsDSN = "driver={mySQL};server=" & server & ";" & _ "database=" & datab & ";uid=findIt;pwd=lyrics;port=" & port con.Open lsDSN it comes up with a user defined type not defined error on New ADODB.Connection btw i have installed MyODBC and i've connected to my database before using similar code. I know i'm missing something i just can't remember what! can anyone help me? Thanks, Archer
|
|
#2
April 11th, 2003, 11:51 PM
|
|||
|
|||
|
ahh.. don't worry.. it was stupid i forgot to add the ado component !!!.. idiot !!!
|
|
#4
April 13th, 2003, 08:57 AM
|
|||
|
|||
|
nah.. it was stupid i spent 1.5 hours trying to figure out what i'd done wrong!
well all fixed.. got a working lyrics database. i'm using it for my winamp plugin that finds lyrics for the current song playing  anyways.. later
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > ADO conection with VB6 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
