Integrate with database on webserver

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - DataView.Sort loses ASC/DESC value I use a DataView object as the datasource for an ASP.NET DataGrid. I am seting the DataView.Sort member with a column name and a direction, eg: dvEmp.Sort = "emp_name DESC"; This works fine, but when I post back to the page and look at the dvEmp.Sort value, it only contains "emp_name", and appears to have discarded the " DESC" specifier. Despite this, the dataview is actually sorted correctly in descending order. What gives? John H. Tag: Integrate with database on webserver Tag: 85971
  - 2
    - DataSet and updating Ok. I have a table with a primary key being an integer. When using VS.NET 2002, it could not create an update command for my table. Being SQL savvy, I created my own update statement below Me.SqlCommand4.CommandText = "UPDATE dbo.links_page SET (title=@title, imageurl=@imageurl) WHERE (link_page_id = @link_page_id); SELECT title, link_page_id, imageurl FROM dbo.links_page It is bound to the SqlDataAdapter I created. When I add a new record, it is getting the proper auto-increment values, and when I execute .Update(myDataSet), the record is added to the database table But after that record is added, it gives me a constraint error. Apparently, it is having a problem with records that are already in the table. It looks like it is attempting to insert copies of them into the table (which violates my primary key. The exact error is Column 'link_page_id' is constrained to be unique. Value '2' is already present How do I fix this problem Tag: Integrate with database on webserver Tag: 85963
  - 3
    - Automatically Convert DB Type to .NET Type Is there an API to convert from a Database type to a .NET System type. I could create a switch statement using the info here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconmappingnetdataproviderdatatypestonetframeworkdatatypes.asp but was really hoping not to have to do this. Thanks, Dave Tag: Integrate with database on webserver Tag: 85962
  - 4
    - size problem with ole object data type (blob) and ado.net Hi there, I've a strange problem with ado.net and an Access db. I need to create a little C# app that take the content of "ole object" field and then save it into a file. The problem is that when I do the following Byte[] byteBLOBData = new Byte[0]; byteBLOBData = (Byte[])(ds.Tables["tblRefAlbum"].Rows[0]["photo"]); I get the exact double of the original size! and if I save this array byte to a file I'll get my file with every two byte set to 00. The result is, of course, not an image. I've tryed to manipulate my array of byte to strip every two bytes but the result is an visible image but not the correct image (it's a scrambled image that appears). Please help, I really need to do this exportation of picture in .net with the access db. Thanks a lot for people whom can help me. Tag: Integrate with database on webserver Tag: 85957
  - 5
    - Oracle Connectivity Issues Angel Saenz-Badillos[MS] wrote: > the bad pool will clean itself out in 4-8 minutes. Uhm.... I tried but it don't seem be good. With the example code posted, after the 5th session-killing, i get a loop with "Connecting... Exception: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.". I waited 20 minutes, but nothing changed..... .net framework 1.1, microsoft provider for oracle, oracle 9.2. Bye Diego Tag: Integrate with database on webserver Tag: 85956
  - 6
    - Can this be done?? Hi Sirs Is it possible to create a transaction which inserts data into a table in such a way that all the inserted rows are NOT visible to other processes accessing the same table until the transaction commits the data?? Thanks in advance Regards Morten Tag: Integrate with database on webserver Tag: 85953
  - 7
    - using DataSet to transport data as XML Hi, I have two exacts databases, but phisically distant and without direct connection. I want data be transported from one place to another. The process that i'm doing to achieve that is loading a DataSet from source database, writting schema to an XSD file, writting data to an XML file sending them by any mean (email as first attempt) and in the other point, receiving the XMLs, loading DataSet and update to a destination database. I have done almost everything , but i have troubles with the last part of the process. How i can say that the changes in the DataSet must be updated in the destination database? Will i have troubles with the relations of the tables ? Regards, José. Tag: Integrate with database on webserver Tag: 85949
  - 8
    - check database exists Hi How do I check whether a database exists before attaching a database Thankx in Advance Priya Tag: Integrate with database on webserver Tag: 85940
  - 9
    - Function, datagrid and findcontrol <ItemTemplate> <asp:HyperLink id=HyperLink2 runat="server" CssClass="LABELGAUCHE" NavigateUrl='<%# funcSite(DataBinder.Eval(Container, "DataItem.WebSite")) %>' Target="_blank">Visit the Website</asp:HyperLink> </ItemTemplate> i want in the function funcSite put hyperlink2.visible = false if there is not a website But i can't find the control. My datagrid name is dgWebSite Thx -- Ceci est une signature automatique de MesNews. Site : http://mesnews.no-ip.com Tag: Integrate with database on webserver Tag: 85933
  - 10
    - OleDb vs Odbc for access database? Hello, I am creating a program that usese MS access database, is it better to use OleDb with Jet provider or is it better to use Odbc? what is the difference betwen them? Alex Tag: Integrate with database on webserver Tag: 85928
  - 11
    - SQLException timeout I am using the .NET SQLData Provider for accessing data from an SQL Server 2000 SP3 Server I have an SQLDataAdapter that it is being provided an appropriate constructed SQLCommand object. The Command's object Timeout Property has been set to 0 i.e. "do not timeout". However, when I am using the SQLDataAdpter Fill method with a DataSet as parameter A and a TableName (string) as parameter B in some cases I get an SQLException with the error code -2 (i.e. timeout). This is not a reproducible behaviour. It usually happens in our customers sites. Just to help you, it cannot be a problem of locks and SQL Server's overload because we run the process that fills in the dataset when nobody else is connected to the SQL server thus it cannot be neither a concurrency problem (locks) nor sql server's overload because there only one user in the server logged in Could you please help me on this. In order to overcome the problem I put a loop of 30 retries to fill the dataset prior to letting the exception be thrown to the caller stack and even with this patch I still have cases that the fill fails to execute with a time-out error What can I do to solve the problem? Is there another property that I can set in the SQL ADO.NET Objects (I had also set the connection timeout to 0) HINTS 1. When the SQLException with the -2 error is thrown the Fill command did not wait a little bit (not even 60 secs). It looks like the error has been immediately sent from the server. 2. The query that I am using in the SQLCommand object is a liitle bit complex (it has aggregate functions, scalar columns and complex WHERE condition that uses xxx IN (SELECT YYY ...). Might be the case that the time out comes from the SQL Preprocessor 3. I put an index in a sensitive column and the exception vanished !! 4. However, this cannot be the solution. I want my queries to execute and my code wait until the execution completes without having to worry about query optimization which is something that will come in next phase of tunning Thank you in advance Stavros K Menegos Tag: Integrate with database on webserver Tag: 85916
  - 12
    - Dataset to Access DB How can I insert all records from a DataSet to an Access Table. Thanks Tag: Integrate with database on webserver Tag: 85897
  - 13
    - Advice on connections Is it possible to have an ado.net connection object that would connect to both SQL Server 2000 and Oracle. Thanks, Will. Tag: Integrate with database on webserver Tag: 85896
  - 14
    - Nulls from msaccess to Vb.Net I've written the following and found that the ISNULL function is not working properly. I want to be able to query the Firstname record from an access database and have it return a string of my preference when the Firstname field is null. I found that this is isn't happening. Under transact-sql ISNULL is to have a replacement parameter and find that I receive a wrong parameters error message with my code. I've tried using the nz command for msAccess and I receive a function not found error. Is there a way to return a string for a null value from vb.net querying an access database?. My code is below Dim x as strin Dim conn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Test.MDB" x = "SELECT Name, ISNULL(FirstName,'John') From MyTable Dim cmd As New OleDb.OleDbCommand(x, conn Dim rdr As OleDb.OleDbDataReade Tr conn.Open( rdr = cmd.ExecuteReade repeaterOrderDetails.DataSource = rd repeaterOrderDetails.DataBind( rdr.Close( conn.Close( Catch ex As Exceptio Response.Write(ex.Message Response.End( Finall If conn.State = ConnectionState.Open The conn.Close( End I End Tr Tag: Integrate with database on webserver Tag: 85895
  - 15
    - can't find a downed server even when it comes back up. Pooling problem? I have a program that looks for remote SQL Servers and pulls information off of them every x minutes. It's possible that the DSL connection to one of the servers can be down for an extended period of time. If that happens, I have good exception handling and logging so that it doesn't try to pull data off of that server. I'm experiencing a problem when a server is down for some period of time, but then comes back up. The problem is that the application immediately fails after trying to open the connection, like it doesn't even try to open it. If I stop and restart my program (it's a .NET program running as a Windows service), then it detects that the server is back up and starts working. One other note - if I change a config file so that the server name is the IP address of the server, OR from IP address back to server name, then the program detects that the server is back up and starts pulling data again. (meaning - I change connection string to something else and the program detects the server is back up). Could this be some sort of connection pooling issue? I need my program to detect when the server comes back up and start pulling data without manual intervention. matt tag Tag: Integrate with database on webserver Tag: 85883
  - 16
    - testing for "" blank nulls vs 2002/xp pro/win forms/MS access 2002 I want to query my database where fieldA = "" (Blank) Select MYDB where fieldA = "" or Blank or Null What is the correct syntax for checking for "" blanks nulls thanks Tag: Integrate with database on webserver Tag: 85874
  - 17
    - Problems instantiating a DataSet from XML schema In a standard Windows project, I created a couple of xml schema and used the generate data set tool under the schema menu. I could then view the schema as data sets and they look right - so far so good. However, when I try to instantiate them by dragging a data set onto a form, as described in the help files, I have problems. The IDE correctly lists the xml schema under typed datasets, but when I hit OK I get told that VS can't instantiate the data sets. Underneath it says to build the solution, fix any errors and try again. I build - get no errors or warnings - but when I go through the process again I get the same error message. What am I missing? Tag: Integrate with database on webserver Tag: 85862
  - 18
    - DataSet.Merge - Expressions not recalculated - Known Bug? When merging a DataSet, if the the DataSet being merged into contains an expression column and the DataSet merging does not, then the expression column is not evaluated for new rows (they are DBNull). Of course, I strip the expression column before updating because of the other bug that causes DataAdapter Update to blow up if an Expression column is present, so this causes the aforementioned bug to occur. Is this a known bug? The workaround is to reset the column.Expression property after a merge. Cole Tag: Integrate with database on webserver Tag: 85859
  - 19
    - Execute requires the command to have a transaction object when the connection assigned to the command is in a pending local transaction Hi there, I have this code to select and insert data into the database. It all works fine if i don't use a transaction but if i do i get the message: Execute requires the command to have a transaction object when the connection assigned to the command is in a pending local transaction. What a i doing wrong here, please help! Dim insertCmd As New SqlCommand Dim myTransaction As SqlTransaction Dim selectAll As New SqlDataAdapter insertCmd.Connection = New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString")) insertCmd.Connection.Open() myTransaction = insertCmd.Connection.BeginTransaction("L1") insertCmd.Transaction = myTransaction Dim t As Integer sqlstring = "Select * from TAanvraagTekening where aanvraagid = " & ds.Tables(0).Rows(i).Item("AanvraagId") & "" selectAll = New SqlDataAdapter(sqlstring, insertCmd.Connection) selectAll.Fill(dsAll) <-----HERE THE CODE FAILS! For t = 0 To (dsAll.Tables(0).Rows.Count - 1) insertCmd.CommandText = "INSERT INTO TAanvraagTekening(AanvraagId,TekeningId,TekeningUitgave,TekeningDatum" & _ ") Values(" & tmpAanvraagId & ", " & dsAll.Tables(0).Rows(t).Item("TekeningId") & ", '" & dsAll.Tables(0).Rows(t).Item("TekeningUitgave") & "'" & _ ",'" & IsoDate(dsAll.Tables(0).Rows(t).Item("TekeningDatum")) & "')" insertCmd.ExecuteNonQuery() Next ....... more code...... myTransaction.Commit() Thnx in advance! Victor Tag: Integrate with database on webserver Tag: 85856
  - 20
    - Attention William Ryan eMVP Bill, You were helping on a thread in this group: "Typed Dataset Problem" and posted a reply to your post and I was hoping that you could reply to it. Thanks Tag: Integrate with database on webserver Tag: 85855
  - 21
    - Resizing rows height in a WindowsForms DataGrid automatically Hi Does the WinForm DataGrid has a property that enables it t increase the height of certain rows automatically, in case whe in those rows, some cells contain text that cannot fit inside of them so instead of just trimming the text, the whole row's heigh increases? Something similar in concept to what an HTM table does. If not, is it possible For example CustomerName|CustomerPhone ------------------------------------- ShortName | 000-0000000 ------------------------------------- This is a very | 001-0000000 long name | ------------------------------------- ShortName2 | 003-2222000 ------------------------------------- Thank you so much for your time :) Tag: Integrate with database on webserver Tag: 85851
  - 22
    - ANN: SocketPro -- A framework implemented with batching/queue, asynchrony and parallel computaion Hi, All: I am happy to annouce that we have released our latest SocketPro version 4 (in beta), an advanced framework written from batching/queue, asynchrony and parallel computation. Key Benefits of SocketPro: Super performance It is a guarantee that SocketPro based client-server applications beat all of .Net remoting, DCOM, COM/Surrogation, MTS/COM+, Corba, Java RMI and Web service in speed UNDER ANY CASES! No joke! Lots of unique features None of common frameworks can provide more features than SocketPro. Many of SocketPro features are unique, which can not be implemented in other frameworks and are found ONLY in SocketPro. Simple to use SocketPro completes all of common distributed application tasks. The latest version of SocketPro can match with anyone of common distributed application frameworks in simplicity. Notification service SocketPro implements a built-in notification service, which enables you to notify a message to one or more clients either from a remote server or from a client. Different programming experience and lots of fun SocketPro is written from batching, asynchrony and parallel computations. You can get a totally different programming experience with lots of fun, and will have no or much less multithreading and event problems to bother you! Accessing your data securely anywhere over all of types of networks, Dial-up, cable, DSL, Wireless modems, and LAN SocketPro is created for internet development with all of types of networks. You can share your databases, files, and messages over all of types of networks. You can even use a phone line modem to access these data with decent speed. Secure Embedded with openssl to secure all of data transaction between clients and servers, beginning with the version 3.0.0.1. Support all of COM-enabled development languages for client applications SocketPro comes with a set of COM objects exposing IDispatch-derived interfaces. It can be used with all of COM-enabled development languages. Support lots of development languages for server applications The latest version of SocketPro supports not only C/C++ with all of compilers available but also dotNet languages. SocketPro supports all of development languages capable of handling window callbacks and threads. Great interoperability Unlike common distributed frameworks, SocketPro has great interoperability among many different development languages. For example, you can easily let old VB code communicate the latest dotNet managed code. Support multiple services with one port As shown in samples, SocketPro server provides different services with one TCP/IP port. You can easily add your services into a SocketPro server. All of services can be switched at run time. SocketPro can be free to you Within a limited time period, you can get a copy of SocketPro for free! -- Yuancai (Charlie) Ye Fast and securely accessing all of remote data sources anywhere with SocketPro using batch/queue, asynchrony and parallel computation See 30 well-tested and real OLEDB examples RDB, a tool for fast and securely accessing remote databases with dial-up, cable, DSL and wireless modems anywhere www.udaparts.com Tag: Integrate with database on webserver Tag: 85845
  - 23
    - Distributed transaction completed errors I am encountering SQLClient errors in a COM+ object (spawned from Biztalk) that extracts data from an xml document and updates a SQL table (version 2000 8.00.760 SP3) Under a fairly low load of documents, there seems to be no problems, but with several messages to process, these errors start to stack up. I also see "SqlConnection does not support parallel transactions. I am only using one SQL connection, one stored procedure - and one SQLTransaction that may be called a couple of times throughout the process Any advice will be greatly appreciated Troy Tag: Integrate with database on webserver Tag: 85840
  - 24
    - Double or float - make your mind up! I use floats in SQL server as they are its standard datatype for dealing with non-integral numbers I thus thought it would be logical to use the SqlDbType.Float for accessing parameters of this type in ADO.NET, from C# However, when I declare an SqlParameter with SqlDbType.Float as its datatype, its Value property after the command has executed can't be cast to a float, only a double. I'm OK with this if this is what the DB engine wants to do - but is it really correct?????? I know I could cast to a float but would there be much point if I'm only doing comparisons, not much maths. I'm mainly after fast performance Thanks! Tag: Integrate with database on webserver Tag: 85818
  - 25
    - Fastest db methods? Could someone tell me which is faster, or no difference, between Which is the fastest out of the following two methods?? Reading a recordset using SqlDataAdapter.Fill(a_dataset) / reading a recordset using SqlDataReader ?? Which is the fastest out of the following two methods?? Reading a recordset using SqlDataAdapter.Fill(a_dataset) / reading a recordset using SqlDataReader *after* doing an ExecuteNonQuery on the same command (after changing an in parameter's value to enable the SQL to be optimized) in to glean output parameters (which need to be used during the reading of the records Which of the following three is faster, or none at all?? Accessing fields using dr.GetInt32(0) / dr["fieldname"] / or dr[0] ?? Tag: Integrate with database on webserver Tag: 85817
- Next
  - 1
    - C# oracle connectivity Consider a situation that i need to connect to a remote oracle database using a ASP.NET interface. I dont have the access to change the TNSname.ora file. In that case, how can i connect to oracle using the following information: 1. Network Address 2. Port 3. SID 4. User Id 5 Password Java does allow this. But the .NET connection string using both ORAClient or Microsoft's Oracle native driver, doesnt allow me to do that. Any body who can help me on this.? --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. Tag: Integrate with database on webserver Tag: 85815
  - 2
    - Still unable to connect to SQL database on non-development machine Hi I have still not been able to sort out the issue of a non-development machine not being able to open a connection to an SQL database. Aaron, if you read this thanks for any help you can/could give me The details are as below My connection code is (using VB.net): myConnection = New SqlConnection("data source=SPEEDY;initial catalog=OpsAdminTest;integrated security=True" MessageBox.Show("connection string: " + myConnection.ConnectionString MessageBox.Show("myConnection.Database: " + myConnection.Database MessageBox.Show("myConnection.DataSource:" + myConnection.DataSource MessageBox.Show("myConnection.Workstationid:" + myConnection.WorkstationId Tr myConnection.Open( Catch ex As Exceptio MessageBox.Show("Error opening connection" End Tr MessageBox.Show("finished initialization" This is done immediately after the InitializeComponent() call in the application When I compile/release the code for installation and then install on the same machine that I developed it on, it works fine. But when I install on the non-development machine, it fails to open the connection >Are you using DSN, if so, is there an appropriate DSN connection on the non development machine The non-development machine has the SystemDSN connection to the OpsAdminTest database as it is an active database that we use for test developement of other services. My company does interactive voice services for various tv/radio/magazines and we use SQL to maintain the services >Are you using Windows or SQL authentication We are using windows authentication for the SystemDSN connection to the database >Have you used SQL Profiler to see if you are even touching the SQL server Sorry this question eludes my limited knowledge. How would I use SQL Profiler in my code to see if I am connection to the server Again, thanks for any help Tag: Integrate with database on webserver Tag: 85809
  - 3
    - Real Simple Insert - doesn't work Hey Trying to do a real simple online Newsletter form - an Insert into a SQL Server DB, but when the submit button is pressed, the page refreshes, but nothing is added to the DB. Code Dim ConDB As SqlConnectio Dim strINSERT As Strin Dim cmdINSERT As SqlComman ConDB = New SqlConnection("Persist Security Info=False;User ID=xxx;password=xxx;Initial Catalog=xxx;Data Source=xxx" strINSERT = "INSERT Newsletter " & "(FName, SName, Email) " & "Values ('" & Fname.Text & "','" & Sname.Text & "','" & Email.Text & "') cmdINSERT = New SqlCommand(strINSERT, ConDB ConDB.Open( cmdINSERT.ExecuteNonQuery( ConDB.Close( appreciate your assistance guys. Tag: Integrate with database on webserver Tag: 85803
  - 4
    - How to determine that rows on server changed and dataset needs to be updated ? Hi, I'm starting using ADO.NET and trying to understand if there is any analog of Server side cursor in ADO.NET. Using ADO i could just open recordset with serverside cursor and adOpenDynamic options. Then if another user has changed values on the server while recordet is opened, i got updated records automatically. In ADO.NET i couldn't find the way to implement this future. Is there any event or something else that informs program that records on the server had been changed ? Best Regards, Giga. Tag: Integrate with database on webserver Tag: 85801
  - 5
    - solve my problem (Type your message here) Hi all, Now I am doing my project using VC++/MFC and sql server as a database.I hava to store the Bitmaps in the database.If anybody knows about how to store the bitmap in the sql server as a BLOB object & retrive it.please help me it is urgent. -------------------------------- From: Ramesh Kumar ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>Dv3OrgDiFEaF9UAPoH2Etg==</Id> Tag: Integrate with database on webserver Tag: 85800
  - 6
    - Updating datagrid display using custom collection I'm having problems refreshing a DataGrid that a custom business object collection (PeopleCollection) is binded to. The PeopleCollection class maintains a collection of PersonInfo items. The PeopleCollection class inherits from CollectionBase and implements IBindingList. The PersonInfo class implements IEditableObject and IDataErrorInfo. What I have so far, is when a user double clicks a row on the DataGrid a 'Person Details' form is displayed showing the details of the person selected. The details of the person may be changed via textboxes on the form. This works well. Problem is if the user changes, say, the name of the person on the form and clicks the OK button the Person Details form is closed, but the new name is not displayed in the DataGrid (it still displays the old data). I know the new name is propagated to the PersonInfo object cause if I click on the row that was changed by the form the DataGrid decides to refresh itself, therefore displaying the new name. So, how do I update the DataGrid when the PersonInfo object is updated? I know the PersonInfo object should be notifying the PeopleCollection object, which should then raise the ListChanged event. The DataGrid updates nice and well on addition and removal of people from the the collection. Problem is only with modification of person objects. I've been working with a small sample program that you can download from microsoft's website. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadvnet/html/vbnet02252003.asp Hope you can understand my problem and help out. If there's any articles on the web that may point me in the right direction, let me know. Thanks a bundle to all replies. Much appreciated. Tag: Integrate with database on webserver Tag: 85792
  - 7
    - finding child tables Oracle. 1)how to find all the the existing chaild tables of a master table? ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>uQ+Pk5MDTU2Wcrlfzf3Buw==</Id> Tag: Integrate with database on webserver Tag: 85791
  - 8
    - very rookie VBScript ADO RDS Binding question Looking at what is posted here, I'm afraid this will be a real dumb thing to ask (I'm just getting into web programming after having worked in mainframe programming for a long time). I'm learning about ADO RDS Binding. My (simple) web page finally has been made to successfully retrieve a little data from my sample database (which has a "songs" table and a "users" table - joinable on a field called "username"). I'm now trying to persist the extracted recordset (eventually in XML and in a "stream") and to make a user fiendish (oops - I meant "friendly") "table" with sortable column headers and all that... To help me learn about the topic, I found a very interesting MSDN article that had a great looking VBScript at the bottom. The idea of the script is to present form input fields via the page and you can override defaulted connection info and have the script draw you a simple "table" from one of your database tables... Well - I can't get the VBScript to work... I get the form inputs to show up just fine but when I click the "run" button, nothing seems to really happen (and I sure don't get my MS Access info displayed in a "table" on the screen like is supposed to happen). So, my question is "can someone coach me as to how to get the script really to work?" I can share where to find version of the script if that would help. The MDSN article is at: (except for very minor tailoring like putting my column names in where they had different columns, my script is exactly like the one in the article)http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdobjaddataconx.asp Some of my connection info is as follows: ' CONNECTION STRING DataBasePath = Server.MapPath("..\db\fpdb\srtestdb.mdb") DatBaseDriver = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" DataBaseSource = DatBaseDriver & DataBasePath ' CONNECTION Set DBConn = Server.CreateObject("ADODB.Connection") DBConn.Open(DataBaseSource) ' Create an ADO recordset object Set rsSRDB = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT [songs].[songtitle], [songs].[songgenre], [songs].[songusername], [users].[username], [users].[emailaddr] FROM users LEFT JOIN songs ON [users].[username] =[songs].[songusername];" ' Open the recordset with the SQL query rsSRDB.Open strSQL, DBConn ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: Integrate with database on webserver Tag: 85789
  - 9
    - Strongly typed data sets Hello there, How can I automatically create strongly typed data set from existing SQL Server 2000 tables. I know that I can drag and drop a table to generate one, but I'd like to generate strongly typed data set for all specified tables with relations between them ? Is it possible with Microsoft Visual Studio Enterprise Architect 2003 or another tool ? Thank You Best regards Rafal Grzybowski Tag: Integrate with database on webserver Tag: 85785
  - 10
    - Date Querry Hello, I am working with an Access Database and am trying to return a Querry that is between two specified dates, I have tried the following and none of them work: 1) ADataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Contributions WHERE 'Date' > " & dtpFrom.Text & " and 'Date' < dtpTo.Text & ";", AConnectionString) 2) ADataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Contributions WHERE [Date] BETWEEN DATEPART ('" & dtpFrom.Text & "') AND DATEPART ('" & dtpTo.Text & "')" , AConnectionString) 3) ADataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Contributions WHERE 'Date' > 1/1/2004 and 'Date' < 6/1/2004;", AConnectionString) No records are returned. Any suggestions will be greatly appreciated. Thanks, Chuck Tag: Integrate with database on webserver Tag: 85783
  - 11
    - Advice on filtering and using a Data View Using vb.net, I created a data view and would like to filter the view and determine if a record or group of records exists. My question..........is there a property I can check to determine if the view contains records meeting my criteria after filtering is performed? Also if the view does in fact contain records, is there a way to loop through view to get certain field values from it? Wil. Tag: Integrate with database on webserver Tag: 85773
  - 12
    - Error create DataAdapter with Config wizard. hi I was trying to use following query to create Data Adapter SELECT DISTINCT Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Customers.CompanyName, Customers.Address, Customers.City FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerI Error always happen with -------------------------- Primary Key Columns Missin -------------------------- The wizard can not automatically create queries for updating the database because your query does not include some primary key columns. Do you wish to add the primary key columns to your query Please suggest how can I fix it rgds Fish. Tag: Integrate with database on webserver Tag: 85763
  - 13
    - Get "table doesn't have a primary key exception" I get a "table doesn't have a primary key" exception during a .Rows.Find(string); However the table has a primary key. I moved it from one column to an other. But the table designer shows it. What could be wrong? Tag: Integrate with database on webserver Tag: 85753
  - 14
    - Web Services and SQL Server Stored Procedures I've written a very basic web service that is used by my PocketPC to add two numbers together. It works fine. So next I'm writing a WebService which accesses my SQL Server and returns rows appertaining to a specific OrderId. I have written a stored procedure called spGetConfirmedOrder to which I pass the OrderId and it works okay until I need to reference it in my code then it doesn't recognise it. Is there something that I'm missing out here do I need to get involde with SOAP and WDSL files or can I just use ADO.NET? Regards Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.667 / Virus Database: 429 - Release Date: 23/04/2004 Tag: Integrate with database on webserver Tag: 85749
  - 15
    - DataGrid master-detail indicator Microsoft make a feaure in Datagrid that support master-detail in the one grid. but for end user i prefer to present MD by tow grids. on the master grids have automatic indicator (+), this is redundant, and end user may confuse with it. can i remove the (+) indicator from master datagrid? how to do that? Tag: Integrate with database on webserver Tag: 85741
  - 16
    - SqlConnection Question Hi , I have a Dll with few functions and when i m opening a connection by using one of the Dll functions and i m relating the connection to some SqlDataReader then i can't use the connection for other purpose until i will close the DataReader . why is that ? why i can use the connection for other things but for SqlDataReader more then once ? how can i work with the same connection ? should i work with one connection or should i open a new one ? please notice that i need to use the connection while i m in the middle of some loop in the datareader (While DataReader.Read() ...) Best Regards , Tiraman :-) Tag: Integrate with database on webserver Tag: 85732
  - 17
    - batch query ?! I just watch an overview of ADO.NET 2 on MSDN TV. In that demo the SqlDataAdapter featured a batch mode where you cold submit update of many line with one query. (instead of the line by line update as now) I thought it was a great feature. Now in my own PocketPC database application (www.ihookdb.com :) I have my own "data access layer" and I thought it would be nice to use batch update too. (and because it's my code I could do it today :) And there a few question came to my mind (on about how to do that) 1. I was thinking, oh well man, it's simple, just queue the query with ';' in the middle. but there is a problem if I write UPDATE MyTable (field1, field2) VALUES (@field1_1, @field2_1) WHERE ID=@field3_1; UPDATE MyTable (field1, field2) VALUES (@field1_2, @field2_2) WHERE ID=@field3_2;..... N times (where N is my batch size) (notice I write @field_1 for 1st query, @field1_2 for the second, etc ...) but what if I use a batch size of 100 and they submit only 3 line changes ? should I create the query depending on the number of changes ? how to do that cleanly ? 2. but there is worst ! lest say I do an INSERT with an ID Identity column, I should have a SELECT @@IDENTITY after my insert. but what happened if I do many insert at a time ?!.... Any SQL Admin to rescue me ?!! Tag: Integrate with database on webserver Tag: 85726
  - 18
    - How To Use Null ? Hi , i would like to init an integer param to Null dim x as integer x = null how can this be done ? -- Best Regards , Tiraman :-) Tag: Integrate with database on webserver Tag: 85722
  - 19
    - Oracle Client Hi, Anyone out there successfullly used the microsoft client to get data back via a stored procedure? If not, can the oracle client be used on 8.1.7? The proc is simply 'get * from widget' I have a cursor as the output parameter in the proc. My addparameter command in .net is correct: myDBNull = Convert.DBNull strSQL = "proc_GetColWidths" cmdConn = New OracleClient.OracleCommand(strSQL, New OracleClient.OracleConnection(mstrConn)) cmdConn.Parameters.Add(New OracleClient.OracleParameter("xx", OracleClient.OracleType.Cursor, _ 2000, ParameterDirection.Output, True, 0, 0, "", DataRowVersion.Default, myDBNUll)) cmdConn.CommandType = CommandType.StoredProcedure cmdConn.CommandText = strSQL cmdConn.Connection.Open() cmdSource = cmdConn.ExecuteReader(CommandBehavior.CloseConnection) I get ora-06550 error when the executereader fires Appreciate any help to sort this out. Thanks Bob Tag: Integrate with database on webserver Tag: 85704
  - 20
    - Common Database Interface I am trying to develop a program that would work with any database using ADO.NET. I am having a hard time because of the differences in SQL syntax between databases. One example is when I try to specify the column name, some databases require that I put the name between square brackets, others between quotes, etc. I had a similar problem with data/time fields, but I could solve it by using an algorithm with reflection and tags in the SQL sentences. I would really appreciate if anyone could tell me if there is a standard syntax to specify column names that all the databases should accept. At this point I concluded that I will have to create settings in my program to enable the user to enter with this format, but something automatic (as I found for date) would be much better. My deadline for this project is next week, so I would appreciate if anyone could send me feedback as soon as possible. Regards, Lourenço. Tag: Integrate with database on webserver Tag: 85703
  - 21
    - DataSet problems - selecting on aggregate functions I have a dataset containing an already-populated single datatable which I which to perform an operation on. The structure of the table is below: Specifically, I want to get the most recent message for every unique {Group, User, Subject} subject to TimeStamp being less than an AsOfDate that is externally specified. I then want to bind this table to a DataGrid. I am having trouble since I am used to Access queries (new to the .NET arena), and do not know where to start. TableName: Messages Fields: Group (String) User (String) Subject (String) Message (String) TimeStamp (DateTime) Primary Key: {Group, User, Subject, TimeStamp} Any help would be most appreciated. Thanks! Tag: Integrate with database on webserver Tag: 85698
  - 22
    - Adding two a Datagrid Hi all, Ok I have a sub that creates a Datatable loads some values then I bind it to a DataGrid to show the user. I later need to add values to the third Column in that datagrid? Ok I tried a Global datatable but at the line where Datagrid.Datadource = Datatable it takes like 3 - 5 seconds? thanks for any help Gerry Tag: Integrate with database on webserver Tag: 85691
  - 23
    - Type.GetType of Byte-Array Hello, I want to set the schema of a DataTable. It should have the same structure than my Datatable in SQL Server. The last column is a Timestamp called Stempel. Timestamp is treaten an a Byte-Array. What can I do to set the Type for this column? Dim myDataTable As DataTable = New DataTable("Adressen") myDataTable.Columns.Add("ID", Type.GetType("System.Int32")) myDataTable.Columns.Add("Vorname", Type.GetType("System.String")) myDataTable.Columns.Add("Nachname", Type.GetType("System.String")) myDataTable.Columns.Add("Stempel", Type.GetType("???")) Thank you Steffi Tag: Integrate with database on webserver Tag: 85684
  - 24
    - Generate ADO.NET DataSet outside .NET Framework Hi All We have a big application server build using Delphi 7. Then, our idea is to build a web tier (client) using ASP.NET / Web Forms. My idea: generate manually a ADO.NET DataSet (XML) in Delphi 7, based in Delphi DataSets. How Can I do this? Thanks Guinther Tag: Integrate with database on webserver Tag: 85674
  - 25
    - What data object should I use with a DataGrid I am creating a page that will use a DataGrid. It will display a list of people. Each row will have an Edit button that will take the user to another page where they can edit that particular record. Each row will also have a Delete button that will delete the record. Should I use a DataSet as the datasource of the Grid? Tag: Integrate with database on webserver Tag: 85672

I've got a database on a remote webserver hosted by my ISP that
collects data from a website. I only have FTP access to the
webserver. What is the best way to get the data from this DB into an
existing database inside my internal LAN? I suppose I could FTP a
copy of the webserver DB, but I am wondering if there is a better way.

Thanks in advance for any help.

Dave

Top

Re: Integrate with database on webserver by William

William
Tue Apr 27 18:48:34 CDT 2004

Dave:

I'd normally say exposing the data as a webservice and using it to build a
dataset, then updating from there would be one way, but you say you only
have FTP access. If that's the only way you have, I don't see many other
options here.
"dave" <thorung@mailcity.com> wrote in message
news:f9e0449e.0404271043.64e2ea8f@posting.google.com...
> I've got a database on a remote webserver hosted by my ISP that
> collects data from a website. I only have FTP access to the
> webserver. What is the best way to get the data from this DB into an
> existing database inside my internal LAN? I suppose I could FTP a
> copy of the webserver DB, but I am wondering if there is a better way.
>
> Thanks in advance for any help.
>
> Dave

Top