Database Discussion Boards

Re: Parameters in access connection

MalikRizwan19-Dec-05 17:44

MalikRizwan

19-Dec-05 17:44

Ofcourse you can use that !

R A M

Re: Parameters in access connection

MyNothing19-Dec-05 19:47

MyNothing

19-Dec-05 19:47

string strConnect = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyNothing.MDB;Jet OLEDB:Database Password =MyNothing;"

Re: Parameters in access connection

Sasuko19-Dec-05 23:33

Sasuko

19-Dec-05 23:33

sorry i mean connect to a password protected .mdb, but avoid to specified in the connection string the password used.
In SQL server i can do it but in .mdb access?

Re: Parameters in access connection

MalikRizwan20-Dec-05 1:29

MalikRizwan

20-Dec-05 1:29

Sasuki,
Infact you have to populate the Password screen yourself in Access you can use this
string strConnect = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyNothing.MDB;Jet OLEDB:Database Password =" & Text1.Text & ";"

OR
string strConnect = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyNothing.MDB;Jet OLEDB:Database Password =" & InputBox$("Enter password") & ";"

R A M

eVC++ 4.0 to SQL Server 2000

rbrad1234519-Dec-05 6:58

rbrad12345

19-Dec-05 6:58

I've recently completed a Pocket PC application in VB.NET that works with connections to a local SQL Server 2000 CE DB and a SQL Server 2000.

I'd like to look at doing the same thing using eMbedded Visual C++ 4.0 and OLE DB for a CE.NET device. While there are plenty of resources for SQL CE I can't find any for SQL Server 2000.

Does anyone know of a good sample for eVC++ that hits both SQL CE and SQL Server? No ActiveSync and no IIS for this solution thus RDA and Merge Repl are of no value.

Any input is much appreciated!

Do SQL Server Views take Parameters???

code-frog19-Dec-05 6:52

code-frog

19-Dec-05 6:52

Can SQL Server views be constructed to take parameters?

Some assembly required.

Code-frog System Architects, Inc.

Re: Do SQL Server Views take Parameters???

Chris Meech19-Dec-05 8:59

Chris Meech

19-Dec-05 8:59

The short answer is no. But this link[^] says it much better. Smile | :)

Chris Meech

I am Canadian. [heard in a local bar]

Remember that in Texas, Gun Control is hitting what you aim at. [Richard Stringer]

Nice sig! [Tim Deveaux on Matt Newman's sig with a quote from me]

Re: Do SQL Server Views take Parameters???

rmhewa20-Dec-05 20:20

rmhewa

20-Dec-05 20:20

As far as I know you cant pass parameters to a view. As an alternative what you can do is create a user defined function in sql server (2000 and later) where you can pass parameters to the function,do what ever the process or selections you want and then return a table from the function.

Rohitha M.Hewa
Senior IT Executive
Naturub Group of Companies - Sri Lanka

WIndows CE SQL

SpeBeeTo19-Dec-05 4:25

SpeBeeTo

19-Dec-05 4:25

I am using .NET C# to program a database program. I am modifying a program that already exists, and it creates an "SDF" file on my Pocket PC. Be warned, I am a very big newbie, and I've been trying to read up on this question, but it seems the more I read, the less I am understanding it all. Sigh | :sigh:

I have tried to install and use Microsoft Server 2000 (with Server CE), but I keep getting error messages 1069 and no matter waht I do, it doesn't seem to help.

So I was wondering if I could use a MySQL database for this program?

Furthermore, I have the database (with images/blobs) currently in MS-Access format, which was made on my PC. This is the database I would like to have on my PocketPC (I don't want to be able to edit it or anything. Just show it, with the pictures that go with the ID #.)

Thanks so much everyone. I'm really getting confused about this all.

ADO/ADOX Problem

karnav zaveri19-Dec-05 0:33

karnav zaveri

19-Dec-05 0:33

Hi,

I want to create dynamic Microsoft Access Jet 4.0 database ( *.mdb) files and database schema ( tables (Data Definition Language ) ) using ADO connectivity.

For that I have come up with the solution to use ADOX technology which provides database and schema creation facility, for Microsoft Access Database.

So I want to know the latest version msadox.dll file thru which ADOX can be used to access database.

And also write feasibility of using ADOX technology instead of ADO technology.

Please be hurry...........
Its urgent....

Thanks and Regards,
Karnav

Thanks and Regards
Karnav Zaveri,
Prodcut Development Engineer,
Amtel Security Systems.

Copy Table Problem

tadhg8819-Dec-05 0:00

tadhg88

19-Dec-05 0:00

Hi I am developing and web app for my final year in college but I am having problems trying to keep my 2 databases up-to-date (one in college and the other at home) I’m just wondering if there is anyway to copy a single table from the college db to the home including the table design and data etc. So I’m just wondering if anyone has any ideas of how I would go about doing this
Thanks in advance
Tim

Re: Copy Table Problem

albCode19-Dec-05 4:35

albCode

19-Dec-05 4:35

try to BackUp DataBase then in ur PC call it by Restore
hope helps???

Re: Copy Table Problem

tadhg8819-Dec-05 6:08

tadhg88

19-Dec-05 6:08

no i need to copy one tables data from one database to another not the whole database

Re: Copy Table Problem

Chris Meech19-Dec-05 9:04

Chris Meech

19-Dec-05 9:04

If it is just data, then you should be able to use some kind of Unload/Load utility for your database to do this. Additionally most databases also have some kind of Export/Import utility that will also include the the table design info that you are after.

Chris Meech

I am Canadian. [heard in a local bar]

Remember that in Texas, Gun Control is hitting what you aim at. [Richard Stringer]

Nice sig! [Tim Deveaux on Matt Newman's sig with a quote from me]

insert into mulitiple tables???

WetRivrRat18-Dec-05 9:31

WetRivrRat

18-Dec-05 9:31

Hey folks,
i've run into a sort of brick wall this weekend, and can't find much that will work....here's the issue.
i need to do an insert into 2 tables, for an invetory control app,
I know this query is wrong, its just a description of what i want to do...

Insert into PC (PC_Service, PC_Serial, mon.mon_name, PC_Model, PC_Name, PC_Loc, PC_IP) <br />
values(1, 'SerialNujmber','SerialNujmber', 'Model1', 'deviceName', 1, '192.168.0.1') <br />
select *<br />
from mon inner join pc<br />
	on pc.pc_id = mon.mon_to_pc <br />
where <br />
pc.pc_serial = '123456789'

"Insert into Mon ( Mon_loc, Mon_Serial, Mon_serial2, mon_service, mon_to_pc) <br />
values ('1', 'KR-032DVX-47602-19Q-ABKQ', 'kermit the frog', '1', (select PC_ID from PC where pc_serial = 'fasdf'))"

the first is the overall desire...the second is my last resort..

Any ideas will be helpful

thank!!!

string Beautiful;
Beautiful = "ignorant";
label1.Text = "The world is full of " + Beautiful +" people.";

Why is common sense such an un-common comodity?

Re: insert into mulitiple tables???

Luis Alonso Ramos18-Dec-05 10:42

Luis Alonso Ramos

18-Dec-05 10:42

You could do something like this:

INSERT INTO Mon (Mon_loc, Mon_Serial, Mon_serial2, mon_service, mon_to_pc)
    (SELECT '1', 'KR-032DVX-47602-19Q-ABKQ', 'kermit the frog', '1', PC_ID
         FROM PC where pc_serial = 'fasdf')

Or if you are using a stored procedure, get the PC_ID into a variable, and use it in the INSERT. The above query will insert multiple records if the SELECT PC_ID FROM PC happens to return multiple records, although by looking at the name of the fields, I wouldn't think so for this particular case.

I hope this helps!

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

Re: insert into mulitiple tables???

WetRivrRat18-Dec-05 13:23

WetRivrRat

18-Dec-05 13:23

That Worked!!!!

THANKS

Big Grin | :-D

string Beautiful;
Beautiful = "ignorant";
label1.Text = "The world is full of " + Beautiful +" people.";

Why is common sense such an un-common comodity?

Re: insert into mulitiple tables???

Luis Alonso Ramos18-Dec-05 16:19

Luis Alonso Ramos

18-Dec-05 16:19

You're welcome! I'm glad I could help! Smile | :)

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

Need simple code

gharry18-Dec-05 8:30

gharry

18-Dec-05 8:30

I am not that good in asp.net and sql.

I need a simple piece of code to see if a value is in a datatable.
Allready have this but how to proceed:

Dim LUConn As SqlConnection = New SqlConnection("server=localhost;uid=sa;pwd=;database=EventMngt")
Dim LUString As String = "SELECT * FROM C_Registered_horses WHERE Horse_Name = " & Horse_Name.Text
Dim objLUConnCommand As New SqlCommand(LUString, LUConn)
Dim objConnReader As SqlDataReader

Try
LUConn.Open()
objConnReader = objLUConnCommand.ExecuteReader()

Catch Err As Exception
MessageLabel.Text = "Horsename not found. Try again or use Passport number." & Err.Message
Horse_Name.BackColor = System.Drawing.Color.LightGoldenrodYellow
btnSubmitNext1.Visible = "false"

Finally
LUConn.Close()
MessageLabel.Text = LUString
Horse_Name.BackColor = System.Drawing.Color.LightGreen
btnSubmitNext1.Visible = "true"

End Try

Any help is welkom.

Re: Need simple code

Luis Alonso Ramos18-Dec-05 10:46

Luis Alonso Ramos

18-Dec-05 10:46

ExecuteReadering is not enough, you have to actually Read something:

objConnReader = objLUConnCommand.ExecuteReader()
 
If objConnReader.Read Then
   ' At least one record was returned
Else
   ' No records returned
End If

If you want to process multiple records, then call Read in a loop

objConnReader = objLUConnCommand.ExecuteReader()
 
Dim counter As Integer
 
While objConnReader.Read Then
   ' Process the record
   counter = counter + 1
Wend

I hope this helps!

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

Re: Need simple code

gharry19-Dec-05 6:31

gharry

19-Dec-05 6:31

LuisR thankx for the info and it helps.

Is it possible to use the retrieved valuas ore should one use a other aproach.

Re: Need simple code

Luis Alonso Ramos19-Dec-05 6:44

Luis Alonso Ramos

19-Dec-05 6:44

objConnReader = objLUConnCommand.ExecuteReader()
Dim counter As Integer
 
While objConnReader.Read
    ' Process the record
    lstNames.Items.Add objConnReader.GetString(0)  ' First column
 
    counter = counter + 1
Wend

The data reader has methodos for returning different types of data from a specified column index (GetInt32, GetString, and so on). Use GetOrdinal to get the column index from the column name.

See my reply to Albanian on why you should use parameters instead of concatenating strings for building a SQL query.

I hope this helps!

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

-- modified at 12:44 Monday 19th December, 2005

Re: Need simple code

gharry19-Dec-05 22:12

gharry

19-Dec-05 22:12

It Does, Thanks for the help

Re: Need simple code

albCode19-Dec-05 4:20

albCode

19-Dec-05 4:20

Dim LUConn As SqlConnection = New SqlConnection("server=localhost;uid=sa;pwd=;database=EventMngt")
Dim LUString As String = "SELECT * FROM C_Registered_horses WHERE Horse_Name = " & "'" & Horse_Name.Text & "'"
Dim objLUConnCommand As New SqlCommand(LUString, LUConn)
Dim objConnReader As SqlDataReader

Try
LUConn.Open()
objConnReader = objLUConnCommand.ExecuteReader()

Catch Err As Exception
MessageLabel.Text = "Horsename not found. Try again or use Passport number." & Err.Message
Horse_Name.BackColor = System.Drawing.Color.LightGoldenrodYellow
btnSubmitNext1.Visible = "false"

Finally
LUConn.Close()
MessageLabel.Text = LUString
Horse_Name.BackColor = System.Drawing.Color.LightGreen
btnSubmitNext1.Visible = "true"

End Try

' "SELECT * FROM C_Registered_horses WHERE Horse_Name = " & "'" & Horse_Name.Text & "'"

Re: Need simple code

gharry19-Dec-05 5:05

gharry

19-Dec-05 5:05

Hi Albanian,

Cant see the difference between my code and your answer

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.