Recent content by myasin78

I will try it tomorrow. thanks,

Thanks for reply! I did search MAS90(best software) website and i downloaded the ODBC driver to connect. I got a connection to the database, but even though i provided a username and passwd throught DSN str,i get prompt for MAS 90 database Signon I found someone with the same problem but he is...

Hello All, I wrote a vb app that connects to provideX database through ODBC Conn. I pointed the odbc to the right database path. eg: \\myserver\share\companyA\po.soa I assume *.soa is the database files for ProvideX. I tested my application with Access/ODBC and worked fine. but after I...

here is what i got: "DSN=odbcname ;UID=myuser" as you see there is a lot of space, I did Trim$ on them and got nothing different. I apperciate you help. thanks,

I tried that I got DSN=odbcname thanks, myasin78

Hello All, I am reading ini file to open DB connection. I am having problem generating cnn string to open DB here is some of the code, hope to get some help. Dim dummy As String Dim odbcName As String * 255 Dim user As String * 255 Dim pwd As String * 255 Dim buffer as string * 1024 Dim...

thanks for the code, but I keep getting Compile error: on the line you give me. here is the error. " Constants, fixed-length string, arrays, user-defined types and declare statments are not allowed as public members of object modules " thanks,

Do you know which API I should use for .ini calls thanks,

I forget to do: cnn.open buffer thanks anyway, it is working now.

Hello All, I setup ODBC DSN name to connect to MS Access DB. Public Function OpenDB() As String Dim buffer As String buffer = "DSN=name;UID=;PWD=" OpenDB = buffer End Function Private Sub cmdStart_Click() Dim GetDBConn As String Dim sql As String GetDBConn =...

I wanted to thank you for you help. I finally get it to work. here is my code, in case if someone else needs it. Private Sub cmdftp_Click() txtResult.Text = "Working" txtResult.SelStart = Len(txtResult.Text) With InetFtp .AccessType = icUseDefault .Protocol =...

I added a control Inet (Microsoft Internet Transfer Protocol)and called it inetFtp. this is what defined inetFtp. I am not sure why do i have to defined in my code since its a control. I draged it from the control bar. anyway, i added more code to test the connection, here is my code, it seems...

I have added the inetFtp control. right now i have no errors nor result. I don't know what is the probelm i have put in the test file that i am trying to ftp localy. here is the new code. Option Explicit Private Sub cmdftp_Click() Dim host_name As String Enabled = False...

here is what i got. Error "variable undefined (inetFTP)". I need to declare inetFTP as an ftp object is that correct? thanks for your help.

I assumed it is a predefined object within VB.