Database Discussion Boards

DB2 Connection

5-Jul-02 9:21

Hi,

Any body can guide on how to connect to AS400 DB2 files using C#?

Many Thanks,
Jassim Rahma

Jassim Rahma

Protected DBF

5-Jul-02 9:20

I need to develop an application for multi user (8 users / time) which MSDE will not allow me to do because it allows max 5 users/time. I personally like DBF files but I have a problem in saving the user's prefrences & password. Can any one guide me please?

Jassim Rahma

Reading an XML file to a Dataset and then from Dataset to SQLServer

Alexandru Savescu4-Jul-02 22:54

Alexandru Savescu

4-Jul-02 22:54

I am doing the folowing operations:

1. Export some tables (that have unique IDs and foreign keys) to an XML file using a DataSet object in .NET. This works file.

2. I want to be able to import that XML file into another SQLServer server that has the same database architecture, but of course, different data.

3. When reading the XML file into a Dataset and then updating the database, some key violations or duplicate records may occur because I exported some unique IDs from one databse server and am trying to import them into another server. Thus, when importing a master table, I must read the XML file and give the corresponding records new IDs accordingly. Since my master table will have several slave tables with foreign keys involved I would have to udpate the slave tables also to maintain the integrity.

I could do all that manually by having lots of structures and maps and hash tables. Is there a change .NET Dataset would take care of everything automatically for me?

Best regards,
Alexandru Savescu

sql server 2000: protocol and encryption

devvvy4-Jul-02 16:30

devvvy

4-Jul-02 16:30

hi, i have 3 questions regarding communication protocols used by sql servers... hope someone can give me some direction, i read the "help" and some books, didnt find anything...

QUESTION 1: how can u ping a sql server instance?

for example:

ping www.myserver.com:1433 (for default instance)
ping www.myserver.com:3333 (some designated port for a named instance)

is this correct? any why do i have to configure thru both?
a. client network utility (i thought communication protocol used by an application is really up to the client application itself? why do we need to configure it thru sql server)
b. server network utility (this i understand, but one more question. let's say we installed a few protocols, when a client connection comes in, is it SQL server that's responsible for detecting the protocol used by the client connection? and it's SQL server that pick the matching protocol - if available/installed?)

QUESTION 2: "force protocol encryption" in "server network utility"

a. what does it mean? to encrypt "out-going traffic"? or "incoming traffic"? How does this work between server and client?
b. If this checkbox is available on the main dialog, then why can i also configure "Enable Encryption" under "multi-protocol" encryption?
c. And how can i enable SSL for TCP/IP? Under "properties" for TCP/IP (in SQL Server Network Utility), i cant find any "Enable SSL encryption" checkbox?
d. "protocol encryption": which layer? I presume they just encrypt application layer header rite?

QUESTION 3:
what about named pipe? I have no idea what name piped really means... Can i type the "named pipe" from a command prompt and "ping" the resource as if I am using TCP/IP?

I know it's a protocol used by SQL server, but is this all i need to know?

Thanx!! Confused | :confused:

norm

Re: sql server 2000: protocol and encryption

Richard Deeming16-Jul-02 6:08

Richard Deeming

16-Jul-02 6:08

norm wrote:
ping www.myserver.com:1433

Ping only works at IP address level. If you need to connect to a specific port, try Telnet.

norm wrote:
a. client network utility
norm wrote:
b. server network utility

SQL Server needs to know which protocols are enabled. The Server Network utility is used for that. The Client Network utility is used to configure which protocols are enabled on the client. If the client app specifies a network library to use, as long as it is enabled on the client and the server, everything should be OK. AFAIK, if the client doesn't specify a protocol, it will try the available protocols until it finds one that works.

norm wrote:
QUESTION 2: "force protocol encryption" in "server network utility"

a. AFAIK, it encrypts both ways.
b. Confused | :confused:

I can't see that option.
c. The protocol encryption is SSL encryption.
d. No idea.

norm wrote:
QUESTION 3:
what about named pipe?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpic/html/msdn_npipes.asp:
A pipe is a simple data transfer mechanism that works, well, pretty much like a pipe: You stuff things in one end and the things come out the other end. You can establish a pipe both locally (using either so-called anonymous pipes or named pipes) and to a remote machine (a named pipe). In order to be able to utilize a named pipe over a network, one machine must have created the pipe (the server), and another machine that wants to use the pipe (the client) must know both the name of the server machine and the name of the pipe on the server machine.

How to add a Record ID column?

4-Jul-02 4:03

Hi, all.
a table named Employees, which has one column named "Name" and 3 records, like below:

Name
-----
Mike
Tom
Jacky

now i wanna display one more column named ID, which is a continuous integer, let the result like:

ID Name
------------
5 Mike
6 Tom
7 Jacky

how to write this query can make this result(using ms sql)? thanks a lot.;)

Re: How to add a Record ID column?

SimonS5-Jul-02 10:32

SimonS

5-Jul-02 10:32

Do the Name values have to tie up with a specific integer value in the resultant table?
If not, why not give this a try:
1. Move Employees data into temp table
2. drop Employees table (or backup)
3. recreate new Employees table with ID and Name field
4. Iterate thru temp table and fill new Employees table.

...done. Poke tongue | ;-P

Does the ID field have to be a PK?

Cheers,
Simon

"Sign up for a chance to be among the first to experience the wrath of the gods.", Microsoft's home page (24/06/2002)

Get n records starting from...

Luca Leonardo Scorcia2-Jul-02 0:16

Luca Leonardo Scorcia

2-Jul-02 0:16

Hi! This is my first post here - hope you'll help me easily! Smile | :)

First of all, I'm using ASP with an Access DB. I need the SQL expression or some ADO instructions to get only n records starting from a record of which I have the primary key value.

If I had the record number it would be easy, but I don't have it, I only have the random primary key...

Thank you in advance

Luca Leonardo Scorcia
http://zip.to/kojak (only in Italian)

Re: Get n records starting from...

SimonS2-Jul-02 2:25

SimonS

2-Jul-02 2:25

You're probably going to have to use a client-side cursor with Access.

But, here are couple of questions:
1. how many rows are there?
2. are you sorting the resultset?

Cheers,
Simon

"Sign up for a chance to be among the first to experience the wrath of the gods.", Microsoft's home page (24/06/2002)

Re: Get n records starting from...

Luca Leonardo Scorcia2-Jul-02 3:04

Luca Leonardo Scorcia

2-Jul-02 3:04

Mhhh... what's a client-side cursor with Access? Smile | :)

The rows are ~2000, but they will grow maximum to 10000, I think...
Yes, the results are sorted.

This is the code I use to display the messages from record M to record N...

Sub WriteMessages(startAt, nEndAt)
  Dim indent_level, strSQL

  strSQL = "SELECT TOP " & nEndAt - 1
  strSQL = strSQL & " id_msg, id_thread, placement, reply_count, date, id_autore, author, subject, text"
  strSQL = strSQL & " FROM Bacheca"
  strSQL = strSQL & " ORDER BY id_thread DESC , placement"

  Dim rstThreads
  Set rstThreads = Server.CreateObject("ADODB.Recordset")

  rstThreads.Open strSQL, adminDBConnString
  rstThreads.Move(startAt - 1)
	
  do until rstThreads.EOF
     indent_level = (Len(rstThreads("placement")) - 1) / 4 + 1
     WriteMessage indent_level, rstThreads("id_msg"), 'Lots of parameters here
     rstThreads.MoveNext
  loop

  rstThreads.close
  set rstThreads = nothing
End Sub

I want to do the same thing, but starting from a certain record, whose number I don't know, but that has a certain value as primary key.

Luca Leonardo Scorcia
http://zip.to/kojak (only in Italian)

Access 2000 schema info

SimonS1-Jul-02 3:39

SimonS

1-Jul-02 3:39

I need to get schema info (viz: primary/foreign keys, indexes) for a table in access.

Am I able to use ADO.NET or do I still have to use ADOX?

Any code samples?

Cheers,
Simon

"Sign up for a chance to be among the first to experience the wrath of the gods.", Microsoft's home page (24/06/2002)

sysobjects in Access 2000

SimonS29-Jun-02 7:31

SimonS

29-Jun-02 7:31

If Access is now running off MSDE, why am I not able to select from the system tables as in SQL personal edition?

Any ideas?

Cheers,
Simon

"Sign up for a chance to be among the first to experience the wrath of the gods.", Microsoft's home page (24/06/2002)

Access - UNION and 2 queries with Params

Giles28-Jun-02 8:49

Giles

28-Jun-02 8:49

Say I have two queries that are of a similar structure, and take parameters for a client ID e.g. from ADO I would call them like..

First Query

{CALL qData1 ('Mr Bob') }

and the Second Query

{CALL qData2 ('Mr Dave') }

If I wanted to use these in a Union how would I build it, as I cannot seem to figure out how to use Queries/Stored procedures with parameters in a Union.

Any ideas?

DataGrid paging

27-Jun-02 10:55

I have a datagrid which I use to update a table but I have a little paging problem

when I add a new entry I would like to page to the last page but I do not know which is the last page as it could have incremented by the addition of the new record.

is there a way of seeing from the datagrid or dataset just how many records there are (or were) or should I just do another query on the database to get a recordcount. Its probably in there but I just can't see the wood for the trees.

Thanks again

Shaun

Re: DataGrid paging

Mazdak9-Jul-02 9:03

Mazdak

9-Jul-02 9:03

ShaunW wrote:
I do not know which is the last page

Maybe pagecount property is what you want.

Mazy

"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down

odbc woes in .net

27-Jun-02 5:58

I have an access database mounted via an ODBC datasource

I can view it in the solution explorer but when I try to access it I get the following message 'You cannot use an OLE DB provider for ODBC drivers'. What does that mean? How do I access the database via this route.

I can view the same database if I use the jet drivers however the jet drivers treat my date/time fields as pure date fields and so I lose all time (hours,mins,secs) information.

Please help

Shaun

Re: odbc woes in .net

27-Jun-02 10:49

okay I've switched my database to SQL 2000 and that version of datetime works fine - but if anyone can help with the above it would be appreciated.

Shaun

Re: odbc woes in .net

Richard Deeming2-Jul-02 0:14

Richard Deeming

2-Jul-02 0:14

The error message means that you cannot use the OLEDB Provider for ODBC to access an ODBC datasource through the System.Data.OleDb objects. You need to download the ODBC.Net provider from Microsoft and use that instead.

CRecordset - Retrieving SQL & Parameters on Fail

Henry Kafeman27-Jun-02 0:59

Henry Kafeman

27-Jun-02 0:59

Help please - I have an INSERT query of the form:
INSERT INTO MyTable (Field1, Field2...) VALUES (Value1, Value2...)
into a SQL Server Database. It is failing due to invalid text in one of the Parameters.
Now, I want to report the SQL query and Parameter Values when the failure is detected to aid debugging any future issues.
But GetSQL() only returns the SELECT query - the m_strUpdateSQL contains the "INSERT ... VALUES (?, ?...)" but there is no access Function!
Also if I try to use GetFieldValue() (to try to report the parameter values) my application just dies with an exception - presumably because they are only valid for a SELECT?
Is there any way to get at the Parameter Values?

Any help from someone out there who is familiar with CRecordsets, etc. would be gratefully received.

SQL Image

Hesham Amin26-Jun-02 20:47

Hesham Amin

26-Jun-02 20:47

Hi..
I use ADO to store Images in a SQL Server 2000 Database

I want to know how to get the size of th stored image..
second: The log file Gets full quickly as I save large data .. Is there a way to truncate it after completing the Image saving Operation ?
Confused | :confused:

Re: SQL Image

27-Jun-02 10:26

1) select DataLength(imagefieldname) from TableName
2) use the WriteText/ReadText stuff which is not looged.

OLE DB Provider problem

StefanM26-Jun-02 12:16

StefanM

26-Jun-02 12:16

I have created a ATL/COM project in VC6 that will run as a service. Then I added a OLE DB Provider and modified it to just return 2 rows of a very simple record layout.
It compiles with no errors or warnings!
Then I launch Visual Basic and create a standard exe projekt, the first thing I do is to add a DataEnvironment Designer. When I open the property dialog on "DataEnvironment1" I get a list of providers to choose from, and my provider is also listed there.
When I select the provider I have created and presses next button, I get an error message saying something like this: "The provider is not available, check that you have installed it correctly" !!!!!!

Confused | :confused:

What have I missed? How do I install/register my provider?

I have ofcourse started the service!

Don't give me a RTFM, cause I have!

Confused

ado and createdatabase

Gabriel.P.G26-Jun-02 7:52

Gabriel.P.G

26-Jun-02 7:52

Is there any way to create a Jet database using ADO? I was using
CreateDatabase() with DAO, but now my employer wants ADO code ( yes, i´m always way behind the technology curve Cry | :((

) ). I found the
dao to ado migration guide on msdn but it uses ADOX. Any Idea???

Thanks

Gabriel

Old C programmers never die. They just cast into void

Re: ado and createdatabase

RChin28-Jun-02 0:58

RChin

28-Jun-02 0:58

As far as I know ADO does not have db creation functionality.
database creating and structural management should be done via ADOX (which is very easy to implement!) Smile | :)

-chin-

Missing OLE Provider.

Kevin Gutteridge26-Jun-02 6:04

Kevin Gutteridge

26-Jun-02 6:04

I need to hook Visual C++ to a Visual Foxpro database. There is a mention of an OLE Provider (vfpoledb on the Micrsoft site) and there is even an example of this on Codepage. But where can I get it?

I have now installed Fox Pro itself but no joy, my machine is XP is that makes any difference.

Can someone please point out the obvious to me?

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