Recent content by tatochka

I have a VB6 application that calls Excel to read and write data. It worked absolutely fine on Windows 2000 machine. Now I got Windows XP and every time VB tries to call Excel I get the message "Error -2147417851; Description: Automation error. The server threw an exception." I tried everything...

I have a VB6 application that calls Excel to read and write data. It worked absolutely fine on Windows 2000 machine. Now I got Windows XP and every time VB tries to call Excel I get the message "Error -2147417851; Description: Automation error. The server threw an exception." I tried everything...

Does somebody know if there is any way except CE Query Builder to pull information out of CE database? VB code may be? We need to store information about all our CE reports in another database so we could read it and create reports out of it. We have CE 10.

Yep, that was it. I added the file name and it works. Thanks again.

I get this message when coping or moving file. I tried different kind of files and different directories. Still the same message. Can somebody help? Here is the code: *********************** Dim fso As New FileSystemObject, file1, file2, fldr As Folder Set file1 =...

Thank you very much Sheco for all your help. I changed the code to: ' Open connection. Set cnn = New ADODB.Connection cnn = "......" cnn.Open ' Open recordset Set rsIhdaDoc1 = New ADODB.Recordset rsIhdaDoc1.LockType = adLockOptimistic rsIhdaDoc1.CursorType =...

The user is the owner of the table.

I need to add and delete data in oracle table from VB app. Here is my code: ************************************* Dim cnn As ADODB.Connection Dim rsIhdaDoc1 As ADODB.Recordset Set cnn = New ADODB.Connection cnn = "Provider=MSDAORA;Password=password;User ID=userid;Data Source=test;Persist...

I have 2 Oracle 9i databases. One is test & one is production. I'd like to write a script that will let me to update production table with data from test table. Not all fields have to be updated. Is it possible in one script?

Thank you very much Kurt. I got it working.

I need to export crystal report to fixed length format. None of the suggested formats in Crystal exporting is doing it. Does anybody have an idea?

Yes, the user is a member of sysadmin and securityadmin roles. I don't get an error message from the server when it is running (supposly) sp_addlogin. It just doesn't create a new user. When I try to login with the new user name I get a message, because user was not created under SQL security .

Here is the problem I am having. We have a SQL database on the server. Through VB app I connect to the server (OLE DB) and can create new users for the server (and users database) by running sp_addlogin. It all happens programaticaly in VB. Now we copied the data to another server. Create a...

In case somebody is interested... I called microsoft and all I had to do was register MSSTDFMT.DLL.

It is vb6. SP5 is installed. All windows critical updates are installed.