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?
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
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
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.
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
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
