Problem with Microsoft Access ODBC driver
Wed, 18 Jun 2008 08:46:45 -0400
Hi,
For some reason Microsoft's ODBC driver for MS Access reports an index
for every foreign key that exists on a table.
For example, consider the two tables.
create table parent(id integer primary key)
create table child (cid integer, id integer references parent(id))
For some reason, Access crea ...
|
problem in calling a sp using sql native client provider for SQL
Server 2005
Wed, 18 Jun 2008 02:39:52 -0700 (PDT)
i am facing a problem in calling a sp using sql native client
provider for SQL Server 2005. I have a stored procedure which return
some rows as output. I am calling this sp through my vb application
using "DSN=MyDSN; UID=MyUID; PWD=MyPWD" as connection string, in this
case i am getting output (row returned f ...
|
Connections to data sources
Thu, 12 Jun 2008 08:27:00 -0700
We have an old access database which someone is trying to connect to from a
linked server in SQL2005. In SQL2000 this worked with no issue however I
cannot now find a ole db provider which will allow me to connect to this db.
Is this possible anymore or does the fact that it is access 97 mean the
connection ...
|
sp_preprexec error
Wed, 11 Jun 2008 17:34:00 -0700
Hello,
I am receiving the following error when sending a paramaterized statement
from a web page to SQL Server via ODBC connection
Msg 8179, Level 16, State 2, Procedure sp_prepexec, Line 1
Could not find prepared statement with handle 1.
Here is the captured statements received by SQL server (captured ...
|
Problem With View and Changing Field Length
Tue, 10 Jun 2008 23:13:36 -0500
I had a strange situation with a view in SQL 7, that I could use some input
on.
I had a very simple view -- select a, b, c from table1 where x=y and z=q.
Field a in table1 originally was varchar 70. A long time ago I changed it to
varchar 95.
I used this view as an ODBC linked table in an Access MDB. Rec ...
|
SQL Native Client / ODBC connection
Tue, 10 Jun 2008 19:08:46 -0400
When I try to connect to my SQL Server Express using an ODBC connection
(from the ODBC Control Panel in Windows XP SP2 Administrative Tools)
clicking on the drop down list of servers times out with no servers listed.
I can connect to the SQL server from SQL Management Studio, and it's
installed on the same m ...
|
Creating a Linked server to a tmberline database
Tue, 10 Jun 2008 07:04:00 -0700
Hi all,
I have a Timberline construction application that I am trying to link to SQL
server 2005 so I can import the data to SQL server for reporting services. I
have created the linked server using the below CREATE LINK SERVER below and
if I right click and test connection it is succesful, when I try to dri ...
|
|
|
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv(
Mon, 2 Jun 2008 23:39:02 -0700
Hello,
i an custiomer environment, we have sporadic ODBC Errors.
This ist the error message: [Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionRead (recv())
Environment:
Client/Server with Windows Server 2003 Enterprise OS, new Service Packs.
SQL Server 2005 Ent. SP2, installed on the Server.
...
|
Connection Error -2147217843
Mon, 2 Jun 2008 14:06:03 -0700
Receiving this error
ODBC SQL Server Login failed for user''..
NativeError 18452
when we try to launch an application using vb6.
I receive the error above when trying to run a vb6 program that uses sql
server authentication in the ODBC.
When I checked the ODBC for this DSN it tests fine.
It has been se ...
|
SQLAllocEnv failed Cannot find the langiage DLL (wl50??t.dll)
Sun, 1 Jun 2008 19:34:00 -0700
All the ODBC Userd DSN disappeared after joined the user to the new domain or
change the user profile.
When I tried to add the odbc drive in user DSN, i got this error message
when try to add in the SQL Anywhere 5.0 in User DNS.
SQLAllocEnv failed Cannot find the langiage DLL (wl50??t.dll)
...
|
