|
If you create an XML file from the data in Oracle, you could then create a DTS package in SQL Server to import the data in.
Nick Parker
|
|
|
|
|
I tried text and memo and it doesn't work
please HELP !!!!!
|
|
|
|
|
Do you use visual c++? I can remember that if you use CString for those fields it was ok.
Mazy
"The path you tread is narrow and the drop is shear and very high,
The ravens all are watching from a vantage point near by,
Apprehension creeping like a choo-train uo your spine,
Will the tightrope reach the end;will the final cuplet rhyme?"Cymbaline-Pink Floyd
|
|
|
|
|
Another question,If you use VC what do use to connect to database and manage it?
Mazy
"The path you tread is narrow and the drop is shear and very high,
The ravens all are watching from a vantage point near by,
Apprehension creeping like a choo-train uo your spine,
Will the tightrope reach the end;will the final cuplet rhyme?"Cymbaline-Pink Floyd
|
|
|
|
|
|
Sorry,I'm VC guy not VB.When you ask question here I suggest you clarify it.Tell what code you use or another things. I hope another people help you. 
Mazy
"The path you tread is narrow and the drop is shear and very high,
The ravens all are watching from a vantage point near by,
Apprehension creeping like a choo-train uo your spine,
Will the tightrope reach the end;will the final cuplet rhyme?"Cymbaline-Pink Floyd
|
|
|
|
|
I want put array of 400 byte into a field in Access Table from my VB code .
How ???
|
|
|
|
|
I wrote some custom software for my local school board, and generally have just been manually installing the files for them, and setting up things on my own. The program needs to access a MS Access Database (Using DAO), and generally speaking it gets the job done.
However, now that I have tweaked polished and got out all the minor bugs of the program and would now consider it "final" (they have been using it for a month now w/o any major issues), and would like to make an installation program for them so they can have it on CD/whatever and if for whatever reason, they need to re-install it will install and run just fine.
However, when it comes to the database stuff, I am not sure what other things (beyond my program/dll's itself) I'd need to include. The thing that got me thinking, is the other day they upgraded from win98 to win2k, and my program started to crash on them when they attempted to open the database, I ended up popping in the VC CD and simply installing the data access components and nothing else, and that fixed the problem. However, what would I need to re-distrbute along with my program to avoid that problem?
Every time they need to re-install the program for whatever reason, I dont have to want to run over and tweak things for them, and would be nice if I had a nice simple installation program that took care of all those things for them.
|
|
|
|
|
Hi!
I have a mdb database in a server named \\netbackup (MSVC++ , MFC DAO program). The problem is that:
I can't run the program unless I have entered the server with my password in advance. I must do that in the code. I mean enter the password. Becouse the users can not have the password. How can I put the password entery in the code.
|
|
|
|
|
ergin wrote:
I can't run the program unless I have entered the server with my password in advance. I must do that in the code.
I think you can also solve it with your IIS too.Go there and change the security of your project.
Mazy
"The path you tread is narrow and the drop is shear and very high,
The ravens all are watching from a vantage point near by,
Apprehension creeping like a choo-train uo your spine,
Will the tightrope reach the end;will the final cuplet rhyme?"Cymbaline-Pink Floyd
|
|
|
|
|
I can open in VB.NET ADODB.Stream using Open() without parameters but I can’t do that in C# using Open() with or without parameters. Is this relates to SP1 or SP2?
Imports System.Web.Services
Imports system.Xml
Imports System.Configuration
Imports ADODB
Imports MSXML2
Imports System.Reflection.Missing
' Read the foramtted XML into the Stream
Stream = New ADODB.Stream()
Stream.Open() 'it works
Stream.WriteText(orderXML)
Stream.Position = 0
‘------------------------C#---------------------
ADODB.Stream Stream = new ADODB.Stream();
Stream.Open(); // compilation error (case 1)
Stream.Open("",ADODB.ConnectModeEnum.adModeUnknown,ADODB.StreamOpenOptionsEnum.adOpenStreamUnspecified,"",""); // runtime exception (case2)
//I tried another way to invoke Open()
Object[] p=new Object[5] ;
p[0] = Missing.Value;
Stream.GetType().GetMethod("Open").Invoke(Stream,p); //the same exception as in case2.
|
|
|
|
|
Cannot figure out how to process BLOBS in parts via ODBC - i.e. how to get part of a BLOB into program variable and/or update it in place.
Is it possible at all?
Could anyone provide any comments on which ODBC functions to use?
Some examples would be very nice too.
Thanks.
|
|
|
|
|
|
Hello
I need to get Alert_SID.log file from my client application for parsing.
Can I make this (getting this file) via SQL Query (via ADO Connection to Oracle server) or other Oracle 8 services, without any additionaly services (non Oracle) for transfer this log file from Oracle server host to client host.
Thanks
Ernst Maurer
|
|
|
|
|
When I convert my DataSet to an XMLDataDocument, the XML result looks something like this:
<NewDataSet>
<Table>
<ID>123</ID>
<Name>Bob</Name>
</Table>
</NewDataSet>
How do I specify what the tagnames should be of the root and row elements? I would like my result to be something like this:
<Employees>
<Employee>
<ID>123</ID>
<Name>Bob</Name>
</Employee>
</Employees>
Is the only way to do this by first reading an XML schema into the DataSet? If so, is there a way to write the schema in such a way that only the root and row elements are renamed, but the column elements are processed as is?
|
|
|
|
|
I'm just hazarding a guess here, but couldn't you set the DataSetName and DataTableName properties of your data structure/object.
some semi-pseudocode
dsEmployees.DataSetName = "Employees"
dsEmployees.Tables[0].DataTableName = "Employee"
Or I could be spouting a load of bull
Bruce Duncan CP#9088, CPUA 0xA1EE, Sonork 100.10030
Hi everyone. My name's Bruce. And I suffer from VB.
|
|
|
|
|
It works (except that it's TableName instead of DataTableName). Thanks!
|
|
|
|
|
I have to make a website on a win2000 server with ASP.NET. This website has to retrieve data from a db2 database on a linux server. Can someone tell me if this is possible and how I should do it?
ASP.NET is not a problem, but I have never worked with db2 and linux before.
Ludwig
|
|
|
|
|
I'm using the OLEDB consumer templates and VC6.
Is there a way I can get a rowset of data from the database, disconnect from the database, and then work with the data in a disconnected scenario.
Like disconnected ADO recordsets, but using plain vanilla OLEDB.
I've searched all over google(groups) and come up empty, plenty of similar questions to mine, but no useful answers (if any).
Bruce Duncan CP#9088, CPUA 0xA1EE, Sonork 100.10030
Hi everyone. My name's Bruce. And I suffer from VB.
|
|
|
|
|
I don't know if it exists in OLEDB or not(I think it does).Use adUseClient for your cursor type.
Mazy
"The path you tread is narrow and the drop is shear and very high,
The ravens all are watching from a vantage point near by,
Apprehension creeping like a choo-train uo your spine,
Will the tightrope reach the end;will the final cuplet rhyme?"Cymbaline-Pink Floyd
|
|
|
|
|
Is it possible adding a db user by script like creating a db by script etc...
Thanks
|
|
|
|
|
I have written a DTS package that when run can takes a considerable amount of time to complete. I have found the problem areas within the package where a mass delete is taking place. Since I am unaware of future dataset sizes it will be deleting, is it possible to have my ActiveX script only increase the connection timeout period when it would typically timeout under the default time period. Or would it be considered ok to just increase the timeout period regardless of the dataset size? Thanks.
Nick Parker
|
|
|
|
|
Well , I wrote a little app in VB that queries a table. I used DAO.I created a SQL generator that builds up a statement. But somehow only if I use * instead of % it works. For example , if i execute
select * from Phonebook where Firstname like 'M*'
I will get the appropriate records beginning with M. but if i write:
select * from Phonebook where Firstname like 'M%'
than all i get is an empty recordset! Why is that?! i remember that i used % before and it worked just fine. maybe someone knows what is the problem? thx!
|
|
|
|
|
% is standard SQL, however Access (and thus DAO) uses *.
I got bit by the opposite problem when I made the transition from DAO to ADO/SQL Server
James
Sonork: Hasaki
"I left there in the morning
with their God tucked underneath my arm
their half-assed smiles and the book of rules.
So I asked this God a question
and by way of firm reply,
He said - I'm not the kind you have to wind up on Sundays."
"Wind Up" from Aqualung, Jethro Tull 1971
|
|
|
|
|
Ahh thanks. And what about ADO ? Does it work with % or must use * too ?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
