I have a requirement that i have to load data from multiple access tables in a database with same structure into sql server table having same structure of source.
Please some one help.
View Complete Post
I've tried and looked on many sites with different solutions for which non of them resolved my issue. I've a blank Sharepoint site and want to view data from an SQL DB. It says that a Server Error occurred and that the Data Retrieval Service didn't worked
out while listing the DB's.
I tried using the 3 methods... using the also the connection string in different ways... when I do it using VB, Office and Java... I can see the data from that DB... why on Sharepoint Designer it doesn't? It supposed to be more easier than other tools.
I'm really desperate. Any help is very welcome.
I have a bunch of databases running on a SQL server 2008 instance. They're all set to the default Latin collation, and the server is set to UK English locale.
I have an access database using linked tables to the SQL server. The lcal PC is Windows 7 and also set to English UK locale.
However, the date fields in the SQL server tables are interpreted by Access as "text" type, not date. When I type a date into them in standard UK english format - dd-mm-yyyy, access accepts them but the SQL server rejects them because for some reason
it is wanting to store the data in the format yyyy-dd-mm.
I realise I'm no expert, this is probably something really simple and I'm probably being stupid, but can anyone shed any light on WTF i going on here and why, and how I fix it. I realise I could code in access forms something to force the date into
yyyy-dd-mm format and re-interpret it to English when I want to display it, but that's clunky and horrible.
Any ideas gratefully received. Thanks.
hello all, i have a webform that I am sending to and Access database and i am using dreamweaver cs4. The form consists of fields that would be sent to multiple database tables. I have tried creating server behaviors to insert the record, and have gotten it to add the records to the various tables, HOWEVER the foreign keys of the tables were not linked (i am using autonumbers for the Primary keys).
i was thinking to split the web form into 3 forms...a form for each table, as i would have to retrieve the autonumber from the database after the first form is sent. Could someone help me achieve this?
The code that was created by dreamweaver for the first webpage is as follows
i have a stored procedure which returns three tables to a dataset ..... now i need to merge all three tables to a single table from d same dataset
like dataset1 has table1 table2 and table3 .... i want all the three tabels to be merged into dataset1 itself .... instead of three diffrent tables so that i can show all three table data in a single datagrid as a compact data and combination of 3 tables from d single dataset.....
can some1 help me please.....
Hi,I've working on a chat type project at the moment. I was originally using a DB but decided to move to XML which has improved speed a lot and also made the control more portable. I have two related issues that I was hoping you guys could pass comment on.The first is dealing with multiple users either reading or trying to write to the xml file when someone else already has it open. I've had to be an Exception loop around the write process to 'queue' the writes from different users. This means that sometimes there is now an issue with speed of response.The second issue is to do with the speed at which my code read and writes xml. Speeding it up would help my app generally and but would also help with issue one.Here is my code. Just so you are aware, when someone makes a post it does Savemessage and then Getmessages. Getmessages also runs every 3 seconds regardless:
public List<Chat.Message> Getmessages(int numberOfMessages, int lastMsgID)
List<Chat.Message> res = new List<Chat.Message>();
DataSet xmlDB = new DataSet("xmlMSG");
if (xmlDB.Tables.Count > 0)
// I only want a maximum of the last
I´d like to verify if somebody see this scenario:
* I create a site, using te meeting site template;
* I give Full Control access to an user;
* When this user try to upload an item in a library, in this site, it was showed the message "Acces Denied".
* If the user press "back" in the Internet Explorer tool bar and press "F5" to refresh, the file is there.
* The same problem is ocurring, when he try to create a meeting.
Somebody ever see this error!?
Thanks a lot
I need to setup two separate webshops with public access and different layouts using AX2009 Enterprise Portal.
However I am uncertain how to implement two completely different layouts/designs because the Sharepoint Templates are located inside the 12 hive and not seperate for each website.
Can anybody give me some hints on how to do this - and if so, which requirements I have to meet (VSS 3.0 or MOSS Standard / Enterprise) in order to do it.
I am speculating whether I need to setup two separate web-servers with each own Sharepoint installation (and Business Connector Proxy)
Thanks in advance
I'm trying to link an InfoPath form to an Access database, I want to connect the InfoPath form to 3 tables in the Access database but InfoPath will only recognise parent-child relationships in a series (e.g. the "Company" table is the parent to
the "Customer" table, which is again parent to the "Orders" table)
I need to have two parent tables and one child table, though (e.g. "Customer" is parent to "Orders", but "Inventory_Item" is also parent to "Orders"). Is there any way to establish this in InfoPath? I'm using Windows XP, InfoPath 2007 and Access 2007.
I have a SharePoint 2007 List with Expiration Enabled in Information and Policy Management. I have a datatime column ExpiryDate which i used in Expiration. On Expiration I have chose to delete the item. Through Central Admin I run the expiration by clicking
"Process Expired Items now" button. I got the following error in the Windows event viewer.
Expiration Service for site http://md-rmanimaran failed.
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
Category: Information Policy Management
Where I need to specify the login details to get rid of this error? Anybody Please help..
I'm tried SELECT * INTO XXX FROM OPENROWSET alongwith Microsoft.ACE.OLEDB.12.0.
Apparently the query requires the sql account to have SYSADMIN privileges.
Considering that SYSADMIN should not be provided to a database account on a Production Server, I tried using the Linked Server method.
Following is my code.
Exec sp_addlinkedserver 'AB2','Ace 12.0','Microsoft.ACE.OLEDB.12.0','\\18.104.22.168\sagarr\Test1\cpc\c2\AB2.xlsx',NULL,'Excel 12.0;IMEX=1'Exec sp_addlinkedsrvlogin 'AB2','false',NULL,NULL,NULLgoSELECT * INTO [CPCAB2.xlsx] FROM OPENQUERY([AB2] ,'SELECT * FROM [Sheet1$]')Exec sp_dropserver 'AB2','droplogins'
Now i get the following error
Error.15247-User does not have permission to perform this action
My Excel file, Database and Windows Application run on separate machines.
i have provided the following privileges
GRANT ALTER ANY LOGIN TO sqlaccountGRANT ALTER ANY LINKED SERVER TO sqlaccountEXEC sp_configure 'show advanced options', 1RECONFIGUREEXEC sp_configure 'ad hoc distributed queries', 1RECONFIGUREThe DisAllowAdHocProcess in