MS SQL Server :: DTS Connect To Access 97 Secure Database Trouble...

Secure Access To Database
Hello Experts!!

Let me start off by saying I'm not a SQL expert and have very limited knowledge on the topic.Here is my question:Our organization has an archiving solution that stores data in a SQL database. This applicaton creates two SQL accounts. One that is used to archive to the database. The second to browse the database from a search interface provided by the application. With all the federal compliance issues I see that they require the data to be stored in "a non-rewriteable and non-erasable format". My question is. How can I prevent the database from being erased in the SQL database? As 'Administrator' I can open Enterprise Manager and open a table in the database and simply delete any record that I wish. I understand that might have this ability because I'm logged on as Administrator. How do I prevent access to this database and prevent access modify the records. I believe the only two accounts that should have access to the database are the Archive and Browse accounts required by the application.

View Replies !

K, I Got Dreamweaver To Hook Up To My Access Database(Yes Lots Of Trouble) BUT...
when I hit F12 to preview my page and forms etc it goes to this error

This error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying.
For more information about HTTP errors, see Help.

AND when I try to hold up to an SQL database it wont let me and says the server doesnt exist still. Whats wrong with my SQL server and what can I do to resolve this problem?

View Replies !

Sp_addlinkedserver With Secure Access Db
I am trying to add a linked server from my sql svr 7.0 server to my secure acess 97 db. The database is mydb.mdb, the security db is mydb.mdw. I have tried the following:

sp_addlinkedserver
@server = 'MYDDB1',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = 'C:dbmydb.mdb',
@provstr = 'DRIVER={Microsoft.Jet.OLEDB.4.0};SERVER=c:dbmydb. mdb;UID=xxx;PWD=yyy;'

and other combinations of this. While the server is added to sysservers, I cannot get to any of the objects. None of the help even mentions linking to a secure database. I am totally desperate at this point and greatly appreciate any help.

View Replies !

Secure/selective Data Access
Dear netters,We are looking to build a SQL Server database that will be hooked up toa Web server (WebLogic or a .NET).The database will house data for multiple customers, and therequirement is to have no customer see other customer data. Web serverwill be responsible for authenticating users (ids and passwords will bemaintained there/possibly stored in the database, but will not beactual database logins) -- and establishing pooled connections to thedatabase, using some sort of a proxy login.Ideally, we do not want to have the database itself visible to "theworld", it should reside behind a firewall, and be accessible throughthe Web server, which will do all authentication and routing.We want to have either tables or views defined in such a way that:1. Users can only see their own data and NEVER can see anybody else's.2. Users' access to the database is logged (this includes updates aswell as queries).3. We would like to provide some sort of a reporting mechanism -- whereusers can form their own queries. So, something like a Crystal or anAccess front end, that users are typically familiar with... The problemis that this requires users having direct access to the database (?),and opens up tables (unless, there is a way to create parameterizedviews that will always restrict access to a subset of records).Any advice on how to best implement this is greatly appreciated.Thank you in advance!

View Replies !

Using Access To Connect To Sql Database
Can someone explain how to use Access to connect to and use a sql database?
thanks

jarnone@bellsouth.net

View Replies !

Cannot Connect To Access Database
I have followed the instructions to the letter and still cannot connect to the Access database on the desktop. I am running XP Pro with Office 2003. I am using MaAfee virus scan and I disabled Access Protection, buffer Overflow protection. On-Delivery E-mail scanner and On-Access Scanner iare still enabled. . The error log on my device reads "Failure to open SQL Server with given command" and Error connecting to Access Database.

Also is there a VB equivelent to the Visual studio application avaiable for download?

Thanks in advance

View Replies !

SQL DTS To Access A Secure Web Page And Retrieve File
Ok, here is the problem.

SQL Server 2000 DTS Package
Need to access a secure website which displays a list of available files for download.
Firstly need to read that page to determine the most recent file.
There is a view link to the file which uses java script to post back information for file download.

Any ideas please ?

View Replies !

Secure SQL Server Remote Access From ISV Application
Hi guys

I'm writing a C# application which connects to a local SQL database for data access. The application connects to SQL Server through windows authentication, but opens up the port and sqlbrowser to others on the network wanting to access the database through SQL Server authentication, and also allows remote users to connect to this server remotely if they have the login and password (and because the port is already open)

I understand this is not secure and open to attack, and am unsure of how to secure these processes without blocking these three types of access, from A.) the local user, B.) the network user and C.) the remote user across the net.

Have researched this a fair bit, but get somewhat lost amongst all the jargon.

View Replies !

Secure Microsoft Access To SQL Linked Tables
Not sure if I'm posting to the right group or not, pls tell me where else to post.

My question is: I have a microsoft access database on a client desktop that links to tables in sql server. Is there a way to encrypt the data that goes back and forth between access and sql?

View Replies !

Ssis, How To Connect To Access Database?
MS Access database was one of the standard data connections in DTS. Excel is listed as a scourc/destination, but access is not. Question:

What is the best connection to use for MS-Access databases for output of data?

We generally process the ETL in SQL server then, export to Access database.

THANKS!!

Dave

View Replies !

How To Connect To A SQL Database From Access 2002
Currently i have a SQL database on our server and an adp file that allows the end user to open the database to play with the data.

On the client side the user navigates to the adp file from above and opens it which allows them to do their work.

I need the same database but for another department, so i copied the SQL and adp file to another folder and renamed it. I then open the adp file from the new folder created using Access 2002 on Win XP Pro SP2, click File navigate to connection and refresh the data source and server name but i cant see the new database i copied over.

I then stop/start the Sql server but same issue. I now think i might need an ODBC connection but when going into ODBC the other database has no connection setup in there therefore i guess i dont need to for the new database. I type the name of the new database in connection (Access 2002) and comes back with an error (Cant find it)

Any idea about this one? all im trying to do is have the same database with a different name and allowing clients to connect to it?

Thanks

View Replies !

What Syntax Should I Use To Connect To Access DB (having System Database) Via OPENROWSET?
MS SQL Server 2005 Express.
I'm trying to connect to Access DB (having System Database) via OPENROWSET.
Everything (client, server and access file) is on local drive.

This works (ODBC):

select *
from openrowset('MSDASQL',
                            'Driver={Microsoft Access Driver (*.mdb)};Dbq=C:MBK.mdb;SystemDB=C:SECURED.MDW;Uid=me;Pwd=pw;',
                             'select * from [Mbk]')

This works (Jet.OLEDB):

select *
from opendatasource('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:MBK.mdb;Jet OLEDBystem Database=C:SECURED.MDW;User ID=me;Password=pw;')
...Mbk

This won't work (Jet.OLEDB):

select *
from openrowset('Microsoft.Jet.OLEDB.4.0',
                  'MS Access;Database=C:MBK.mdb;System Database=C:SECURED.MDW;UID=me;PWD=pw;',
                  'select * from [Mbk]')

saying ... "Wrong argument".

This won't work (Jet.OLEDB):

select *
from openrowset('Microsoft.Jet.OLEDB.4.0',
                  'MS Access;Database=C:MBK.mdb;SystemDB=C:SECURED.MDW;UID=me;PWD=pw;',
                  'select * from [Mbk]')

saying ... "There are no permissions for usage of object C:MBK.mdb". It seems that it simply hasn't found system database file C:SECURED.MDW, cause when I change SystemDB=C:SECURED.MDW to something like BlahBlahBlah=C:SECURED.MDW the same message is shown.

So, what is the right syntax for stating System Database in OPENROWSET query string? And why 'System Database' won't work?

Thank you.

View Replies !

Unable To Connect To SQL Server Database CANNOT ACCESS THE OLD THREAD
The reason I had to start a new thread was that the old thread seems to be closed. There is no "Reply" button showing.

I still have the same problem. The last post asked if I was sure I was using SQLExpress.

I only have SQLEXPress and I have never had anything else. Therefore the question becomes - Why does the system seem to think I have another version?

Alan

View Replies !

SQL Server 2005 Database Connect To MS Access 2007 With Error
Dear all,

I am running an Access adp application with SQL Server 2005 as back end database. I run a query by using Management Studio query window, and it returned correct results with some columns containing NULL value. But when I run this query through MS Access client side, popup an error "Data provider or other service returned an E_FAIL status" and crash the Access application. I moved the database back to SQL Server 2000, and it runs perfect on both client side and server side returning the correct result. This query is important for the application. Please help!!!!

Query as followed:

SELECT     TOP (100) PERCENT dbo.VWINFO312FYTRStreamEnrolments.StudentID, dbo.RequiredStreams.StreamType,
                      dbo.VWINFO312FYTRStreams.StreamCode + CAST(dbo.VWINFO312FYTRStreams.StreamNo AS varchar) AS FullStreamCode,
                      dbo.DaysOfWeek.DayCode, dbo.VWINFO312FYTRClasses.StartTime, dbo.VWINFO312FYTRClasses.EndTime, dbo.VWINFO312FYTRClasses.Room,
                      dbo.Tutors.TutorName, dbo.Tutors.PhoneExtn, dbo.Tutors.OfficeHours, dbo.DaysOfWeek.DaySequence, dbo.RequiredStreams.StreamOrder
FROM         dbo.RequiredStreams INNER JOIN
                      dbo.VWINFO312FYTRStreams ON dbo.RequiredStreams.PaperID = dbo.VWINFO312FYTRStreams.PaperID AND
                      dbo.RequiredStreams.StreamCode = dbo.VWINFO312FYTRStreams.StreamCode INNER JOIN
                      dbo.VWINFO312FYTRStreamEnrolments ON dbo.VWINFO312FYTRStreams.PaperID = dbo.VWINFO312FYTRStreamEnrolments.PaperID AND
                      dbo.VWINFO312FYTRStreams.StreamCode = dbo.VWINFO312FYTRStreamEnrolments.StreamCode AND
                      dbo.VWINFO312FYTRStreams.StreamNo = dbo.VWINFO312FYTRStreamEnrolments.StreamNo LEFT OUTER JOIN
                      dbo.DaysOfWeek INNER JOIN
                      dbo.VWINFO312FYTRClasses ON dbo.DaysOfWeek.DayCode = dbo.VWINFO312FYTRClasses.DayofWeek ON
                      dbo.VWINFO312FYTRStreams.PaperID = dbo.VWINFO312FYTRClasses.PaperID AND
                      dbo.VWINFO312FYTRStreams.StreamCode = dbo.VWINFO312FYTRClasses.StreamCode AND
                      dbo.VWINFO312FYTRStreams.StreamNo = dbo.VWINFO312FYTRClasses.StreamNo LEFT OUTER JOIN
                      dbo.Tutors ON dbo.VWINFO312FYTRClasses.ResponsibleTutor = dbo.Tutors.TutorID

View Replies !

So You Think Your Database Is Secure!?
So you think your database is secure? Think again.Scuba by Imperva Database Vulnerability Scanner is a FREE, lightweightJava utility that safely scans Oracle, DB2, MS-SQL, and Sybasedatabases for known vulnerabilities and configuration flaws. Scuba byImperva finds hundreds of flaws like unpatched software, unsafeprocesses and weak passwords: the high risk vulnerabilities thatexpose your databases to attack.Based on its assessment results, Scuba by Imperva creates clear,informative reports with detailed test descriptions. Summary reports,available in Java and HTML format, illustrate overall risk level. WithScuba by Imperva, you are quickly on your way to meeting industry-leading best practices for database configuration, security andmanagement.Scuba by Imperva has been developed by the Application Defense Center(ADC), one of the most authoritative groups in the Database Securityspace. While comparable products cost anywhere from a few hundred toseveral thousand dollars, Scuba by Imperva is fully functional andCOMPLETELY FREE.You can download Scuba by Imperva from http://www.imperva.com/go/scubauglFor help and questions about Scuba by Imperva please emailJoin Bytes!

View Replies !

So You Think Your Database Is Secure? Think Again.
So you think your database is secure? Think again.Scuba by Imperva Database Vulnerability Scanner is a FREE, lightweightJava utility that safely scans Oracle, DB2, MS-SQL, and Sybasedatabases for known vulnerabilities and configuration flaws. Scuba byImperva finds hundreds of flaws like unpatched software, unsafeprocesses and weak passwords: the high risk vulnerabilities thatexpose your databases to attack.Based on its assessment results, Scuba by Imperva creates clear,informative reports with detailed test descriptions. Summary reportsillustrate overall risk level while detailed reports point outspecific holes in your database infrastructure. With Scuba by Imperva,you are quickly on your way to meeting industry-leading best practicesfor database configuration, security and management.Scuba by Imperva has been developed by the Application Defense Center(ADC), one of the most authoritative groups in the Database Securityspace. While comparable products cost anywhere from a few hundred toseveral thousand dollars, Scuba by Imperva is fully functional andcompletely free.You can download Scuba by Imperva from http://www.imperva.com/go/scubaugl

View Replies !

How Can I Secure My Database??
hello all,

I've recently started using sql express 2005. I've used the features very conveniently.

But one thing i coudn't understand is how can i secure my database from unwanted access.

I've Installed Sql Express 2005 with mixed mode authentication (Sql authentication) and attached my Database. But it also connects with Windows authentication, and all my data tables are openly visible.!!

How can i Secure my database now..!!!

My intention is to restrict access to my databases only to certain users (may be SQL Logins)

Please guide me how to accomplish this...

Thanks

View Replies !

How To Secure The Database
Hello...

I develop a .NET Application which uses a SQL Express Database. The application will be distributet to several customers. That means the customer must have (or install) SQL Server Express Edition .

But we dont want that the users manual access to the database.

As far as understand that is not possible because the user (customer) will be the administrator for the SQL Server Express because it runs in his own PC (no password security).

Am I right? Thank you..

View Replies !

Secure Database ,only For 1 User
Hello,
Is possible to create database file with only one user(No local acount used by Windows authentication)?

I want copy with my aplication also database mdf file with secret data .I don't want so as user loged to sql server as 'dbo' user ( Windows authentication) can view or edit it.

It is possible?

Ondra.

View Replies !

Secure Database Files For Sp_attach_db

hi,

My problem is, I am going to ship MSDE with our product. Now the problem is that if some one copies the .MDF and .LDF files and uses "sp_attach_db" to attach the db files to his own server then my database will be exposed to him. I have tried this and it gets exosed. I cant deploy NT Authentication for the database, bcoz if the end user installes Enterprise manager then my database will be exposed to him. Is there any way that i can sequre the LDF and MDF files of my database so that no one can use that with sp_attach_db? I m using MSDE(Sql server 2000).

View Replies !

Secure Social Security Number In My DataBase
Hi, i have a data base in SQL 2005 and i it has many tables with confidencial information Like Social Security numbers, Credit card Numbers, etc. And i would like to encrypt this information or make something to make this info invisible to any hacker, or any person that logs on the server.

Here are the limitations:

1 - I cant make any changes in the front end, so if i encrypt the data, I have to make all the modifications in the database, and if the front end needs some encrypted information, the database should dencrypt it.

Any one has any idea ???

Best Regards.

View Replies !

Webparts, Using Custom Database And Secure Conection String
Hello all, i think this is my first post here.

I'm on a project development right now. It's about creating a webpart,
connecting to a custom database (when i mean custom, i mean created
specifically for the webpart), using a normal connection string. This,
'cause i don't want to put SQL code directly on cs files.

My point is, if exist a way to secure the connection string putting in
on a config file? Just like when you put the connection string in a
web.config or app.config on regular application / website development,
and retrieving it with
System.Configuration.ConfigurationSettings.AppSettings for example.

I've tried to add an app config file to the webpart project, but when
i'm deploying it on sharepoint (using stsadm) i get an error (webpart
is causing problems message).

Then, is there a way to add a config file in xml to retrieve the connection string in webpart developing?

I've included a sample of my code.

Best regards and thanks in advance.

    #region DEFINICION DEFAULT PROPERTY, TOOLBOXDATA Y XMLROOT (NAMESPACE).

        [

            DefaultProperty("Text"),

            ToolboxData("<{0}:MainCode runat=server></{0}:MainCode>"),

            XmlRoot(Namespace="CreacionDocumentos")

        ]

    #endregion

    #region CLASS: MainCode, codigo principal de la aplicacion

    public class MainCode : WebPart

    {

        private const string defaultText = "";

        private string text = defaultText;

        private static string sConn = "Data Source=MYSERV;" +





    "Initial Catalog=MYBD;" +





    "Integrated Security=True;";

        private static SqlConnection myConn;

        private static SqlDataAdapter myDataAdapter;

        private static DataSet myDataSet;

View Replies !

Access Trouble

I'd been using this DB for months. Then I had to install Vista and it's become very difficult to work with because of so many security demands. You set permissions here and there and it still does not work. For some reason the permissions are being wiped out often after a sign off.

Anyhow it seemed to work until about an hour ago off and on. Accasional breakdowns happen. I also want to add that I am debugging a huge C# app and Sql Server is attached to it. So the conditions are definitely unstable but that part of code which broke down has not been changed for months.

I had to disconnect DBs and reconnect them in Sql Server and VS back and forth a number of times.

In short, I got this error (after some other similar):

Cannot open user default database. Login failed.
Login failed for user 'DDMNVT61AlexBB'.
    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at tapTCPports_1.HttpHistoryRequests.subHistoryRequest_Click(String symbol, String passThru, String discriminator) in C:VCsharp_Projects apTCPports_1HttpHistoryRequests.cs:line 103

I go to Sql Server and see all tables in the Server Explorer.

I go to my VS Server Explorer and see all tables.

Connection strings haven't been changed.

What could be the problem?

Thanks.

View Replies !

Trouble Upgrading From Access To SQL On The Web
Hello

I have a problem regarding the importing the access database in the SQL server 7.0.
We have a matrimonial portal named www.viwahmandap.com which is using an access database.We are using the dsn to access this .mdb file. Now we will be upgrading to SQL 7.0.The server administrator won't
do anything like importing the access database .So i will have to download the access database on our domain ,import this access file into an SQL database using the DTS wizard which is available in SQL 7.0(This i can do). This will create the respective .mdf & .ldf files.Now What are the next steps to be followed at my end? What should i ask for from the the server administrator?Are there any changes required in my ASP application.What else should be done?Please help.

Ashish

View Replies !

Secure A Single SQL Server Database + Make Float Fields Encrypted
Hi all,

I am developing an application for a big office which uses SQL Server 2000.
Apart from my database, on that server, there are two databases by other companies.
The administrator also has access to server but the client only wants him to backup the database.

I have two questions:

1) First of all (if it is possible) I would like to protect my own database from the other companies.

I don't want them to:

see the data in the tables (around 20 tables)
make changes to the stored procedures (more than 100 stored procedures)
be able to backup the database

2) The client will save sensitive data to the database (mainly currency amounts, salaries etc) which he wants to keep hidden.
I am using float type for these fields and I would like to make the data encrypted. I could do it for nvarchar fields but changing these float to nvarchar would be time consuming.

Thanks for your patience reading this!

Would really appreciate some help on any of these

Nicolas

View Replies !

Error Message: &&"Cannot Open Database.[DBNETLIB][ConnectionOpen(Connect()).] SQL Server Does Not Exist Or Access Denied&&".
I installed SQL 2005 including backward compatibility, MSDN libraries and SP2 a new Windows 2003 server (chose mixed mode authentication). Installation was successful and I then installed an off the shelf database with Windows authentication which also installed successfully.
I created a new group in AD, added the database users into the group and gave db-owner rights to the group in SQL as advised by the installation guide. However, when I try to open the database it gives an error message saying "Cannot open database.[DBNETLIB][ConnectionOpen(Connect()).] SQL server does not exist or access denied". I also tested it adding an individual user (myself) as a user to no avail.
When I set up DSN in ODBC on my computer I can successfully test the connection but can't run the application. The connection is via TCP/IP.
Any suggestions?

View Replies !

Trouble Translating Query From Access To SQL Server
Gary writes "I'm imported the query from Access (where it worked perfectly) to SQL View where the "Iif" statements caused an issue.

Here's a SMALL portion of the original:
SELECT tblTransactionBuyer.TransBuyerID,
tblDefaults.CompID,
([TransBuyerPropSalePrice]*([DefBasePercentVA])/100) AS LoanBaseVA,
[TransBuyerPropSalePrice]*
(IIf([TransBuyerPropSalePrice]>=[DefLoanMinJumbo],[DefFundingJumboVA],
IIf([TransBuyerVaUsed]="Yes",[DefFundingUsedVA],[DefFundingVA])))/100 AS VAFunding, ......

Below, are my changes so far, but I'm stuck.
SELECT tblTransactionBuyer.TransBuyerID,
tblDefaults.CompID,
([TransBuyerPropSalePrice]*([DefBasePercentVA])/100) AS LoanBaseVA,

[TransBuyerPropSalePrice]*
If([TransBuyerPropSalePrice]>=[DefLoanMinJumbo],[DefFundingJumboVA],
If([TransBuyerVaUsed]="Yes",[DefFundingUsedVA],[DefFundingVA]/100)) AS VAFunding, ........

It appears that I may not be able to put an IF into a SQL SELECT. If not, how can I get the same effect ?

Thanks. Gary

Listed Below is the Full Access Query:

SELECT tblTransactionBuyer.TransBuyerID, tblDefaults.CompID, tblTransactionBuyer.TransBuyerEntryDate, qryUserAlphaList.UserName, qryUserAlphaList.UserAreaCode, qryUserAlphaList.UserPhone, tblTransactionBuyer.TransBuyerName, tblTransactionBuyer.TransBuyerVaEligible, tblTransactionBuyer.TransBuyerPropAddress, tblTransactionBuyer.TransBuyerPropCity, tblTransactionBuyer.TransBuyerPropSalePrice, ([TransBuyerPropSalePrice]*([DefBasePercentFHA])/100) AS LoanBaseFHA, ([TransBuyerPropSalePrice]*([DefBasePercentCONV])/100) AS LoanBaseCONV, ([TransBuyerPropSalePrice]*([DefBasePercentVA])/100) AS LoanBaseVA, ([TransBuyerPropSalePrice]*([DefBasePercentJumbo])/100) AS LoanBaseJumbo, [LoanBaseFHA]*[DefMipFHA]/100 AS MipFHA, [LoanBaseCONV]*[DefMipCONV]/100 AS MipCONV, [LoanBaseJumbo]*[DefMipJumbo]/100 AS MipJumbo, [TransBuyerPropSalePrice]*(IIf([TransBuyerPropSalePrice]>=[DefLoanMinJumbo],[DefFundingJumboVA],IIf([TransBuyerVaUsed]="Yes",[DefFundingUsedVA],[DefFundingVA])))/100 AS VAFunding, [LoanBaseFHA]-[DownOverMinFHA]+[MipFHA] AS LoanTotalFHA, [LoanBaseCONV]-[DownOverMinCONV]+[MipCONV] AS LoanTotalCONV, [LoanBaseJumbo]+[MipJumbo]-[DownPaymentJumbo] AS LoanTotalJumbo, [LoanBaseVA]+[VAFunding]-[DownPaymentVA] AS LoanTotalVA, [TransBuyerPropSalePrice]*([DefMinDownPayFHA]/100) AS MinDownFHA, [TransBuyerPropSalePrice]*[DefMinDownPayCONV]/100 AS MinDownCONV, [TransBuyerPropSalePrice]*[DefMinDownPayVA]/100 AS MinDownVA, [TransBuyerPropSalePrice]*[DefMinDownPayJumbo]/100 AS MinDownJumbo, tblTransactionBuyer.TransBuyerIntRate, tblTransactionBuyer.TransBuyerLoanYears, tblTransactionBuyer.TransBuyerHazardIns, tblTransactionBuyer.TransBuyerFloodIns, tblTransactionBuyer.TransBuyerClosingDate, IIf(([TransBuyerConvDownPayPercent]/100)*[TransBuyerPropSalePrice]>[TransBuyerConvDownPayCash],([TransBuyerConvDownPayPercent]/100)*[TransBuyerPropSalePrice],[TransBuyerConvDownPayCash]) AS ConvDownPay, tblDefaults.DefBuyAppraisal, tblDefaults.DefBuyCreditReport, tblDefaults.DefBuyJumboUnderwriting, tblDefaults.DefBuyVAUnderwriting, tblDefaults.DefBuyFHAUnderwriting, tblDefaults.DefBuyCONVUnderwriting, tblDefaults.DefBuyJumboTaxService, tblDefaults.DefBuyVATaxService, tblDefaults.DefBuyFHATaxService, tblDefaults.DefBuyCONVTaxService, tblDefaults.DefBuyFloodCert, tblDefaults.DefBuyAbstractTitle, tblDefaults.DefBuyMiscFedex, tblDefaults.DefBuyRecording, tblDefaults.DefBuySurvey, tblDefaults.DefBuyAttorney, tblDefaults.DefBasePercentFHA, tblDefaults.DefBasePercentCONV, tblDefaults.DefBasePercentJumbo, tblDefaults.DefBasePercentVA, [TransBuyerPropSalePrice]*[DefPropTaxRate] AS PropTax, [LoanBaseFHA]*[DefBuyOrigFHA]/100 AS OrigFHA, [LoanBaseCONV]*[DefBuyOrigCONV]/100 AS OrigCONV, [LoanBaseVA]*[DefBuyOrigVA]/100 AS OrigVA, [LoanBaseJumbo]*[DefBuyOrigJumbo]/100 AS OrigJumbo, [DefTitleInsDollar]*([TransBuyerPropSalePrice]/[DefTitleInsPerX]) AS TitleInsurance, [OrigFHA]+[DefBuyAppraisal

View Replies !

SQLExpress - Remote Access Trouble When Publishing A Site
Hi all,
I followed this excellent tutorial (from Microsoft) about creating and using a SQLExpress db table internal to your website:
http://www.asp.net/learn/videos/video-08.aspx
and the site I created works just fine - locally. When I publish to my web host provider I get this error:
[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
My web host provider supports .NET 2.0 but doesn't support MS SQL Server. But that should matter - right? Because I'm putting the db instance right in the website?
I did a search and followed some of the advice:
I went into the SQL Server Surface Area Config Mgr and set SQLExpress for local and remote connections and rebooted/republished. I also have SQL Server 2005 installed as a separate entity (if that makes a difference).
I still get the above error. This is the connection string from the web.config:
<connectionStrings><add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Customers.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>And this is the call from the markup:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [Customer]"></asp:SqlDataSource>
Does any know the fix for this?
Thanking you in advance
Pat

View Replies !

Trouble With Cursor Designed To Revoke Object Access.
Hi everyone. I am having difficulties with a cursor that I am trying to write. The purpose of the cursor is to loop through all tables in a selected Database and revoke "Select" access to that table for the indicated role (RoleToRevoke). I am getting the error on the @name variable within the REVOKE statement. I have placed a comment indicating where I am getting the error. Is there a way to have sql server interpret this @name variable within the REVOKE statement? Thanks for your help.

Code Snippet

USE [Database_Name];

Declare cursorExample Cursor for
Select TABLE_NAME
from information_schema.tables
Where TABLE_TYPE='Base Table'
and TABLE_SCHEMA='dbo'

Declare @name as varchar(255)
Declare @ErrorSave as int
Declare @ErrorCount as int

Open cursorExample

Fetch Next from cursorExample into @name

SET @ErrorSave = 0
SET @ErrorCount = 0

Begin Tran

While @@Fetch_Status=0

Begin

--Getting Error on Line below on @name
REVOKE SELECT ON OBJECT::@name FROM RoletoRevoke;

IF (@@ERROR <> 0)

BEGIN

Print 'Error Revoking Access to Table: ' + CAST(@name AS varchar(75))
SELECT @ErrorCount = @ErrorCount + 1
END
IF (@@ERROR = 0)

BEGIN

Print 'Successful Revoking Select Rights on Table: ' + CAST(@name AS varchar(75))

SELECT @ErrorSave = @ErrorSave + 1
END
Fetch Next from cursorExample into @name

End

IF @ErrorCount = 0

BEGIN

COMMIT TRAN
PRINT 'COMMITTED TRANSACTION'
PRINT 'Total Tables Affected:' + CAST(@ErrorSave AS varchar(75))
END
ELSE

BEGIN

ROLLBACK TRAN
PRINT 'ROLLED BACK TRANSACTION'
END

Close cursorExample
Deallocate cursorExample
GO

View Replies !

Connect To RDB Database-CONNECT TO ORACLE RDB HYC00 (Driver Not Capable)
i am using reporting services to prepare reports. My database though is not SQL is RDB. I using ODBC to connect to RDB with "Oracle ODBC for RDB" Driver version 2.10.17.00. This is my data source.

When i use this datasource to create a report when designing a query i get an error "CONNECT TO ORACLE RDB HYC00 (Driver not capable)" and i cannot see the tables graphically set the relations and prepare the query. The only way is to write manually the statement in rdb format and this is very difficult.

Is there a way to be able to design my query graphically?

View Replies !

Trouble Exporting Database
Hi all, this has been bothering me for a few days now so i thought id better get some good advice!
I am going through the process of exporting a SQL Server 2005 DB to my hosting company for the first time. Initially I tried using SQL Server Management Studio to "Export" the DB, which has all of the membership functionality (by runnung aspnet_regsql.exe) and a few extra tables - nothing too complicated.
Exporting with SQL SMS did not seem to copy my stored procedures accross and this gave me problems.
I then tried SQL Server Database Publishing Wizard - as recommended by this post: http://weblogs.asp.net/scottgu/archive/2007/01/11/tip-trick-how-to-upload-a-sql-file-to-a-hoster-and-execute-it-to-deploy-a-sql-database.aspx
So this is my process:
1. set up empty DB on hosting server2. get admin to allow dbo permissions on this DB3. open SQL SDPW and create a script which will create an exact copy of my local DB4. run the script on my new empty Db on server...
when i do this i get the following errors:
Msg 208, Level 16, State 1, Procedure vw_aspnet_Users, Line 3Invalid object name 'dbo.aspnet_Users'.Msg 208, Level 16, State 1, Procedure vw_aspnet_MembershipUsers, Line 3Invalid object name 'dbo.aspnet_Membership'.Msg 208, Level 16, State 1, Procedure vw_aspnet_Profiles, Line 3Invalid object name 'dbo.aspnet_Profile'.Msg 208, Level 16, State 1, Procedure vw_aspnet_UsersInRoles, Line 3Invalid object name 'dbo.aspnet_UsersInRoles'.Msg 208, Level 16, State 1, Procedure vw_aspnet_WebPartState_User, Line 3Invalid object name 'dbo.aspnet_PersonalizationPerUser'.

When i look at the DB hosted on the server, it seems that all of my stored procedures are there. One thing I noticed was that some of my "Views" were in the "Tables" folder (i dont know if this matters)The result that this is having is that I do not get any errors, but the queries on my page where i reference one of my views (like vw_aspnet_MembershipUsers), the latest records are not appearing.I think that somehow my stored procedures are not referencing the correct views and tables maybe?Anyway - if anyone has come across this, please help me out (even if its just to say ive done something stupid )

View Replies !

Having Some Trouble Connecting To A Database....
I am doing one of the Microsoft virtual labs "Creating ASP.NET Web Applications with C# - Part 2" using Visual Web Developer Express. I am trying to fill a gridview with database information, but it gives me the error "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)".This is on the local machine that I am executing the code. public void BindGrid(string sortfield)
{
//Create DataAdapter to fetch data from Prodcuts table
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Products", myConnection);
//Create dataset and fill it with Product data
DataSet ds = new DataSet();
myCommand.Fill(ds, "Products");
//Bind Product data to Datagrid
DataView Source = ds.Tables["Products"].DefaultView;
Source.Sort = sortfield;
dgProducts.DataSource = Source;
dgProducts.DataBind();
} It stops on the line "myCommand.Fill(ds, "Products"); and points out the error mentioned earlier. I am not sure what to do...any help would be greatly appreciated, thanks in advance, and I apologize as well if I have not pointed out enough information.

View Replies !

Trouble Deploying Sql Database
I used VWD 2005 Express to create my web application (that uses a sql 2005 database), and now I'm trying to deploy it. I was to understand that all I had to do was to upload all my files to the root folder and the web host's server (webhost4life.com). However, they require me to upload the sql 2005 db to a seperate sql server using a control panel that is very clunky. Does anyone know how to upload the sql 2005 db to the host server or an online tutorial where I could go to learn? Thanks for the help!

View Replies !

Having Trouble Connecting To Database
Hi I am new at this.
I have a little program written in C# in asp.net. The program basically accesses a database and stores new records. The database is supposedly already attached to MSDE so I am able to see the tables of the database inside asp.net. I can click on the individual slots of the table and modify the datas manually. However, I want to connect to the database from my C# program and be able to input data into the database via the website that the C# program produces. After I type in the data into the website and click the submit button on the website, I get an error page that says this:
Login failed for user 'sa'
the line of code thats causing this error is:
con = new SqlConnection("data source=(local)\NetSdk; initial catalog=Friends; user id=sa");
Why is it not able to connect to the database?

View Replies !

Restoring SQL 7.0 Database Trouble
Hi,

I'm trying to restore sql 7.0 database. The backup was initiated by backupexec (with sql agent).
After restoring database, Enterprise Manager shows New DB as "Loading". Any attempt to enter the DB returns an error about the fact that database is in the middle of recovery.
(SQL 7.0 + SP.3)

Any help would be appreciated

P.S one event I managed to pull from SQL was: "Bypassing recovery for database 'CAAMDB' because it is marked IN LOAD."

View Replies !

Trouble Writing To A Database
I am trying to write to a database through C++ with the ODBC stuff. I can connect to and close the database as well as write certain things to it. I am having trouble writing strings or chars to it though. I'm not really a DB programmer and probably won't have to do it in C++ for a long time, so I'm just looking for some quick help so I can move on to other stuff. I know this code probably won't look right either since I;ve only seen this stuff for about 2 days now. Basically I have a string that I want to bind using SQLBindParameter so that I can use it in an ExecDirect statement. Basically when I run the little code snippet below, it writes some crazy character set out. Any help would be appreciated because I really have no clue what I'm doing.

SQLCHAR test1 = 'a';
SQLINTEGER test = SQL_NTS;

retcode = SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR,0,0,&test1, 0,&test);

View Replies !

I Am Having Trouble Connecting To The Database

Dear Sir -

I am new to thsi and I have installed the SQL server 2005 Dev (not express). I am useing Visual Web Express - When I create an application and attempt to launch it - the web config tell me that I am unable to connect to the Database - in the properties page (sidebar) the database status says closed - an I cannot seem to connect if though I go into the connections and test it says connected!

What is happening?

I need this to work? Can anyone assist?

View Replies !

Trouble Using SQL Database In VB Express
First off, I am fairly new to sql.

I've created an sql database in VB express, created some tables, and entered some data in those tables. My problem now lies with actually using that data. What i'd like to do is have a Sub use the database's data and fill in a series of variables. Right now i have the Sub using an Excel file to assign the information, looks like this:

Public Sub CharStatDefault() 'loads each character's default stats

CharSheet = xlBook.Worksheets(2)

P.initialize()

For excelInt = 1 To 22

P.C(excelInt).Initialize()

With P.C(excelInt)

.Vit = CharSheet.Range("AC" & excelInt).Value

.Phy = CharSheet.Range("AD" & excelInt).Value

.Mag = CharSheet.Range("AE" & excelInt).Value

.Off = CharSheet.Range("AF" & excelInt).Value

.Def = CharSheet.Range("AG" & excelInt).Value

.Agl = CharSheet.Range("AH" & excelInt).Value

End Sub

So basically i want to change the CharSheet.Range("XX" & excelInt).Value to something that utilizes the data from my database.

View Replies !

Having Trouble Creating Database Diagrams
tried to add a third and fourth table to an exsiting relationship diagram in VS05 server explorer, when i click save i get an error "the operation could not be completed" i am able to create new diagrams but it seems every time i click save, and close the diagram the reopen it and add new tables then click save i get the same error message, i dont even try and create the actual relationship but just add a third table and boom the problem occurs
thanks in advance

View Replies !

Serious Trouble Getting Database Table Information
I would like to know how to (if it is at all possible) in SQL (or even ADO) to retrieve all the data concerning database X's

a) Tables
b) Tables column names
c) Tables column's data types

I don't want to use the doa.tabledefs object.. .i would prefer to do it in SQL, but using ADO objects (since I am developing stuff in VB) would be ok too.

Please Help.. i have been going crazy trying to find anything useful.. email me back please!

Thanks,
Matt

View Replies !

Trouble Restoring A Database To A Different Server
Hello everyone.
Pretty new to SQL Server and i've run into some trouble with something I am attempting to do.

Basically, we imported one of our databases on one of our SQL Servers to a new sql server that we just setup. That went ok with no problems. The DB is now in the new SQL Server.

Now, we need to copy the contents of a second DB from the original server into this new sql server DB. For reference:

We imported a DB Called: siebeldb
We want to import/overwrite another DB into that same DB. We backedup the DB and moved the file to the new SQL server.

So:

Import/Restore: sbprd01(a backup file) into siebeldb

I hope that makes sense.

I have the following command that I am trying to execute in the SQL Query analyzer:

RESTORE DATABASE siebeldb
FROM DISK='C:Documents and SettingsAdministratorDesktopsiebelprddb092509.bak'
WITH MOVE 'siebelprddb_Data'
TO 'C:Program FilesMicrosoft SQL ServerMSSQLDatasiebeldb_Data.mdf',
MOVE 'siebelprddb_Log'
TO 'C:Program FilesMicrosoft SQL ServerMSSQLDatasiebeldb_Log.mdf',
REPLACE

It is running right now, but seems to be running into errors. I just added the 'REPLACE' option according to the t-sql reference guide.

Does my script look ok? Am I doing anything wrong?

Thanks,.

Sektor

View Replies !

Cannot Connect To SQL From Access
I can connect to SQL from some Access forms that are in SQL test server.

But when I try and connect to the same forms on a development server I cannot insert records. Even though I have changed the connection in the script.

Can someone please tell me what I am doing wrong????? I do have full permissions both boxes.

Thanks,
Dianne

View Replies !

Having Trouble Following Tutorial - Working With Data In ASP.NET 2.0 :: Creating A Data Access Layer
HiI'm having problems following the tutorial on creating a data access layer - http://www.asp.net/learn/dataaccess/tutorial01cs.aspx?tabid=63 - when I try to compile in Visual Studio 2005 I get namespace could not be found. I followed exactly the tutorial - I created a dataset and added this code in my aspx page. <asp:GridView ID="GridView1" runat="server" CssClass="DataWebControlStyle"> <HeaderStyle CssClass="HeaderStyle" /> <AlternatingRowStyle CssClass="AlternatingRowStyle" />In my C# file I added these lines... using NorthwindTableAdapters; <<<<<this is the problem - where does this come from? protected void Page_Load(object sender, EventArgs e) { ProductsTableAdapter productsAdapter = new ProductsTableAdapter(); GridView1.DataSource = productsAdapter.GetProducts(); GridView1.DataBind(); }Thanks in advance

View Replies !

Trouble Converting Datatype For Database Insert
Hi,
I need to take a value from a textbox and insert it into a field in my database which takes decimals. My problem, no matter what I try I cannot convert the value so that the database will accept it. This all happens when the submit button is hit on my webpage. Here is the cmdSubmit_click sub code:

Dim surveyNum As Decimal = Decimal.Parse(txtSurveyNum.Text, Globalization.NumberStyles.Number)
myCmd.CommandText = "INSERT INTO survey(ID) VALUES('" & surveyNum & "')"
myCmd.Parameters.Add("surveyNum", SqlDbType.Decimal)
myCmd.Parameters("surveyNum").Value = System.Convert.ToDecimal(txtSurveyNum.Text)

myConn.Open()
Try
myCmd.ExecuteNonQuery()
lblMessage.Text = "Record successfully updated"
Catch
lblMessage.Text = "Query error: " & Err.Description
End Try
myConn.Close()

Thnx in advance, any help would be greatly appreciated.

View Replies !