Showing posts with label provider. Show all posts
Showing posts with label provider. Show all posts

Tuesday, March 20, 2012

[VB.NET2003] DataControl with MDI

hello,..

Inof: using VB.NET 2003 ADO provider - My Database MS Access2003

i want just simple code of how to add Datacontrol on MDI Parent and control this Datacontrol for each MDIChild?

like if i have these Datacontrol [ Add, Save, Delete, Update, Edit, Print] was installed in MDI Parent with Toolbar and you can by these Datacontrols to control each MDI Child form?

also i have in each MDI Child Form Tabcontrol how to programme this code as you see in my link picture

http://img502.imageshack.us/img502/1...controlsw3.jpg

You will most likely get the help you seek by posting the question to one of the VB.NET Form related forums, or one of the VB.NET or Access related NNTP newsgroups.sql

Tuesday, March 6, 2012

[Microsoft][ODBC SQL Server Driver]Timeout expired

Hi:
I am getting this error when the .asp page tries to connect to the DB server.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Timeout expired
The web server is Windows 2000 Advanced Server, Dual CPU with
Hyperthreading, P4 with 2 GB RAM. The database is SQL 2000 Standard Edition
with SP3 and Cumulative Patch for Microsoft SQL Server (815495)MS03-031
installed on a remote server with the same config. I have also tried all the
possible variations like increasing the VBscript timeout in IIS from 90 to
300 and Global transaction timeout in COM+ applications from 60 to 300. This
however is not helping either. When I check the anonymous concurrent sessions
I find atleast 950 connections at any given time. Also installed MDAC 2.7
Refresh on both the servers.
Can any one help me on this please.
Mitul Z.
Hi Mitul,
This error message is somewhat a generic error message for ODBC. Here are
some ideas for troubleshooting the issue.
1. From the server hosting your web server, can you connect to the SQL
Server using Query Analyzer? If you do not have Query Analyzer available,
you can test connectivity by creating a test ODBC DSN and using the test
facility. Can you connect to the SQL Server with these techniques?
2. If you can connect using Query Analyzer or an ODBC test DSN, then the
issue is with the asp page itself. If you cannot connect to the SQL Server
using these tests, the problem is with ODBC configuration or a network
level problem is at play.
If you suspect a network problem is at play, Network Monitor traces will be
very helpful for your troubleshooting. That will at least allow you to
know if your connection request is reaching the SQL Server.
Please let me know if this information helps.
Thank you.
Gary
This posting is provided "AS IS" with no warranties, and confers no rights.

[Microsoft][ODBC SQL Server Driver]Timeout expired

Hi:
I am getting this error when the .asp page tries to connect to the DB server
.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Timeout expired
The web server is Windows 2000 Advanced Server, Dual CPU with
Hyperthreading, P4 with 2 GB RAM. The database is SQL 2000 Standard Edition
with SP3 and Cumulative Patch for Microsoft SQL Server (815495)MS03-031
installed on a remote server with the same config. I have also tried all the
possible variations like increasing the VBscript timeout in IIS from 90 to
300 and Global transaction timeout in COM+ applications from 60 to 300. This
however is not helping either. When I check the anonymous concurrent session
s
I find atleast 950 connections at any given time. Also installed MDAC 2.7
Refresh on both the servers.
Can any one help me on this please.
Mitul Z.Hi Mitul,
This error message is somewhat a generic error message for ODBC. Here are
some ideas for troubleshooting the issue.
1. From the server hosting your web server, can you connect to the SQL
Server using Query Analyzer? If you do not have Query Analyzer available,
you can test connectivity by creating a test ODBC DSN and using the test
facility. Can you connect to the SQL Server with these techniques?
2. If you can connect using Query Analyzer or an ODBC test DSN, then the
issue is with the asp page itself. If you cannot connect to the SQL Server
using these tests, the problem is with ODBC configuration or a network
level problem is at play.
If you suspect a network problem is at play, Network Monitor traces will be
very helpful for your troubleshooting. That will at least allow you to
know if your connection request is reaching the SQL Server.
Please let me know if this information helps.
Thank you.
Gary
This posting is provided "AS IS" with no warranties, and confers no rights.

Saturday, February 25, 2012

[Microsoft][ODBC SQL Server Driver][SQL Server]I/O error (bad page ID)

Hi!

Im having this error when doing a query to a SQL Server 2000 Database:

Microsoft OLE DB Provider for ODBC Drivers error
'80004005'

[Microsoft][ODBC SQL Server Driver][SQL Server]I/O error
(bad page ID) detected during read at offset
0x000000003ac000 in file 'E:\Program FIles\Microsoft SQL
Server\MSSQL\Data\sitioIAC_Data.MDF'.

It doesnt happend in some queryes trough a ASP file.

What could it be??

Thank You
JuanRun DBCC CHECKDB against that table(s) with REPAIR_ALLOW_DATA_LOSS option. Refer to BOL for more information on DBCC CHECKDB & CHECKTABLE topics.

Friday, February 24, 2012

[Help] EXECUTE permission denied on object

Microsoft OLE DB Provider for SQL Server error '80040e09'

EXECUTE permission denied on object 'wwfSpTimeAndDateSettings', database 'iobmi6_ETSasp', owner 'dbo'.

/forum/functions/functions_date_time_format.asp, line 82


What does the EXECUTE permission denied on object... line mean?It means that the object owner decided NOT to run the following statement:

grant execute on dbo.wwfSpTimeAndDateSettings to <you>|||Ok i spent time trying to figure out how to fix it bymyself... but i have no idea. I'm trying to install Iportal... so i remade sure i installed all the files completly. Looked up my database info to see that correct. Is it somthing with my database not having dbo autority? (cause then i'll need to ask my hosting for it)|||What is the User ID specified in the connection string? Issue the statement from the previous post and replace <you> with that value.|||Dude! did you read rdjabarob post? if yes, read it again .. if you still don't get it, then I suggest you do some BOL reading about "permissions-SQL Server: Managing permissions"