Database

FirstPrevNext

Re: Looking for Info Jon Gohr6-Sep-01 5:46 Jon Gohr 6-Sep-01 5:46  Yes, that's correct. I thought I had seen an article or some info on how to do it somewhere. I may be mistaken however. I want to return a recordset from a COM/DCOM dll written in Visual C++ to a scripting or VB client. Thanks Much! Re: Looking for Info Carlos Antollini6-Sep-01 5:51 Carlos Antollini 6-Sep-01 5:51  You need to build a ATL Project. look Into the site, Info About ATL and ADO. If you don't find nothing, I can send you a sample, of Using ADO into ATL Project. I Work every day with that Kind of Project. Cheers!!!! Carlos Antollini. Re: Looking for Info Jon Gohr6-Sep-01 6:10 Jon Gohr 6-Sep-01 6:10  Cool, I found some info here and on microsoft's site in regards to doing this with ATL. Thanks!! Re: Looking for Info Rashid Thadha6-Sep-01 10:14 Rashid Thadha 6-Sep-01 10:14  see article at http://www.codeproject.com/atl/atl_ado.asp Re: Looking for Info 8-Sep-01 12:26 8-Sep-01 12:26  Hi I think what you want to do is almost the same as what the RDS.DataFactory can do for you. If you need to extend the functionality - you can create your own based on the DataFactory. Search for RDS in the MSDN .Net not compatible to Studio6? Sandos Ganzales4-Sep-01 19:45 Sandos Ganzales 4-Sep-01 19:45  I installed .Net,and I found the component writed with VB was correct while debug step by step,then I make the dll.But it does not work correct.(In one method of this component ,I called one function of another dll just for unzip files.) If this is caused by .net? sandos What database should I use? Michael Martin3-Sep-01 20:52 Michael Martin 3-Sep-01 20:52  I am building an application that will require a database to store information. I am wondering what ones are available for me to use. I like the ease of distribution of Access, just dump the file on the target machine make sure the newest MDAC is installed and of you go with ODBC calls or whatever. Problem is when I attempted to setup a database I couldn't create table or field names as whatever I liked. I could name evrything to anything in SQL Server but it requires the files and MSDE on the target machine to run. This is annoying. Is there a database out there that allows me to create table and fields names to anything I like, doesn't require something like MSDE to access it programatically? I wouldn't mind free as I may want to create some application in my personal time for free distribution and I don't want to break the bank doing it. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018 "Don't belong. Never join. Think for yourself. Peace" - Victor Stone Re: What database should I use? Steen Krogsgaard3-Sep-01 23:22 Steen Krogsgaard 3-Sep-01 23:22  Why couldn't you name your tables and fields in Access (=Jet) as you like? As far as I know there is little difference between Jet and SQL Server? 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" Re: What database should I use? Michael Martin4-Sep-01 4:59 Michael Martin 4-Sep-01 4:59  Have to look into it again, I tried a couple of months ago and seemed to get locked into a wizard interface that kept giving me choices of existing table and field names. Then got the sh*ts and moved onto SQL Server, just think it is overkill for any litle dinky stuff I will work on in my own time at the moment. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018 "Don't belong. Never join. Think for yourself. Peace" - Victor Stone Re: What database should I use? Carlos Antollini4-Sep-01 5:06 Carlos Antollini 4-Sep-01 5:06  Problem is when I attempted to setup a database I couldn't create table or field names as whatever I liked. Did you try with Dao or with ADOX?. I can to do that..... Try with ADOX or with CDAOWorkspace, CADOTableDef, etc. If you need samples, please let me Know..... Best Regards!!!! Carlos Antollini. Re: What database should I use? Michael Martin4-Sep-01 15:35 Michael Martin 4-Sep-01 15:35  My descriptive powers of the written word have failed me again, I'm a moron. What I was trying to say was - When creating a database from within Access itself I couldn't just name the tables and fields they contained anything I wanted, a wizard kept getting in my road and pissed me off so much I went to SQL Server which was overkill. I will pul my head in, try all this again and learn to express my question better next time. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018 "Don't belong. Never join. Think for yourself. Peace" - Victor Stone About ADO Connection ? 3-Sep-01 8:48 3-Sep-01 8:48  Hello ! Which is better ? *** Create one ADOConnection at start point, and use it globally in program or *** Create an ADOConnection whenever and everywhere needed tanks Re: About ADO Connection ? Gerald Schwab3-Sep-01 9:23 Gerald Schwab 3-Sep-01 9:23  Create an ADOConnection whenever it's needed. Re: About ADO Connection ? Mehrdad6-Sep-01 0:13 Mehrdad 6-Sep-01 0:13  Hello Gerald Schwab ... your answer is good!, but Creating an ADOConnection whenever it's need, may slow down my application, isn't it ? tanks! Re: About ADO Connection ? Carlos Antollini3-Sep-01 10:24 Carlos Antollini 3-Sep-01 10:24  Is better to use the adoconnection like a global variable for your application, but you must open the adoconnection when you need, and leaving that connection open, for future use, and closing the connection when you close the Applictaion. But if your applictation need to use the connection every a long time, is better open the connection every time that you needm, but always leaving the connection like a global function. Cheers.... Carlos Antollini. Re: About ADO Connection ? Mehrdad6-Sep-01 0:42 Mehrdad 6-Sep-01 0:42  Hello Carlos Antollini .... your answer is good, too ! but, I have problem with that when I use Transaction with Option_Explicit set to ON. In some cases i should restart my application. Re: About ADO Connection ? Carlos Antollini6-Sep-01 3:05 Carlos Antollini 6-Sep-01 3:05  You are working with VB? Regards!!!! Carlos Antollini. Re: About ADO Connection ? Mehrdad18-Sep-01 9:07 Mehrdad 18-Sep-01 9:07  Hello, Carlos Antollini ! No,... I'm working with Delphi 5.0 Regards!!!! Re: About ADO Connection ? Carlos Antollini18-Sep-01 9:44 Carlos Antollini 18-Sep-01 9:44  I'm Sorry, I don't Know Nothing About Delphi.... But If you use the Connection like a Global Variable, You don't must to forguet to close the connection, when Close the Application. For other part, I don't Know what happens in Delphi. I'm Sorry Again.... Best Regards!!!! Carlos Antollini. Re: About ADO Connection ? Mehrdad20-Sep-01 8:53 Mehrdad 20-Sep-01 8:53  Hello again, Carlos Antollini ! Tanks for your helps. Regards!!!!;) Mehrdad. XML Support in SQL Server - does ANYONE use it? Nick Blumhardt2-Sep-01 21:42 Nick Blumhardt 2-Sep-01 21:42  ... trying to get a FOR XML rowset back out through ADO/ASP now, and its becoming a nightmare! strings I select like this: SELECT '<hello/<' are just great, but something simple like: SELECT blah FROM blogg FOR XML AUTO, ELEMENTS gives me rubbish, like: ?colname??L?anothercol?a??somethingelse?andmoreshite which isn't making much sense to me, unless its a UNICODE problem... thanks in advance if anyone can help Nick Firehose mode error Not Active1-Sep-01 17:56 Not Active 1-Sep-01 17:56  I have an ASP page in which I am trying to start a transaction <br /> var Conn = Server.CreateObject("ADODB.Connection");<br /> Conn.Open("MyDB");<br /> Conn.BeginTrans();<br /> Conn.Execute("sp_InsertNew " + name);<br /> The stored proc, sp_InsertNew, as you would imagine just inserts a record into a table When I try this I get the error, "Transaction cannot start while in firehose mode." MSDN says this is a bug with SQL Server 2000 and the Enterprise Manager. The problem is I am trying this with an ASP page and ADO connection. Can anyone shed some light on this? ADO Errors _Magnus_31-Aug-01 0:54 _Magnus_ 31-Aug-01 0:54  Im using ADO to access an SQL server and everything is working ok except for when an error occurs. Then the description and source properites in the error object is *always* null. The native error number is how it should be. Anyone got a clue what could cause this? (we also access the db with MFC and ODBC and there the description is correct) /Magnus Re: ADO Errors Rashid Thadha31-Aug-01 3:08 Rashid Thadha 31-Aug-01 3:08  Send your code snippet so we can have a look at what you are doing wrong Re: ADO Errors _Magnus_31-Aug-01 4:03 _Magnus_ 31-Aug-01 4:03  Here is the codesnippet used to get the error. The _ConnectionPtr passed in is either the connection pointer used to execute the command or gotten from _RecordsetPtr->GetActiveConnection() NativeError contains a valid number as said but all strings are NULL. void EmitError(_ConnectionPtr piCon) { if(piCon == NULL) return; ErrorsPtr ptrErrors = piCon->Errors; if(ptrErrors == NULL) return; long lCount = ptrErrors->Count; ErrorPtr ptrError = NULL; CString sError; for(long n = 0; n < lCount; n++) { ptrError = ptrErrors->GetItem(n); if(!(ptrError == NULL)) { LogEmit("%s\nState: %s, Native: %d, Source: %s\n\n", (LPCTSTR)_bstr_t(ptrError->GetDescription()), (LPCTSTR)_bstr_t(ptrError->GetSQLState()), ptrError->NativeError, (LPCTSTR)_bstr_t(ptrError->GetSource()) ); } } } /Magnus

Last Visit: 31-Dec-99 18:00     Last Update: 22-Sep-24 13:34 Refresh ᐊ Prev1...2450245124522453245424552456245724582459 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

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