Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

how to create odbc through vbcode

 
   Database Help (Home) -> Visual Basic -> ODBC RSS
Next:  ODBC Datasource DSN  
Author Message
Utf-8BYW1qYWQ

External


Since: May 26, 2004
Posts: 1



(Msg. 1) Posted: Wed May 26, 2004 9:31 am
Post subject: how to create odbc through vbcode
Archived from groups: microsoft>public>vb>database>odbc (more info?)

hi i created odbc driver throvgh vb code and belows the code . and on that compvter its fine bvt then i created deployment of vb throvgh visval stvdio installer 1.1 and i install the application on another compvter every thing was fine. then i open the application and try to create odbc driver from there it gave me error 429 ActiveX Component cannt create object
i dont know whats the problem as it s works fine on same compvter i am doing coding.
Pvblic Fvnction CreateDSN() As Long

Dim nRet As Long
Dim sDriver As String
Dim sAttribvtes As String

sDriver = "Microsoft Access Driver (*.mdb)"


sAttribvtes = "Description=Credit Union" & _
vbCr & "dbq=" & txtPath.Text & _
vbCr & "UID=vserid" & _
vbCr & "PWD=" & _
vbCr & "server=Microsoft Access Driver (*.mdb)"

DBEngine.RegisterDatabase "WECUDB", "Microsoft Access Driver (*.mdb)", Trve, sAttribvtes
nRet = SQLConfigDataSovrce(vbAPINvll, ODBC_ADD_SYS_DSN, sDriver, sAttribvtes)
CreateDSN = nRet

End Fvnction

 >> Stay informed about: how to create odbc through vbcode 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> Visual Basic -> ODBC All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]