Visual Basic

access password protected database connection string

28-Jan-07 8:59

They are generally passed as a string array to your program's entry point, although it wouldn't surprise me to find they are also a property of the Application object.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

pankajgarg1228-Jan-07 1:07

pankajgarg12

28-Jan-07 1:07

Sir/madam,
I am using access database.I have applied password to the database.Now , I wanted to make the connection string.Presently , i am using the .udl file to make the connection string and in the udl file , in the case of choosing the provider, i am using Microsoft Jet 4.0 OLE DB Provider.and after then i am comming to the connection tab.There i am facing the following error after typing the password and clicking the test connection button.

Test connection failed because of an error in initializing the provider.Cannot start ur application.The workgroup information file is mising or opened exclusively by another user.

But , I have closed the database and even i have restarted my machine.But i am encountering the same problem.
Please help in making the connection string when i have applied the password.
Thanks and Regards
Pankaj

Re: access password protected database connection string

Guffa28-Jan-07 1:25

Guffa

28-Jan-07 1:25

I didn't really read all of your post, it really get tiresome when you make every other word bold, but here is page where you can see examples of connection strings:

www.connectionstrings.com[^]

---
Year happy = new Year(2007);

Re: access password protected database connection string

jaakinye28-Jan-07 9:34

jaakinye

28-Jan-07 9:34

Try to create user's account with the password you are using for connection string

jaakinye

autogenerate column in datagridview in vb.net 2005

pankajgarg1228-Jan-07 0:40

pankajgarg12

28-Jan-07 0:40

Sir/Madam,
I have a table , having two fields , first for name and second for roll number.I don't have serial number field in that table.Can , I display Serial number field in the datagridview , with those two fields.
I mean if i have ten records in the table. Then datagrid should display record no for each row, like for first row it should display 1 , and for second row , there should display 2 and so on.This should happen in the extra column in the datagridview.Is it possible.
Please help.
Thanks and regards
Pankaj

Re: autogenerate column in datagridview in vb.net 2005

coolestCoder28-Jan-07 2:22

coolestCoder

28-Jan-07 2:22

Hi,
You can use sql query in this case. If your current sql query is -

select name,rollno from students

Then modify the query as -

select 0 as [Serial No.],name, rollno from students.

This modified query will generate a column named Serial No. whoes rows will be filled by 0. Then in the program use a counter to count the rows, in the RowDataBound event handler. Replace the text in column 0 with the counter value. You will get your desired resutls.

Hope i am clear enough.

I am assuming that you are using SQL Server as database.

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

coolestCoder

crystal reports using vb.net 2005

pankajgarg1228-Jan-07 0:34

pankajgarg12

28-Jan-07 0:34

Sir/madam,
I am facing problem in the crystal reports.Now , Suppose I have 20 records into the database(each record contain one field for name).I am able to display them in the reports in the vertical order , to get the print outs .But the problem is , I am not able to display these 20 records in two column.Two columns means , First column has ten records and second column has 10 records.Actually , the purpose of using two columns is , I want to save the page . I want to put the names on the envelope , after getting the print out , I will cut those names from page and finally will be pasted on the envelope.Is there any option to do this task.Hope , I am trying to make u understand my problem.
Please help.
Thanks and regards
Pankaj

eventscheduler

Doritkatz27-Jan-07 23:56

Doritkatz

27-Jan-07 23:56

Hi
I need to conver c# project to vb.net
from
http://www.codeproject.com/csharp/eventscheduler.asp[^]
I did it for the class library (by using a translator )
now I need to implement the code and I can't do it

Schedule s = new IntervalSchedule("Test_Interval", DateTime.Now.AddMinutes(10), 45, TimeSpan.Zero, new TimeSpan(TimeSpan.TicksPerDay));<br />
			s.OnTrigger += new EventScheduler.Invoke(ScheduleCallBack);<br />
			Scheduler.AddSchedule(s);

I wrote

MessageBox.Show("Test will now create Interval schedule")<br />
           Dim s As New ES.IntervalSchedule("Test_Interval", DateTime.Now.AddMinutes(1), 45, TimeSpan.Zero, New TimeSpan(TimeSpan.TicksPerDay))<br />

and it's won't work with s.ontrigger.....

What can I do

How to display a grid on form in vb 2005

Mekong River27-Jan-07 23:54

Mekong River

27-Jan-07 23:54

Hi, in windows form designer in vs 2005 pro, how to display a grid (a small dot) on the form like vb.net 2003?

Registration Free COM with VS 2003

Atara27-Jan-07 23:34

27-Jan-07 23:34

I recently learned that on XP (and later) OS, you do not need to register activeX, if you use "isolated" option from vs 2005 menu to create a special manifest file.

Does anyone know how can I make the required manifest lines if I only have VS 2003 ?

Thanks,

Atara

Christian Graus28-Jan-07 0:24

28-Jan-07 0:24

VS2003 doesn't create manifest files. I also don't see how a COM dll can work without being registered, unless the manifest contains the GUIDs and so on, and everything has to be in the same directory.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Atara28-Jan-07 1:03

28-Jan-07 1:03

The manifest should contain clsid.

This technologie (COM dll can work without being registered) should work on XP sp2, and Vista. according to the documentation it should work on .Net 1.1

but I can not find the exact format of the needed manifest file Frown | :(

more about this "Reg Free COM" technologie in -
http://msdn.microsoft.com/msdnmag/issues/05/04/RegFreeCOM/[^]

Atara

Atara31-Jan-07 2:42

31-Jan-07 2:42

I solved it with the help of:

(1) Escape DLL Hell - Simplify App Deployment with ClickOnce and Registration-Free COM
(VS 2005 Article)
http://msdn.microsoft.com/msdnmag/issues/05/04/RegFreeCOM/

(2) Registration-Free Activation of COM Components: A Walkthrough
(VS 2003 Article)
http://msdn2.microsoft.com/en-us/library/ms973913.aspx

(3) oleView.exe
C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\Tools\oleView.exe (or . . . \Tools\Bin)
oleView.exe: File->View TypeLib

The solution:

1. The main manifest (myProg.exe.manifest):

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0">
<assemblyIdentity
type = "win32"
name = "myProg"
version = "1.0.0.0" />
<dependency>
<dependentAssembly>
<assemblyIdentity
type="win32"
name="myAxFile.X"
version="1.0.0.0" />
</dependentAssembly>
</dependency>
<dependency>... more files ...</dependency>
</assembly>

2. The myAxFileN manifest (myAxFileN.X.manifest):

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0">
<assemblyIdentity
type="win32"
name="myAxFileN.X"
version="1.0.0.0" />
<file name = "myAxFile.ocx">
<comClass
clsid="{...clsid...}"
threadingModel = "Apartment" />
<typelib tlbid="{...tlbid...}"
version="1.0" helpdir=""/>
</file>
<comInterfaceExternalProxyStub
name="myAxName"
iid="{...iid...}"
proxyStubClsid32="{00020424-0000-0000-C000-000000000046}"
baseInterface="{00000000-0000-0000-C000-000000000046}"
tlbid = "{...tlbid...}" />
</assembly>
The id are taken from oleView.exe: File->View TypeLib generated file.

I hope it will help you to start digging your specific needs.

Atara

Atara4-Feb-07 23:11

4-Feb-07 23:11

or, you can use only one manifest file, e.g:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0" >

<assemblyIdentity type="win32" name="myProg.exe" version="1.0.0.0" />

<file name="file1.ocx">
<typelib tlbid="{...}" version="1.0" helpdir="" />
<comClass clsid="{...}" tlbid="{...}" threadingModel="Apartment" />
</file>

<file name="file2.ocx">
...
</file>

</assembly>

Note: all *.ocx, *.dll files of the activeX should also be in the same folder, with the manifest and the exe files.

Atara

VBS File

Mohammad Daba'an27-Jan-07 20:30

27-Jan-07 20:30

:->Hello all,

I want to make a vbs file that will take some data and then will redirect me to a nwe web page with the entered data as a query string,

is there any one can help me or have a ready done vbs file Blush | :O

Thanks alot
Hamody

Christian Graus27-Jan-07 20:41

27-Jan-07 20:41

What is a VBS file ? Do you mean a script for classic ASP, using VBScript ? I heartily recommend you use ASP.NET, unless you hate yourself. Having said that, the web development forum is for ASP questions.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Mohammad Daba'an27-Jan-07 21:04

27-Jan-07 21:04

yeah i mean visual basic script file,

i want to make it as a sparated file without using visual stuodio.net

for example;
make a new text file ane write the following lines inside it:

Dim m
MsgBox "You must enter a quantity."

and then save it as ddd.vbs, then double click on it, u will see its action.

i want to make a one as this but for the purpose that i asked in my sent question Cry | :((

Thanks alot
Hamody

Christian Graus27-Jan-07 21:47

27-Jan-07 21:47

Well, how is this script going to be run via a web site, if it's just sitting at a random place on your hard drive ? Why does it matter than you use or don't use VS ?

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Mohammad Daba'an27-Jan-07 22:06

27-Jan-07 22:06

hellllllo,

i want to make a separate vbs file, i cannt use vs.net to run t through vs.net or i dont want to run it under html document.

please man, if u know how i can call a web page through the vbs file send t to me

Thanks alot
Hamody

Christian Graus27-Jan-07 23:06

27-Jan-07 23:06

Mohammad Daba'an wrote:
i want to make a separate vbs file,

OK - this file is never going to run under .NET. It doesn't matter what you use to edit it.

Mohammad Daba'an wrote:
i dont want to run it under html document.

OK, then where does the query string magically come from when you run this file. When you double click on it, how does it relate to a URL at all ?

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Mohammad Daba'an27-Jan-07 23:11

27-Jan-07 23:11

Dear There,

ok, for the editting, I will use notepad to write the vbs file,

i just need now the code that i can use to call a url, eg, www.yahoo.com
by running this vbs file Confused | :confused:

Thanks alot
Hamody

Christian Graus27-Jan-07 23:23

27-Jan-07 23:23

Oh, I see. You just want to launch a URL, and create a query string. I thought you wanted to process one.

I'm not sure, but I know that in C++ and C#, the code to run a program will run the default browser and open a URL, if you pass it a URL.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Mohammad Daba'an27-Jan-07 23:32

27-Jan-07 23:32

ok dear, u now understand 80% of what i want,

in asp.net when i want to go to another page i put (response.redirect("........"))

i want to know what is the code to open a url when i click on button for example in using vbs,

i willnt use asp.net, the example i sent u is on vbs, i will make a vbs file that when i open it it will appear an input box inside it and it has 2 button, ok and cancel, when i fill the url and press ok it will open an IE page and display the url i entered.

i want the code that will call the entered url, hope u understand me now Poke tongue | ;-P

Thanks alot
Hamody

Christian Graus28-Jan-07 0:23

28-Jan-07 0:23

Yep, I understand. We've been discussing this for 4 hours. It took me 30 seconds to find how to open a web page with VBS, via a simple google search

set Window = CreateObject("InternetExplorer.Application")

Window.RegisterAsBrowser = True
Window.Navigate("www.microsoft.com")
Window.MenuBar = True
Window.ToolBar = True
Window.AddressBar = True
Window.StatusBar = True
Window.FullScreen = False
Window.Resizable = True
Window.Visible = True
Window.Width = 850
Window.Height = 720

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Mohammad Daba'an28-Jan-07 0:48