Database

FirstPrevNext

Access 2000 ODBC weirdness Michael Martin22-Feb-02 12:14 Michael Martin 22-Feb-02 12:14  Wrote a front end in VC++ to a small Access 2000 database utilising ODBC. When I add a new row to a table and then read through the table again to display the contents on screen the new row is missing. If I read the table a second time the new row is there. I Open and Close the database connection after each action so I don't believe that I am reading the data from cache. Any idea why the new row is missing when I read throught the table immediately after adding the row? Michael Martin Australia mmartin@netspace.net.au "Don't belong. Never join. Think for yourself. Peace" - Victor Stone SQL Server Transact SQL Michael Martin22-Feb-02 12:13 Michael Martin 22-Feb-02 12:13  Just wondering what I need to add to a VC++ program to allow me to directly access an SQL Server database using Transact SQL. Is there an SQL Server SDK? Michael Martin Australia mmartin@netspace.net.au "Don't belong. Never join. Think for yourself. Peace" - Victor Stone Re: SQL Server Transact SQL Li Mu Bai25-Feb-02 4:27 Li Mu Bai 25-Feb-02 4:27  You could add an ADO class found in CodeProject somewhere and in there you can create strings which consist of your T-SQL then you get a recordset back. you dont need an sql sdk. I hope thats what you wanted;) The Wudan Master Re: SQL Server Transact SQL Cliff Dabrowski25-Feb-02 5:06 Cliff Dabrowski 25-Feb-02 5:06  ADO or ADO.NET (as required) are excellent choices. If however you are looking for more low level access then take a look at DBLib. This is the native accessibility layer for SQL*Server. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vcsample98/html/vcsmpdblib.asp Success is measured by ones ability to mask complexity with simplicity. Re: SQL Server Transact SQL Carlos Antollini25-Feb-02 4:58 Carlos Antollini 25-Feb-02 4:58  You can use the dbengine of sql server or my ado classes Regards.... Carlos Antollini. Sonork ID 100.10529 cantollini I have yet to meet a C compiler that is more friendly and easier to use than eating soup with a knife. Oracle on Unix Paul Selormey18-Feb-02 19:56 Paul Selormey 18-Feb-02 19:56  Hello All, This is a pure newbie question on use of Oracle database. I need to design a system to access Oracle database on a Windows client. We only have Oracle installed on Windows server. Can someone help me with the options available, if any? Do I have to install a client version on the Windows machine? Will the client version access the database on Unix Machine? Any another information will be highly appreciated. Best regards, Paul. Paul Selormey, Bsc (Elect Eng), MSc (Mobile Communication) is currently Windows open source developer in Japan. Re: Oracle on Unix sergunya5-Mar-02 20:55 sergunya 5-Mar-02 20:55  You should install oracle client on every machine from wich you will connect to Oracle. Location of Oracle (WinNT or Linux) is not important. You just have to configurate tnsnames.ora files on client machines. Usual practice is design single Oracle client driver that will communicate with Oracle and all client applications will communicate with him. So you don't need to install oracle client on all machines, but you need to realize your own transport protocol to communicate client applications and your driver. Good Luck, Serge Re: Oracle on Unix Paul Selormey5-Mar-02 21:46 Paul Selormey 5-Mar-02 21:46  Thanks so much for the information. I am also looking at the 9i internet features too. The main problem was that the customer was limiting us to only HTTP access of the database. Best regards, Paul. Paul Selormey, Bsc (Elect Eng), MSc (Mobile Communication) is currently Windows open source developer in Japan. Cursel type and datagrid Mazdak18-Feb-02 5:13 Mazdak 18-Feb-02 5:13  Hi guys: I have two question about ADO.Net 1.How or where can I set the "Curser type"? 2.I have datagrid that connect to database with sqlDataAdapter,and sqlConnection. In VC++ I could set the propety of grid to 'Allow Update' or 'Allow Delete' 'AddNew', Now in ADO.Net how can set the grid as "Updatable" or "readonly"? Thanks Mazy Don't Marry a Person You Can Live With... Marry Someone You Can Not Live Without Re: Cursel type and datagrid Andres Manggini20-Feb-02 16:15 Andres Manggini 20-Feb-02 16:15  I don't think you'll find that property, if you use a DataSet it will be always Client Side <help> Property Value true if the grid is in read-only mode; otherwise, false. The default is false. Remarks In read-only mode, the grid can be scrolled, nodes can be expanded or collapsed, and so on, However, no additions, edits, or deletes may take place. The DataGridColumnStyle also has a ReadOnly property that can be set to true to prevent data from being edited, on a column-by-column basis. The ReadOnly may be set to true if you want to prohibit the user from editing the data directly in the DataGrid. For example, you may want to let users to see all columns in a table, but allow them to edit specific fields only through TextBox controls on a different form. Andres Manggini. Buenos Aires - Argentina. Re: Cursel type and datagrid Mazdak20-Feb-02 19:36 Mazdak 20-Feb-02 19:36  thanks Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 SQLFetchScroll / SQLExtendedFetch ->? Sander13-Feb-02 4:50 Sander 13-Feb-02 4:50  Please read the message ExecuteSQL -> ? first. I learned yesterday that ExecuteSQL doesn't return colums, and used the following lines of code to execute a SQL statement: CRecordset sg; sg.Open(CRecordset::snapshot, _T("SELECT * FROM Leden ORDER BY Voornaam")); But when I call the function which will execute this code , I get an error, and it says that I have to call the SQLFetchScroll / SQLExtendedFetch method first, but... how? Re: SQLFetchScroll / SQLExtendedFetch ->? Mazdak13-Feb-02 5:15 Mazdak 13-Feb-02 5:15  I'm not sure but I think you have to first bind CDatabase to CRecordset: CDatabase aDB; aDB.OpenEx(_T("DSN=test"),CDatabase::openReadOnly | CDatabase::noOdbcDialog); CRecordset aRS(&aDB); aRS.Open(CRecordset::forwardOnly,"SELECT *from Table1"); Mazy Don't Marry a Person You Can Live With... Marry Someone You Can Not Live Without Concept behind SQL Server alex.barylski12-Feb-02 20:06 alex.barylski 12-Feb-02 20:06  Can somebody give me an explanation of how the SQL server works and compared to say Access...? This much I know: SQL is a language used for manipulating, reading, sorting the database. Where is the SQL engine...? Is it part of the Access program...? or part of the metadata in the Database...? Are the SQL commands stored in the DB..>? SQL Server runs much faster than Access, cuz it's designed to take advantage of Server hardware(Raid disks, 2 processors, etc) where as access is normal window app designed for client computers. how does an access DB differ than a SQLServer DB..>? They both can execute the commands right..? Do they share the same file structure...? Is SQL Server a application..? Can the SQL Server used Access DB through a driver like ODBC...? These are just some questions i have regarding DB technology. If i'm in the wrong forum...my appologies...if i'm incorrect about anything...my appologies Cheers "An expert is someone who has made all the mistakes in his or her field" - Niels Bohr Re: Concept behind SQL Server Mazdak12-Feb-02 20:33 Mazdak 12-Feb-02 20:33  Check this Mazy Don't Marry a Person You Can Live With... Marry Someone You Can Not Live Without Re: Concept behind SQL Server alex.barylski12-Feb-02 22:18 alex.barylski 12-Feb-02 22:18  I have that book already actually... "An expert is someone who has made all the mistakes in his or her field" - Niels Bohr Re: Concept behind SQL Server Mazdak12-Feb-02 22:34 Mazdak 12-Feb-02 22:34  If you read first day of that book you'll notice that there is good comparsion between SQLServer and Access.SQLSever is faster than Access and better when want to write database in large scale for server and clients. Let me give you more details: You want to use this command:"SELECT * FROM anything WHERE something" your database has 500,000 records,when you execute this command,Access first first return all 500,000 records to the client and then client filter it,but SQLServer send command to server,server filter records and only return proper records,you this is really affect on speed.(your process happend on server.) Also Access databese size has more limitation than SQLServer . HockeyDude wrote: Where is the SQL engine...? Is it part of the Access program...? I'm not sure but I don't think that is correct. Hope that helps you Mazy Don't Marry a Person You Can Live With... Marry Someone You Can Not Live Without Re: Concept behind SQL Server alex.barylski12-Feb-02 23:58 alex.barylski 12-Feb-02 23:58  Mazdak wrote: You want to use this command:"SELECT * FROM anything WHERE something" your database has 500,000 records,when you execute this command,Access first first return all 500,000 records to the client and then client filter it,but SQLServer send command to server,server filter records and only return proper records,you this is really affect on speed.(your process happend on server.) I remember that much, but do Access and SQL Server has the ability to use the same DB...? Is the Access file format the same as SQL Server...? probably not right..? So you would need a go between driver wouldn't you...? ODBC, this was developed to solve this very problem correct..? However it seems ADO is the way to do thing now, so what I really wanted to do was. Create a DB in Access, cuz it's all I have on my client computer. upload it to a website...but use SQLServer to access and return recordsets...? The Server would require the special SQLServer software (MySql) whatever right..? But can these (Say i use Perl's DBI) which I think uses ODBC and MySql...??? Can scripts I write in Perl/ASP access Access DB...??? I hope I made myself clear...it's really early morning here and I'm quite tired.. Cheers! "An expert is someone who has made all the mistakes in his or her field" - Niels Bohr Re: Concept behind SQL Server markkuk13-Feb-02 0:32 markkuk 13-Feb-02 0:32  HockeyDude wrote: The Server would require the special SQLServer software (MySql) whatever right..? MySQL has nothing to do with Microsoft SQL Server, I thought you were asking about MS SQL Server? You can use DBI to use any database with an ODBC driver, including MS Access. You can't use MySQL to handle Access database files. Re: Concept behind SQL Server alex.barylski13-Feb-02 2:05 alex.barylski 13-Feb-02 2:05  Isn't MySql like SQLServer, but freeware...? "An expert is someone who has made all the mistakes in his or her field" - Niels Bohr Re: Concept behind SQL Server markkuk13-Feb-02 2:35 markkuk 13-Feb-02 2:35  MySQL is like MS SQL Server in the same way as Linux is like Windows XP. Re: Concept behind SQL Server alex.barylski13-Feb-02 2:47 alex.barylski 13-Feb-02 2:47  So one is super charged the other is freeeware...i know this...but unless your developing enterprise solutions, couldn't you get away with MySQL...? SQL Server i've heard is like typical MS product $$$$ For web development...do some web hosting services already supply SqlServer on there Server...? And charge you monthly fees...? Even with this solution i'd need cheaper than that...so i'm thinkiing MySql would be best "An expert is someone who has made all the mistakes in his or her field" - Niels Bohr Re: Concept behind SQL Server Mazdak13-Feb-02 1:37 Mazdak 13-Feb-02 1:37  Good morning(or afternoon)! HockeyDude wrote: but do Access and SQL Server has the ability to use the same DB...? no,but SQLServer(MS SQLServer) can import database from Access or any other type, to SQLServer DB or any other kind like visual foxpro ,even Excel or text file.But it can not use .mdb(Access) file directly,just import and export. I don't know if it is possible to do this in program with codes. HockeyDude wrote: Create a DB in Access, cuz it's all I have on my client computer. upload it to a website...but use SQLServer to access and return recordsets...? The Server would require the special SQLServer software (MySql) whatever right..? It's not very clear for me,but I think you can't do all these things in one file.(as I said above) HockeyDude wrote: Can scripts I write in Perl/ASP access Access DB...??? I've never test it but I don't see any reason that they can't access Access DB.(.mdb file). Mazy Don't Marry a Person You Can Live With... Marry Someone You Can Not Live Without Re: Concept behind SQL Server alex.barylski13-Feb-02 2:18 alex.barylski 13-Feb-02 2:18  Good enough then. I'll have to go do some more reading when time permits and maybe come back with more questions. Til then!! "An expert is someone who has made all the mistakes in his or her field" - Niels Bohr Re: Concept behind SQL Server Mazdak13-Feb-02 2:11 Mazdak 13-Feb-02 2:11  HockeyDude wrote: Can scripts I write in Perl/ASP access Access DB...??? I found it,you can Mazy Don't Marry a Person You Can Live With... Marry Someone You Can Not Live Without

Last Visit: 31-Dec-99 18:00     Last Update: 2-Jul-24 8:46 Refresh ᐊ Prev1...2439244024412442244324442445244624472448 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.