Forum Array

Cannot Initialize The Data Source Object Of OLE DB Provider

When I try to run this SQL "Select * from  [GGSyncCSV]...[MerchoMasterInfo#CSV]",  I am getting the following error.   OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "GGSyncCSV" returned message "Unspecified error". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "GGSyncCSV".   The [GGSyncCSV] link server was created by following SQL statement a couple months ago.   EXEC master.dbo.sp_addlinkedserver @server = N'GGSyncCSV', @srvproduct=N'Jet 4.0', @provider=N'Microsoft.Jet.OLEDB.4.0', @datasrc=N'D:IntegrationGordonGotch', @provstr=N'Text' EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'GGSyncCSV',@useself=N'False',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL   GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'collation compatible', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'data access', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'dist', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'pub', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'rpc', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'rpc out', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'sub', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'connect timeout', @optvalue=N'0' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'collation name', @optvalue=null GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'lazy schema validation', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'query timeout', @optvalue=N'0' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'use remote collation', @optvalue=N'true'   The SQL statement "Select * from  [GGSyncCSV]...[MerchoMasterInfo#CSV]" always returns the content of the CSV file until 2 days ago.     I like to ask: is there anything that causes OLE DB provider "Microsoft.Jet.OLEDB.4.0" not working properly?   Any possible solution for this issue?   Thanks.

View Answers

Very Similar Questions

Forms Data Controls :: How To Copy A Set Of Data From The Existing Data In UI
forums.asp.net
How can I copy a set of data from the existing data in UI.

Web Forms :: How To Retrieve Data Saved In Sql Db Into Checkboxlist
forums.asp.net
I've used checkboxlist to insert data into the sql database... example... checkboxlist have values 1,2,3,4,5... If is select 1,3 and 5 the values stored in databse will be 1,3,5. Now i want to retrieve those values into similar checkboxlist(1,2,3,4,5), but only 1,3 and 5 saved in db should be selected, 2 and 4 unselected....

Ffmpeg :: Cannot Open Shared Object File: No Such File Or Directory In Unknown On Line 0
www.webhostingtalk.com
Rapidly growing error logs showing the same message $ug-non-zts-20020429/ffmpeg.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20020429//usr/local/lib/php/extensions/no-debug-non-zts-20020429/ffmpeg.so: cannot open shared object file: No such file or directory in Unknown on line 0 root@server [~]# ls /usr/local/lib/php/extensions/no-debug-non-zts-20020429 ./ ../ eaccelerator.so* root@server [~]# ls /usr/local/lib/php/extensions/no-debug-non-zts-20020429 ./ ../ eaccelerator.so* Using cpanel 11 / centos 4

Forms Data Controls :: Insert Dropdownlist Item To Db?
forums.asp.net
I got this to populate the dropdownlist, but I'm not sure how to setup the codebehind to insert the selected value when I select it and hit "insert" in the detailsview. Details View <asp:DetailsView ID="DetailsView1" runat="server" Width="400px" DefaultMode="Insert" AutoGenerateRows="False" oniteminserted="DetailsView1_ItemInserted"> <Fields> [Code]....

Accessing Silverlight Object Data From Aspx Page?
stackoverflow.com
I am new to silverlight and I am wondering if it is possible to access silverlight object data from the aspx page that host it. Or have silverlight write to a hidden field on the page on client side. What I am trying to do is to use silverlight to upload file via WCF (client to WCF Service directly instead of posting data back to the web server then forwarded to WCF service). When uploading a large file, user can still do some data entry etc. And once the upload is done have it write some data return by the WCF service to the aspx's hidden field and postback to the server on submit.

Forms Data Controls :: Insert Date To Access Db?
forums.asp.net
In gridview, one of my fields is date. (i have editing enabled). I want, everytime i update the gridview, to get date and store it in [date] field in database.

Forms Data Controls :: Correct Use Of Listvieuw With Object Data Source?
forums.asp.net
i made a small n-tier webapplication, a DATA project with my business objects a DA project with my datacces logic and a GUI project woth my website. For the CRUD operations on my main tables I use a lot of listviews, that works fine but when data grows its slows down.I used already used optimal paging & shared collection's to preventing database acces if data is already loaded en that helps alot.But I see when a user select the EDIT command the select of my listview is performed what is not needed, also when the user than select cancel the select is again called , is this normal behavior or do I made a  mistake in program logic somewhere because this behavior is slowing my application down.

Value Cannot Be Null, Parameter Name Source?
forums.asp.net
I have this code in my code behind class. I keep getting this error that "Value cannot be null, parameter name source" [Code]....

Samsung :: Data Link Cable - Cannot Get Bitpim To Detect Phone
www.howardforums.com
i just got a samsung sch a870 and i have a link cable from a650 that fits into the phone, i downloaded some drivers that were posted on this site in some thread and it says that my phone is recognized by my computer as a modem or something, but anyways, i cannot get bitpim to detect my phone, is there any information that you can provide me iwth.

Convert Custom JSON Object To A .NET Object?
stackoverflow.com
I have a JSON object that looks like this. { "Errors":{ "err1":[ //* Array of err1 objects [code].... PD: I'm currently using Newtonsoft's JSON.Net library. Public Sub New(ByVal jsonText As String) Dim jObject As JObject = jObject.Parse(jsonText ) Dim jErrors As JToken = jObject("Errors") Dim jS = New JsonSerializer() [code]....

Flash :: Handle A Time Object From Php In Flex (parse It To A Date Object)
stackoverflow.com
I've got a php backend which delivers a time (e.g. '07:00:00'). This time is recognized as a string but I need it as a Date. So what I need is: Convert a string '07:00:00' to a Flex Date object. Is there a way to do this (without using regular expressions)?

DataSource Controls :: Linq Group Cannot Get The Data Returned
forums.asp.net
I'm attempting to further reduce a dataset/table by various user input.  Part of this process is grouping the data by a timestamp prior to a summation.  I'm trying to use LINQ and cannot get the data returned that I need.  [Code]....

MVC :: Object Reference Not Set To An Object Error When Try To Add Controller
forums.asp.net
When I try to add a new controller in ASP.net MVC2 beta, I get a strange error: Object reference not set to an instance of object, and the system returns me to the template page. I can add an MVC 1.0 controller. Does anybody experienced this isssue? I migrate my project from 1.0 to beta 2. as described in the release document.

Forms Data Controls :: Cannot Insert The Value NULL Into Column 'UniqueID'
forums.asp.net
so i have a FormView bound to an SQL datasource. Using the Auto generated insert/update/delete. "Cannot insert the value NULL into column 'UniqueID'" The FormView Default view = Edit I have set the PKey and the Datasource is loading the record from a session. The record is loading no problem, just wont update.

Forms Data Controls :: DetailsView - Cannot Insert The Value NULL Into Column 'Title'
forums.asp.net
why I am getting this error when I try to insert data in a DetailsView 2.0?  Cannot insert the value NULL into column 'Title',table'C:INETPUBWWWROOTTESTAPP_DATAQUIZ.MDF.dbo.Question'; column does not allow nulls. INSERT fails. I used the Configure Data Source wizard to set this up and Question ID is a autonumber. When you autogenerate the Insert button on a Detailsview control and click on that button during run time the control posts back with text input areas where you are supposed to type the Title, Answer1, Answer2 etc. Obviously I typed data in to this text area labeled Title. It didn't work and that's why I'm asking about the control. Because I can't debug the control I am having a hard time figuring out where the problem is. Here is the code: [code]....

Forms Data Controls :: Cannot Insert Explicit Value For Identity Column In Table 'UserDetails'
forums.asp.net
I have error: Cannot insert explicit value for identity column in table 'UserDetails' when IDENTITY_INSERT is set to OFF. I'm trying to insert a record through a BLL (Business Logic Layer) class with an 'Insert' button attached to the FooterTemplate of a GridView2. My code:   [Code].... [Code].... BLL layer code:   [Code]....   The field 'idUser' is autoincremented. When I use SqlDataSource with a DetailsView, add option it adds a record and autoincrements the 'isUser'.

MVC :: Delete View - Object Reference Not Set To An Instance Of An Object
forums.asp.net
I'm walking through the ASP.NET MVC "Contacts Manager" tutorial. [URL] I've followed exactly what's said in the tutorial, but I keep getting the following exception from the "Delete View". Object reference not set to an instance of an object.Line 10: Line 11: Are you sure that you want to delete the entry for Line 12: <% = Model.FirstName %> <% = Model.LastName %> ? Line 13: Line 14: <% using (Html.BeginForm(new { Id = Model.Contact_Id })) When i suprress line 12, I still get this Line 12: Line 13: Line 14: <% using (Html.BeginForm(new { Id = Model.Contact_Id })) Line 15: { %> Line 16: <p> I just don't know. Maybe the POST DELETE method is not communicating with the datacontext... The important question is why the only the "Delete View" is not working???

Forms Data Controls :: Cannot Scroll In IE8
forums.asp.net
I have a panel with a vertical scrollbar. When I set the property of the panel "enabled = false" then I can't scroll anymore in IE8, but I can still scroll in Chrome.

Forms Data Controls :: Cannot Implicitly Convert Type On Datalist
forums.asp.net
I have a datalist which querys the database and pulls the data ApplicantID, date, and testimonial into the datalist. I now want to get the username from the ApplicantID. Im using TLists to do this but on the line ApplicantDetails = JustClick.DAL.DataRepository.ApplicantProvider.GetByApplicantID(ApplicantID); im getting the error cannot implicitly convert type on datalist can anyone help as to why and how I can fix this cheers. The code im using is below  protected void testimonialsList_OnItemDataBound(object sender, EventArgs e)         {             TList<BLL.ApplicantTestimonials> Testimonials; [code].....

Add Properties To StdClass Object From Another Object?
stackoverflow.com
I would like to be able to do the following: $obj = new stdClass; $obj->status = "success"; $obj2 = new stdClass; [code]...

Data Integration :: How To Parse Data And Assign Variable To Text
forums.adobe.com
I have three dynamic text boxes. variables respectively (caption0,caption1,caption2). My xml file is structured as: <?xml version="1.0" encoding="iso-8859-1"?> <captions> <caption>Roll over this</caption> <caption>This is the first Caption.</caption> <caption>This is the second Caption.</caption> </captions> I am trying to create a rollover where when you rollover caption0; caption1 and caption2 are displayed in sequence. Everything works except though only the first caption is ever displayed. For the other two I get "level0.caption1" and "level0.caption2" instead of the text in the xml file above. How do I parse the data so that each of the variables are assigned the text in the xml file?

Forms Data Controls :: Gridview To Excel (adding Data Outside Of The Gridview)
forums.asp.net
I was wondering if it is possible to add additional data to Excel document created from gridview. What I want to do is to manually add data to certain rows and columns (date, couple of titles, etc), but I'm not sure how to do it. Currently I'm using the following code: [Code]....

Forms Data Controls :: Best Way To Select Data Using A Query Built By Controls
forums.asp.net
er trying to develop in asp.net and I think  this is the best site that I visited ever.I'm  trying to develop webapplications with some controls like calendars, textbox, check box etc. in order to allows to the user to built a query made by himself (and complementing with strings), and of course only to display data according to the gathered information by  the controls.

Forms Data Controls :: Insert Data Using EntityDataSource In FormView - C#
forums.asp.net
I am new to formview .My formview works fine, when I insert data into the database directly and then do an update on it. It throws an error when I try to insert a new record.  The error just says "An error occurred while updating the entries. See the inner exception for details." How to insert data into the table using an entity dastasource?

Get Data From Previous Page For Search Function And Display Returned Data Into Gridview
www.vbforums.com
I implemented PreviousPage to get data from previous page for my search function and display the returned data into a gridview. The gridview's allowpaging is enabled, but every time I go to next page, my previous page data is lost... how can I resolve that?

Forms Data Controls :: How Do Display A List Of Data Returned From The Database
forums.asp.net
How do display a list of data returned from the database like this. [code]....

Forms Data Controls :: How To Load Data From GridView To DataTable
forums.asp.net
How can I load (copy) the data that is present in the GridView into the DataTable? I am planning on loading the DataTable from GridView and update a row from the datatable and load the newly formed data with the GridView. Note : Here I am not using datasource.

Forms Data Controls :: How To Copy Data From Formview
forums.asp.net
i have a formview <formview> ,,,,, </formview> in the formview i have  a lot of fields , ID , Name , Email ,,,,,, etc  how can i copy the name to textbox ,?! i have try this : protected void Page_Load(object sender, EventArgs e) { TextBox txt = FormView1.FindControl("Email") as TextBox; Tetbox1.text = txt.text ; }

Forms Data Controls :: 2008 - How To Retrieve Data From GRIDVIEW1 Using Column SELECT Button
forums.asp.net
I am using ASPNET2008 with VB Scripting and not C# Scripting I am encountering new problem. On the WebFrm1, I just don't know how to write the coding to retrieve the CUSTOMERID data in order to retrieve the details from SQL SERVER table  to fill the textbox controls.Here is the decription of the GRIDVIEW column In the GRIDVIEW1 on the left edge one of the column is SELECT button which let the userclick on it to select the specific CUSTOMERID on the column next to it on the right. Here are the coding from SOURCE <asp:ButtonField ButtonType="Button" Text="Select" CommandName="SelectClick"     DataTextField="CustomerID" > </asp:ButtonField>

Forms Data Controls :: Access BoundField Data In ItemUpdating Event Of DetailsView
forums.asp.net
I use ObjectDataSource and DetailsView for Updating records . my Bll input parameter method is an Object instead of regular parameter . So i though i could make my own ObjectParameter in ItemUpdating event of DetailsView and i need some modifiation on the data that user input on boudfield in detailsView . I don't know how to access BoundFiled data from ItemUpdating Method of DetailsView.

Forms Data Controls :: Access Same Row Data From Dropdownlist_selectindexchanged Event
forums.asp.net
I have the program structure as below. How can I set some label values in the gridview row from dropdownlist in selected index changed event? how to write ddl_selectedindexchange? <asp:GridView ..... <div..> <asp:dropdownlist runat="server" onselectedindexchange="ddl_selectedindexchange"></dropdownlist> <asp:label  runat="server" id="label1".....> </div> </asp:GridView>

Databases :: Inserting Malayalam Data To Blob Data Field?
forums.asp.net
I am using asp.net 3.5 framework and mysql as my database. When i am saving malayalam data in to the database having datataype blob, it saves like '????'. But when i insert the specified value directly using the mysql query browser, then i can able insert the correct malayalam value.

Forms Data Controls :: Displaying Data In A Datalist?
forums.asp.net
I am displaying data in a datalist.i have to repeat the same data vertically twice.

Forms Data Controls :: C# DataList Editing Example Using Data From A Database
forums.asp.net
I am relatively new to the .Net development world and I am trying to convert the C# DataList Editing example shown on the ASP.net Quickstart Tutorials page to use a actual database for the datasource, instead of the in-memory example that is given... Can someone give me an example of how the behind code would look like when using a database for this example, instead of using the data in-memory, as the example does... I have the DataList template setup correctly to look like the example does, I just cannot figure out how to load my data in from my database. Any SQL database example, with two or three fields, would be enough to illustrate how this can be done... note that I am looking for a specific solution to the example given on the Quickstart Tutorial.

Forms Data Controls :: How To Bind Data To A Control On A Gridview
forums.asp.net
what i have is a gridview and i have added a new control , textbox, what i want to do is bind the value from a particular column in the Usercontext.searchedresults ( datatable) to it. The issue is that the datasource for the gridview is a Dataview (whcih is a filtered number of columns from the datatable) that does not have that column in it but the Usercontext.searchedresults does have it. i tried the following but doesnt seem to work Text='<%# UserContext.SearchResults.Select("INV_NO = " + DataBinder.Eval(Container.DataItem, "InvoiceNo") + " && INV_LINE_NO = " + DataBinder.Eval(Container.DataItem, "InvoiceLineNo"))[0]["D1_CODE"] %>'> NB: D1_CODE is the new column ..

Forms Data Controls :: Calendar Control: Bind Data?
forums.asp.net
I need to bind some data to my ASP.Net 3.5 calendar control. The data will be appointments and the fields are appointment datetime and title. The title field should display in the proper day of the month. Also, when a user clicks on a date in the month calendar, they should be redirected to a form to add a new appointment.

Forms Data Controls :: Unable To Show Data In Datalist
forums.asp.net
this is my ocde [Code].... for this i want show data as india:assam india:bihar india:up but it show the result 0 0 0 why the queary not woriking correctly i am using mysql database.

MVC :: Select Multiple Oracle Data & Session Data
forums.asp.net
currently, after allowing the user to login, the controller calls the function in the DAO which retrevies the info from my oracle database. this is the current part of the code that i have, which only allows me to get 1 item from the database and stores it to the string. [Code].... I would like to get more then 1 data from the database such as the the user's name, birthday, userstatus etc.. and put them all into a session data, to allow them to be used throughout the website.

Forms Data Controls :: Show Data Randomly In Datalist?
forums.asp.net
I want to load data from database and show randomly in datalist.. like when user see the page all the data from database showing on the page using datalist or listview. and when the user refresh the page, all the data randomly changed and show in the datalist or listveiw..

Forms Data Controls :: How To Print All Data In DataList
forums.asp.net
I want to give print option to print all data in datalist.

Forms Data Controls :: Update Data Within Datalist?
forums.asp.net
I have a datalist that is populated via a database. I would like to enable the user to update a single field. I have followed the msdn tutorial for updating data within a datalist .. this is working marginally - when I click on 'edit' the datalist disappears, then when i search for the same entry again, the datalist becomes the editable version - [Code]....

Forms Data Controls :: Merge Data In DataList?
forums.asp.net
I have a DataList for displaying FAQ's from a table that contains the following columns - Question, Answer, Dept and Subject.  If there are multiple entries for the same Subject, I'd like to group them together using the one Subject heading as in the example below: Subject 1 Question 1? Answer to question 1. Subject 2 Question 2? Answer to question 2. Another answer to question 2. Still another answer to question 2. My question is how can this be accomplished; the code is pasted below. [Code]....

Forms Data Controls :: Retrieving Data From Datalist?
forums.asp.net
I have a datalist. I put a linkbottun in itemtemplate and set commandname property to SELECT. I wante when a user clicked on it retrieve information from there. I use this code snipet : Dim dli As DataListItem For Each dli In DataList1.Items Dim i1 As String = DirectCast(dli.FindControl("lblpid"), Label).Text Dim i2 As String = DirectCast(dli.FindControl("lblpname"), Label).Text Dim i3 As String = DirectCast(dli.FindControl("lblprice"), Label).Text Dim i4 As String = DirectCast(dli.FindControl("lblcategory"), Label).Text Session("pid") = i1 Session("pname") = i2 Session("price") = i3 Session("category") = i4 next but it retrieve information of all items in datalist where as I want information about itmes which is select. how can I reach to the index of itme which is clicked?

Forms Data Controls :: Unable To Retrieve A Gridview Selected Row Cells Data
forums.asp.net
i am still stumped with this operation: i am trying to retrieve a GridView selected row data..here is my code.. the commented part that gives me the selectedindex works just fine....but the one giving the selected row cell value does't work and  there is no error.. The update operation is done successfully...weired. i need to assigned selected row cells values to variables  ..do some calculations and then re-assign the result calculation to cell[9].. protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { string s = GridView1.SelectedRow.Cells[5].Text; TextBox1.Text = s.ToString(); //string s2 = GridView1.SelectedIndex.ToString(); //TextBox1.Text = s2.ToString(); }

Forms Data Controls :: Retrieve Column Data From GridView For RowDeleting In C#
forums.asp.net
The date displays just fine in the grid.  I am having trouble with deleting the row in the grid.  I have researched and played with different things with the grid, but I can't seem to get it to work.  Most examples are in VB and I coding is C#.   What happens is the code (see *** in C#) doesn't return the column 0 (UserName) from the GridView.  So the next statement blows up becasue there is no UserName.  I used a ASP.Net VB book I got from a VB class I took to come up with the code. When I typed in "grdUsers.Rows(e.RowIndex)"... I got help from Intellisense, but the rest of the line ".Cells(0).Text"... I got no help.  I included below the code that I think is pertinent to the problem I'm having. [Code]....

Forms Data Controls :: When Click On Title Header To Sort A GridView Some Data Disappear
forums.asp.net
When I click on my GridView header "End Time" all the rows which contain the string "N/A" disappear. Here is my code: [Code].... Note: GetSortDirection returns "endTime ASC" or "endTime DESC" and save in ViewState: [Code].... Then I fill the DataAdapter and use the ViewState info to sort it: [Code]....

Visual Studio :: Using Business Objects As Data Source For MS Report Rdlcs With WAPs?
forums.asp.net
Since there is no App_Code directory, I am unable to get my generics class to appear in the datasources for an rdlc that I create in my WAP project.  I think there might be some limitation where we cannot use generics business objects as the datasource or reports since the WAP has no App_Code folder where the class must normally reside for the reporting datasources to pick it up as a datasource.

Forms Data Controls :: Copy Data From Db To Textbox?
forums.asp.net
I have a web page like this default.aspx?id={0-n} default.aspx?id=5 for example  how can i copy this number to textbox !? i mean the 5  or any another number  i must use it in text box

Forms Data Controls :: Attempting To Bind Data From A Dropdown List / Cannot Insert The Value NULL Into...
forums.asp.net
I am attempting to bind data from a dropdown list that was populated from another datasourceID. I've bolded what I believe is relevant to this issue in the code below. But basicly its binding the proper county on the pull down menu but when I hit form submit it dosnt postback that info instead its null. [code]....

Forms Data Controls :: Read A Data Table And Write In Access DB?
forums.asp.net
I need to read a table from a dtgrid there is one code for example?

Forms Data Controls :: How To Read Data From Stored Proceedure And Display To Gridview Using Object ...
forums.asp.net
I have an object datasource which is using Business object as a myconnection The method i have defined under myconnection is Publicstatic DataTable getfn(String dtype, String did, String dprefix, String dname) { datable table = new datatable(); then declared stored proceedure and defined parameters and assighned values In the stored proceedure it has a query like select column1,coloumn2,coloumn3 As Call from table where I need to take data from Call and display it to the gridview through object datasource .

Actionscript 3 :: Parse JSON Object To Custom Class Object In It?
stackoverflow.com
I want to parse JSON string to some my custom object in Action script 3. Is there some libs to do this.[code]...

Connect To Db On Linux Server Using Toad?
stackoverflow.com
How to connect to MySQl db on linux server using toad? what i should give on host? i get the error Can't connect to MySQL server on 'tinywall' (10061)

How To Link A Button To Button Play Of Media Clip In OLE
www.vbforums.com
I created a button and also added a media clip in OLE and hire it. So how to link the button to OLE in order to open the music file when we run the program?

Source Codeto Assign To A Button(new Created)from Excel A Procedure From A VB Project
www.xtremevbtalk.com
I created a button in Excel. The question is which is the source code for assigning to this button a procedure from VB?c - is my buttonc.OnAction="Love"Love is a procedure from a Vb projectsub love()end sub.So..helppppI am waiting your help

Source Codeto Assign To A Button(new Created)from Excel A Procedure From A VB Project
www.vbcity.com
I created a button in Excel. The question is which is the source code for assigning to this button a procedure from VB?c - is my buttonc.OnAction="Love"Love is a procedure from a Vb projectsub love()end sub.So..helppppI wait your help 

VBA Code To Stop Access 97 Db Converting To Access 2000
www.vbforums.com
HiI have written a database in Access 97 that uses replication. I have recently discovered that some users have Access 2000 and that it does not givew the option to just open the db but just gives the option to convert it.I'm afraid if it is converted access 97 users would not be able to use it.Is there any way that I can include code in my db to stop the db being converted, something that automatically just opens the db without prompting the user.Any help would be mmuch appreciated.thanksCooks.

OLE Run At The Press Of A Button?
www.vbforums.com
Hello I Want To Make The Object That Is Contained In An OLE Run When I Click A Command Button.Could Someone Please Tell Me How?

Link Table From .mdf (sql Srv) File Into Access Db
www.access-programmers.co.uk
i have a pc which doesn't have sql server installed. is it possible to link tables from .mdf file sitting on the pc into access database?

Script To Read/write/amend/delete On The Tables In A Mysql Db
www.webmasterworld.com
Running on a unix box and looking for a good (free!) php script I can use to read/write/amend/delete on the tables in a mysql db. Been searching for a while but can seem to find one with a good web front end to use.

Link DB In VB Form
www.vbforums.com
I m updating table of one instance in Oracle with the data of another table in another instance using link I m able to to do it in Oracle i need to the same using VB form how do i do that. link is not workin in VB 6.0 its giving Run time error 91 Object Variable or with blockvariable no set...

Read JSON Data From A Server To A Dataset Object?
www.vbforums.com
I am trying to read JSON data from a server to a dataset object, any idea on how this can be done. I have tried using the DataContractJsonSerializer class but it only seems to work for objects. JSON Data { "firstName": "John", "lastName": "Smith", [code].... The code above works to an object, but I want to parse the JSON data to a dataset object.

Passing A JSON Object As A Dictionary(Of String, Object) To WCF Web Service?
stackoverflow.com
I'm trying to setup a WCF web service to be consumed by JavaScript using JSON and jQuery.I've noticed that you can send JSON without a DataContract if the service method parameters match the naming structure of the JSON object: <ServiceContract(Namespace:="http://foo.com/bar")> <AspNetCompatibilityRequirements(RequirementsMode:=AspNetCompatibilityRequirementsMode.Allowed)> [code]....

RegEx - How To Retrieve String Variable From External Source And Parse It
stackoverflow.com
Part of my project is to retrieve a string variable from an external source (google docs) and parse it. This string represents width and height. I have no problem retrieving, I just need to parse it in to two strings. The string has 4 variations. Here are examples: 3"x4" 3"hx4"w 3hx4w 3x4 The width is always the first number and the height is always the second. Sometimes, the width and height have decimal points. Any way to parse this into two strings of the numeric values only?

Flex :: Load Local File As JSON Source?
stackoverflow.com
In a very simple first AIR application (I'm using Flash Builder 4.5), I am trying to accomplish the following on my MacBook: Read a local file (JSON format) into the AIR app. Parse through the file. Display some selected contents in a grid. That's it. I've found an example that does some simple JSON parsing in Flex, but the problem is that it loads the JSON source from a remote web site. So do I need to load any file-specific libraries to make this work in AIR? Or can I simply refer to the file by using the Mac file-path? I just want the local file to be the JSON source. The parsing is already taken care of.

Actionscript :: Custom Object Does Not Fully Encode Into JSON Object?
stackoverflow.com
I have the following class: public class PartBean extends DatabaseObjectBean{ [Bindable] public var partNumber:String; [Code].... I end up with this string: {"description":"Test","partNumber":"-1"} I am not sure why the array is not being encoded as well.

Flash :: Cast A Display Object To Custom Class Object?
stackoverflow.com
How can i cast a object to another type? in AS3 i tried putting (objectType) infront of the variable but it doesnt work, below i have added objects of fishes into the child, and i am getting the fishes back out when mouse down is triggered, and then calling the fishes what to do. however i cant call the method of the custom class fish because it is a displayobject.[code]...

Actionscript 3 :: Custom Object To ByteArray Then To Custom Object?
stackoverflow.com
Having problem reading bytearray of custom objects. public class CustomObject extends Object { public function CustomObject() { public var _x:Number = 100 [Code]....

ActionScript 3.0 :: Listening For Custom Event Dispatched From Parent Object In Child Object?
www.actionscript.org
I want to listen for a custom event dispatched from the document class in a custom subclass. For example, let's say in the document class I have: ActionScript Code:[code].... So that the subclass will trace 'Event from document class received' when the 'customEvent' event from the document class is listened by the eventlistener. However, the output is only 'customEvent dispatched', meaning it wasn't heard in the subclass.

Forms Data Controls :: Showing Images Saved In DB In GridView?
forums.asp.net
i'm trying to show data in gridview through this code but everything appears except the images. I saved the image in sqlserver2005 as Image datatype and when i try to bind the gridview to the db by wizard the images appear when i press test query but nothing when running the app In Class Named Admin: public DataTable Select_writer(string writer_name) [Code]....

To Transfer A Large DB To Another Server
www.sitepoint.com
to transfer a MySQL database with way over 1 million rows to a different server. What is the best way to do this without losing any data? I've tried using the export feature in phpMyAdmin but it doesn't seem to handle it very well. There has to be a feature in WHM or cPanel,

How To Get Full Path Of Source File Thorough Fileupload
www.vbforums.com
I am using fileupload control in asp.net to locate or browse a file. When i try to get the path of those files with filename property, i just get the filename only and if i try to use this statement Code: Path.GetFullPath(FULPDF.FileName).ToString it gave me my local website server path. how can i get the actual path of file.

Dreamweaver CS3 Access DB?
forums.asp.net
 I have been working on a project, not a very big project. It is a training website with approximately 190 courses. I had things working well with the Access database using ASP. Then I was told to use ASP.NET by fellow programmers. This is a learning experience for me, I am a skilled web designer not as much programming experience. This project needs to be close to done in a month. The  site will have lists of courses based on categories, dates, locations and a search feature. Am I going to run into alot of problems using Dreamweaver? I know it uses 1.1 Framework. Is this an issue if I switch to VS or VWDExpress? Also in Visual Studio why is it always necessary to BUILD befor the page can be viewed? To me Visual Studio seems very cumbersome. For now I want to do minimal coding just as basic a database as I can.

C# - Can Determine If There Is An Open Source Software For A Specific Purpose
stackoverflow.com
We are going to write an entire new application for a reservation system. In this system experts specify their free time in elaborated calendar and users seek them through searched and finally reserve the expert and his time. We prefer to find an open source program like this and try to evolve it instead of creating it from scratch. In this manner our time is saved and that open source program will be completer too.

Web Forms :: Get Any String From View Source?
forums.asp.net
i need to convert currency into other country value( ie.  USD To INR) .  if I open  any site to get a value of  that perticular currency value.  Is it possible to get value from view source . if yes then How And Simply  i want to get  full string from view source  where 'UDS' string found. then How i can search a string from ViewSource(which we get  right click of mouse---- View Source) which belong to other site, i have only url that site.

Web Forms :: Outputcache With Sql DB?
forums.asp.net
I am using VS2008 with C# to create a web application. I am using output cache to improve performance. There are No of places where I had written  a function to fetch the some records from the database. Now the return of such functions will chage only if some record is added in the sql table or some record is updated. So how we can apply cache in that  so that it can detect that a new record is added and check if that record ios in the cache or not if not then it will refresh the cache.

Image Source For A Submit Button?
forums.asp.net
I have a plain vanilla html submit button, ( not the server control, and I don't want to make use of the server control),I want to represent this with an image that i have (.jpeg extension), so how can this be done, do I simply put an img src button within <input> and </input tags> or do I provide it as a link in the value button ( i don't know how to ), or is their some other way altogether.

Update Nullable Column In Db To Null?
forums.asp.net
Can anyone reliably get the EDS to save a nullable column to the databse as a "null" when bound to any of the controls such as "FormView"?I have tried using several different UpdateParameters (Session, ControlParamater, Parameter,  etc). I have tried setting "ConvertEmptyStringToNull" to true and leaving the property off entirely. Nothing works. On my "Inserts" it works fine.(I have made sure the column is set to nullable = true in the Entity Designer.....)

ADO.NET :: Copy Data From Excel File To Sql Db?
forums.asp.net
i trying to copy data from excel file to sql db I am using sql BulkCopy for this pruposein c# the following statement keep producing an error: for(i=0;i<DataSetRows;i++) { SqlBulkObj.ColumnMapping.Add(MappingDataSet.Tables[0].Rows[i]["Source"],MappingDataSet.Tables[0].Rows[i]["Source"]); }

Forms Data Controls :: Cannot Insert The Value NULL Into Column 'idUser'?
forums.asp.net
I have this error when trying to insert a new record through a 'New' button in asp:DetailsView control. Error details:Message: Sys.WebForms.PageRequestManagerServerErrorException: Cannot insert the value NULL into column 'idUser', table 'C:INETPUBWWWROOTVIEWS1APP_DATADBSEARCHRESULTS.MDF.dbo.UserDetails'; column does not allow nulls. INSERT fails.I have an typed dataset xsd & adapter, where i automatically generate delete, update, insert commands. I also use SqlDataSource.The field idUser doesn't allow nulls on database level, and in the xsd  I marked the following properties:AllowDBNull = false, AutoIncrement = true, AutoIncrementSeed = 0, AutoIncrementStep = 1, ReadOnly = true, Unique = trueMy code is:  [Code].... How to solve the problem or where I should look for the problem?p.s. If i have in DetailsView, idUser field properties set: InsertVisible="True", ReadOnly="False" and i enter a value manually, the records successfully inserts.

Retrieve The Data From The DB To The Gridview Based On The Selected Value From Another?
stackoverflow.com
I am a beginner in Dot net Domain.Presently Im creating a web portal for one of our client.In my portal i have displayed the News headline and a button for details in a Grid view. when i click on the button it has to show the detailed news from DB in another grid view. I have done a code on it.,but it shows some error.I have displayed the code below. protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType != DataControlRowType.Header && e.Row.RowType != DataControlRowType.Footer && e.Row.RowType != DataControlRowType.Pager) { Button btn = (Button)e.Row.FindControl("Button12"); btn.CommandArgument = e.Row.RowIndex.ToString(); } } protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "newsbtn") { int index = int.Parse(e.CommandArgument.ToString()); string key = GridView2.DataKeys[index].Value.ToString(); SqlDataAdapter da = new SqlDataAdapter("select **img,news,detail** from News where news=@n", connect.con()); da.SelectCommand.Parameters.AddWithValue("@n", key); da.Fill(ds, "more"); //if (!IsPostBack) //{ GridView1.DataSource = ds; GridView1.DataBind(); //} } } The error it shows is: DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'detail'.

C# Return Identity After Insert Using SQL DB
bytes.com
I need to know how to return th Id after inserting row, I can do it by many ways, but I need to know why my code doesn't work? [Code]....

Configuration :: DLL Failure Causing "Object Reference Not Set To An Instance Of An Object." - How To...
forums.asp.net
i don't know how far I'm going to get with this considering that I'm pulling together this API for a payment gateway that's isn't very well supported by the developers who supplied it, but... I'm getting an "Object reference not set to an instance of an object" error on this:         ' Put user code to initialize the page here

ADO.NET :: To Call For Last Entered Number From DB
forums.asp.net
How can i write a method using C#.net to call for last entry (Number) from table (details) from DB?

Forms Data Controls :: Assigning An Image Object To A Html Tag?
forums.asp.net
i have an c# function which returns an image . I need to assign this image to html image tag , to display the image on a page. Normally i would use < img src= " ...URL "> , but here i donot have a URL . i have to assign it to an .NET function , which returns an image.

Web Forms :: How To Display Image Depending Upon Db Field Value
forums.asp.net
this is my aspx page code : <a runat="server" id="hlkmail"><img src="../images/send_mail_icon.jpg" alt="" /></a> <a runat="server" id="hlkgallery"><img src="../images/galleryl_icon.jpg" alt="" /></a> this is code behind (aspx.vb) : hlkmail.HRef = "sndmail.aspx?Clientname=" & clientName hlkgallery.HRef = "pgallery.aspx?Clientname=" & clientName above code shows fixed images. i want to display image dynamiccally depending upon the db value. i have a stored proc that returns hasmail ='true/false' and hasgallery='true/false' from database. if true i want to display send_mail_icon.jpg else send_mail_icon_watermark.jpg and gallery_icon else gallery_icon_watermark.jpg. i want to do this in code behind using if loop.

Write Smalldatetime To DB When Checkbox Is Checked?
forums.asp.net
I'm trying to write a date to my SQL database when a checkbox is checked.  It doesn't seem to be working. I am using asp.net C# and have the following line in my formview: <asp:CheckBox ID="DateApprovedCheck" runat="server" Text='<%# Bind("DateApprvd") %>' /> I'm not sure how to structure the code behind so that a checked box adds a smalldatetime to my DB field or a value of null is submitted if the box is unchecked.

Forms Data Controls :: Customizing Cell In Gridview With Information From DB?
forums.asp.net
Im using the GridView to display data from a table in the DB and my last column has some options that a user can select check boxes and drop down list. I need to be able to save the users selection in the db and when they return have their options displayed ie boxes check/unchecked etc... I have looked at [URL] which i can get working and could just write all the html to add but i cant figure out how to pass the the ID for the row from the DB to the cell to be used in the queries.

Forms Data Controls :: Gridview Cannot Find The Method With The Signature?
forums.asp.net
i have a dynamic data layer, i.e every user can add custom fields to database tables, so i need dynamic methods in my application. i know i can use params to specify a variable number of parameters for a method, but the gridview in asp.net looks for a method with the same fields it is updating, i.e if gridview updates fields :name, age, phone, email(suppose email is a custom field of a certain user i.e it doesn't exit for another), and the object data source calls the update method with signature : (name, age, phone, params object[] custom_attributes) an error is generated that the gridview can not find the method with the signature(name, age, phone, email)

Encrypt Source Code Without Using Encrypting Software?
stackoverflow.com
How can I encrypt my PHP source code without using encrypting software?

Looping A Db Insert Statement With Dates?
stackoverflow.com
I need to run a statement that will populate a data base with the same information every time EXCEPT for the date. im currently trying something along these lines and aren't having any luck. DECLARE i_int BINARY_INTEGER := 1; BEGIN WHILE i_int <= 30 LOOP INSERT INTO bs_events.......... I can't seem to get it to work and im stuck in a code hole and cannot think straight. I basically want the date to up by one from 01-30 and then i will manually change the month and run the script again for all 12 months of the year.

Storing <font> Colors In Db?
www.phpfreaks.com
I'm writing a <font color> to mysql for later retrieval but the colors don't make sense. It's posted and retrieved in PHP. If I put in <font color="#ff0000">RED</font> it gets properly stored in the db (I can see it) but it gets retrieved and shows up green instead. I've tried doing the stripslashes() with addslashes(), tried <font color="#red">RED</font> and <font color="red">RED</font>.. no matter what config I try, I always get the word RED showing up green as if I had used <font color="#00ff00">RED</font> instead (when I tried <font color="#00ff00">RED</font> it shows up black. I give. What am I doing wrong? I know it's something dumb, but I can't find a similar issue with any searches. BTW, viewing the Source Code from the rendered page when it's posted shows it's properly tagged as red: color="#ff0000"

Get Webpage Source Code Without Actually Accessing Page
stackoverflow.com
There are lots of web pages which simply run a script without having any material on them. Is there anyway of seeing the page source without actually visiting the page because it just redirects you? Will using an html parser work to do this ? I'm using simpleHTMLdom to parse the page?

Use An Array As Db Select Criteria
www.webmasterworld.com
Is there a neat and tidy way to select rows from a table in a mysql database where a certain field is contained in a pre-defined php array? example: $array[0] = "green"; $array[1] = "red"; $array[2] = "yellow"; then select all the rows where 'colour' is either red, green or yellow. but preferably without using OR in the query .

MySQL DB And Website
phpbuilder.com
localhost is not the option I need. I am trying to figure out what goes into my $dbhost = 'localhost' instead of 'localhost' IP address does not work, nor does 'IP addressort'. Ive also tried whatever.com but that doesn't seem to work either. I keep getting the dreaded "Access denied for user 'xxxxxxx'@'www.whatever.com' (using password: YES). The user has full privledges. As far as I can tell I am not firewalled. Somebody else checked as well and found no reason why I should be denied.

New Eyes On A Mysql Query Statement - Db Error
stackoverflow.com
I'm new at this, what are the problems with this statement: $sql=" SELECT * FROM `calendar` WHERE `DayId` ='".$day."'"; $result = mysql_query($sql, $conn); if (!$result){ echo "DB Error, could not query the database "; echo 'MySQL Error: ' . mysql_error(); exit; } while ($row = mysql_fetch_array($result)) { //set $dayType $dayType = $row[DayType]; } I keep getting the error: DB Error, could not query the database MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 but when I put an "echo $result;" in after the line that starts with $result=... then I get a value for $result of "Resource id #2"

C# - Transforming A List Of Objects Into List<List<string>> Of Data?
stackoverflow.com
I am trying to use the jquery DataTables plugin for my system, using a webservice to populate the data through an ajax call.What I need to return from the webservice is a List like this: List<List<string>>;I have about 120 different domain classes being used by this as the core data objects, so I need some kind of system where I can get the data from the different domain classes and transform them into List<List<string>> in a somewhat automatic way.The way I am getting the data is something like this (example code):List<Core.Room> coreDataList = Core.GetRoomsInHotel(int hotelID);I have been looking into DynamicLinq and System.Reflection, but have gotten nowhereUPDATE: What I need to return from the webservice is an array like this: [ ["data-col-1","data-col-2","data-col-3","data-col-4"], [code]....

JQuery :: Adding A Highlight Animation When Hovering A Sortable Object Over A Droppable Object?
stackoverflow.com
I have a list of objects called projects that are sortable, and a list of objects called categories that are droppable. I need to somehow make it so that when you click on a sortable project, and drag it down so it is hovering over a droppable category, the category that the project is going to go into is highlighted, or outlined or some other kind of animation. I am sure that it could be done by something as simple as an add-class-on-hover-over-droppable-object type function, but I don't know how it is supposed to be setup. Looking through some of the jQuery documentation, I found out that for a droppable object, you can set an over: function(), attribute, but I couldn't get it to work...

Take Values From DB To Combo Box
www.daniweb.com
I need to get the itemId's from the Database to a combo box where the combo box will increase according to the new values. I wrote a code like this [code]... With that I could have taken the item id and the other necessary values displayed according to the id.But the problem is even though it displayed correct values ,always the item id which is selected is the first one.So I cant do any update with it,because it will update only the 1st record in the DB table since update query is working according to the itemId.How should I change the code to get the correct item id selected with its values displayed in the form where I can edit and update it.

Paypal IPN Script: Create On Site That Receives Confirmed Payment Messages And Inserts Into Wordpress...
stackoverflow.com
There are two parts to this question, so I'm going to pubish it as two separate questions. The first one deals with interfacing with IPN and is this: I need to create a simple .php script that can interface with Paypal's IPN system everytime I receive a confirmed payment for a given product. The script will then install the user into my wordpress user's database as a "member" (which is a custom role I've defined) using their email address as their username and the paypal transaction id as their password. I'm doing it this way because I can easily enter all the people who have purchased prior to this, into the database without having to generate random passwords for everyone. The second question will be much easier and that's how to use the IPN data (firstname, lastname, email address and transaction id) to enter the user into the wordpress member database.