|
Hi..
How can I create UDL(Universal Data Links)files programmaticaly without invoking the OLEDB Data Link Config Dialog? I already have the string connection used to connect the database. I´m using only ODBC...
Thanks.
|
|
|
|
|
Hi,
in Oracle 8.1.6 I have stored procedure:
MY_PROCEDURE( my_cursor OUT ref_cursor_type, param2 IN NUMBER, param3 IN NUMBER) AS
BEGIN
IF param2 = 0 THEN
OPEN my_cursor FOR
SELECT col1, col2, col3 FROM table1 WHERE some_id<=param3;
ELSE
OPEN my_cursor FOR
SELECT col1, col2, col3 FROM table1 WHERE some_id>param3;
END IF;
END;
When I try this (in MSVC++):
ADODB::_RecordsetPtr pRec;
pRec.CreateInstance(__uuidof(ADODB::Recordset));
pRec->Open( "MY_PROCEDURE(NULL,10,10)", _variant_t((IDispatch*)m_pConnection,true),
ADODB::adOpenForwardOnly, ADODB::adLockReadOnly, ADODB::adCmdUnknown);
while ( !pRec->adoEOF )
{
...do something...
}
pRec->Close();
I can't enter while block because pRec is empty.
I can enter while block only when I use:
pRec->Open( "SELECT col1, col2, col3 FROM table1 WHERE some_id<=10", _variant_t((IDispatch*)m_pConnection,true), ADODB::adOpenForwardOnly, ADODB::adLockReadOnly, ADODB::adCmdUnknown);
Why? Where is the problem?
|
|
|
|
|
|
I am not very familar with Microsoft Access,but it seems that when you encrypt a access file(in menu tool->security),you needn't enter a username.Now the problem come:
In VB6.0,how can i connect to such a encrypted file?By data control,i didn't find any property related to database security;by ADO,the connection string shall contain a username,but what's the username to such a file?I tried leave it empty,but it caused a error 
|
|
|
|
|
I don't know about VB6,I'm VC guy,but in VC I can pass only file name for connection string:
"DataSource=...\\filepath"
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
|
|
|
|
|
in ConnectionString you just tell the filename,but you still pass without "invalid password" error?(that's what i met in my application)
what object of ADO you use? connection or recordset in VC?
|
|
|
|
|
Anonymous wrote:
what object of ADO you use? connection or recordset in VC?
For connectionstring I use Connection object:
hr = m_pConnection.CreateInstance( __uuidof( Connection ) );
if (SUCCEEDED(hr))
{
hr = m_pConnection->Open(
_bstr_t(L"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb;"),
_bstr_t(L""),
_bstr_t(L""),
adModeUnknown);
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
|
|
|
|
|
Do you encrypt with a password?
If so, why not just try "sa,mypwd" in the connection string.
Cheers,
Simon
"I get paid for my brain and my thinking in several obscure worlds", Olli, The Lounge
|
|
|
|
|
Now i have a encrypted file named "db1.mdb" in D:\,and its password,for example,is "codeproject".You mean i shall write like this?
Dim conn As New ADODB.Connection
conn.Provider = "Microsoft.Jet.OLEDB.3.51"
conn.Open "d:\db1.mdb", "sa", "codeproject"
God blessing me...
|
|
|
|
|
Now i have a encrypted file named "db1.mdb" in D:\,and its password,for example,is "codeproject".You mean i shall write like this?
Dim conn As New ADODB.Connection
conn.Provider = "Microsoft.Jet.OLEDB.3.51"
conn.Open "d:\db1.mdb", "sa", "codeproject"
|
|
|
|
|
I need to show a table ( all the table at once) from access database in my Visual basic application.
How I could do it ???
I tried use the Data Form Wizard of VB
But when I fill the Database name- mdb file (by browser) I gets error message :
Unrecognized database format 'myDB.mdb'
|
|
|
|
|
Wow,
Where do I begin, I would suggest getting a book on intro. Visual Basic and make sure that it has ADO database information in one of the chapters. What you are asking is more that just a specific question, but a project. What are you using to display your data? How are you making your connection to the database(ADO, DAO, RDO)? Is there something more specific that you need help with.
This should get you started:
Dim conn as New ADODB.Connection
Dim adors as New ADODB.Recordset
Dim sql as String
sql = "Select * from [YourTableNameHere]"
conn.ConnectionString = [YourConnectionStringHere]
conn.Open
adors.ActiveConnection = conn
adors.Open(sql)
I'm not sure if this helps or not, but I don't think I am fully clear as to your problem.
Nick Parker
|
|
|
|
|
Inside a DTS package I need to execute a self-extracting zip file. I am currently using CreateObject("WScript.Shell") which works when run in VB or executing the DTS package directly. However when a job is used to execute this package the extracted file gets placed to an undetermined directory. So my questions are:
Why does the extracted file get placed in the correct directory when I execute the code and not when a scheduled job runs it?
What can I do to get the scheduled job to extract the file to the correct directory?
I’m stumped on this one any help is greatly appreciated.
Jason W.
|
|
|
|
|
Is there any way SQL server,oracle can talk to each other,perhaps XMl can fit here but how do you pass data generated by oracle in XML to sql server.
Thank you for spending time.
Vineet
|
|
|
|
|
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.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
