|
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.
|
|
|
|
|
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?
|
|
|
|