Couple of questions really
Posted on 2003-12-11
I have two questions really.
1. I have a modual that connects to a access database at present but I want to change this to connect to SQL SERVER 2000. Also what refrences would I need to add to the project?
Here is the code:
Public dbConn As Connection
Public recSet As ADODB.Recordset
Public Function DBConnect() As Boolean
On Error GoTo OpenErr
'Connects to Database
Set dbConn = New Connection
dbConn.CursorLocation = adUseClient
dbConn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = " & App.Path & "\Test.mdb;"
DBConnect = True
MsgBox "Error Opening " & MSDatabase & vbNewLine & Err.Description, vbCritical, "Open Database Error"
DBConnect = False
Also can anyone give me any ideas on what software I need to code a project for pocket PC also can this be coded in the vb langauge or another langauge?