Search results for query: *

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...

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...

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

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 =...

Hello all, I am tring to write ftp module that ftps specific direcotry to an ftp server. here is my code: Private Sub cmdftp_Click() Dim host_name As String Enabled = False MousePointer = vbHourglass txtResult.Text = "Working" txtResult.SelStart = Len(txtResult.Text)...

hello all, I am looking to read mysql database and then convert the recoreds int xml format. I can read mysql easily, so right now i am testing flat file "tab delimated file" to import the data into xml format. I am using XML::Simple; here is my code. my $fi = "file.txt"; my $xml =...

I am trying to update DB using ADO Recordset. Rs1.addnew with Rs1 !name = str2field(txtname) end with Rs1.update when i run this code i get function not defined. do you know which library should i load to define this function " str2field". thanks, myasin78

I am trying to insert data into DB using VB. I have connected, test connection, select data, all fine. the only problem is that i can't insert data into the tables. here is some function that might help understand the problem. thanks in advance. 'declartion Public Rs1 As New ADODB.Recordset...

I have two Buttons, one to select next record and one to select previous one. the next record works, but the previous one doesn't. the exact error i get "Operation is not allowed in this context" when i hit debug buttion .MovePrevious gets highlited in yellow which is the problem...

Hello, I am trying to fetch an oracle table using vb app. here is my current code. can someone tell me what i am doing wrong. Private Sub Command1_Click() Dim Rs1 As New ADODB.Recordset Dim buffer As String Dim dbConn As New ADODB.Connection Dim strSql As String buffer =...

Hello All, Below is VB code I am using to open an ODBC connection. I have created a DSN called Patent. when i run this code i get the following error. Compile error: User-defined type not defined the compile high lite the following line which has the error. Set dbConn = New ADODB.Connection...

I am currently working on VB6.0 application that uses MS Jet to connect to Access DB. I need to be modify the code in order to make it talk to ODBC DB in stead, could someone send me a sample code please. this is the current code that i have to modify. Public Function GetDBConn() As String...