|
Active Data Object as they pertain to Active Server Pages.
|
|
Understanding Dates in SQL
|
|
Q:
|
I'd appreciate it if someone could point out what the problem is here?
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near '>'.
sSQL="Select * from Subscribe Date> 08/23/2002"
#768 - 2002.09.27
|
|
|
[top]
|
|
|
Storing Three-Digit Years
|
|
Q:
|
Most 3-digit years will pass VBscript's IsDate() function, but are not a valid SQL Server datetime value. I got around this by appending a digit to the front or rear of the 3-digit year, but this doesn't seem like a proper way to do this.
Also, what if I was storing data on ancient history in SQL Server? Like wanting to store the date 02/02/560. Would I have to store it as a string?
Any help would be greatly appreciated.
#767 - 2002.08.23
|
|
|
[top]
|
|
|
Connecting To MySQL
|
|
Q:
|
Is connecting to a MySQL database from ASP as easy as just setting up a DSN and using that in the connection string or can't we connect to it via ODBC/ADO? Is there a bunch of libraries I need to install with ASP?
#766 - 2002.07.12
|
|
|
[top]
|
|
|
Error 0x80004005
|
|
Q:
|
I am having a problem with some ASP code that is connecting to Access using ADO -- the code is returning an error 80004005.
#750 - 2000.01.23
|
|
|
[top]
|
|
|
ADO Connections without a DSN
|
|
Q:
|
Anyone know what the connection string should look like to connect to a database without using a DSN? Or is this possible with ADO?
#507 - 1997.09.06
|
|
|
[top]
|
|
|
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
|
|
Q:
|
I am having this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 97 Driver]
The Microsoft Jet database engine cannot open the file '(unknown)'.
It is already opened exclusively by another
user, or you need permission to view its data.
#478 - 1997.08.09
|
|
|
[top]
|
|
|
Using Microsoft Access Versions
|
|
Q:
|
I'm looking at working with some Access databases and ASPs. Does it matter which version of Access I am using? I have the version that comes with Microsoft Office 95 (V. 7.0 )
#467 - 1997.07.29
|
|
|
[top]
|
|
|
Trimming Blanks
|
|
Q:
|
My ODBC database has a text field of length 7. However if the field only contains 1 character, the ODBC returns a field containing the letter followed by 6 spaces. How do I fix the problem?
#395 - 1997.06.24
|
|
|
[top]
|
|
|
Error ASP 0115
|
|
Q:
|
What causes this error?
error 'ASP 0115' Unexpected error
/disney/main.asp
A trappable error occurred in an external object. The script cannot continue running.
#362 - 1997.04.10
|
|
|
[top]
|
|
|
Inserting a Record
|
|
Q:
|
If I add a new record to my database, how do I keep track of where it gets inserted?
#694 - 1997.03.21
|
|
|
[top]
|
|
|
Communication link failure
|
|
Q:
|
I am getting this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Communication link failure
What am I doing wrong?
#692 - 1997.03.20
|
|
|
[top]
|
|
