Search results for query: *

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.

Every time I close an VB development environment I get the message "The instruction at 0x004581f1 referenced memory at 0x00000000. The memory could not be read. Clik OK to terminate the program. Click Cancel to debug the program." I created a test project with just a form and one...

Does somebody know how to make Datetime Picker control to display nothing instead of Current date as a default value?

The problem was MDAC, has to be updated to the latest version.

The server name is correct (I can even ping it from DOS). "Client Network Utility" and "Server Network Utility" both have Named pipes first in the list. I don't know much about network so I don't know what else to check.

The server name (and IP) is in the host file. I am trying to connect from dif computers with dif operating system. When hit on Test Connection button the exact message is "Test connection failed because of an error i initialization provider. [DBNETLIB][ConnectionOpen (Connect().\SQL...