Hi Magnus,
Try to use parameter for you INSERT statement and declare it as adVarWChar,
which is a Unicode string
Dim loParameter as ADODB.Parameter
Dim locommand as ADODB.Command
......
sSQLStr = "INSERT INTO USERID.MAGNUS_TEST (C1) VALUES (?)"
Set loCommand = New ADODB.Command
Set loCommand.ActiveConnection = conn
loCommand.CommandText = sSQLStr
Set loParameter = loCommand.CreateParameter("Param1", adVarWChar,
adParamInput, 10)
loParameter.Value = sData
loCommand.Parameters.Append loParameter
loCommand.Execute
.......
--
Val Mazur
Microsoft MVP
"Magnus Olofsson" <Magnus XXXX@XXXXX.COM > wrote in
Updating unicode text in Oracle from Excel
1 posts
• Page 1 of 1
- 1. Better way to merge datasets
I'm building a simple db archiving function. Basically, filtering records from a DS based on date and inserting them into an empty archiveDS. using a DataRow[] OldRecs = myDataSet.Tables["OriginalData"].Select("Date < 'somedate' )); work nicely and fast. However putting the records into the archive dataset is slow: ArchiveDataSet.Merge(OldRecs); ArchiveDataSet has the same schema as myDataSet and is empty prior to the merge. Is there a faster way to do this? - 2. DataSet Erroe
Hi I have the bug with the Article ID Article ID : 815119 but the problem is that i have it at run time "sqlDataAdapter1.Fill(dadaSet11)" , while at design time i can fill the dataset from the dataadapter with no problem it gives me the error An unhandled exception of type 'System.ArgumentException' occurred in system.data.dll Additional information: Invalid element value workstation id=IBM;packet size=4096;user id=sa;data source="SVR1\SQLSVR1";persist security info=True;initial catalog=northwind;password="P@ssw0rd". -- Ammar S. Mitoori IT Head QIMCO Co. Tel : +9744831199 Mobile : +9745378400 Fax : +9744831643 - 3. ADO.NET why use multiple tables in a dataset
I'm having a hard time understanding why you would work with more than one table in a dataset. There is a common example where you add the northwind Customers and Orders tables into one dataset and then work with the data with a DataRelation object. Why would you do this when you could just create a stored procedure that joins the 2 tables together and just have 1 table in your dataset? - 4. ADO Query Error 'Path not found'
Newbie to this group, but been doing VB for a long time and ADO in the past 2-3 years off and on. I have a OLE connection that I set up in a UDL file which is on a network share and to which I refer with a UNC Path name, but which connects fine. When I try to Execute a query, however, I get Error 76 'Path not found.' I don't know that I've seen that one before. It's strange, 'cause it doesn't quite make sense to me--what 'path'?? TIA! - 5. Dataform wizard
Hi, I created a new dataform by using the dataform wizard (VB.NET). I delete one or more records and then I close the form and open it again. I add one record but i when i do so I always get a double record. Tx
Next
Re: Updating unicode text in Oracle from Excel
by Val Mazur » Sat, 21 Aug 2004 07:20:25 GMT
Similar Threads:
1.Excel - Paste Special text or Unicode Text
i have two excel files, one that has formulas and one that uses raw values. I need to copy the values from the first sheet to the second one and use Paste Special and Values. However, sometimes the normal Paste Special box does not appear, but another box that says Paste/Paste link with the options of "text" or "Unicode text" appears. Does anyone know what that happens???
2.How to put traditional Chinese text into Unicode Oracle 9i database via Internet Explorer
Hello wisers, We are testing a system which is developed on top of Oracle 9iAS. The client PCs are using Internet Explorer to access the system. We are sure that the Oracle 9i database server is set to use Unicode. The Oracle 9i database server and Oracle 9iAS server are now running on English Windows 2000 server. With client PCs running on traditional Chinese Windows 2000 or traditional Chinese Windows XP, via Internet Explorer we put traditional Chinese text into the system then query the data again, it displays in inverted question marks. 1. How to resolve the problem? 2. Does the Internet Explorer View -> Code Unicode (UTF-8) setting controls content display as well as keyin? 3. Or the system controls the code interpretation of keyin? Thanks, Bruce
1 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 10 guest