First of all, I'm a little inexperienced with the odbc32.dll API's and
not too familiar with all the details of their usage. I have a list of
tables in the database and I'm iterating over that list and building
the primary key for each table. When I perform the iteration my

I am constantly getting connection timeout error when I tried to open SQL
2005 management studio activity monitor.  In connection property window, I
found the connection timeout is set for 15 seconds. However I could not find
place to change the connection timeout. Management ...

I have a serval .asp page with get som data from a SQL database.
Sometimes (not every time) i call one of the pages it gives me this error
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access

I initially set up my server database with window connection. after two
months and my window password is expired and I just noticed that the server
is not started any more since the original password is not working any more.
I tried to register  the server with my sql user ID and ...

When running this query in MSSQL (using mssql jdbc driver):
MSSQLStatement = this.Conexao.createStatement();
MSSQLStatement.execute("EXEC SP_SPACEUSED;")
It's always returning false, but only for this certain procedure....

I use sqljdbc_1.0.809.102 connecting to MSSQL 2000
Here is the connection string:
jdbc:sqlserver://HOST:1600;selectMethod=cursor;databaseName=DB_NAME
Here is the exception:

SQLServer 2000 Database with SP4
fields [content] type is "text"
code below:
====================================

I use a hotfix version sqljdbc_1.0.809.102_enu.exe for sqlserver2005. But
an exception happend as below:
com.microsoft.sqlserver.jdbc.SQLServerException: An I/O error occurred while
receiving the TDS prelogin response.

Good morning we are having a wierd issue with our Windows 2003 server and SQL
2000 sp4 server.  From the client side we use isql queries.  When we reboot
the server the isql queries that are larger then 512 bytes will fail from
both the client or from the sql server itself ...

Does CurrentProject.IsConnected tell me that the ADP is connected to the SQL
database, or that it sees the network?
I have an ACCESS ADP connecting to a SQL db via a wireless network.  I
thought I would check CurrentProject.IsConnected to see if I had lost

Hi;
This works:
SELECT * FROM demo WHERE (name LIKE 'Da[%]ve')
This dies not:

Hi All, I?m using Microsoft?s new JDBC diver sqljdbc.jar and the method
getBoolean in resultSet always return false, because database field is
char(1). According Interface this should return true is char is 1 and
false if char is 0.

I'm looking to make a connection from a host to a SQL server across the
Internet via SSL.  Is this possible?  A link to information would be greatly
appreciated.
Roland Hall

When I try to get the Metadata for schemas/tables/columns in SQL Server 2000
using the JDBC Metadata API (java.sql.DatabaseMetaData.getTables() and
java.sql.DatabaseMetaData.getColumns() ) and the database name has a space or
dot in its name (Eg: "Database 1", "Database.name" ) , ...

I'll provide as much detail as I can.  I have read many messages
regarding this topic, but I just can't seem to follow them in my
specific case.  Sorry I'm so dumb...
Here goes: