Problems Adding MS Access Datasource In VB Studios 2005 Enterprise
Mar 8, 2006
I am running Visual Studios 2005 enterprise edition and I am creating a mobile application to keep track of some receipts. The problem I'm currently having is that even though I can connect to the MS Access Database with Server Explorer that I'll be aquiring data from; Everytime I attempt to use the Data Configuration Wizard to add a new data source that namely the database I get this error message:
The new connection uses a data provider that is not supported. (end of message)
There is no username or password necessary to access this database and it is an Access 2003 database.
Any help would be greatly appreciated.
View 14 Replies
ADVERTISEMENT
Jun 10, 2007
I am a new in .Net Environment. I am moving from VB to VB.Net and Access DB to SQL Server 2005. Please reply me the following questions bellow.
Access Works
SQL SERVER (SS)?
When I create .MSI file it include ADO library in that executable file and my client install software and don€™t need any kind of file to install and wherever my program install it can be accessed by using following connection string.
Con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "dbPAYROLL_DB.mdb;Persist Security Info=False" Con.Open
What file needed on client€™s PC to access SS on server.
What about connection string change dynamically in client sides
I create relation on Access Relationship Diagram.
Where to create these diagrams either on VB.Net Server Explorer or on Management Studio? And how?
Please answers me this basic questions further I have more question in mind but please first answers me these questions€¦
View 1 Replies
View Related
Jul 5, 2005
I'm using net2.0 and SQL server express locally and have succeseffully placed my connection string in my sebconfig file and made connection and grids and detail etc, etc. Now I want to publish what I've done. So I got a free account at maximumasp beta 2.0. They give some room on a sql 2000 server and a empty database. Now I want to add the Northwind table to that DB but I don't have Enterprise manager and have no idea how to add the tables.Can someone please help?Thanks!Rich
View 3 Replies
View Related
Apr 18, 2007
We are importing Flat file data from our Mainframe system. We have a lot of money amounts coming in, but the mainframe does not store the decimals in the flat file. So for example a row in the file might look like this:
+0000007894-0000000563
Where the first value is $78.94 and the second value is -$5.63
Is there anyway to have the Flat file connection manager put in the decimal place for me, or do i have to create derived columns for each column and divide it by 100? There like 50-100 columns per file, so i'm looking for a better, quicker way.
Thanks in advance.
John
View 12 Replies
View Related
Nov 1, 2007
Hello,
I am hoping some of you can direct me to areas I should look into.
First off let me say that everything was fine and worked great up until 3 weeks ago.
Then all of a sudden we began to experience timeouts on a particular query.
The vb.net 2002 code has not changed and is pretty basic stuff to connect to the server and execute the query. The only change I have made to it since then is to add a commandtimeout parameter so it would actually run.
There does not seem to be a specific pattern either to when it runs slow and when it does not.
I can be the only one in the server in the morning (the only one in the office for that matter) and one day the application will execute the query and return data in under 9 seconds and the next day it will be a minute and a half.
I can test it during peak network times and the same thing...one day fine the next day performance is slow.
Also, if I run the query straight from the management studio it will run in 2-9 seconds and from .net it takes 20-90 seconds.
Are there server admin jobs I could run to see if tables are deadlocked, if the network is to busy..anything?
View 4 Replies
View Related
Feb 16, 2007
Hi all,
Hopefully I am posting this question in the correct forum. I am still learning about SQL 2005. Here is my issue. I have an access db that I archive weekly into and SQL server table. I have used the dst wizard to create an import job and initally that worked fine. field I have as the primary key in the access db cannot be the primary key in the sql table since I archive weekly and that primary key field will be imported several time over. I overcame this initally by not having a primary key in the sql table. This table is strictly for reference. However, now I need to setup a unique field for each of the records in the sql table. What I have done so far is create a recordID field in the sql table that is an int and set as yes to Identify (auotnumber). That worked great and created unique id for all existing records. The problem now is on the import. When I try to import the access table i am getting an error because of the extra field in the sql table, and the error is saying cannot import null value into this field. So... my final question is how can I import the access table into the sql table with one extra field which is the autonumber unique field? Thanks a bunch for any asistance.
Bill
View 7 Replies
View Related
Jul 11, 2006
This may be a stupid question, but can someone from MS SQL Server Team kind enough to confirm it, please?
View 3 Replies
View Related
Apr 14, 2008
I have VB2008 express edition and SQL server 2005. When i try to create a new local datasource in my project, the datasource seems to be created just fine however an error message comes up. If i try to create the datasource by selecting it on the 'add new item' menu, an error message says
"The data provider required to connect to the local data file could not be found. The file will be added to the project but the typed Dataset associated with the project will not be created."
If I try to create the datasource by selecting 'add new datasource' from the datasources pane, i can create the connection to a new or existing database but when i click next to proceed to the page defining the dataset, an error message says
"An error occured while converting this connection:
Data provided identified by guid ' 7c602b5b-accb-4acd-9dc0-ca66388c1533 ' could not be loaded"
PLEASE HELP!!
I have no idea how to fix it
thanks,
jordan
View 3 Replies
View Related
May 21, 2006
When I put a sqldatasource in my page and want to configure it and add a new connection to it I recieve this error : "object reference not set to an instance of an object" . Do you have any idea about solving this problem. please help me Thanks
View 5 Replies
View Related
Mar 1, 2006
I am trying to create a MS Access datasource to use it in a IS dataflow. I've done the following things:
1.I've created an ODBC datasource - System DSN, pointing to the Access database.
2.I've created an ODBC connection manager pointing to the ODBS datasource that I created in the previous step.
3.I've created a DataReader Source that uses as its Connection Manager the connection manager that I created in the previous step.
I get the following error message: "Cannot acquire a managed connection from the run-time connection manager." What can I do to solve this error?
Pedro Martins
View 1 Replies
View Related
May 2, 2006
I'm trying to access a group of rows in a data source in my script
component (transformation). Currently im using the connection manager
in the script component, acquire the connection, and issue a query
command to get the data. This will happen on every rows being pass to
the script component from the data source. Is there a better way to
access the a group of rows from the data source?
View 1 Replies
View Related
Feb 22, 2006
I tried to write a CLR stored procedure using C# in SQL 2005 to access an Access
database.
When I use the OleDbConnection class in System.Data, the procedure throws SecurityException at runtime.
Output as following:
System.Security.SecurityException: Request for the permission of type 'System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.PermissionSet.Demand()
at System.Data.Common.DbConnectionOptions.DemandPermission()
at System.Data.OleDb.OleDbConnection.PermissionDemand()
at System.Data.OleDb.OleDbConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at Dbbest.Data.BulkStuff.bulkcopy(String source_oledb_connection_string, String source_table, String destination_table, Int32 batchSize, Int32 notifyAfter)
The action that failed was:
Demand
The type of the first permission that failed was:
System.Data.OleDb.OleDbPermission
The Zone of the assembly that failed was:
MyComputer
View 1 Replies
View Related
Jan 15, 2007
Hi
I am Creating Click Once Windows Application with Reporting Services 2005.I have created Report and Published on Report Server.In my windows application I am successfully able to view my published report through report viewer control.
Now in my application I am getting a dataset from my custom webservice. I want this dataset data to be added to my report as datasource at runtime on Client Side ,as my report is on Report Server.
waiting for help!!
Thanks in Advance
Pankaj
View 8 Replies
View Related
Nov 6, 2007
Hi all,
Please advise which kind of connection should be establish from excel 95 to MS SQL Server.
From my thought, I understand that the connection depends on Windows version rather than excel version.
Thus, I just think that there will not be any issue connecting to SQL Server from Excel 5.0a.
Kindly advise if there is any addtional point to concern/consider further.
What could be issue connecting to SQL Server 2005 from Excel 5.0a.
Thank you very much
View 1 Replies
View Related
Jan 17, 2006
How do I go about accessing the SQL Server Enterprise Manager to use DTS?
Robert
View 20 Replies
View Related
Apr 18, 2001
I like to get a feedback from other DBA's out there, I have a user with a consultant that need's Enterprise Manager installed on the user's desktop
in order for them to develop code for the user.
Is the above a good reason to give out to the user the Enterprise Manager
tools?
Please give me what is acceptable tools for the user/consultan.
Thank you
Jorge
View 1 Replies
View Related
Oct 30, 2006
I'm not a developer and would like your input to compare against what a sales rep is telling me.
I'm managing a small web project that will have a database with a max of 20,000 records with less than 50 field each. It will be hit by anything from 200 to 500 people in a day (max) via Internet connection from all over with all sorts of speed.
The users will select less than 50 filters to obtain the results of the info they are looking for among the 20000 records. Most users will only choose less than 10 filters per search.
That's all that the database will do...seems to me enterprise is way too much, but since I'm not expert, need one of you to help with your input.
Thanks very much!
View 5 Replies
View Related
Aug 21, 2006
I've never used SQL Server before. I installed VB 2005 Express (I've been working with VB since I was 16), and SQL Server 2005 Express.
I installed the server with all the default settings and created a small database to handle customer information (a remake of some Access and Oracle databases I've made before).
I'm told, however, each time I try to connect to the database via VB, that SQL Server isn't accepting remote connections...
Remote? It's on a local computer. So is VB...what is going on here? Is there a setting I've missed?
Warren Ayen
IBM
View 12 Replies
View Related
Apr 25, 2006
I'm trying to build WebService to use result as DataSource for RS 2005 (XML DataSource).
But I have a strange problem.
I have WebMethod with parameters.
When I'm testing my WS in browser then everything works just fine.
But... When I'm trying to call this web-service from VS2005 environment then something strange happens.
Looks like VS passing parameters incorrectly to my WS (not passing at all!)
I've created very simplyfied version just to check parameters:
using System.Xml;
using System.Xml.Serialization;
using System.Messaging;
using System.Text;
using System;
using System.Web.Services;
[WebService(Namespace = "http://company.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class GetRemoteData : System.Web.Services.WebService
{
[WebMethod]
public XmlElement GetData(string CompanyName, string FunctionName, string ParameterList)
{
XmlDocument xmlDocument = new XmlDocument();
XmlElement xmlElement1;
xmlElement1 = xmlDocument.CreateElement("parameters", "values", "urn:errors");
xmlElement1.InnerText = String.Format("{0}, {1}, {2}", CompanyName, FunctionName, ParameterList);
return xmlElement1;
}
}
In the browser WS returns all passed parameters back correctly. VS - not.
What's wrong with my code? Why MSDN example works fine?
Do I need to specify some undocumented (soap specific) attributes?
Where I can find full tutorials how to create RS-compatible web-service?
(Sorry for cross-posting but I have no single reply...)
View 3 Replies
View Related
Mar 31, 2008
Hi guys,
I want to give someone read only permission to our SQL server so they can log in and look at the database structure and query a few tables. I've set up the user but the problem is that when I connect in SQL server remotley, it shows all the other DB's on the server even though it is restricting access to them. Can these other DB's be hidden so that only the DB the user has access to shows up?
Cheers for your help!
View 9 Replies
View Related
Dec 14, 2007
I am new to both Reporting Services and Webservices implementation so I am just trying to use a simple example. I found a Webservice on the internet that returns movie information:
http://www.ignyte.com/webservices/ignyte.whatsshowing.webservice/moviefunctions.asmx?wsdl
I am trying to call in using XML DataSource and with absolutely no luck. Here are the steps I have followed:
DataSource type: XML
Connection String: http://www.ignyte.com/webservices/ignyte.whatsshowing.webservice/moviefunctions.asmx
Report Data Quert:
<Query>
<SoapAction>http://www.ignyte.com/GetUpcomingMovies</SoapAction>
<Method Namespace="http://www.ignyte.com/whatsshowing" Name="GetUpcomingMovies">
<Parameters>
<Parameter Name="month">
<DefaultValue>12</DefaultValue>
</Parameter>
<Parameter Name="year">
<DefaultValue>2007</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath>RunQueryResponse{}/RunQueryResult{}/diffgram{}/DataSetName/TableName</xmldp:ElementPath>
</Query>
I am getting an error: The XmlDP query is invalid. (Microsoft Report Designer)
Any help? I am trying to figure out this simple example so I can apply it to my own webservice.
Thanks
View 1 Replies
View Related
Nov 18, 2006
created an Oracle datasource (tried both ole db & oracle client) in Visual Studio 2005 report project - works fine connecting and preview of report within ide , deployed to Reporting Services web server, received the following error when attempting to run the report on web server:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'oracle'. (rsErrorOpeningConnection)
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
web server has oracle client 9i client installed and connecting to db ok through sql plus (this server also is loaded with VS2005 and the SqlServer2005 db)
any thoughts or direction greatly appreciated
View 4 Replies
View Related
Feb 22, 2006
We are in the process of configuring a j2ee application with SQL Server 2005. We have downloaded the new version of SQL Server 2005 Java Database Connectivity (JDBC) Driver 1.0.
We are having some issues in getting it to work using the XA datasource. Description of the error is as follows:
javax.transaction.xa.XAException: java.sql.SQLException: Failed to create the XA control connection. Error: Could not find stored procedure 'master..xp_sqljdbc_xa_init'..
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.start(Unknown Source)
Has anyone else has encountered this and possibly found a solution.
Regards,
Bindu
View 33 Replies
View Related
May 24, 2006
Hi,
I'm just starting to use SQL Server 2005 Reporting services, and need to use an XMLdocument as the datasource. I will get the xml data from a webservice and then need to bind it to the report. Here is what I am doing:
1. I created a webservice at the following location:
http://localhost/myWebDirectory/myService.asmx. this webservice has a method called "GetXMLDocument" that has 1 parameter (sql). This method uses the sql statement to fill a dataset from a SQL Server database, converts it to an xmlDocument, and returns the xmlDocument. Here is a sample of the results:
<?xml version="1.0" encoding="utf-8" ?>
- <NewDataSet>
- <Table>
<ReportName>GirlsNamedMary</ReportName>
<ReportFriendlyName>All Girls Named Mary</ReportFriendlyName>
<ReportDescription>This is a test SQL Server Reporting Services report. It has no parameters.</ReportDescription>
</Table>
</NewDataSet>
2. I created a datasource in my reports project as follows:
- Name: TestDataSource
- Type: XML
- Connection string: http://localhost/myWebDirectory/myService.asmx
3. I created the following dataset:
- Name: TestDataSet
- Data source: TestDataSource
- Query string:
<Query xmlns="http://tempuri.org/Service/GetXMLDocument">
<Method Namespace="http://tempuri.org/Service" Name="GetXMLDocument"/>
<ElementPath />
</Query>
I am getting this error:
------------------------------------------------------------------------------------
An error occurred while executing the query. Failed to execute web request for the specified URL.
Additional Information:
----> Failed to execute web request for the specified URL. (Microsoft.ReportingServices.DataExtensions).
------------------------------------------------------------------------------------
I cannot figure out why I have this error. The service runs fine from the browser, but I just can't get it to work in Reporting Services. What am I doing wrong?
View 17 Replies
View Related
Sep 11, 2007
Hello,
I'm trying to configure JBoss application server to use SQLServer 2005 as database with XA transactions.
I can start a new transaction, access SQLServer from within the transaction, but when committing, there is the following XAException from SQLServer:
16:04:20,926 INFO [STDOUT] javax.transaction.xa.XAException: java.sql.SQLException: COMMIT: Status:0 msg:*** SQLJDBC_XA DTC_ERROR Context: xa_commit, state=1, StatusCode:-4 (0xFFFFFFFC) ***16:04:20,926 INFO [STDOUT] at com.microsoft.sqlserver.jdbc.SQLServerXAResource.commit(Unknown Source)16:04:20,941 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.commit(XAManagedConnection.java:176)16:04:20,941 INFO [STDOUT] at com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord.topLevelOnePhaseCommit(XAResourceRecord.java:641)16:04:20,941 INFO [STDOUT] at com.arjuna.ats.arjuna.coordinator.BasicAction.onePhaseCommit(BasicAction.java:2619)16:04:20,941 INFO [STDOUT] at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1779)
[...]
The system is running on Windows Server 2003 64bit with SQLServer 2005 64bit, and JBoss running on JDK 1.5.0 (32bit)
Can anyone tell me what this message indicates?
Regards,
Martin
View 3 Replies
View Related
Mar 5, 2008
We have a few reports that we would like to require the user to enter a password before they can view the report. Is there a way to do this?
Thank You
Kaysie
View 4 Replies
View Related
Nov 14, 2007
I try to add data to SQL via Access Forms. When I add a data and open tables in Access which are connected to SQL, I can see my new datas. But if I open tables in SQL Server Management Studio I can not see any of those new datas. What should I do to solve this problem. I will be very happy if you can help me about this matter.
Thanks in advance...
Berk
View 3 Replies
View Related
Jun 8, 2005
I've searched around google & here and can't find a solution.
I can connect to my database via a connection string on the web server
but cannot connect via Enterprise Manager or just by ODBC connection on
my local machine.
I can ping the server fine and switched off my XP firewall & my router firewall, port 1433 is also open.
Someone has tested this from another machine and it works fine (cheers).
What else can I try, this is driving me insane!
Thanks in advance
R
p.s I'm on Win XP SP2, SQL Server 2000 sp3a
View 10 Replies
View Related
May 11, 2001
Hi,
I have a user who has created several SQL7 databases and uses a VB app which schedules jobs (under the sa account) on the SQL server. How can I allow this user to view scheduled jobs on the server ? I don't want to give him too many priviledges.
Thanks,
Tim
View 4 Replies
View Related
Sep 22, 2007
We just installed an application, WhatsUpGold, to monitor our servers. Management won't let me host that on my primary SQL box. So, we are using MSDE on the local machine (call that box my_netmon).
I can access the db with very basic functionality using osql while on the my_netmon machine. I've added my domain user account as a System Admin using the following commands.
exec sp_grantlogin @name
go
exec sp_addsrvrolemember @name, 'sysadmin'
But when I go to the my_sql machine and try to attach to it with Enterprise Manager I get an error that the server does not exist.
What gives??? Is it just not possible, or am I missing something here?
My goal is to just be able to see the data stored in the MSDE db. Write views, etc...
Please advise,
Marc
View 2 Replies
View Related
Jan 16, 2008
We are expanding an application's database hardware to have a mirrored failover server. Normally in this case we just have the application add "Failover Partner=MirredServerName" in the connection string.
However, this application is using the Enterprise Library Data Access Block and we can't find any documentation describing how to setup the Failover Partner using this library. Any help would be appreciated.
JOHNF
View 3 Replies
View Related
Jul 10, 2006
Hello,
I am running an SAP installation on clustered DELL poweredge 1850's with a shared scsi disk system. I am running Windows 2000 sp4 with sql 2000 sp4. I am trying to restore a database from a .bak file on a clustered disk. When I attempt to access the disk through enterprise manager it is not there. I only get access to the E: drive (which is clustered as well)
View 1 Replies
View Related
Jan 2, 2008
Dear All:
I am new to SSRS 2005.
I have created many shared datsources and reprots at http://localhost/resportserver.
I am trying to access these reports from ReportViewer in the web application. Actually I want to use these reports for different customers by just changing the datsource programitically.
Is this is a possible?
Thank you
Theju
View 2 Replies
View Related