when i trying to make run the sql server in the sql server configuration I recieve this message the specific module could not be found [08007007e]. I wnat to know how to solve it
View 3 Replies
when I click on the lookups tab with SQL Server 2005 Legacy DTS I get the following error.
The specified module could not be found. (ERROR_MOD_NOT_FOUND)
Some modules the query builder depends on could not be found. The query builder designer will not be functional.
What module is this and how do I get it?
Hi,
I tried to change / add password in SQL Server Compact Edition 2005 (in Mobile 5.0) via SQL Server Management Studio. As a result I got an error: "The specified module could not be found." I wonder why and how can I change the (blank) password to a new one?
Regards and thanks in advance,
Mixxo
I'm new to ADO.NET and need help with this error.
Currently running Vista Home Premium 64 and Visual Studio 2008 Trial.
1. Create Win form app.
2. Add new data source...
3. New connection - SQL Server Compact 3.5 - Northwind.sdf
4. Highlight Products and Suppliers.
5. Drag both onto Win form
6. Run with debug
7. Error message "Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)"
some blogs advice change dir in SQL Server Compact 3.5 in regedit but regedit doesn't even have SQL Server Compact 3.5; only SQL ServerSQLExpress.
reinstall SQL Server Compact 3.5 and problem still exists.
anyone knows how to fix this problem?
Hi Everyone,
I have problem when installing SQL 2005 Enterprise to my Windows 2003 R2 cluster. I install the SQL instance on the first node in my cluster, it analyses the cluster and comes up with no errors or warnings, i answer all the installation questions and proceed with the installation. When installing the SQL engine I see the status changing as the instance is started and then stopped again etc, finally the status changes to "removing backup files" when it get an error that reports:
"The setup has encountered an unexpected error while Completing Commit. The error is: The specified module could not be found."
Unfortunately there isnt any more information to go on. Any help would be appreciated.
I've got a package which reads a text file into a table and updates another. I set up configurations so that I could import it into the SSIS store on both my dev and live servers. Now, I'm getting this error. I tried removing the configs and am still getting it.
I've been through each step and everything looks okay. Does anyone have any idea (a) what's wrong, (b) how to localise the error or (c) get any additional information? Or do I just have to recreate the package from scratch?
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at PartnerLinkFlatFileImporter: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found.
Error at PartnerLinkFlatFileImporter [Log provider "SSIS log provider for SQL Server"]: The connection manager "" is not found. A component failed to find the connection manager in the Connections collection.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
Is it possible to change the EXECUTE AS principal on a module (such as a stored procedure or function) without having to redefine the entire module in an ALTER statement? I didn't find anything in BOL about it in the ALTER PROCEDURE or ALTER FUNCTION articles. If there is a system sproc that does it, I couldn't find it. Changing system tables is not an option (assuming that is an option) for me.
View 1 Replies View Relatedokay so pretty much I am using the asp.net 2.0 membership/roles.i wanna make a search box that users can type in a name and it will search the database. most likely in the table "aspnet_Users"so when users search i want it to be like this:cmd = select * from [table] WHERE username = textbox1.text (ofcourse with parameters instead of concatenation).but i want it to have a "like" in thereso if the users type in "fenix" they should get results matching CLOSE to fenix. so masfenix, fenix, fenxi, and you know related names. that are similar. should I use LIKE? and if so HOW do i use that?is it just gonna becmd = select * from [table] where Username LIKE @username@username = textbox1.text ?thanks
View 3 Replies View RelatedHello everyone! This is my first post so please bear with me. We haverecently re-vamped an Access application such that in each of our 5locationsa local SQL server receives published updates from our main office server.Remote servers also send their local updates to the master and they are inturn propogated to all of the other remote servers. The new design worksgreat except for one annoying bug we have been chasing for two weeks:"Faulting application msaccess.exe, version 9.0.0.2719, faulting modulemso9.dll, version 9.0.0.2720, fault address 0x0007ee2d." When a user getstheerror, they hit close and it terminates Access. If they move the error offthe screen and continue working the application continues. They havediscovered this and have been doing so but the fact that the error appearsmust be fixed. If anyone can point me in the right direction it would bemuchly appreciated. Thanks in advance!- Markmweber_at_warrenlumber_dot_com
View 1 Replies View RelatedDear All,
I am facing one problem on my SQL server 2000.
While accessing some records from the database I am getting this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Unable to load communication module. Driver has not been correctly installed.
I am using ODBC connection with sql authentication
How to solve this issue.
with regards
Shaji
Hi, Am migrating my SQL 2000 legacy app to SQL2005 and am dealing with restrictions on the underlying system tables. Have taken advice that Granting VIEW state to all users is heavy handed (especially meta data access at SERVER level). Now looking at Module signing which is great. I can supply SP's which target the few System table/ information schema fields that I require. Now I Sign the Sp's cool, now I grant exec rights to the application role (doesn't work). Create a db role and put my users in it, okay grant role exec on Sp's (fine they work).
However my application runs under an application role always, so my users rights are ignored and it appears that its only the users not the approles who can benefit from the module signing ? I know I can switch too and from approle using cookies but I seem to be going round in cirlces here.
Essentially is there any 'EASY' and 'CONTROLLED' way that my application user who has no rights, who immediately switches to the application role can see the dbName (All rows ) from master.sysdatabases ?
Thansk for any advice
Help please. I have a custom assembly that was written in vb.net 2003 which is working great on RS2000 and also on RS2005 on my development machine. To get it to work on RS2005 all I had to do was copy it into the ...MSSQL.3Reporting ServicesReportServer folder. The assembly is named prjCheckDate and is simply a function to calculate dates where the user types in a "T-x" string, the x is number of days backwards from today, and returns that actual date.
On the customer's production machine, when I try to upload the report RDL, via Report Manager, I get the following: "Error while loading code module: €˜prjCheckDate, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null€™. Details: Could not load file or assembly 'prjCheckDate, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Access is denied. (rsErrorLoadingCodeModule) Get Online HelpError in class instance declaration for class prjCheckDate.classSymDate: [BC30002] Type 'prjCheckDate.classSymDate' is not defined. (rsCompilerErrorInClassInstanceDeclaration) Get Online Help
There is an error on line 11 of custom code: [BC30451] Name 'prjCheckDate' is not declared. (rsCompilerErrorInCode) Get Online Help "
I have gone to the rssrvpolicy.config file and added a code group as follows: "
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="prjCheckDAte.dll"
Description="This is custom assembly for T-x date format processing">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerinprjCheckDate.dll"
/>
</CodeGroup>"
This was added immediately after the existing entry for the URL membership "$CodeGen$/*" area per MSDN (ms152828).
I'm still getting the same error. I did not get to reboot the server this is on as it is a production machine and the client is hesitant to allow a reboot since this machine is used to log time and attendance and needs to be available 24x7.
Appreciate any help. Thanks. Jim
With this query i get only the records i need, but i would like to output in this way
1 - 20
21 - 30
31 - 40
of course in the real environment the ID are not consecutive, this is just one example of data.
declare @temp table (ID int)
declare @i int = 1
while(@i<1000) begin
insert into @temp values (@i)
set @i=@i+1
end
select ID from (
select ID, row_number() over (order by ID)
as rn
from @temp
) q where (rn % 20=0) OR (rn % 20=1)
when i create a new database in microsoft sql server management studio,following error message is occurred;
===================================
Cannot show requested dialog.
===================================
The specified module could not be found. (Exception from HRESULT: 0x8007007E) (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand)
at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseGeneral.Microsoft.SqlServer.Management.Sql Mgmt.IPanelForm.OnSelection(TreeNode node)
at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.DynamicallyEmbedUserControl(ViewI nfo vi, TreeNode node)
at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SetView(Int32 index, TreeNode node)
at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SelectCurrentNode()
at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.InitializeUI(ViewSwitcherTreeView treeView, ISqlControlCollection viewsHolder, Panel rightPane)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(ISe rviceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartTh read()
----------end of error message--------------------------
Microsoft.SqlServer.Management.Common package is situated in
Microsoft.VisualStudio.vspConnectionInfo.dll.
This dll also exist in the same folder path(D:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDE
) with SqlWb.exe(SQL Server Management Studio).
i assume that dll can't be known by exe.
how can i make exe know dll. or, is my assumption wrong?
if so, how can i make it work?
Thanks in advance,
Can i share a function module to all the reports in a report project, that i can use the functions in the formating or expressions. Is there any way to add a assembly reference to the project and can include all the functions in an assembly file?
View 6 Replies View RelatedHi!
i am getting this error when i execute the package in production environment
Source: Select Tickets DTS.Pipeline
Description: The module containing "component "Conditional Split" (142)" cannot be located, even though it is registered.
End Error
Error: 2006-09-01 14:03:40.36
Code: 0xC004706E
Source: Select Tickets DTS.Pipeline
Description: The module containing "component "Data Conversion" (5863)" cannot be located, even though it is registered.
End Error
Error: 2006-09-01 14:03:40.36
Code: 0xC004706E
Source: Select Tickets DTS.Pipeline
Description: The module containing "component "OLE DB Source" (1)" cannot be located, even though it is registered.
End Error
Error: 2006-09-01 14:03:40.36
Code: 0xC004706E
Source: Select Tickets DTS.Pipeline
Description: The module containing "component "Excel Destination" (4516)" cannot be located, even though it is registered.
End Error
Error: 2006-09-01 14:03:40.36
Code: 0xC004706E
Source: Select Tickets DTS.Pipeline
Description: The module containing "component "Flat File Destination" (6486)" cannot be located, even though it is registered.
End Error
Progress: 2006-09-01 14:03:40.36
Source: Select Tickets
Validating: 0% complete
End Progress
Error: 2006-09-01 14:03:40.37
Code: 0xC0048021
Source: Select Tickets Conditional Split [142]
Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "Conditional Split;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All R
ights Reserved; http://www.microsoft.com/sql/support;0".
End Error
Error: 2006-09-01 14:03:40.37
Code: 0xC0047017
Source: Select Tickets DTS.Pipeline
Description: component "Conditional Split" (142) failed validation and returned error code 0xC0048021.
End Error
Progress: 2006-09-01 14:03:40.37
Source: Select Tickets
Validating: 20% complete
End Progress
Error: 2006-09-01 14:03:40.37
Code: 0xC004700C
Source: Select Tickets DTS.Pipeline
Description: One or more component failed validation.
End Error
Error: 2006-09-01 14:03:40.37
Code: 0xC0024107
Source: Select Tickets
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 2:03:39 PM
what is the problem? any one who has faced this
any solution
thanks,
jas
I have a custom assembly that I wrote. I placed it in the GAC and the report runs fine locally. I placed it on the server in the GAC and it kicks out the following error when deploying:
Error while loading code module: €˜SSRSReporting, Version=1.0.1.0, Culture=neutral, PublicKeyToken=de4c010eaf2f2fe8€™. Details: Could not load file or assembly 'SSRSReporting, Version=1.0.1.0, Culture=neutral, PublicKeyToken=de4c010eaf2f2fe8' or one of its dependencies. The system cannot find the file specified. ....
If I put the file in the /bin directory on the server there is no issues and it works fine. I need to to deploy to the GAC though. I restarted IIS and the RS services. I still have the same issue.
I need to select specific values from all rows where the value of a specific column is "Active"
This part works: SELECT LastName, FirstName, MiddleInit, ClientId FROM dbo.Client
But I want to add: WHERE StatusType = (Active) and how to do this.
We have a "main" SQL 2014 server who imports XML files using SSIS in a datacenter. In remote sites (which are warehouses), there is an instance of SQL 2014 Express. A merge replication is setup, as every operations done on each site must be "forwared" to the main database, as some XML files are generated as output for an ERP system.
Now, the merge replication replicate all the data to the server on each sites. But a specific site don't need the data of every other sites, only the data relevant to itself (which is the warehouse code). Is there a way to replicate only the data relevant to each individual sites to the subscribers? Or is there a better way than replication to accomplish this?
I want to ship 500,000 aged transactions each night to an archive table and delete them from their source table in one or more logical units of work (LUW). Each row is approx 60 bytes and there is only one non clustered index on the source table presently.
I'm trying to weigh the pros and cons of 3 alternatives. One of them would basically insert the non-aged rows into tempdb, ship the aged records, truncate the table and then insert the tempdb records back into their source all in the same LUW.
For this alternative, I'd at least like to turn off logging when the records get inserted into tempdb as I dont see any value in logging that part of the activity. Is this possible?
Hi All,
Could you guys please help me with printing reports invoked thru command line/ URL access to print automatically to specific printers and specific trays and also is it possible to set the specific printer and tray as parameters.
Any suggestions is appreciated
Thanks A lot in advance
e,g :
http://localhost/reportserver?/testreports/employee sales&UserID='ABC'&LName=Lastname='victor'&rs:Command=Render
Hi,
I have come to know from the SQL Server documentation that the Hardware Security Modules (HSM) can be used for Cryptographic Key storage within SQL Server to increase the level of protection of data at rest. We provide a HSM Solution which protects cryptographic keys and performs cryptographic operations onboard. The aforesaid fact about SQL Server and HSMs motivates us to test our HSM product with the SQL Server. Our HSM solution provides SDK for applications/servers to communicate with the HSM hardware. The SDK basically consists of two libraries:
-MS CAPI Interface (CSP Library)
-PKCS#11 Interface (cryptoki Library)
I have found this forum best for such kind of discussion. So could you guys on the list let me know:
- How the CSP or PKCS#11 library can be integrated with the SQL Server for HSM box to protect the cryptographic keys?
- Would I need to write a new Interface/Wrapper for this integration, If yes please help?
Thanks in advance.
Harsh.
Hi there !
Thanks for taking the time to read this thread.
I don't know whether anyone has this problem, but I am definitely not using the right keywords to search for a thread.
My situation is this...
I have a dataset that has values to fill cells to multiple tables in a report.
However, I only want to select specific data from the dataset to fill textboxes and others.
I cannot change the stored procedure, but the sample of the data is shown below:-
Row Stat Val
0 dtRpt1 02/01/2005
1 Value1 1
2 Value2 2000
3 dtMailSent 02/28/2005
4 Value3 0
5 Value4 5
6 Value5 658
I know it looks weird, but the row really represents which "row" or textbox is it to fill with the Val. The Stat Column is just a way to make sure that I am filling the right values.
so my new report would have multiple tables to denote different categories.
In my first table, I tried putting the cells as follows:-
(expressions are highlighted in italics and bold)
TextBox1 =IIF(Fields!Row.Value =0, Fields!Val.Value,"")
Table1
Column1
DetailRow1 =IIF(Fields!Row.Value =1, Fields!Val.Value,"")
DetailRow2 =IIF(Fields!Row.Value =2, Fields!Val.Value,"")
Table2
Column1
DetailRow1 =IIF(Fields!Row.Value =3, Fields!Val.Value,"")
DetailRow2 =IIF(Fields!Row.Value =4, Fields!Val.Value,"")
DetailRow3 =IIF(Fields!Row.Value =5, Fields!Val.Value,"")
DetailRow4 =IIF(Fields!Row.Value =6, Fields!Val.Value,"")
I only expect this report to print out one page holding the previous values.
However, it ended up printing like this
----------------------------------------------------------
Table1
Column1
DetailRow1 1
DetailRow2
Column1
DetailRow1
DetailRow2 2000
Table2
Column1
DetailRow1 02/28/2005
DetailRow2
DetailRow3
DetailRow4
Table2
Column1
DetailRow1
DetailRow2 0
DetailRow3
DetailRow4
Table2
Column1
DetailRow1
DetailRow2
DetailRow3 5
DetailRow4
Table2
Column1
DetailRow1
DetailRow2
DetailRow3
DetailRow4 658
------------------------------------------------------
I tried putting it into the headerrows instead of DetailRows, and it ended up printing the last value.
Is there anyway to do this ? print all the values out in one table ? I tried using textboxes, but I think I got my expression wrong.
Is this the correct expression ?
=IIF((Fields!Row.Value,"Dataset") =1, (Fields!Val.value, "Dataset"), "")
and it give me an error
The value expression for the textbox €˜textbox5€™ contains an error: [BC30455] Argument not specified for parameter 'FalsePart' of 'Public Function IIf(Expression As Boolean, TruePart As Object, FalsePart As Object) As Object'.
Appreciate any advice or suggestion for this scenario !
Thanks!
Bernard
I am very early on in developing a website to track issues with projects which is tied to a SQL database. I have my Projects Table, my Users Table, and am creating a third table to track issues. I'm wondering what is the best way to assign specific users to specific data/projects. The user should only be able to view & update the projects assigned to him. He should not be able to see other projects. What is the best way to assign projects/data to the users to make sure they are only viewing their data?
View 1 Replies View RelatedDear All:
When i try to debug the northwindoledb example with VS2005 i get the foolwing error message.
Is there a way to configure the solution to run witn WM5 emulator.
The application run with wm5 emulator when i set the plataform to Windows Mobile 2003, but i want to use the wm5 platform to debug my application with wm5 emulator.
------ Rebuild All started: Project: northwindoledb, Configuration: Debug Windows Mobile 5.0 Pocket PC SDK (ARMV4I) ------
Deleting intermediate and output files for project 'northwindoledb', configuration 'Debug|Windows Mobile 5.0 Pocket PC SDK (ARMV4I)'
Compiling...
Employees.cpp
northwindoledb.cpp
stdafx.cpp
Generating Code...
Compiling resources...
Linking...
coredll.lib(COREDLL.dll) : fatal error LNK1112: module machine type 'THUMB' conflicts with target machine type 'ARM'
Build log was saved at "file://d:Proyectos_VS2005Northwindoledb_WM2003_SQLEW_Windows Mobile 5.0 Pocket PC SDK (ARMV4I)DebugBuildLog.htm"
northwindoledb - 1 error(s), 0 warning(s)
========== Rebuild All: 0 succeeded, 1 failed, 0 skipped ==========
We have a brand new sql 2k server. Its all up to date on service packs(both win2k and SQL).I went in to enterprise manager and added a new db. I can run sprocsand raw sql against the new db just fine from Query Analyzer.When I try to make a dts package that refers to my new db I get thefollowing error:Error desription: deferred prepare could not be completed.Could not locate entry in sysdatabases for database 'mydbname'. Noentry found with that name. Make sure that the name is enteredcorrectly.OK, so I look in sysdatabases and see 'mydbname'. Just in case im anidiot... I actually copied the db name from that table and paste it inmy dts window.My dts package is using an "execute SQL task" to call a stored proc.To be ecxact:USE mydbnameGOEXEC MyProcWhen I click on the parse button, is when I get that error message.I have deleted the db, restarted the server, and recreated the db witha slightly different name. I can replace mydbname with pubs ornorthwind and all is ok. It just doesnt like new db's.Any help would be greatly appreciated.Thanks,Dave
View 1 Replies View RelatedGreetings,
I've found a bug in SQL CE 3.0/3.1. This has been confirmed to be present by other users of this and the microsoft.public newsgroups, both in the Windows CE versions and the desktop x86 versions. I got this response:
Laxmi Narsimha Rao ORUGANTI MSFT wrote:
Can you please provide the simplified repro with full VS Solution you have thru our blog: http://blogs.msdn.com/sqlservercompact/contact.aspx. First contact us and then we will exchange directly thru mail.
And that's where it has ended (after I contacted the team via the blog - no response). Other forum users have suggested that I post here repeatedly until I get a response, so that's what I'm doing. Apologies.
TIA
ID
Been trying to get this one but need a little input.
SELECT a.Id,g.LabName......
FROM someTbl a,table g
WHERE a.id = @idAND (b.calLab = g.ID OR g.LabName = ???)
With the above, if b.calLab = 0 then there is no entry in table g.(I didn't develop the table or would have included NONE)
So, how to tell g.LabName to come back as 'None' if b.calLab = 0?
Thanks,
Zath
Hello,
I'm working on a function that will return the results in a SELECT statement. But it's not being called properly, and I can't understand why it isn't working. If anyone can help me out I'd greatly appreciate it.
Here's the function code:1 FUNCTION [dbo].[UDFproduct_Search]2 ( 3 @search_string varchar(255)4 )5 RETURNS TABLE 6 AS7 RETURN 8 (9 SELECT product_id10 FROM product11 WHERE product_item_number LIKE '%' + @search_string + '%' OR12 product_part_number LIKE '%' + @search_string + '%' OR13 product_name LIKE '%' + @search_string + '%' OR14 product_commodity LIKE '%' + @search_string + '%'15 )
This SELECT statement returns the expected value:SELECT * FROM UDFproduct_Search('CABINET')
This SELECT statement returns the expected value:1 SELECT * FROM where_used WHERE product_id 2 IN(SELECT product_id FROM product3 WHERE product_item_number LIKE '%' + 'CABINET' + '%' OR4 product_part_number LIKE '%' + 'CABINET' + '%' OR5 product_name LIKE '%' + 'CABINET' + '%' OR6 product_commodity LIKE '%' + 'CABINET' + '%')
This SELECT statement returns errors:SELECT * FROM where_used WHERE product_id IN(UDFproduct_Search('CABINET') Error:'UDFproduct_Search' is not a recognized built-in function name.
I've tried adding dbo to the function call, and in various locations, but I still get the error. Hope someone can point something out I missed.
Thanks.
hi... i am very new to SQL server.. previously was using MySQL...
now i am trying to connect my project to SQL Server..
but i wasnt able to...
i keep getting errors
System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at System.Data.Odbc.OdbcConnection.Open() at icms.DB.q(String mySTR) in C:icmsDB.vb:line 30
below is my webconfig
i am not very sure about the value for the user.. because if it is MySQL i can get it from my control centre.. but what about SQL server ? where should i get my value ?
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="db" value="icms" />
<add key="db_user" value="sqladmin" />
<add key="db_server" value="server" />
<add key="db_pwd" value="*****" />
<add key="session_timeout" value="600" />
</appSettings>
<system.web>
<compilation defaultLanguage="vb" debug="true" />
<trace enabled="true"/>
<customErrors mode="RemoteOnly" />
</system.web>
</configuration>
======================
Dim myCMD As New SqlCommand
Public Sub New()
Dim db_server = AppSettings("db_server")
Dim db = AppSettings("db")
Dim db_user = AppSettings("db_user")
Dim db_pwd = AppSettings("db_pwd")
Dim DBConnection As String = "DRIVER={SQL Server};" & _ '<==== is my driver correct?
"SERVER=" & db_server & ";" & _
"DATABASE=" & db & ";" & _
"UID=" & db_user & ";" & _
"PASSWORD=" & db_pwd & ";" & _
"OPTION=3;"
myDB.ConnectionString = DBConnection
myCMD.Connection = myDB
End Sub
'Public Function q(ByVal mySTR As String) As OdbcDataReader 'SQL Query
Public Function q(ByVal myStr As String) As SqlDataReader
myCMD.CommandText = myStr
Try
myDB.Open()
q = myCMD.ExecuteReader(Data.CommandBehavior.CloseConnection)
Catch ex As Exception
Err(ex.ToString)
End Try
End Function
Public Sub c(ByVal mySTR As String)
' COMMAND ONLY
Try
myCMD.Connection.Open()
myCMD.CommandText = mySTR
myCMD.ExecuteNonQuery()
myCMD.Connection.Close()
Catch ex As Exception
Err(ex.ToString)
End Try
End Sub
Hi
I have inhereted this application and I am a newbee at asp.net.
Fisrt my apologies for posting such a large amount, I just wanted to
give you all the information that I possibly can.
I have the follwoing error "Specified SQL server not found".
Server Error in '/ppasa' Application.
--------------------------------------------------------------------------------
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]Specified SQL server not found.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]Specified SQL server not found.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[COMException (0x80004005): [Microsoft][ODBC SQL Server Driver][DBMSLPCN]Specified SQL server not found.]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options) +0
PPASA.PPASA.OpenCloseDB(Boolean Connect) in c:inetpubwwwrootPPASAPPASA.vb:9
PPASA.Login.btnSubmit_Click(Object sender, EventArgs e) in c:inetpubwwwrootPPASALogin.aspx.vb:38
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
The process of my application works as follows.
1)Login.aspx submits the username and password. It is linked to Login.aspx.vb with the following statement
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="Login.aspx.vb" Inherits="PPASA.Login"%>
2)In Login.aspx.vb (below) has a call to PPASA.vb with the following statement Call OpenCloseDB(True).
Public Class Login
Inherits System.Web.UI.Page
#Region " Web Form Designer Generated Code "
'This call is required by the Web Form Designer.
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
End Sub
Protected WithEvents Label1 As System.Web.UI.WebControls.Label
Protected WithEvents Image1 As System.Web.UI.WebControls.Image
Protected WithEvents Label2 As System.Web.UI.WebControls.Label
Protected WithEvents txtUsername As System.Web.UI.WebControls.TextBox
Protected WithEvents Label3 As System.Web.UI.WebControls.Label
Protected WithEvents txtPassword As System.Web.UI.WebControls.TextBox
Protected WithEvents btnSubmit As System.Web.UI.WebControls.Button
Protected WithEvents btnClear As System.Web.UI.WebControls.Button
'NOTE: The following placeholder declaration is required by the Web Form Designer.
'Do not delete or move it.
Private designerPlaceholderDeclaration As System.Object
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub
#End Region
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
End Sub
Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
Dim rs As ADODB.Recordset
Call OpenCloseDB(True)
rs = cnn.Execute("SELECT ID FROM PPASA_User WHERE Name='" & UCase(txtUsername.Text) & "' AND Password='" & txtPassword.Text & "'")
If Not rs.BOF And Not rs.EOF Then
Call PopulateUserInfo(rs.Fields(0).Value)
Server.Transfer("PPASAMain.aspx")
Else
Call ClearLoginBoxes()
End If
Call OpenCloseDB(False)
End Sub
Public Sub PopulateUserInfo(ByVal MyID As Integer)
Dim rs As ADODB.Recordset
Call OpenCloseDB(True)
rs = cnn.Execute("SELECT ID,Name,Security FROM PPASA_User WHERE ID=" & MyID)
If Not rs.BOF And Not rs.EOF Then
rs.MoveFirst()
'CurrentUser.ID = rs.Fields(0).Value
'CurrentUser.Name = rs.Fields(1).Value
'CurrentUser.Security = rs.Fields(2).Value
Session.Add("ID", rs.Fields(0).Value)
Session.Add("Name", rs.Fields(1).Value)
Session.Add("Security", rs.Fields(2).Value)
Session.Add("DonorID", 0)
End If
Call OpenCloseDB(False)
End Sub
Private Sub ClearLoginBoxes()
txtUsername.Text = ""
txtPassword.Text = ""
End Sub
Private Sub btnClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClear.Click
Call ClearLoginBoxes()
End Sub
End Class
3)PPASA.vb then creates the connection to the Database. PPASA.vb looks like this.
Module PPASA
Public cnn As New ADODB.Connection
Public Sub OpenCloseDB(ByVal Connect As Boolean)
If Connect = True Then
If cnn.State = 0 Then
cnn.Open("Description=PPASA;DRIVER=SQL Server;SERVER=THE-ONESERVERA;UID=sa;PWD=123;APP=Microsoft Data Access Components;DATABASE=PPASA")
End If
Else
If Connect = False Then
If cnn.State = 1 Then cnn.Close()
End If
End If
End Sub
Public Function CheckSecurity(ByVal Actual As Integer, ByVal Required As Integer) As Boolean
If Actual >= Required Then
CheckSecurity = True
Else
CheckSecurity = False
End If
End Function
End Module
4)After I submit Login.aspx the application boms and gives me the "Specified SQL server not found".
Extra Info:
The Sql server is up and running. I have tested it by connecting with 2 test connection files index.asp and index2 .aspx.
Here are the files. The files also return results from the pubs db.
index.asp
<%
Set conn = Server.CreateObject("ADODB.Connection")
strConn="DRIVER={SQL Server};SERVER=THE-ONESERVERA;UID=sa;PWD=123;DATABASE=pubs"
conn.open strConn
sql = "SELECT * from authors"
set rs = conn.Execute(sql)
if not rs.EOF then
while not rs.EOF
lastname = rs("au_lname")
firstname = rs("au_fname")
response.write "LASTNAME :: " & lastname & " \// FIRSTNAME :: " & firstname & "<br>"
rs.movenext
wend
end if
conn.Close()
Set conn = Nothing
%>
and index2.aspx
<%@ Page aspcompat=true %>
<%
Dim objConn
Dim strConn
Dim objRs
Dim objCmd
Dim objField
strConn="DRIVER={SQL Server};SERVER=THE-ONESERVERA;UID=sa;PWD=123;DATABASE=pubs"
objConn = Server.CreateObject("ADODB.Connection")
objCmd = Server.CreateObject("ADODB.Command")
objRs = Server.CreateObject("ADODB.RecordSet")
objCmd.CommandText = "SELECT * from authors"
objConn.open (strConn)
objCmd.ActiveConnection = objConn
objRs = objCmd.Execute
If Not objRs.EOF then
Do While Not objRs.EOF
response.write ("VALUES :: ")
For Each objField In objRs.Fields
Response.Write (" " & objField.value & " \// ")
Next
response.write ("<br>")
objRs.movenext
Loop
End if
objConn.Close()
%>
There are also the following files in the bin directory.
Interop.ADOR.dll
Interop.MSChart20Lib.dll
Interop.Scripting.dll
PPASA.dll
utCharting.dll
So my question is this, why do I get the error "Specified SQL server not found", when I dont get the error with the test connection files.?
Do I have to do anything with the .dll file in the bin directory, like register them or something?
How does the Login.aspx.vb file call the PPASA.vb file when I see no reference to PPASA.vb
in the Login.aspx.vb file?
I would appreciate any help or suggestions.
Thanks
I have 2 server 2003 boxes one has sql 2000 and the other has IIS. I can pull up my pages on the iis server but as soon as my app tries to access the sql server I get cannot find server. All my settings are correct in the web.config file. I do not have this problem with the same setup on server 2000 boxes. Also active dir is not set up on the 2000 or 2003 boxes. Can someone please help.
thanx
weisenbr
I am trying to connect to my SQL Server through my ASP.NET webpages. My problem is that, no matter what I do, it always says that the server is not found. I know the IP address of my server, and this IP address works from other computers within my network, just not mine.
I have no idea what it could be. If anyone knows, any help would be greatly appriciated.
Jags