What are SQL or MSDE best practices for connections - Database Discussion Boards

First Prev Next

Re: Multi-threading app using OLE DB calling into a shared Access DB

Rashid Thadha30-Aug-01 12:10

Rashid Thadha

30-Aug-01 12:10

This may not be related - but

Do you call CoInitialize(NULL) and CoUnitialize() in all your Threads? This basically loads the OLE Library that OLE DB requires.

Re: Multi-threading app using OLE DB calling into a shared Access DB

Steen Krogsgaard3-Sep-01 23:25

Steen Krogsgaard

3-Sep-01 23:25

Perhaps calling the IIdle::Idle would remove the locks? The Jet OLE DB docs makes it clear that we should call this methods frequently.

Cheers
Steen.

"To claim that computer games influence children is rediculous. If Pacman had influenced children born in the 80'ies we would see a lot of youngsters running around in dark rooms eating pills while listening to monotonous music"

ADO Refresh Method Problems (beginner)

Bigge29-Aug-01 7:38

Bigge

29-Aug-01 7:38

Hi Im using the Refresh Method With ADO C++(I had to many problems with Createparameter Method)

bstr_t bstr = L"DSN=MEAS2SQL;
pCon->Open(bstr, (BSTR)NULL, (BSTR)NULL, -1);
pCommand->ActiveConnection = pCon ;
pCommand->CommandType = ADODB::adCmdStoredProc
pCommand->CommandText = _bstr_t("URBAN");

"It works with executing a stored procedure without parameters"
But when i inlude parameters with this lines i get the error.

pCommand->Parameters->Refresh();
pCommand->Parameters("@pkMbtID") = '160';

I get the error:
error C2064: term does not evaluate to a function

I spent several hours with this Plezz Help.

PS. They say CreateParametr is Faster then Refresh Method i wonder how much faster?

Re: ADO Refresh Method Problems (beginner)

Martin Bohring5-Sep-01 22:10

Martin Bohring

5-Sep-01 22:10

Parameters is a collection, so you have to use.
In VB the Item property is the default property of the parameters collection.
But in C++ there are no default properties.

BTW I don't thing defaulting everthing as done in VB does the programmer
do an favour. Defaulting rules can change, because there are defined
by the type lib you are coding againts.

So if you happen to have a newer type lib installed where the default props have changed, you
will run into trouble. So I have the attitude to never depend on default probs
and methods in any language I use (VB, C++, VB script)

pCommand->Parameters->Item[_T("@pkMbtID")]->Value = _T'160'

And is your parameter really a string or is it a number ?

The Value is a _variant_t, so you can stuff in a number, if that's what you really want.

Identity Columns

27-Aug-01 8:45

Hi there,

I was wondering why you would want to use an identity column as opposed to using a Primary Key or UniqueIdentifier data? What's the advatnage if any?
Where would this be suitable?

Re: Identity Columns

Rashid Thadha30-Aug-01 12:14

Rashid Thadha

30-Aug-01 12:14

The Identity column generates a unique identifier for you, therefore you do not need to worry about generating a unique identifier?

This is suitable when you require a unique identifier !!!

Problems with ODBC and MSACCESS

Simone Giannecchini26-Aug-01 11:37

Simone Giannecchini

26-Aug-01 11:37

I'm deployng an application ith Visual c++ 6.0 + service pack 6 on a PC where i have installed win2k.My problem is that qhen i try to connect to a MSACCESS database (either 97 or 2000) usign ODBC technology in the output window appears this message (i think it's a TRACE message) "First-chance exception in SimoFatt.exe (KERNEL32.DLL): 0xC0000005: Access Violation."; so my application continues its work (i do not receive any exceptions) but very very slowly. CAN SOMEONE SUGGESTS ME A SOLUTION FOR THIS PROBLEM that makes me fool?
THANKS
PS I apologize for my bad english. Confused | :confused:

What are SQL or MSDE best practices for connections

Rod Hamilton24-Aug-01 3:12

Rod Hamilton

24-Aug-01 3:12

My question relates to whether its better to maintain a connection to the SQL database and pass the the pointer to CRecordset when required or use a connectionless set-up (which seems to be the default) where you open the database during each CRecordset use?

Doesn't maintaining the connection reduce overhead? Is there any documentation on the pros and cons?

Rodney

Access database!!!!!

22-Aug-01 6:24

Hi, I try to connect via ASP to access database, the connection seems to be ok but every time i try to write via ASP on my access database, i got a message error who said database are read only, i cant update them why?

Is it just a setting?

everythings is in a virtual directory, the connection as I said is ok but i cant write on the database...

Thanks in advance

Regard

Manon Smile | :)

Re: Access database!!!!!

Anders Molin30-Aug-01 2:51

Anders Molin

30-Aug-01 2:51

Often it's because the anonymous webuser don't have write access to the directory where the access-db is...

- Anders

Money talks, but all mine ever says is "Goodbye!"

Re: Access database!!!!!

Drawil6-Nov-01 20:19

Drawil

6-Nov-01 20:19

Dear Manon
Be sure that you have a Key in your Data Base.

Drawil

Best Regards Smile | :)

Access 2000

21-Aug-01 3:00

I wrote a program that performs SQL operations on a access 2000 (*.mdb) database. It works fine on my machine with Access 2000 and VC++ SP3 installed. When I move it to another machine without either of these applications, my queries don't work.

I'm pretty sure that I need to update the ODBC drivers on my "plain" machine. If I was to make a re-distibutable, what files would I want to include with it so that my program will work on any Win 9x/2k platform?

Thanks,
Ryan

Re: Access 2000

CodeGuy21-Aug-01 4:59

CodeGuy

21-Aug-01 4:59

You need the latest version of MDAC + the Jet4.0SP3 patch.
http://www.microsoft.com/data

CodeGuy
http://groups.yahoo.com/group/wtl

Re: Access 2000

22-Aug-01 12:04

it's include with win 2000 professional!

Re: Access 2000

CodeGuy22-Aug-01 12:18

CodeGuy

22-Aug-01 12:18

The question was, "How do I make it work on any Win 9x or 2000 machine?" For this,
you will always need MDAC. The newest version (with patches) is not the one that was
distributed with Win2K, but has been since updated.

CodeGuy
http://groups.yahoo.com/group/wtl

Duplicating (copying) a table in SQL Server database

User 988520-Aug-01 13:13

User 9885

20-Aug-01 13:13

I want to copy a table (not rename - the original table should remain as it is) with all the data in it to another table. Is there any way to do it inside a stored procedure in MS SQL Server?

Thanks

Thomas George

modified 29-Aug-18 21:01pm.

Re: Duplicating (copying) a table in SQL Server database

Chanceamatic22-Aug-01 14:38

Chanceamatic

22-Aug-01 14:38

Highlight the table and select All Tasks -> Export. This will bring you into DTS. Select the Source and then the Destination (in this case they will be the same). Select Copy Table(s), hit next, select the table you want from the source drop-down and then type in a name for the destination table. You can use Transform here to manipulate the fields, etc. Hit Next, you can run this imediately or save in which you can call this DTS Package from a Job, Stored Procedure, etc. (See BOL about calling DTS packages from an sp.)

Another way:

Select * into (new_table_name) from (old_table_name)

This will create a new table with all the info. (NOTE: This 'transfer' is not logged as a transaction, thus can not be rolled back. I believe you can check FULL RECOVERY on you DB and this will correct this.)

Good Luck!

ADO bug in VC++ 6 SP5 + Processor Pack

John M. Drescher15-Aug-01 18:09

John M. Drescher

15-Aug-01 18:09

I have recently installed both SP5 and the Processor Pack to visual C++ 6 and I am having the following
problem. When an exception occurs inside a try catch block inside a function that calls ado methods
the function crashes (in the debug build) on return. The following code runs fine when compiled with
an earlier service pack and no processor pack, but with SP5 + Processor Pack it crashes during the return
from the test function. Also if I compile it on a pc with an eariler sp, it will debug and run fine
on a machine with the latest sp (as long as you don't try to compile!).

The following code has been reduced to the smallest part that I could get it to crash. I compiled it
as a Win32 console application and did not change any of the default values. In SP5 + processor pack
an access violation occurs when test() returns. This was tested on win2k. I compiled and tested it in
debug build only.

#include "stdafx.h"

// You must change this to match your path
#import "D:\program files\common files\system\ado\msado15.dll" \
no_namespace \
rename( "EOF", "adoEOF" )

void test()
{
_RecordsetPtr pRst = NULL;
try
{
throw "a";

pRst->Open(_variant_t(), _variant_t(),adOpenStatic ,
adLockReadOnly, adCmdText);
}
catch (...)
{

}
}

int main(int argc, char* argv[])
{
test();
return 0;
}

My question is 1) Has anyone seen this problem? 2) am I doing something wrong?

Re: ADO bug in VC++ 6 SP5 + Processor Pack

Rashid Thadha16-Aug-01 22:31

Rashid Thadha

16-Aug-01 22:31

your code where you have

throw "a";

looks well dodgy !!!!

maybe you should remove that

Cool | :cool:

Reading Fixed Width Files with ADO?

Pete Bassett14-Aug-01 0:54

Pete Bassett

14-Aug-01 0:54

Hi all.

I'm looking to read a flat/fixed width text data file with ADO. I'm assuming that i'll have to write a Schema.ini with all the field definitions in before hand.

Is this correct?

Also, the nice Fixed with import wizard in Access, is there anyway to automate this? I.e., me use it in my app?

Thanks! Pete

Field Existence with ADO

10-Aug-01 4:15

Hi, I was wondering if there was any way I could check for the existence of a field in a table without poking the database and handling an error. I'm sure there is a way, but all my searching has led to no avail. Confused | :confused:

Re: Field Existence with ADO

Rashid Thadha10-Aug-01 6:22

Rashid Thadha

10-Aug-01 6:22

use the FieldsPtr class

e.g.

FieldsPtr ptrFields = NULL;
FieldPtr ptrField = NULL;

// assign the Fields that we have from the recordset
ptrFields = m_pRS->Fields;
int nCols = ptrFields->Count; 

FieldPtr ptrField = NULL;
_variant_t vCol((long)-1);
for (int i = 0; i < nCols; i++)
{
   vCol.lVal = i;
   HRESULT hr = ptrFields->get_Item(vCol, &ptrField);
   if(FAILED(hr))
      _com_issue_error(hr);
            
   // now check if the field exist
   if ((LPCSTR)ptrField->Name == "My Field")
   {
      // Do Something
   }
}

select * from multiple tables??????

martinsz10-Aug-01 3:45

martinsz

10-Aug-01 3:45

Hi!!

I am using ASP-script and an access-database. I want to make a select query
that shows all the data in many tables how is it possible to do this?
An example:
I want to see the names of all companys in the company-table and I also want
to see their adresses wich are in the adress-table and I also want to see
their email-adresses wich are in the email-table. But I also want to see
the companys who do not have for example an email-adress. How is it possible
to extract this kind of data?

/Martin S
Cool | :cool:

Re: select * from multiple tables??????

Carlos Antollini10-Aug-01 4:01

Carlos Antollini

10-Aug-01 4:01

Select 
  Company.Name, Adress.Adress, email.email 
From 
  Company, Adress, email
where
  Company.ID = Address.id And
  Company.Id =* email.id

You Understand. The secret is the =*.
But You can use *= depends de case.
I need to clarify something. The =* is a RIGHT JOIN and the other is a LEFT JOIN. In some databases engine =* or *= are no soported, in that case you need to Use the syntax LEFT|RIGHT JOIN.

Test if don't work please notify me, that Y will help you.

Cheers!!!! Smile | :)

Carlos Antollini.

Re: select * from multiple tables??????

martinsz10-Aug-01 4:53

martinsz

10-Aug-01 4:53

Thanks for your answer Carlos;)
But since I am using an Access database it does not seem to work by using "*" sign. I would be grateful for other suggestions!!!

Best regards/ Martin Cool | :cool:

Last Visit: 31-Dec-99 18:00 Last Update: 13-Jun-24 3:55

Refresh

ᐊ Prev 1...2451 2452 2453 245424552456 2457 2458 2459 2460 Next ᐅ

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