MS Access query variables - Database Discussion Boards

Re: How can I connect to MS Access via a remote?

Jeremy Falcon19-Jul-02 4:49

19-Jul-02 4:49

Bart-Man wrote:
A program...is that the problem should I use an asp page instead?

No, not at all.

Could you tell me what language you are using? RDS (what you are using) over ADO is idenpendent of language, but I'm gonna try and past a code sample for ya.

Jeremy Falcon
Imputek

"..." - Paul Watson 07-17

Re: How can I connect to MS Access via a remote?

Bart-Man19-Jul-02 7:00

Bart-Man

19-Jul-02 7:00

Jeremy Falcon wrote:
Could you tell me what language you are using?

I am using Visual c++ 6.0 to connect to the database.

Cool, thanks for your help! Smile | :)

Re: How can I connect to MS Access via a remote?

Jeremy Falcon19-Jul-02 7:58

Jeremy Falcon

19-Jul-02 7:58

http://support.microsoft.com/directory/article.asp?ID=kb;en-us;Q220152

You'll want to change the connection string, etc. of course.

Bart-Man wrote:
Cool, thanks for your help!

You're welcome. Smile | :)

Jeremy Falcon
Imputek

"..." - Paul Watson 07-17

Re: How can I connect to MS Access via a remote?

Bart-Man22-Jul-02 5:30

Bart-Man

22-Jul-02 5:30

It is weird I used microsoft's sample, changed the connection string, and it still does not work.
I noticed something odd about when I connect a "First-chance exception" ocurrs, but my exception code does not catch it. It appears that an access problem occurs on the server side.

I am trying to configure the rds, so that it will allow access..
After several attempts, it still does not work correctly. An msdn article suggested that I download msadc sdk and use that to test that the Rds is working correctly.

At any rate I think the connection string is right, and my query code was right. But the rds is not setup right.

Re: How can I connect to MS Access via a remote?

Jeremy Falcon22-Jul-02 14:34

Jeremy Falcon

22-Jul-02 14:34

Bart-Man wrote:
At any rate I think the connection string is right, and my query code was right. But the rds is not setup right.

Ok, if you get the solution I'd love to hear about it. Inquiring minds wanna know. Smile | :)

Jeremy Falcon
Imputek

"..." - Paul Watson 07-17

Solution to my problem

Bart-Man25-Jul-02 9:45

Bart-Man

25-Jul-02 9:45

I figured it out, it was a configuration problem in rds.
It took awhile to find it buried in msdn, and after many cans of mountain dew. Smile | :)

See the link below for the solution:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdhowconfigurerdsonwin2k.asp

Re: Solution to my problem

Jeremy Falcon25-Jul-02 10:02

Jeremy Falcon

25-Jul-02 10:02

Bart-Man wrote:
and after many cans of mountain dew.

You could be on one of their commericals for this! Mountain Dew helps solve crisis!

Thanks!

Jeremy Falcon
Imputek

"..." - Paul Watson 07-17

MS Access query variables

SimonS18-Jul-02 4:04

SimonS

18-Jul-02 4:04

Is it possible to define and use variables within a query in Access?
I've tried DECLARE, but it didn't work. Blush | :O

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: MS Access query variables

Martin Ziacek18-Jul-02 4:41

Martin Ziacek

18-Jul-02 4:41

PARAMETERS test Text ( 255 );
SELECT Table1.ID1, Table1.name
FROM Table1
where name = [test]

Re: MS Access query variables

SimonS18-Jul-02 21:20

SimonS

18-Jul-02 21:20

Thanks.
I'm keen to do something similar to this:

DECLARE @EntTypeID int

SELECT @EntTypeID=0 --init

SELECT @EntTypeID = ( SELECT [ID] from tblEntityTypes WHERE [Descr]='BLAH')
--do something with the @EntTypeID var.

Anyway to implement this in Access 2000, XP?

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: MS Access query variables

Martin Ziacek19-Jul-02 9:34

Martin Ziacek

19-Jul-02 9:34

Well, you can have query with parameters and access them from Access Basic, however I do not know how to get functionality as you want within one query. When you will write code in Basic and use several queries then you can simulate your code.

Another SQL Server Q

Mazdak18-Jul-02 3:51

Mazdak

18-Jul-02 3:51

Another question about SQL Server.WHat stored in transaction log file?

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

Re: Another SQL Server Q

Martin Ziacek18-Jul-02 4:30

Martin Ziacek

18-Jul-02 4:30

What is stored in transaction log file

Re: Another SQL Server Q

Mazdak18-Jul-02 19:20

Mazdak

18-Jul-02 19:20

Again thank you. Smile | :)

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

CREATE DATABASE

Mazdak18-Jul-02 3:45

Mazdak

18-Jul-02 3:45

I have a question about CREATE DATABASE in SQL Server2000.It has a parameter named FILEGROWTH and COLLATE.Could someone explain them for me? Thanks.

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

Re: CREATE DATABASE

Martin Ziacek18-Jul-02 4:38

Martin Ziacek

18-Jul-02 4:38

Mazdak wrote:
FILEGROWTH

As you are adding data into the database, more and more space is needed. When used space will reach the size of the file, then SQL Server will extend that file by amount specified in the FILEGROWTH.

Mazdak wrote:
COLLATE

COLLATE specifies how you will order strings in the database, depending on selected language. There are different rules to order strings in the different languages.

Re: CREATE DATABASE

Mazdak18-Jul-02 19:17

Mazdak

18-Jul-02 19:17

Thank you. Smile | :)

Re: CREATE DATABASE

Jeremy Falcon18-Jul-02 4:48

Jeremy Falcon

18-Jul-02 4:48

COLLATE specifies how fields are sorted, and FILEGROWTH specifies the increment in which the file size will increase when needed if the DB has its assocated files set to autogrow.

Here's a snippet from MSDN to give you a better idea about COLLATE...

COLLATE

Specifies a collation sequence for character fields in subsequent indexing and sorting operations. ... Note When you specify the SPANISH option, "ch" is a single letter that sorts between "c" and "d", and "ll" sorts between "l" and "m".

Jeremy Falcon
Imputek

"..." - Paul Watson 07-17

Re: CREATE DATABASE

Mazdak18-Jul-02 19:18

Mazdak

18-Jul-02 19:18

Thank you. Smile | :)

First letter from a record in SQL

Robby18-Jul-02 3:25

Robby

18-Jul-02 3:25

Hello,

I am trying to figure out a way to get different characters from different fields to auto-produce a string to display to a user on a web page. For instance, if you enter your name as John Doe and your SSN is 000-00-1234, then I want to be able to go to the firstName, lastName and SSN fields and get only the FIRST letter of the firstName & lastName and the LAST three of the SSN and put them together and add them to the userID field in the table (i.e. JD234). Right now, the SSN fields are split as ssn1, ssn2, ssn3, and are combined and entered into the SSN field as xxx-xx-xxxx.

I would also like the capabilities of creating an ID based on two different things. For instance, if they supply an employee number INSTEAD of an SSN (we are currently changing our ID naming scheme, but not enforcing it at this time), then I would like to take the FIRST letter of the firstName and the last (6) of the employeeID and create the userID from that...do I use an If...Then...Else to see which they entered and produce the ID? Keep in mind that I want to do ONE of the OTHER, but the new scheme (using the employeeID field) takes precedence. Anybody out there done this before?? Thanks for your help!

Why does it have to be so complicated??

Anonymous17-Jul-02 13:02

Anonymous

17-Jul-02 13:02

MySQL Has the following core functions:
connect(), query(), store_result(), fetch_[row, feild]() num_rows(), num fields(),
escape_string(), and close()
There are others, but those are the most used.

Data returned is all characters, and and you get to the data by:
row=fetch_row(query_result);
and row[N] = field N, it's that simple!

Is there anything that simple for ADO or ODBC? I'm trying to port a MySQL app to SQL Server, and having a hard time finding anything that simple. My real concern is handling user-defined queries. In MySQL it was as easy as:
con=connect();
query(con, user_sql);
result=store_restult(con);
feilds=num_fields(result);
while (row=fetch_row(result)){
for (f=0; f

Guide, idea about interacting with remote SQL

tongc17-Jul-02 4:36

tongc

17-Jul-02 4:36

Hi

I want to develope an client application to update/retrieve data from a remote database namely SQL on some maching over the Internet. For example, application to connect to TheCodeProject database to retrieve the appropriate data, format it then output it. In the essence, it just acts like off-line forum reader , without having open the browser and offer some extra functionality like saving, attaching files, etc.... However i m still in the dark of how about to do it. I would like to ask some questions related to the matter:

1) Is C# the most appropriate language to do this?

2) What sort of configuration does the MySQL server needs to apply for my application to make a connection?

3) I want to make the interface of the application Outlook liked, how would i do so?

Thank alot for reading this and looking forward to receive your enlightment!

Best Regard

Installing SQL Server

Mazdak16-Jul-02 5:34

Mazdak

16-Jul-02 5:34

I have windows xp proffesional.I install SQLServer2000 enterprise edition.When I wanted to install "SQL Server Components" it tell me it can't install server tools in this operating system and installed only client tools.

After installation I run Query analyzer.I have to connect to SQL Server.My compuetr name is 'MAZY' and I typed its name the name of server name.But when I clicked to connect to server I got this error:

---------------------------
SQL Query Analyzer
---------------------------
Unable to connect to server MAZY:

Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
---------------------------
OK
---------------------------

I tried "windows authenication" and "SQL Server authenication" too.I get the same thing.In enterprise manager when I want to register my server I get the same error.Any idea? Cry | :((

Re: Installing SQL Server

Richard Deeming16-Jul-02 5:50

Richard Deeming

16-Jul-02 5:50

The error message about not being able to install server tools actually means it coudn't install SQL Server. This is probably because you're running a desktop OS instead of a server OS.

You should have a second disk with the Personal Edition on it, which will install on your machine.

SQL Server 2000 Enterprise Edition and Standard Edition run on Microsoft Windows 2000 Server, Windows 2000 Advanced Server, Windows 2000 Datacenter Server operating systems, Microsoft Windows NT Server version 4.0 Service Pack 5 (SP5) or later, and Windows NT Server 4.0 Enterprise Edition with SP5 or later
SQL Server 2000 trial software and SQL Server 2000 Developer Edition run on the operating systems listed above for the Enterprise and Standard Editions as well as on Windows XP Professional, Windows XP Home Edition, Windows 2000 Professional and Windows NT Workstation 4.0 with SP5 or later.
SQL Server 2000 Personal Edition and SQL Server 2000 Desktop Engine run on the operating systems listed above for Enterprise and Standard Editions, as well as on Windows 98, Windows Millennium Edition (Windows Me), Windows XP Professional, Windows XP Home Edition, Windows 2000 Professional, and Windows NT Workstation 4.0 with SP5 or later.

Re: Installing SQL Server

Mazdak16-Jul-02 9:22

Mazdak

16-Jul-02 9:22

Thank you very much. Smile | :)

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